Target and actual SQL Server uptime survey results
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
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
It’s been a hectic January with client work and preparations for our 2014 classes so I haven’t blogged as much as I wanted, but I
Now that 2014 is upon us, it’s time for us to start promoting the Spring show of our SQLintersection conference. This year the Spring show
In the first post of the year I’d like to kick off a survey. I’m interested to know whether you’ve ever practiced restoring or rebuilding
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,
As we all wind down for the 2013 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’
Kimberly’s second Pluralsight online training course has just gone live and is available for watching! Her course is SQL Server: Optimizing Ad Hoc Statement Performance
I’ve just heard from our good friends at Pluralsight that our two latest online training courses are now live and available for watching! My latest
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
(New for 2020: we’ve published a range of SQL Server interview candidate screening assessments with our partner Kandio, so you can avoid hiring an ‘expert’ who
We’ve had a mentoring program here at SQLskills for a couple of years (the brainchild of Jonathan), where each of us can pick someone who’s
At the end of every SQLintersection conference we have a closing Q&A session where we answer audience questions about anything to do with SQL Server.
It’s been a long time since I’ve written a post about pure internals, but every so often I get asked how an allocation unit ID
It’s quite well known that you can optimize error log file management using SSMS to change the maximum number of error log files to 99
We’ve finalized the details of our two classes in Australia next year and they’re open for registration. Kimberly and I will be presenting our popular
Kimberly’s first Pluralsight online training course went live today: SQL Server: Why Physical Database Design Matters It’s 4 hours long and is the first in a
Last week I answered a question on Twitter about DBCC PAGE and asked if I could be sent more details about the problem. The person
My good friend Orson Weston (@weston12) posted a question to #sqlhelp on Twitter earlier: Is there a way out of the box to find when and
My latest Pluralsight online training course went live today: SQL Server: Detecting and Correcting Database Corruption It’s 4 hours long and is the first in
Last week, in the immediate aftermath of the sudden announcement by Microsoft of the cancelling of the MCM/MCSM (Microsoft Certified Master) program, I kicked off
I’m sure most of you have heard the news now that Microsoft has effectively cancelled the MCM/MCSM/MCA program abruptly, with a cold email sent at
Kimberly’s been hard at work finalizing details of the classes we’ll be offering in the first half of 2014 and we have 17 new classes
After going back and forth with someone with a corrupt master database, I’ve just discovered a bug. And unfortunately it goes back to SQL Server
There are only a few weeks to go until our September set of classes start in Bellevue, WA and there are still some open seats
Time for another survey! This survey’s very simple: run the following code on as many of your production instances as you can, and post a
Back in May I started a survey to collect build numbers to see how up-to-date people keep their SQL Server instances and I’ve been putting
I haven’t posted much in July (and won’t until the second half of August as we’re on vacation diving with the kids) and today we’re
I have a busy second half of the year planned, with more classes, conferences, and Pluralsight courses coming up! For classes, I’ll be teaching at
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.