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

• The Night Before Upgrade
• What Are Your Servers Doing While You’re Sleeping?
• Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49
• So, This Happened Today…
• Don’t Get Slimed By Bad Parameter Sniffing
• CAST(‘RealSQLGuy’ AS BELIEVER)
• I’m Board
• Using A Non-correlated Subquery To Avoid DISTINCT
• What’s In My Utility Belt? Issue #2
• Automated Permissions Auditing With Powershell and T-SQL: Part 1

Comments That Were Posted This Week

• John Heimiller on Do You Need A Log Recovery Tool?:

  (Nice to see a fairly recent blog I can post too. I feel weird when I want to post to a blog or forum thats 5 years old….is that person still alive?, etc…)

  I came to the same place with respect to the log mining choices and apex….server side components dissuaded me. I never bothered to check them out. Did you ever figure it out? If its just some Master procs, ok…but my instances are mostly on clusters and don’t want any type of exe’s or stuff on the nodes.

  Thumbs up on your post.

• realsqlguy on Do You Need A Log Recovery Tool?:

  They actually have a document that describes what they’re installing:

  http://knowledgebase.apexsql.com/2009/06/apexsql-log-pre-installation.htmIt’s a combination of DLL’s and extended stored procedures, necessary to allow them to read from an active transaction log. Windows won’t allow remote “shared” file handles. The only way to duplicate a file handle is through a locally installed DLL.

This Week In History

None, the past holds no lessons this week

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