A Identity Bug

Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
   drop table aa
create table...

Man in the MIddle

Are you worried about man in the middle attacks on your database server? If you run Oracle you should be, but SQL Server DBAs should not assume they are safe. Adding communication encryption can be a good idea for SQL Server DBAs.

Backup Compression in SQL Server 2008 – The Complete Presentation

From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.

Turn it...

Regular Service

Steve Jones feels that we ought to get regular service packs from Microsoft to support SQL Server. Not everyone agrees. Do you?

Concrete Code

When building a new database or system, are you designing concrete code? Should you be? Steve Jones comments on matching your needs with your architecture.

One Trip Booked – TechEd 2010

Tia thinks I’m crazy to book early, but I like to have a choice of flights, and I like to...

The PASS Summit Survey Results 2010

I hope there will be more surveys, so I’ll tag this as 2010. The results were released recently, and there...

Beware, events falling from the sky

Are SQL Saturdays falling from the sky? (from Jen McCown, @midnightDBA)
I think so. This past weekend had three events, #39...

Upgrading your Beta/CTP Software

This is one of the reasons that I don’t like to put CTP software (or Beta software) onto machines that...

Adding Administrator

I installed a new VM with SQL Server in it, along with Win 7 and Reporting Services. The plan was...