November classes in Chicago
We’ve released our Fall lineup of classes for registration! Our November classes in Chicago, IL will be: IE0: Immersion Event for Junior/Accidental DBAs November 16
We’ve released our Fall lineup of classes for registration! Our November classes in Chicago, IL will be: IE0: Immersion Event for Junior/Accidental DBAs November 16
My latest Pluralsight course has been published! It’s called SQL Server: Index Fragmentation Internals, Analysis, and Solutions and is just over 2.5 hours long. The modules
In the last IEHADR class we just had in Chicago, I was doing a demo of looking in the transaction log to find the point
Kimberly’s latest Pluralsight course is live! This is part 2 of her very popular course: SQL Server: Optimizing Stored Procedure Performance. The course is more
Last weekend there was a suggestion on the MVP distribution list about having temporary nonclustered indexes on AG readable secondaries, in the same way that
It’s been a while since I’ve done a survey, and this one is inspired by a discussion I had with Matt Slocum (b | t) yesterday that led
Last year PASS introduced some eligibility requirements for voting in the 2014 PASS elections, but a lot of people didn’t get the message for various
(Check out my Pluralsight online training course: SQL Server: Performance Troubleshooting Using Wait Statistics and my comprehensive library of all wait types and latch classes.) One of
We’re very excited to announce that we’re offering a new Immersion Event on Practical Data Science using Azure Machine Learning, SQL Data Mining, and R,
Here’s an interesting question that came up in our IEPTO1 class in Chicago this week (paraphrasing): I was doing a demo recently where I was demonstrating
We’re just about to leave for three weeks of Immersion Events in Chicago, starting next week, and if that wasn’t enough, we’ve got our Spring 2015
Last week, for the second time in as many weeks, I was sent a question in email from someone who had a transaction log that
PASS has just released the top-10 rated sessions from the 2014 PASS Summit for everyone to watch for free! My Advanced Data Recovery Techniques session
Back in 2009 I blogged about how checkpoints work (see How do checkpoints work and what gets logged) and I received a question in email
The story I wrote for our SQLskills Insider newsletter on Monday last week resonated so well with people that I thought I’d publish it here
A couple of weeks ago I kicked off a competition of sorts, to find some people to mentor to celebrate the community voting me “Person You’d
This month’s T-SQL Tuesday (hosted by Kenneth Fisher – @sqlstudent144) is about security This hasn’t been my area of expertise for a long time, although I did write a long
Every year Redgate hands out a series of Tribal Awards, voted for by the SQL Server community around the world. In the 2013 awards I won
Since SQL server 2014 was released back in April last year, there have been some rumblings about changes to how many VLFs are created when
Edit 10/30/19: the latest version of this script, with additions and adapted for newer versions is here. Over the holidays I was playing around with parallelism
The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down some of the
Back in 2009 I started posting a summary at the end of the year of what I read during the year (see my posts from 2009, 2010, 2011,
Last week we joined our wonderful friend (he MC’d our wedding in 2007) Richard Campbell for RunAs Radio show #400, where we jet-laggedly discuss all kinds
It’s hiring time again, as our consulting volume has reached the point where we need more help on our close-knit, expert team! Specifically, we’ve asked
As we all wind down for the 2014 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’
A month ago I kicked off a survey asking how much memory is installed on your largest server that’s running SQL Server. Thank you to
My friend Wayne Sheffield (b|t)is hosting T-SQL Tuesday this month and it’s been a long time since I’ve taken part
Through popular demand we’ve managed to juggle a bit more of our schedule around and found space to fit in another European class in 2015, and it’s
On Friday I made my signature pork ribs for our good friend Bob Ward (along with Kimberly’s truffled cauliflower mash and caramelized broccoli) and I promised
One of the cool new features in SQL Server 2014 is delayed durability (available in all Editions), which is described in detail in Books Online here.
This is a quick post to let you know about a bug that a few people are hitting when running DBCC CHECKDB. The symptoms are
Starting in 2015 we at SQLskills would love to present remotely for your user group, anywhere in the world. Kimberly and I recently did a
In both my wait statistics pre-conference workshops at the PASS Summit and SQLintersection I promised to do a bunch of blog posts. The second one
[Edit 12/10/14: Survey is closed see the editorial here.] One of the trends I’m seeing this year is a slow increase in the number of
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] (Script last updated June
Through popular demand we’ve managed to juggle some of our schedule around and found space to fit in our only class of 2015 in the UK, and
Back in August I wrote a long post about how to ask questions politely and correctly to address what I see as a growing volume
We’ve managed to juggle some of our schedule around and found space to fit in our only class of 2015 in Australia, and it’s open for registration!
It’s well known that one of the common performance issues that can affect tempdb is allocation bitmap contention. I discuss this, and ways to alleviate
I’ve just released our first sets of US classes for 2015 for registration! Our classes in April/May will be in Chicago, IL: IE0: Immersion Event
The two major Fall conferences are 3-4 weeks away so I wanted to give you a heads-up about my new pre-con workshop that I’ve just
(Check out my Pluralsight online training course: SQL Server: Detecting and Correcting Database Corruption.) This is a question that I was sent over email that
Very short blog post to let you all know that I’ve updated my wait stats script so that it works on 2014 and also now
It’s been a bit light on technical posts here over the last few months but now that summer’s over I’ll be ramping up again with
We’ve just released two new courses on Pluralsight: The first new course is the conclusion of Joe Sack’s query-tuning course: SQL Server: Common Query Tuning Problems and
This post is a much-expanded version of the editorial in my last bi-weekly SQLskills Insider newsletter, including a bunch of the feedback I got. (Also see
SQL Server 2005 will end Extended Support on 4/12/2016 (see the Support Lifecyle page for details) and the SQL Server Team in Microsoft is conducting
I’ve just released our final classes of the year for registration! We will be coming to Sydney and Canberra in Australia and teaching our new IEPTO1:
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.