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

• Building The Redneck Treadmill Desk
• Kissing 2013 Goodbye
• Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49
• What Are Your Servers Doing While You’re Sleeping?
• So, This Happened Today…
• The Night Before Upgrade
• I’m Board
• Automated Permissions Auditing With Powershell and T-SQL: Part 6
• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• What’s In My Utility Belt? Issue #2

Comments That Were Posted This Week

• Enrique Argüelles on Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49:
  Hello I have try your query with sql server 2012 RTM and it fails when trying to query WAITSTATS_LOG
• realsqlguy on Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49:
  “it fails” – in what way? Is there an error message? Are you running the scripts from my earlier blog post that create the Waitstats_Log table?

  Start here: http://realsqlguy.com/servers-youre-sleeping/

• Enrique Argüelles on Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49:
  Oh God silly me I didn’t pay attention to that, thanks for the clear up.
• realsqlguy on Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49:
  Happy to help!
• Hernan Lionel Cianfagna on Automated Permissions Auditing With Powershell and T-SQL: Part 6:
  Great stuff!

  Just 2 little improvements

  $insertFullName=$insertFullName -replace “‘”, “””

  $insertUserName=$insertUserName -replace “‘”, “””

  x2 to handle names with apostrophes

  all occurrences of AccessSummary.LoginName need to be COLLATEd to a common collation

This Week In History

None, the past holds no lessons this week

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