Archives: July 2010
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 to performance and accuracy of the code that touches the objects to be changed.
Three… Read more
Not much ado about SQL Server here. Good things come with the number 9. For instance SQL Server got substantially better at version 9 (my opinion). And another good thing is the next addition to our family. We are 5 months in with 4 remaining. My wife and I typically… Read more
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 of these jobs interacted with an Informix database. On the old server, an ODBC driver… Read more
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 conditions will always be evaluated in the same order
- SET and SELECT always change the…
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 we best learn. I don’t have any idea how to learn in detention… Read more
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 back to school and revisit some of the methods that help us to learn.
Join… Read more
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 (only due to a cancellation in May) for helping us present via LiveMeeting. The meeting… Read more
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 (officially when we start the presentation)
6:00 PM for meet and greet
This month we… Read more
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 then finally up to Windows 7. Having never used Windows Vista, there were several nuances to learn.… Read more
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 I continue to make good progress. Thus I will break down each of the goals… Read more