SQL Server 2005 – Page 19

SSIS XML DOM Fun

February 22, 2007 by Jason S, posted in SSIS

I received the following error the other day: Error 17 Error loading LoadTables.dtsx: Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered. Out of nowhere this just comes in and sits on my SSIS package and appears when I try to open up any of the packages and … Continue reading SSIS XML DOM Fun

It’s All About The NULL

February 6, 2007 by Jason S, posted in SQL Server, T-SQL

I read a couple of NULL articles back-to-back today from SQLServerCentral. The first had to do wit the Four Rules of NULL and the second was NULL Versus NULL. Both were pretty good and picked up on how SQL Server uses and characterizes NULLs. I can think of a handful or fifty times that the … Continue reading It’s All About The NULL

SQL 2005 White Paper: Online Index Operations

January 10, 2007 by Jason S, posted in SQL Server, White Paper

How quickly a week goes by... minute by minute... get a little busy and no blogs. Well, here's a quick link to a white paper on Online Index Operations in 2005. A very nice 2005 Enterprise feature that allows building and maintaining of indexes without sacrificing DML concurrency. Or in other words, how to keep … Continue reading SQL 2005 White Paper: Online Index Operations