Month: April 2009

When joining multiple tables together in a query, use aliases every time on every field. Say we’ve got two tables, Customers and Salespersons.  The Customers table has a PreferredSalespersonID field that identifies who their normal sales rep is, and that lets us quickly grab the right salesperson when a customer calls in.  We want to…

It’s alive!  You can download SQL 2008 SP1 here.  If you get a 404 error, come back and try it again.  Seems that the download servers aren’t all synced up. The April 2009 update to the SQL Server 2008 Feature Packs is also available today.

The SSWUG Virtual Conference has posted free 10-minute samples of each speaker’s videos.  You can get a 10-minute intro to several presentations to get a feel for the quality of the videos, the speakers and the material.  The videos take 10-15 seconds to start, so hang in there. Log Shipping 101 SQL Server V-Conference Samples…

Recruiters are everyday people just like you and me.  They have feelings, dreams, families and jobs. What Recruiters Do Their job is to fill empty positions. Notice that I didn’t say that their job is to find YOU a job.  It’s not. There’s a separate group of people out there who work as your agent,…

In Atlanta? Want to get some free SQL Server training?  Want some free food on April 10th? Jason Hall and I will be doing a day-long Day with the Experts session in Atlanta where we’ll be covering performance tuning topics to help you get more performance out of your existing hardware.  My presentations will be:…

At Quest Software, my official job title is Domain Expert.  That means I’m supposed to be the master of my domain – my domain being SQL Server, storage area networks, and virtualization.  Ideally, I’m also supposed to be pretty good at the Quest products for that stuff, too. I don’t have a written job description…

I’ve been working with the community for years, spreading the good word about Microsoft products and helping the community, and it’s finally paid off: I’m an MVP! I’ve been recognized for the work with the Microsoft product that’s closest to me – literally.  Check out these pictures of my office over time: My Office in…