You’ve got a performance problem and you know just the cool index trick that will fix it! Until it goes utterly wrong. Join me for this free session in the 24 hours of PASS to see multiple quick demos of index changes that seem like a great idea… until they either don’t work, or make things worse. How to sign up My session is on Wed, July 19, 9 am Pacific / 12 pm Eastern / 4pm UTC. Register for this free event here. BYO dog!
I’ve got a whole bunch of free, live webcasts scheduled on SQL Server training! I’d love for you to join me for these sessions: Thu, June 8, 10AM Pacific – Should Developers Manage Index Maintenance? Thu, June 22, 10AM Pacific – Why an Index and Statistics Can Make a Query Slower Thu, June 29, 10AM Pacific – Statistics Maintenance Frequently Asked Questions Thu, July 6, 10AM Pacific – SQL Server Management Studio Shortcuts & Secrets Thu, July 13, 10AM Pacific – The Weird, Wonderful World of Partitioned and Columnstore Indexes in Execution Plans Thu, July 20,10AM Pacific – How to Identify the Most Important Queries to Tune Reserve your spot today!
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 it feels right. There’s been a couple of reasons for this. When it started, I wanted a major break from meetings. I wanted to see what it was like to have a more flexible schedule. It turns out I sometimes like working early, or late, and I like doing some writing on Sundays. For the last four months, there have been some practical reasons around this, too. There’s a house renovation and building boom going on in Portland, and three construction crews have been madly at work directly outside my windows for months. Between the hours of…
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 it locally there from my query tuning courses. Happy hacking!
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 playlist of perfmon tips here.
Find out if getting certified will help you land an entry level DBA job. If you do want to get certified, get Kendra’s tips on preparing for the exam in this 17 minute episode. Option 1: Listen to or download the audio podcast episode You can listen on the run by subscribing to the podcast on iTunes , on Google Play, or plug this RSS feed into your favorite podcast app: http://dearsqldba.libsyn.com/rss Option 2: Watch the YouTube video Links from this episode SQL Server User Groups: http://www.pass.org/Community/Groups/LocalGroups.aspx SQL Saturdays: http://sqlsaturday.com/