Seamless Upgrade

One of the things mentioned in a keynote at the recent PASS conference was the idea that SQL Server 2008 would be a seamless upgrade. Or maybe I misunderstood and it will seem less like an upgrade 🙂

Tame Those Strings! Part 7 - Proper Casing Strings

Need to proper case names? Want a quick way to reformat a series of words? This article examines a SQL approach to quickly proper casing all words in a field.

What is the Maximum Page Size in SQL Server 2000?

I have always read that 8060 bytes is the maximum size. This is stated over and over again in Books Online, the MS site and numerous other sites, including this one. However a post in our forum recently questioned this. I decided to verify the problem and do a little research.

How many network cards do you need per...

Compliance

The Sarbanes-Oxley act has become a four letter word to many IT people in the US. Thankfully I only had to deal with it for about 9 months before I left to go work on my own, but it was a long 9 months. Especially since I did half the work with JD Edwards and then did it again with Peoplesoft 🙁

Halo 3

This week Steve looks at SQL Server 2008 pricing, Windows XP, and Halo 3

Paperwork Day

Doing payments for articles, expenses, and a few articles. This is definitely a paperwork day. As much as I like...

You are configuring a SQL Server 2005 Integration...

The Quickest Podcast in the Business

I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishment, it's here. I'd...

I Don't Have a Black Eye

Though it kind of looks like that. Here's the first video podcast.

Halo 3

Actually it's probably the 20th, but it's close...