Will the Cloud Eat My DBA Job? (Dear SQL DBA Episode 31)

Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? In this post I talk about the future of database administration and give tips on strategizing your career. Watch this week’s 28 minute episode, or scroll down to read a written version of the answer. Us YouTubers love […]


Adding Partitions to the Lower End of a Left Based Partition Function

I recently got a table partitioning question from a reader: We now need to load some historical data into the table for 2013 so I want to alter the function and schema to add monthly partitions for this. But I can’t work out how to do this using SPLIT? Every example and tutorial I’ve looked […]


Confused by sp_who2 (Dear SQL DBA Episode 30)

This week’s ‘Dear SQL DBA’ question gets us down to the essentials Recently, when I was checking if there are any hanging transactions in my database via “sp_who2 ” procedure… A transaction is “AWAITING COMMAND” LastBatch date is more than a week ago ProgramName is “SQLAgent – Generic Refresher” Is the transaction hanging? Learn the […]


New online course: Troubleshooting Blocking & Deadlocks for Beginners (Free!)

I made y’all a SQL Server style Valentine’s day present: a new FREE online training course. Here’s a quick trailer: Course info: Troubleshooting Blocking & Deadlocks for Beginners You need to prove if blocking is killing the performance on your SQL Server. Learn to set up simple, lightweight monitoring using free tools and scripts to […]


Should I Learn Fulltext Indexing? (Dear SQL DBA Episode 29)

This week’s question is about a longstanding feature in SQL Server that sounds really cool: full-text search. If you’re learning performance tuning, how much time should you invest in researching and learning about full-text indexes? Watch this 18 minute video, or scroll on down to read the written scoop on full-text search. Dear SQL DBA… […]


Understanding Left vs. Right Partition Functions (with Diagrams)

You’re designing table partitioning, or you want to make a change to an existing partition function. It’s critical to understand the difference between how “left” and “right” partition functions behave, but the documentation is a bit confusing on this topic. Honestly, even after years of working with partitioning, it’s easy to get confused about left and […]