I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
In which Phil Factor's attention wanders whilst reading some software product announcements and imagines what would have happened if the current IT Bloggers had been in charge of the White Star Line at the time of RMS Titanic.
Installing the sample databases in SQL Server 2008 isn't as straightforward as in previous versions. Brian Knight shows what needs to be done in this video.
If you are building packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post.
I always consider taking seminars and technical conferences as a key component in my DBA education framework
I had been doing the validation with a T-SQL User Defined Function (UDF), but it was getting too slow as the number of e-mails grew. I needed a faster alternative, what options do I have?
In which Phil Factor responds to the muse and writes a poem in the style of a School Song, in which he tries to give a mention to all the top writers and forum-posters.
Continuing his discussion on SQL Server 2008 Data Collections, Greg Larsen explains how to create your own custom Data Collections.
It's been busy since my last update, lots of stuff to work on! I probably won't get it all in one post, but I'll try to hit the highlights. The main event over the past two weeks was my first board meeting in Seattle. I arrived Monday afternoon
ANSI SQL can perform breakthrough any-to-any hierarchical data structure reshaping. These are transformations that are performed utilizing only the structure semantics in the data assuring correct semantic results.
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Team, I'm trying to figure out what will be the best recommendation to configure...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers