SSIS Documentation suggestions on Microsoft Connect

For SSIS developers, the need for proper documentation is crucial.  However, the built-in object for documentation, the annotation, is difficult to use.  It doesn’t wrap text, doesn’t support varying font styles in a single instance, and doesn’t offer spell checking.  Further, all annotations are “at large” and are not attached to a particular object – they are associated with a…


Getting Into the Biz, Part 2

In a previous blog post, I began writing about how one might start a career as a database professional, and agreed to share my own experience in doing so.  Since every person and every situation is different, I don’t declare my experience to be a recipe for success, but I’m happy to share it in hopes that someone can learn…


Being The Best vs. Being Affordable

I read a post on Brent Ozar’s blog last week that discussed employers’ expectations when hiring new team members.  Though the story was specific to database professionals, the same principles apply to almost any hiring situation.  The moral of Brent’s story is that when hiring, just like in real life, you have to compromise what you may really want to stay within…


Transaction Rollbacks with Identity Columns

Have you ever noticed unexpected gaps in sequences in SQL Server identity columns? Even though you’ve got transactions set up for your inserts and a no-deletion policy, you find that there are missing values in what should be an unbroken sequence of numbers.  The problem could be partially related to transaction rollbacks. Conventional wisdom would lead one to believe that…


Never Delete Data?

Should you ever delete data? Data quality is important, and completeness is a measure of the quality of data.  Whether you refer to it as data integrity, permanent retention, or simply maintaining a complete audit trail, it can be effectively argued that purging old data clouds the big picture that the data presents.  After all, any data that is worthy…


Your Local User Group

When I talk to other SQL Server professionals, I’m often surprised at how many do not have any involvement in their local SQL Server user group.  As best I can tell, the problem is not limited to SQL Server types – many technical pros do not even know that there are user groups in their area, much less participate in…


Getting Into the Biz, Part 1

I’ve seen a good deal of coverage recently that is geared toward those who have recently begun a career as a database professional.  Brad McGehee posted this week about some potential topics for a book for new SQL Server developers, and Craig Outcalt is publishing a series of articles on SQLServerCentral.com aimed at new DBAs.  Brent Ozar also has a…


SQL Quiz: Two Mistakes

I was tagged by Gail Shaw to post two big mistakes made during my professional career.  The only challenge here was to narrow the list down to two 🙂 The first one is very easy.  During my early days working with SQL Server, I wore a lot of hats, including that of web developer.  One of my first major web projects was…


SQL Quiz: Career Challenges

I’ve read a number of responses from Chris Shaw’s first DBA networking quiz.  I missed out on the first one, but I have been tagged by Grant Fritchey for the second round. The Questions for this quiz… What are the largest challenges that you have faced in your career and how did you overcome those? 1) The first one of these, I still…


The Next Generation DBA

DBA, database developer, analyst, SQL grunt, or whatever your title may be, there is no question that your role will be evolving in the next few years. I read a couple of posts from Jason Massie about the Death of the DBA (part 1 and part 2) earlier today, in which he predicts a diminishing market for database administrators, and SQL DBAs…