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

• Do You Need A Log Recovery Tool?
• Building (for FREE) a Virtual Server for SQL Demos
• Don’t Get Slimed By Bad Parameter Sniffing
• Cheating DBCC To Fix Index Corruption
• Building The Redneck Treadmill Desk
• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• Using A Non-correlated Subquery To Avoid DISTINCT
• No, Simple Mode Doesn’t Disable The Transaction Log
• Automated Permissions Auditing With Powershell and T-SQL: Part 3
• Transparent Data Encryption’s Dirty Little Secret

Comments That Were Posted This Week

• Thomas Mucha on What Are Your Servers Doing While You’re Sleeping?:
  Hi SQLGuy,

  I realise this is a pretty old post, but I was wondering if you’d recommend using the method you described above over Extended Events Sessions for wait_stats collection?

  Thanks,

  Tom

• Thomas Mucha on The Value of Writing Good:
  I don’t think it was too subtle. Some people are a little too literal, rather than lateral in their thinking, I guess.

This Week In History

None, the past holds no lessons this week

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