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

Archives: July 2007

The Business of Publishing

Despite my casual approach to the editorials and my job, this is still something of a business and Red Gate wants to find ways to engage people more. During a discussion today, everything was out there: pidcasts, videocasts, RSS feeds, and more.

Not sure where this will go, but the…

Read more

0 comments, 586 reads

Posted in The Voice of the DBA on 10 July 2007


I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information from the EVENTDATA() function. One of the things I noticed was that with CREATE_LOGIN and ALTER_LOGIN events, you cannot get back the T-SQL information. This makes sense because these two…

Read more

CTEs and where have I been?

I haven't posted much lately, but it has been a busy few months with many family activities.  At work, I am happy to say that we are in the middle of upgrading our financial system, which includes an upgrade from SQL Server 2000 to SQL Server 2005 64 bit.  Basically,… Read more

0 comments, 400 reads

Posted in Advice from Aunt Kathi on 9 July 2007

Wiki For Books Online

Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be tremendously powerful to get not just the official MS line but also the hard lessons learned that you often run across in forums and community generated articles. I haven't looked…

Read more

0 comments, 551 reads

Posted in SQLAndy on 9 July 2007

The Perils of NewID for Randomizing Results

NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its a "true" random, but usually good enough for day to day purposes. It's a decent technique and easy enough to apply, but it can be a performance killer. In the…

Read more

0 comments, 819 reads

Posted in SQLAndy on 9 July 2007

Service Packs and Support

More coming next week in editorials and already a note on the site, but support for both SQL Server 2000 SP3a and SQL Server 2005 RTM ends on Tuesday.

What does this mean? Well when support ends, at least mainstream support, you can't make free calls on it. So if…

Read more

0 comments, 593 reads

Posted in The Voice of the DBA on 7 July 2007

Latest Service Packs and Books Online

I was reading a new post at SQL Server Magazine titled The More Things Change (full version available to registered users of sqlmag.com) by SQL Server MVP Brian Moran. It revealed an experience he recently had at Tech·Ed, where some folks who work with SQL Server weren't aware…

Read more

The Video World

I wonder what you think of this: video shorts. I've gottne the Lockergnome newsletters for years and they've proven interesting enough for me to skim them every few days. I noticed Chris had started videos when I was checking the podcast list on iTunes and these seem kind of…

Read more

0 comments, 554 reads

Posted in The Voice of the DBA on 6 July 2007

Midlands PASS Chapter July Meeting with SQL Server MVP Wayne Snyder

SQL Server MVP Wayne Snyder Speaks on SQL Server Integration Services (SSIS)

Midlands PASS Chapter - July 12, 2007 Meeting
Sponsored by AgFirst Farm Credit Bank

The Midlands PASS Chapter is pleased to announce SQL Server MVP Wayne Snyder as our speaker for our July meeting. Mr. Snyder will speak… Read more

Cursors to Increase Performance?

I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In the previous iteration of tuning they had found that running a portion of the query inside a cursor actually yielded better performance than a one query takes all set based…

Read more

0 comments, 666 reads

Posted in SQLAndy on 6 July 2007


One of the suggestions I saw today was to add blogs to the user profile on the site and not just email and IM. I think it's a great suggestion, but unfortunately I'm in a lockdown for the most part. The new site beta should come out next week and…

Read more

0 comments, 577 reads

Posted in The Voice of the DBA on 5 July 2007

70-444 Exam Prep Book

I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks good! I wrote the SSIS chapter and it is amazing what a couple good editors can do to make it really look professional.

I've enjoyed the simpler rules and spontaneity…

Read more

0 comments, 687 reads

Posted in SQLAndy on 5 July 2007

The Journey to Katmai

I wrote an article recently on the Journey To Katmai, looking at some of the new features that are coming in SQL Server 2008. I've actually got a second part almost done, so I'm trying to learn more about this next version of the platform to finish it. From what…

Read more

0 comments, 609 reads

Posted in The Voice of the DBA on 4 July 2007

Who said that breaking up is hard to do?

Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking up is hard to do" in the song by the same title. I'm sure we've all gone through a break up at some point. But breaking up isn't necessarily a… Read more

Working Remotely

Most people I know tend to work in one of two places consistently: work or home. So they've built a setup that allows them to comfortably get things done in either location.

I'm not so different in that I work at my desk downstairs most of the time during the…

Read more

0 comments, 522 reads

Posted in The Voice of the DBA on 3 July 2007

Breaking Up is Easy to Do

Breaking Up is Easy to Do

It's nice to be able to package a process into a single, tidy, elegant query, but it isn't always possible to do so. And even if it is possible, it may not be the best way to do it. Often, we can get… Read more


This is pretty cool, a, earthquake test for Project Black Box from Sun. They take one of their systems to a University in CA that has a platform that can simulate an earthquake. It fares pretty well, and I think this is an interesting model. I think lots of facilities…

Read more

0 comments, 576 reads

Posted in The Voice of the DBA on 1 July 2007

Newer posts