More businesses than you think are still using SQL Server 2000
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
Menu
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
Those nice folks at Pluralsight are offering everyone on the planet a free 24-hour pass to check out all their online courses (more than 400
This is an interesting case that came up recently, and that I’ve seen a few times before, but which I haven’t seen explained anywhere. Using
I originally blogged a series of corruption demos and associated databases back in 2008, for use with SQL Server 2005 and 2008. Since then the
The last post of the year! It’s been a really excellent year all round and time for my traditional post counting down the numbers that
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)
A couple of weeks ago I kicked off a survey asking how often you perform full backups of your databases. Here are the results: The
A couple of weeks ago I kicked off a survey about where you store your backups. Here are the results: The’Other’ responses are: 8 x
In this survey, I'm interested in how often you perform a full database backup of your production databases. I'll editorialize the results in a week
As we approach the 2012 holiday season, we want to give the SQL Server community a holiday gift to say ‘thank you’ for all your
In this survey I'd like to know where you store your SQL Server backups. If a disaster occurs, where do you get them from? It
At the SQL Connections conference earlier this month, at the start of my talk on Making SQL Server Faster, Part 1: Simple Things, I talked
As you know we're recording a lot of content for Pluralsight, and they've just published my latest course today: SQL Server: Logging, Recovery, and the
We're there as part of your team when you need us, without the hassle of contracts and scoping calls. We realize that many of you
This isn't a SQL Server related post, but I wanted to let you know about a new conference that's starting in December. It's being run
As you may know, we have a mentoring program here at SQLskills (the brainchild of Jonathan), where each of us can pick someone who's attended
That's a quote from one of my favorite comedy shows, Blackadder. With Hurricane Sandy bearing down on the North East Coast of the US today,
For the last few weeks I've been thinking about performance baselines, mostly because I've been producing Erin's new Pluralsight course on Benchmarking and Baselining. It
All kinds of little bits of information have been added to the output of various DMVs, functions, and commands in SQL Server 2012. One which
About a month ago I kicked off a survey with some code to run to figure out how many log files your databases have (see
All of our 2013 public classes are now open for registration! Based on requests from people, attendee ratings of the hotels we used this year,
Several times over the last month, I've been asked about the query that drives DBCC CHECKDB and other consistency checking commands, which has a variable
We can make SQL Server scale really well, but we can’t scale ourselves. Although our Immersion Events are extremely popular, and in high demand, we
In this survey I'd like to see what the distribution of the number of log files per database is for your servers. I'm planning to
(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.) Back in
The SQL Connections Fall show will be in Las Vegas again this year, October 28th through November 2nd. We’ve put together another great show (Kimberly
You may have noticed that my blog’s been pretty quiet in June and empty in July. May and June were frenetic travel and work months
Demand dictates that we hire another SQL guru to join our close-knit, expert team! Specifically, we’ve asked well-known SQL expert and MVP Erin Stellato to
Time flies when you're having fun! August is fast approaching and it brings the last set of scheduled SQLskills Immersion Events of 2012 – Bellevue,
Last week on the MVP distribution alias there was a discussion on undocumented DBCC commands and someone asked why so many potentially useful DBCC commands
(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
Earlier this morning I noticed a discussion on the SQL MCM distribution list (that all the original MCM instructors are part of) that was trying
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.