SQLskills holiday gift to you: all 2013 Insider videos
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’
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:
To celebrate our newly revamped IE1 and IE2 classes becoming IEPTO1 and IEPTO2, through the month of July you can register for either October class
I’ve just released our final US classes this year for registration! We’ve revamped our IE1 and IE2 classes so they’re now both focused on performance
This is a question that came up this morning during our IE1 class that I thought would make an interesting blog post as there are
This is a quick blog post to let you know about a bug in SQL Server 2012 SP1 that can cause data loss when performing index maintenance.
Exactly five years ago I published survey results showing target uptime SLAs and actual uptime measurements. I re-ran the survey a few weeks ago to
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] Back in February I
It’s been five years(!) since the last time I asked about your target uptimes for your critical SQL Server instances and I think we’d all
(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.) In many
We’ve had a mentoring program here at SQLskills for a few years (the brainchild of Jonathan), where each of us can pick someone who’s attended
For the longest time the guidance around tempdb is that if you shrink it on a live system then it could cause tempdb corruption. A
Over the last few weeks I’ve been investigating a series of customer corruption issues (on one customer’s system) where it appears that the page checksum
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] In some of the
[Edit 2016: Check out my new resource – a comprehensive library of all wait types and latch classes – see here.] Wait statistics, as you
Two weeks ago I kicked off a survey that presented a scenario and asked you to vote for the log_reuse_wait_desc value you’d be most worried to
The Simple Talk folks from Red Gate have been running a Geek of the Week interview series over the last few months and this week
Time for another fun survey, this time around factors causing the transaction log to grow. Imagine you’re the DBA for a company and you come
(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.) Two weeks
[Edit: 3/25/14 No more codes left – thanks for all the data! – please don’t send any more.] Yes, you read that correctly. Call me
As we draw close to our IE1 Immersion Events in Sydney and Melbourne, we have a few seats still available so we’re offering a special
Here’s another survey for you, and I’m really looking forward to seeing and discussing the results of this one. Imagine you’re the new DBA for
A couple of week ago I kicked off a survey about the extent of your experience with the DBCC WRITEPAGE command. Here are the results:
Back in 2012 I blogged about using fn_dblog and fn_dump_dblog to figure out the point at which something occurred that you’d like to restore to
Fellow MVP Chris Shaw (b | t) wrote a blog post earlier this week on learning from mistakes and tagged me to write a similar
In this survey I’d like to know what your experience is using the DBCC WRITEPAGE undocumented command. This survey is closed – see the editorial
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.