Chapter 3 of the Defensive Database Programming Book by Alex Kuznetsov teaches us about how to “survive” changes to database objects. Alex brings to light how simple changes to the underlying schema could be damaging […]
Category: SQLServerPedia Syndication
A little Dance with SSIS and Informix
Not too many moons ago I embarked on porting some servers over from SQL 2000 to SQL 2008. On some of these SQL 2000 servers, we had numerous DTS packages performing various ETL functions. One […]
Defensive Db Programming Chapter 02
This is the review of the second chapter of the book Defensive Database Programming. The title of this chapter is “Code Vulnerabilities Due to SQL Server MisConceptions.” This chapter examines three common misconceptions: WHERE clause […]
Gettin’ Skewled
Observe and Report This month we get to frolic in our memories of school days. Thanks to HeadMaster Robert Davis (Blog | @SQLSoldier), we are entreated to a little detention while we figure out how […]
July SSSOLV UG Meeting
This is really late notice – apologies in advance. We will be holding the LV UG meeting July 8th at the same time and same place as usual. 777 N Rainbow, Ste 250. 6:30 PM […]
SQL 2008 DTS
It’s a Bird… No, not really. It’s just Windows 7. I have recently upgraded to Windows 7. I took the roundabout trip to do that going from Server 2003 to Windows XP and […]
Q2 Goal Review
As we close out the Second Quarter of 2010 it is time to review progress made on the Goals I set at the beginning of the year. Just like the end of Q1, I think […]
Declare Scalar Variable
Lately I have been going through a bunch of maintenance style scripts and fixing them. Along with fixing them, I have also been updating them to work more efficiently and to work in SQL 2008. […]
Data Compression
I see database compression, as offered with SQL 2008, to be more like these file compression utilities than DriveSpace. Data compression in SQL 2008 is not an all or none implementation. You get to pick and choose what gets compressed. That is a big time bonus for me.
Defensive Database Programming Chapter 01
Today I am finally getting around to the review of the first chapter as promised. I talked about the book a bit in the first post on the subject, which can be found here. This […]