I've been searching for a way to get SQL scripts into OneNote while retaining syntax highlighting from SSMS for a long time now. It...

We had some unfortunate event befall one of our SQL clusters lately, and it’s led to some interesting fallout. First, the TempDB LUN was un...

This is a question we get as SQL Server DBAs all the time:  is this database in use?  Most of us are in the habit of putting this question b...

SSRS will often timeout when starting under Windows Server: The error is:  Windows could not start the SQL Server Reporting Services (MSS...

Sometimes you have need for a SSL certificate on a Windows server when you don't have IIS installed.  Like when you want to install SQL ...

I ran into a problem recently that really had me scratching my head for awhile:  when I launched the Windows Store on Windows 8.1 with a new...

While it's possible to view the SQL Server error log location in the SSMS GUI, sometimes you want to build a script that'll write a ...

When you need to GO in your batch Sometimes you'll run into a situation where you want to script a series of SQL batch statements dyna...

SA Login  SA Login authentication failures, essentially, should never happen. Mostly that's because we generally shouldn't be usi...

I was tasked with importing a .SAS7BDAT file into SQL Server the other day, and there were enough non-intuitive pieces to it that I thought ...