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

Archives: June 2010

Who2 Article Published

I just had my second article published on June 14, 2010 at SQLServerCentral.  I will be posting a follow-up to that article in the near future.  The follow-up is related to the discussion in the thread for the article.  The article is titled: What, Where, When, How, Who2.  The… Read more

0 comments, 970 reads

Posted in SQL RNNR on 22 June 2010

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.  Most have been corrected / updated.  The most recent script I have been looking at… Read more

0 comments, 628 reads

Posted in SQL RNNR on 22 June 2010

24 HOP Available

Just a quick note.  PASS has made the 24 Hours of PASS available via streaming video.  You can check it out at 24 Hours of PASS.  There is a variety of topics and sessions from which to choose.


Read more

0 comments, 459 reads

Posted in SQL RNNR on 16 June 2010

June S3OLV Wrapup

Last night we had our monthly Chapter User group meeting in affiliation with PASS.  Honestly, the experience was quite humbling and embarrassing.  What could one do though given the circumstances?  You may be wondering what I am talking about right now.  Let me explain.

I had arranged for a couple… Read more

0 comments, 571 reads

Posted in SQL RNNR on 11 June 2010

Data Compression

We have come to that time of month again – blog party.  This time, the party is hosted by Jorge Segarra (aka SQLChicken) (Blog | Twitter).  The rules have also changed this month, though ever so slightly.  Now, we must insert a pic into our blog post… Read more

0 comments, 1,012 reads

Posted in SQL RNNR on 8 June 2010

June 2010 S3OLV Meeting

The S3OLV monthly meeting is being held this Thursday.  We will be meeting at the same location and time as usual.  This month we have a couple of vendors coming to speak.  Fusion IO and Kynetx will both be in town giving presentations.  Come and enjoy the presentations and the… Read more

0 comments, 481 reads

Posted in SQL RNNR on 7 June 2010

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 book was written by Alex Kuznetsov (blog).

In this chapter, Alex discusses… Read more

0 comments, 787 reads

Posted in SQL RNNR on 7 June 2010

DTS and 2008

Have you ever been required to update your SQL Server environment and needed to test it?  I know, rhetorical question.  I am in such a process currently.  We have the entire gambit of project killers in play as well.  We have short deadlines, requirements to maintain current technologies (i.e. DTS)… Read more

0 comments, 651 reads

Posted in SQL RNNR on 4 June 2010