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

There seems to be a lot of confusion about SSIS administration in a clustered environment, and I think a lot of it comes down to SQL error m...

SSMS provides a nice way to query many SQL Server instances at one time using the Central Management Server (CMS) functionality.  You can ri...

I don't think I'm alone in having wished time and again for a good SQL formatting option from within SSMS. I've posted about us...

It's a common problem SQL Server (especially) DBAs have: how do I find out when the last time this database was used? SQL Server is so...