How to tell who changed a log file characteristic?
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
Menu
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
[Edit 2016: The team ‘fixed’ the problem in SQL Server 2016 by skipping consistency checking these indexes unless WITH EXTENDED_LOGICAL_CHECKS is used.] It’s no secret
For those of you who were planning to register for our IE1 Immersion Event (on Internals and Designing for Performance) in Chicago at the end
There’s cool mechanism that the buffer pool has called disfavoring, that sometimes kicks in to prevent pages from a different database being flushed from the buffer pool
My latest online training course was published by Pluralsight on Friday: Communications: How to Talk, Write, Present, and Get Ahead! The course is 2.5 hours
Whenever I’m teaching about index fragmentation I get asked how to track page splits proactively. This can be useful to discover fragmentation occurring in indexes
(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
This is a quick post to announce that we’ve designed a cool new SQL Server conference, where we control all aspects of the show (including
A while back I wrote a comprehensive disaster-recovery flow chart in poster form for SQL Server Magazine, and I’m very happy that it’s now being
We all obsess with making our databases and our clients’ databases healthy and fabulous, but often we forget about looking after ourselves. Over the last
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.