SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2010

Defensive Db Programming Chapter 03

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

0 comments, 1,600 reads

Posted in SQL RNNR on 26 July 2010

5 down 4 to go

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

5 comments, 509 reads

Posted in SQL RNNR on 23 July 2010

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 of these jobs interacted with an Informix database.  On the old server, an ODBC driver… Read more

1 comments, 1,305 reads

Posted in SQL RNNR on 23 July 2010

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:

  1. WHERE clause conditions will always be evaluated in the same order
  2. SET and SELECT always change the…

Read more

0 comments, 1,780 reads

Posted in SQL RNNR on 15 July 2010

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 we best learn.  I don’t have any idea how to learn in detention… Read more

0 comments, 776 reads

Posted in SQL RNNR on 13 July 2010

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 back to school and revisit some of the methods that help us to learn.

Join… Read more

0 comments, 567 reads

Posted in SQL RNNR on 12 July 2010

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 (only due to a cancellation in May) for helping us present via LiveMeeting.  The meeting… Read more

0 comments, 423 reads

Posted in SQL RNNR on 12 July 2010

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 (officially when we start the presentation)

6:00 PM for meet and greet

This month we… Read more

0 comments, 554 reads

Posted in SQL RNNR on 7 July 2010

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 then finally up to Windows 7.  Having never used Windows Vista, there were several nuances to learn.… Read more

2 comments, 3,347 reads

Posted in SQL RNNR on 7 July 2010

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 I continue to make good progress.  Thus I will break down each of the goals… Read more

0 comments, 509 reads

Posted in SQL RNNR on 6 July 2010