I first started blogging about latches and some of the deeper parts of SQL Server internals last year (see Advanced performance troubleshooting: waits, latches, spinlocks)
During every one of our Immersion Events, we designate Thursday evening as 'open mic' night where anyone can do a 15-minute presentation on anything they
Back in November last year I blogged about Jonathan's idea to mentor someone who's attended one of our classes and how Jonathan, Joe, and I
Spring takes a while to get going in the Pacific Northwest but spring is definitely in the air now that it's May – and spring means
This is part three of my three-part series of posts about what I recommend on a visit to Scotland. I’m writing posts because I get
In my previous post I explained how the sp_configure settings are stored in a special page in the master database called the CONFIG block. Sometimes
Earlier today I blogged on our SQL Server Pro magazine blog about false-alarm corruptions you will *definitely* see if you restore a backup of the
(Sitting in the back of the class while Kimberly's teaching and I'm cranking through my massive backlog of blog posts.) Inside a lave tube with
This is part two of my three-part series of posts about what I recommend on a visit to Scotland. I'm writing posts because I get
A long time ago, in a galaxy far, far away I kicked off a survey about memory configuration. Actually it was back at the start
I’ve blogged about problems with database snapshots a few times previously (see my Database Snapshots category) but here’s a new one that I’ve been meaning
A friend of ours on the SQL Server doc team asked me to recommend some places to visit for their upcoming trip to Scotland so
Back in 2009 I ran a survey about methods of running consistency checks. I recently re-ran the survey to get a better idea of the
Just over thirteen years ago, at the end of January 1999, I arrived in the US on an H1B visa to start working for Microsoft, after
I have a day off today at SQL Connections while Kimberly and Jonathan educate the crowds about SQL Server 2012. I thought I'd mess around
Three years ago I ran a survey about consistency checking methods. A lot has changed since then, including database sizes, 24×7 operations, and a lot
I love getting questions in email about SQL Server. I tell every class that they can send me questions and they'll get a response –
We're just back from presenting three Immersion events back-to-back in Tampa (see Brad Hoff's summary here, Tim Radney's here, and Randolph Potter's here) and while there
Earlier today there was a question on the MVP mailing list asking how SQL Server keeps track of per-column modification counts. From 2008 onwards, the
Yes, it's that time again. We're just about to have the Spring show so its time to start planning for the Fall 2012 show. Once
Yes, really. So what? Several times in the last week I've heard of people denigrating anyone who is still running SQL Server 2000 (paraphrasing): How
(This essay appeared in our latest SQLskills Insider newsletter over the weekend and generated such a lot of discussion that I thought I’d share it with all
Time for another survey – this time around memory configuration. Here is some code to run if you're on SQL Server 2008 and 2008 R2
(A pair of Much-Desired Flabellinas mating.) We spent most of January in Indonesia and as part of the trip we spent 11 days on
Back in January I posted the results of the cluster key size survey I ran in 2011 and explained how the larger the cluster key
We decided to escape the wintery weather in Seattle this year by coming to Indonesia for January (our third trip here), including a long
Back in November I kicked off a survey that had you run some code to get some details about your cluster keys, nonclustered indexes, and
The last post of the year! It's been an excellent year all round – I thought that instead of doing a long post about goals
Back in 2009 I started posting a summary at the end of the year of what I read during the year (see 2009, 2010) and people
Last week I presented for the PASS Virtual Chapter on Professional Development about Communication Skills and the whole thing was recorded via LiveMeeting. It's 70
(2-foot wide Octopus during a night dive off Turneffe Caye, Belize) Kimberly and I headed to Belize in November for our first dive trip
Every so often I do non-SQL blog posts about things and one of the topics that comes up again and again is communication skills. The
It's the end of the financial year for most companies and we've had two companies in the last week approach us about pre-paying for 2012
We’re continuing to add to our 2012 class roster (see the Tampa classes in February/March) and we’re coming back to Chicago by popular demand in Spring
Jonathan Kehayias is such a nice guy. After our recent perf tuning Immersion Event in Chicago last month he had an idea for each of
Continuing with my "index health" series, I've got another piece of code for you to run. This time I'm interested in the number of columns
Yesterday I blogged about how having too few or too many nonclustered indexes can be a big problem for performance (see here). Today I’m posting
Back at the start of August I kicked off a survey (see here) that gave you some code to run to produce an aggregate list of
(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
Yes, it's that time again. We're just about to have the Fall show so its time to start planning for the Spring 2012 show. Once again Kimberly
We’ve started to confirm our 2012 classes, and we’re coming to the south-east of the US by popular demand in Spring 2012! We’re teaching three 5-day classes
Days like this don’t come around very often for us here at SQLskills.com – we’re expanding again! It’s been seven months since Jonathan Kehayias came
I bet you'd love the answer to be "SQLskills.com"? Well now it can be. Over the last few months some of our clients for whom
This is a question that came up today on Twitter, and is actually something I’ve been meaning to blog about. One of the biggest space
The September edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's
We're teaching on-site with a financial client in New York for two weeks and in a session this morning on log file architecture I was
The September SQL Server Magazine articles are now available on the web and include my latest feature article on Using Database Repair for Disaster Recovery.
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.