Are I/O latencies killing your performance?
(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
(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
Over the last few months we’ve started thinking about our 2014 and 2015 international class locations. We’ve been in London for the last three years
This survey is closed – please don’t spend your time sending any more data – thanks In this survey I’d like to see what the
As a counterpart to my recent survey on what the oldest version of SQL Server you have in production (see the results here), I kicked
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
In this survey I’d like to know what the newest version of SQL Server is in your environment – it has to be an instance
Last week I kicked off a survey asking what is the oldest version of SQL Server you have in production. Here are the results: I’m
In this survey I’d like to know what the oldest version of SQL Server is in your environment – it has to be an instance
As of this afternoon all eight classes we’re doing in Chicago in April/May are sold out – that’s 160 people we’ll be training! The reason
A while back I kicked off a survey asking what mechanism you use for running your regular SQL Server database maintenance. Here are the results:
I haven’t done any surveys this year and I’d like to get back into doing one every week or so for the next few months.
Back in February I ran a bunch of performance tests of DBCC CHECKDB on SSDs, to evaluate the effects of degree-of-parallelism (DOP) and various options
While Kimberly was selecting underwater photos for our new website, she came across this one from our dive trip to the remote NE of Indonesia
Our New Website Late last year we finally decided to make time to revamp our blogs and website, and move onto WordPress. I really wish we’d
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.