This month is the (lucky) 13th T-SQL Tuesday and is being hosted by Steve Jones (blog | twitter). Steve is asking about issues we've had interacting with a business in order to get the job done. Specifying project requirements often leads to the classic problem of "do what I meant, not what I said!". In my …

Read More

This month's T-SQL Tuesday comes a week early so it doesn't conflict with the PASS Summit, which makes sense since many active bloggers will be in attendance. Sadly I won't be, but there's always next year! Paul Randal (blog | twitter) is hosting this time around, and the question he's asking is "Why are DBA …

Read More

This Month’s T-SQL Tuesday topic comes from Sankar Reddy (twitter) and he’s asking for SQL Server myths and misconceptions to be de-bunked. I’ve got 2 myths I’d like to set the record straight about. They’re rather closely related, and concern the "Lock Pages in Memory" setting. What’s it do? Without getting into an …

Read More

This post is my contribution to T-SQL Tuesday #10, which is being hosted by Michael J. Swart (blog | twitter) Each year my Boy Scout troop has a rummage sale as a fundraiser. All the scouts and their families gather up their old clothes, books, toys, electronics, and any other treasures they no longer need and donate …

Read More

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 …

Read More

AIN'T YOU GOT NO BOOKLEARNIN'? This, the eighth T-SQL Tuesday is hosted by the SQL Soldier, Robert Davis (Blog | Twitter) and he's asking how we learn and how we teach. How I Learned Throughout my school years I seem to have been assigned a disproportionate number of "old-school" teachers who could be …

Read More

This post is my contribution to T-SQL Tuesday #007, hosted this month by the SQLChicken himself, Jorge Segarra (Blog | Twitter). Since I'm a bad DBA and have yet to get my hands on a copy of R2, I'll make use of the rule that we can discuss any feature from 2008. My favorite is filtered indexes, as they were the …

Read More