Cumulative Update – 6 for SQL Server 2008 R2 Service Pack 2 Is Now Available !

The 6th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...

Friday Fun – Football Derbies

This is an off-topic post for a Friday. With Cardiff City reaching the premier league this week and all the...

Getting the lowdown on 18456 errors

If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...

Backing Up Azure SQL Database to the Cloud

When I first started working with Azure SQL Databases, I wasn’t sure what it would take to backup a database....

dynamic sql and a char crash

Dynamic SQL can be helpful, but a pain to debug. I spent hours today working on figuring out why my...

SQL Saturday #175–Fargo

One of the goals early on with SQL Saturday was to spread them far and wide. Andy Warren and I...

Microsoft let new SQL Server version name slip?

There has been lots of speculation in the SQL Server community as to what the official name of the next...

PASS Business Analytics Conference: the ultimate networking

I went to the PASS Business Analytics Conference last week, and had an absolute blast.  I presented two sessions, and...

Monitoring SQL Server Agent job run times

Introduction

A few months back, I was asked how long a particular nightly process took to run. It was a super...

How to default SSRS date parameters to the first and last day of the the previous month

Populating default dates in SSRS can be helpful to save the user from having to constantly input the date range...