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...

Conditional Default Values in SSRS

I’d like to share with you a laziness efficiency method I use when developing reports in SQL Server Reporting Services. ...

Convert comma separated string to table and vice versa

I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...

Denali

Is all set to be officially known as SQL 2012 and will be finally released in....... 2012!
Announced at the PASS...