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 […]
TSQL 2sday Coming Up
TSQL Tuesday is fast upon us once again. In fact, in my time zone, it is just a day away. This month the event is being hosted by Robert L. Davis. We get to go […]
S3OLV July Recap
This month we had our first adventure in LiveMeeting presentations. We had the pleasure of listening to Jack Corbett give us some good information on using Profiler and creating traces. Jack was the guinea pig […]