Visiting Scotland (part 2)
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
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.
A few weeks back I kicked off a survey asking whether you have SharePoint in your SQL Server environment at all. Here are the results:
Back in May when we were out in Chicago teaching one of our classes we had a spare day so we drove an hour
Cue spooky music… I used to love the X-Files, where one of the catch-phrases was Trust No One. Their other major catch-phrase was The Truth
Here's a survey I've been meaning to run for quite a while – that Kimberly and I are really interested in. For all the databases
This question came up on the #sqlhelp tag on Twitter today, and it's something I'm interested in too: what percentage of SQL Server environments include
There are several reasons why I’ve drastically cut back on the amount of time I spend in the various online SQL Server forums, including: People
A couple of weeks back I kicked off an off-topic survey about which internet browsers and email clients people use. Here are the results:
Three weeks ago I kicked off a survey about using database snapshots – see here – because I don’t really know how much they’re used or
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.