It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

• The Phoenix Project: a DBA rises from the ashes
• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• Building (for FREE) a Virtual Server for SQL Demos
• Cheating DBCC To Fix Index Corruption
• Do You Need A Log Recovery Tool?
• Don’t Get Slimed By Bad Parameter Sniffing
• So, This Happened Today…
• Automated Permissions Auditing With Powershell and T-SQL: Part 6
• Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49
• Winning From Within: a book review and a new attitude

Comments That Were Posted This Week

• Robert L Davis on SYS.PARTITIONS: Better Than X-Ray Vision:
  Remember though that you’re looking at it from a “partitions” perspective. So if the table or index is partitioned, there will be one row per partition and the row count will be the row count for the specific partition. To get the total row count for an index or table, you would need to GROUP BY object_id and index_id and SUM() the rows column.
• realsqlguy on SYS.PARTITIONS: Better Than X-Ray Vision:
  Thanks Robert, great point and great tip!
• Nelson on The Phoenix Project: a DBA rises from the ashes:
  This was a great recommendation from Thomas. From the first chapter I was laughing and I couldn’t stop finding similarities with the environments I have worked on. I still apply the lessons to my daily experiences and so far I still see how the situations described on the book still occur again and again. Looking forward to the next recommendation

This Week In History

None, the past holds no lessons this week

That’s it for this week. Get back to work!