Foreign Keys can reference UNIQUE indexes (without constraints)

Something I learned while the SQL Server 2008 Internals book was in tech edit (thanks to our *awesome* tech editor Ben Nevarez – who, unfortunately, does not have a blog or anything…yet! (well, I'm hopeful)), was that you can use a FOREIGN KEY constraint to reference a UNIQUE index – one without a PRIMARY KEY or […]

Getting the most from the system you have now!

Given the general state of the economy…many companies are looking to cut back. Going back over what we've done and "optimizing" things -> budgets, expenses, etc. is the norm right now. And, scaling back is not always a bad thing – unless the wrong things are cut. Unless the wrong things are used to motivate […]

Getting started in speaking publicly – clear and concise presentations

Well, I had wanted to come up with a clever reply to my husband's oh-so-romantic blog post (here). And, well, in all honesty, that *is* the best present for me… but, probably not what most would say is romantic ;-). We've both had quite an effect on each other's presentation styles. We constantly remind each […]

Understanding backups and log-related Trace Flags in SQL Server 2000/2005 and 2008

Paul and I started discussing a comment that came up regarding the many issues surrounding logging & recovery. It's one of our favorite topics and in fact was the title to an article that Paul recently wrote for TechNet here: And, as a sidenote, depending on how much you already know about the transaction […]

Where in the world does time go?

I know where I go but where the heck does the time go (it seems to move much faster than I)? First off, I hope everyone had a truly lovely holiday season. I know they've long since past for everyone but maybe this reminder will bring back a nice memory from the holidays as it […]