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

• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• 20 Abuses: Procedurally Going In Circles
• Do You Need A Log Recovery Tool?
• Using A Non-correlated Subquery To Avoid DISTINCT
• CAST(‘RealSQLGuy’ AS BELIEVER)
• SQL Query Formatting – Putting Lipstick On A Pig
• Automated Permissions Auditing With Powershell and T-SQL: Part 3
• What Are Your Servers Doing While You’re Sleeping?
• Automated Permissions Auditing With Powershell and T-SQL: Part 4
• Automated Permissions Auditing With Powershell and T-SQL: Part 2

Comments That Were Posted This Week

• alex hatcher on What Are Your Servers Doing While You’re Sleeping?:
  This site is blocked under WebSense. I have no idea why, just FYI
• realsqlguy on What Are Your Servers Doing While You’re Sleeping?:
  Thanks for letting me know Alex. I assume it’s due to some of the embedded SQL scripts. I’ve dropped them a note to find out why they’re blocking me.
• realsqlguy on What Are Your Servers Doing While You’re Sleeping?:
  Websense has responded to me already. They have recategorized “realsqlguy.com” – “Categorization updates should be reflected in the next scheduled database publication, and will be available shortly to Real-Time Updates subscribers.”
• alex hatcher on What Are Your Servers Doing While You’re Sleeping?:
  and… McAfee “web gateway” is (WAS) blocking it as well. We use both tools, but today they are working for ya.
• Duncan Fairweather on Using A Non-correlated Subquery To Avoid DISTINCT:
  this page renders poorly in chrome; can’t see the queries
• realsqlguy on Using A Non-correlated Subquery To Avoid DISTINCT:
  Thanks for bringing this to my attention, Duncan. A lot of this older content was migrated over from Blogger, and the formatting was lost along the way. I’m slowly fixing bad posts as I find them. I’ve corrected this one.

This Week In History

None, the past holds no lessons this week

The post Friday Followup For November 29, 2013 appeared first on RealSQLGuy.