sql server

I’m having problems with SQL Server 2008 SSMS and the Open Empty Environment setting. It’s not doing what it did in 2005 and it’s giving me heartburn. I’ve posted the issue up to...

Running an SSIS package via the SQL Server Agent jobs can be an entertaining experience when said package errors out. It gets even worse when the DBA in question uses an Integration...

Having a problem renaming or deleting a file / folder that is referenced by SQL Server or SSIS? Here’s a tip. If you’re trying to rename or delete a directory folder /...

John Scalzi has an interesting blog post on "How to have a Writing Career like Mine." The first sentence in that blog is "you can’t." Then he goes on to...

Craig Ferrell has a wonderful article over at SQLServerCentral.com about how to approach the business of job hunting in SQL Server. It’s a good read. If you’re looking for a new...

Following up on my previous post, Creating #Excel Templates in #SQLServer #SSIS, this post walks you through how to use that template for new files. I should note that I...

I’ve seen a lot of advice on the net lately advising people to use Excel templates for their SSIS packages, but I haven’t seen many articles discussing how to create...

#WIT = Twitter hashtag for Women in Technology. I’m not sure where the numbers come from, but everyone in my local SQL Saturday community seems to agree that the number of...

Yesterday, someone asked a question on SQLServerCentral.com that caught my attention: “What would be the best way for defragging a disk on which database files are also stored?” This poster...

I’ve seen a lot of requests, and advice, for networking at conventions and conferences. I thought I’d add my own two cents to the pile. If you are planning to...