Meme Monday: 11 Words or Less

Thomas LaRock (Blog | Twitter) has started a community blog series call Meme Monday.
Here’s my entry:

Community is nice, but displaces work if...

SQL Saturday #63 – Dallas: Wrap-up

SQL Saturday #63 – Dallas was a great event. The venue was great, although parking was a little unclear (I had...

SQL Saturday #63 – Dallas: Resources

I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....

Change SQL Startup Parameters with PowerShell

Backups Abound

The Annoyance
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...

NOLOCK for Developers

What is NOLOCK?
NOLOCK is a table hint for SQL Server that tells the engine to not take locks and ignore...

SQLskills Immersion Event on Internals and Performance – Day 5

Overview
Today was the fifth and final day of the Internals & Performance immersion event. I have really enjoyed learning from not...

SQLskills Immersion Event on Internals and Performance – Day 4

Overview
We just finished the fourth day of SQLskills learning. Today was all on indexes and statistics. We learned about choosing...

SQLskills Immersion Event on Internals and Performance – Day 3

Overview
Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a...

PowerShell Script for Paul’s Survey: how is your tempdb configured?

Paul Randal (b | t) posted a survey how is your tempdb configured? Since I just happen to be at a...

SQLskills Immersion Event on Internals and Performance – Day 2

Overview
Day two of the SQLskills Immersion Event is over and I have listed the interesting parts below. The food, again,...