sqlworkbooks-dog-catching-300-300

New Free Webcasts on Interviewing and Indexing

Sharpen your performance tuning and indexing skills this summer, for free, one week at a time! I’ve recently added five more free webcasts for summer to my lineup: Thu, July 27, 9AM PST /12 PM EST – The Case of the Slow Temp Table Thu, Aug 10, 9AM PST /12 PM EST – SQL Server […]

microphone

Why I’m Inspired to Start Up Live Webcasts Again

For a while now, I’ve been indulging in what feels like a huge guilty pleasure: an almost meeting-free existence. I’ve been living life scheduled on my own terms. I commit to appointments for workouts, volunteering, haircuts, and medical appointments, but not much else. I’ve been publishing pre-recorded videos and online courses which I can make whenever […]

batch-mode-hacks-square

Batch Mode Hacks in SQL Server (Dear SQL DBA Episode 42)

Learn what batch mode is in SQL Server, and how you can trick SQL Server into using it (even without a “real” columnstore index). This week the video, explanation, links, and demo code are all over at SQLWorkbooks.com.  The content just ended up being useful enough that I wanted to be able to link to […]

3.1-Transactions-vs-Batch-Requests-square

SQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)

Perfmon counters are great for measuring workload, but choosing which counter to baseline can be confusing. The Transactions/sec counter has big blind spots Watch a quick 5 minute demo showing that the SQL Statistics\Batch Requests/sec counter sees more of your workload than the Databases(_Total)\Transactions/sec counter does. Want more perfmon tips for SQL Server? Check out my YouTube […]