A whole site for reviewing of SQL Server MVP Deep Dives

This book just keeps amazing me. Not only as I read through some chapters for the first time, and others for the second and third times, but also as I read reviews of it written by other people. The guys over at http://sqlperspectives.wordpress.com are a prime example. They’ve been going through each chapter, each writing … Continue reading A whole site for reviewing of SQL Server MVP Deep Dives

Re-running SSRS subscription jobs that have failed

Sometimes, an SSRS subscription fails for some reason. It can be annoying, particularly as the appropriate response can be hard to see immediately. There may be a long list of jobs that failed one morning if a Mail Server is down, and trying to work out a way of running each one again can be … Continue reading Re-running SSRS subscription jobs that have failed

T-SQL Tuesday – Query Cost

In SQL Server, the cost of a particular plans is based largely on I/O, which makes this post a good candidate for this month’s T-SQL Tuesday, hosted by Mike Walsh who, like me, walks a straight path. In considering I/O – the movement of data generally In and Out of disk and memory – my … Continue reading T-SQL Tuesday – Query Cost