I recently ran into a snag when I wanted to use Power BI for some projects at home. Like any curious data enthusiast, I downloaded Power BI Desktop to my personal laptop, excited to dive in. Almost straight away, I was met with an all-too-familiar screen: Power BI kept asking me to enter my email …
Author Archives: Sudarshan
Table Names in the database and the last time they were Updated
Ever wondered to see all the tables names and the last time they were updated? This is a query which will give you all the desired result. Select Distinct Object_name(object_id) as DatabaseName, Object_id, Database_id, Last_user_update From Sys.dm_db_index_usage_stats Where database_id = db_id() and last_user_update is not null