Archives: July 2007
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…
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…
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
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…
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…
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…
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…
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
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…
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…
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…
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…
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
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…
|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…