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

I’ve had a hard time coming up with a title for this post, because while the concept is easy to understand, it’s difficult to summarize. We...

[Update 1/2915] Head over here for a solution for OneNote 2013.  Annoying, but it works! I use OneNote as a SQL script repository, and i...