Survey: what is the most worrying wait type?
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
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
This is a really simple post, making sure you’re aware of the incredibly cost-effective way you can get hold of the kind of quality SQL
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
(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
Our last scheduled IE1 Immersion Event on Internals and Performance in Bellevue, WA in September has just sold out at 36 students, and there’s still
Last month I kicked off a survey asking you to run some code to send me data on the size, number of files, and number
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
This month the SQLskills team is presenting a series of blog posts aimed at helping Accidental/Junior DBAs ‘keep the SQL Server lights on’. It’s a
Time for another survey (I’ll editorialize the files/filegroups data from the last survey next week). This survey’s very simple, run the following code on as
As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer. We have a new Immersion Event for the
As I announced in our Insider newsletter last week, we’ve designed some new Immersion Events to expand the curriculum we offer. We have a new Immersion Event on Advanced
As an update to our current round of SQLskills community mentoring (round 4 – see post here), Joe and Erin are now mentoring people they’ve
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.