Not much to do here in Tokyo while waiting for the Bangkok flight except read and blog, and I've already done enough reading for one
Microsoft's popular performance troubleshooting whitepaper has been updated for SQL Server 2008. You can download Troubleshooting Performance Problems in SQL Server 2008 at http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docx. I've
At the last few conferences I've presented at, there have been questions about using SSDs (Solid-State Drives) for enterprise storage and whether that will change
This week's survey is a little more complicated. I'm interested in the physical layout of your databases. I've got four surveys, for a variety of database
Last week's survey was on how *you* manage the size of your transaction log (see here for the survey). Here are the results as of 4/10/2009
This is a hilarious video of what Facebook would be in real-life – well worth a couple of minutes for a lunch-time laugh. http://www.youtube.com/watch?v=LrFdOz1Mj8Q Enjoy!
Last week’s survey was on how you should store large-value character data in SQL 2005+ (see here for the survey). Here are the result as
The May 2009 TechNet Magazine is now available online, and it's the annual security issue. In there is an article I wrote highlighting 10 common
In February this year we stopped off in Bangkok on the way to and from teaching in Hyderabad. On one of the days we did some
Jack Li, one of the Senior Escalation Engineers in Product Support, just posted details of an interesting case over on the CSS blog – his article
After teaching some of the MCM-SharePoint class last week, one of the attendees pointed me at a blog post about measuring churn in SharePoint databases.
In this week's survey, I'd like to know *how* you run consistency checks, not how often. I'll report on the results next week (around 3/27/09)
I’m teaching the Microsoft Certified Masters – Database qualification this week here in Redmond, and in part of day one I discuss the FILESTREAM directory
As you may know, Kimberly and I teach (and wrote) the first week of the 3-week Microsoft Certified Master – Database qualification. From next week
Both 2005 SP3 CU2 and 2005 SP2 CU12 contain fixes for two bugs that cause corruption in LOB data. The first bug may happen when
As you may know, DBCC CHECKDB (and some of the other DBCC CHECK*) commands use an internal database snapshot to get a transactionally consistent view
This is an interesting case that cropped up yesterday – the transaction log is damaged so a log backup doesn’t work (with the error below):
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.