Here we are with another fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show

Obviously this week is another slow week, here is what I found interesting this past week in SQL Land:

Using SQLIOSim to Diagnose SQL Server Reported Checksum (Error 824/823) Failures

Another good post by the PSS SQL Server Engineers

There is code available to take advantage of the sp_replwritetovarbin heap overflow bug

In a default configuration, the sp_replwritetovarbin stored procedure is accessible by anyone. To disable this proc you can run this as an admin on the box

Before disabling this pro read BradC's comment so that you do not break replication

Calculating Median and Mode with SQL Server can be frustrating for some developers, but it doesn't have to be. Often times, inexperienced developers will attempt to write this with procedural programming practices, but set based methods do exist. Be…

Here we go with the links for week 3

Interpreting Output from SQLIOSIM

Kevin Kline has a nice post about interpreting output from SQLIOSIM, he also made a follow up post here: More Tidbits on SQLIOSIM

A common mistake DBAs make is overlooking the need to maintain the indexes that ship with system databases. Fragmentation is a concern on user databases but also is something that must be maintained on databases like ReportServer for SSRS.

I’m going to focus on SSRS as an example but keep this open to all of the systems databases you have on your instances.

Most successful reporting services implementations come with daily report generations, changes and high execution rates. That means the tables in the ReportServer database will change along with your reports. ...