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 (for FREE) a Virtual Server for SQL Demos
• Don’t Get Slimed By Bad Parameter Sniffing
• Cheating DBCC To Fix Index Corruption
• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• Do You Need A Log Recovery Tool?
• Using A Non-correlated Subquery To Avoid DISTINCT
• Building The Redneck Treadmill Desk
• T-SQL Tuesday: Are We There Yet?
• Connect The Tweeps
• Automated Permissions Auditing With Powershell and T-SQL: Part 2

Comments That Were Posted This Week

• mark willium on Cheating DBCC To Fix Index Corruption:
  You are right, we can’t run DBCC CHECKDB command on the database without changing the database in single user mode and that leads the database down. There is an easy & efficient tool that repairs corrupt SQL server database files and recovers tables, indexes, stored procedure and many more. It works on do-it-yourself basis and does not alter the origional database. Tool can be find here: http://www.mssqldatabaserecovery.com/

This Week In History

None, the past holds no lessons this week

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