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
• Automated Permissions Auditing With Powershell and T-SQL: Part 1
• Cheating DBCC To Fix Index Corruption
• Do You Need A Log Recovery Tool?
• Don’t Get Slimed By Bad Parameter Sniffing
• Automated Permissions Auditing With Powershell and T-SQL: Part 3
• Using A Non-correlated Subquery To Avoid DISTINCT
• Automated Permissions Auditing With Powershell and T-SQL: Part 2
• Automated Permissions Auditing With Powershell and T-SQL: Part 5
• Automated Permissions Auditing With Powershell and T-SQL: Part 4

Comments That Were Posted This Week

• Richard Douglas on Do You Need A Log Recovery Tool?:
  Hi Tracy,

  Dell Software (formerly Quest Software) has a Log Reader component that is available in two of it’s tools. Toad for SQL Server and LiteSpeed for SQL Server.

  Like Apex it requires a component on the server and you can read online transaction logs and also from the log backups to either redo or undo a transaction and it will create the required script for you to run.

  Of course the benefit of having it with LiteSpeed is that you can perform all of your backups restores and even object level recovery from within the same product.

  Regards,

  Rich

This Week In History

None, the past holds no lessons this week

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