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

PowerSQL – Find and Replace string on multiple file of local or remote machine

Copy and Paste the below content in Set-FindandReplaceString.PS1. Please read the instructions carefully. Try to do a dry run on some...

A Replacement for DBCC IND in SQL Server 2012

Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles.  Some...