My upcoming speaking engagements

In the last weeks it was very silent on my weblog, but life is pretty fast in 2012.
Currently I'm preparing...

Not enough storage is available to complete this operation

This message appears in the TDP SQL dsmsched file.  It’s usually associated with low levels of contiguous memory
BackupVirtualDeviceSet::SetBufferParms: Request large...

RYO Maintenance Plan – Database Backups, Part 3

4 out of 5 DBAs agree
I’ve covered creating my backup directories and the actual backup of the database(s). The last...

Using Reporting Services as your Software Frontend

Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to reports of...

What is Microsoft Connect?

Microsoft Connect (blog, twitter) is a site where you can post feedback to improve the quality of many Microsoft products and...

Whitepaper – Extending Reporting Services with Custom Code

Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you.  Prepare for Marketing...

A Script A Day - Day 7 - Memory Queries

Today's script is a collection of a few memory queries I've collected from various sources over the years.  These queries are by no...

Arithmetic Overflow in sp_MSarticle_validation

This is probably a rare occurrence — but I've noticed that data validation for an article with 10 billion or more...

Avoiding Bad Query Performance

There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:

That’s certainly not...

Computed Columns and Divide by Zero

I have a few posts on computer columns, the basics of computed columns, using CASE in a computed column, and...