Blog

T-SQL Tuesday #009: Beach Time!

This month's T-SQL Tuesday is brought to us by Jason Brimhall (Blog | Twitter) and he's asking what we do to prepare for some time off.   Databases don’t take any time off, and in my experience DBAs rarely do either.  We do earn our vacation like every other employee though, and every once in a while we might even be allowed to use some of it!   When I’m getting ready to go on a vacation, I take 2 simple steps to help ensure that things stay “business as usual” while I’m out of the office: Documentation The same…
Read More

Three Events That Brought Me Here

Back in January, Paul Randal (Blog | Twitter) started a wonderful blog meme that asked you to write about 3 events in your life that brought you to where you are today.  I had the pleasure of reading many excellent posts written by people that I really look up to.  I wanted to participate, but I didn’t have a blog back then.  I’m 7 months late to the party (the story of my life!) and I’ll warn you that I don’t think my tale is nearly as inspiring as others that I've read, but I thought I’d share anyway. 1.…
Read More

Speaking At Chicago Suburban PASS This Week

Tomorrow night I'll have the pleasure of speaking at the August 2010 Chicago Suburban SQL Server User Group meeting.  Here's the details: WHERE:  Microsoft Offices - 3025 Highland Parkway Suite 300, Downers Grove, IL WHEN:  Tuesday, August 3, 2010.  6:00 - 9:00 pm I'll be giving my presentation entitled "Backups and Restores In Depth".  I'll discuss some of the finer points of backups, restores, and how they work.  I'll also cover the three recovery models in detail and add some best practices along the way. I'm not the only act though, Wendy Pastrick (Blog | Twitter) will also be speaking.  Her…
Read More

Review: Picasa Web Albums

This is the fourth post in my series on cloud backup solutions.  Previous posts were: Disaster Recovery Strategies for the Home A review of MozyHome Remote Backup A review of Jungle Disk Today's topic is Google's Picasa Web Albums, henceforth known as PWA.  Unlike the other solutions I've covered, PWA is not explicitly intended to be a backup solution.  It's designed as a platform for sharing your photos and videos with others, however it also does an excellent job of storing them in the cloud and letting you retrieve them with ease.  I've been using it as a form of…
Read More

Six Tips For Avoiding Bad Table and Column Names

Do you like it when your schemata are easy to understand and maintain?  If so, keep the following in mind when choosing names for tables and columns.  If you're feeling evil and want to inflict some frustration on others, this might give you some good ideas too... 1.  Data types make horrible names There's no rule that says you can't name a column after a datatype - it will just be awfully confusing.  The following code works perfectly: create table INT ( char datetime not null, foo int null, bit bit null, timestamp datetime null ); The birth of the…
Read More