Building an Effective Data Warehouse Architecture Presentation

I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals...

SQLSaturday #250 in Pittsburgh

Welcome to SQLSaturday #250 in Pittsburgh
http://www.sqlsaturday.com/250/

SQLSaturday is a full day FREE  training event for SQL Server professionals and those wanting to learn more about SQL...

When I run “Script as” it isn’t (or is) … How do I fix it?

When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix...

SQLSat 235 Wrap-Up

Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for Curacao in my queue.  I had fully intended on...

SQLSat 235 Wrap-Up

Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for...

My Next Phone May Be a Nokia

I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...

The Case of the NULL Query_Plan

As a DBA, we're often asked to troubleshoot performance issues for stored procedures.  One of the most common tools at...

Good Intro Podcast on Hadoop

Have you heard about Hadoop but don't know much about it? What about "big data?" Would you like an intro...

Actual Emails: TL;DR: Stop using varchar(max)

Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich...

SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command

Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...