The SQLCAT team have published another excellent whitepaper – this time the long-awaited one on the SQL Server 2008 data compression feature. Thirteen people inside
There’s still a widely held misconception that when properly in the FULL or BULK_LOGGED recovery models that full or differential backups can truncate the log.
This week's survey is inspired by this morning's Kimberly+Paul hot-tub conversation around data-dependent routing vs. network load balancing, which then turned to SLAs. Yes, we
About a year ago, I blogged a cool script that would work out how much of a database has changed since the last full backup
This week's survey is inspired from many stories I saw on the forums and Twitter this week – mostly bad, one good (someone I'm following
Last week's survey was another two-fold one – when you buy new servers, what architecture to you predominantly buy, and why?; when you buy new
Go to www.wordle.net/create and enter a URL. Here's what it thinks of my current blog homepage: Cool!
I've just been setting up some of our new hardware, and wanted to do some background reading to ensure I use the correct disk partition
A sad, tear-jerky story about how a socially-inept, stay-at-home shut-in, SQL expert gets a new lease of life and finds he really does have friends out
This is a true story, and unfolded over the last few days. It’s deliberately written this way, I’m not trying to be patronizing – just illustrating
Page splits are always thought of as expensive, but just how bad are they? In this post I want to create an example to show
Hopefully all of you reading my blog already know to use the WITH ALL_ERRORMSGS option whenever you run DBCC CHECKDB (which is now the default
This week's survey is another two-parter, part 1 of which suggested by Mike Walsh on Twitter: When you buy new servers, what archictecture do you
Another quickie today. If you're using Activity Monitor in SQL Server 2008, or Performance Data Collection with the Server Activity system data collection set, then you may
This has come up a few times now, most recently in an email question this morning – subsequent runs of DBCC CHECKDB show varying numbers of
Jason Massie posted an interesting statistic yesterday – Facebook has 1.5 petabytes of image storage, and it grows by 25TB daily – I wonder how
In one of our visits to Bangkok this year, we toured the Imperial Palace. I uploaded a bunch of photos to Facebook of statues that
Here's an interesting bug that was just recently fixed, and someone actually hit it today, so it's time to blog it. Bottom line is that
Finally! All those customers out there who are frustrated by not being able to turn on the 'lock pages in memory' option to protect the
A short post to start the day (in India) and then at lunchtime I'll do how it works: FILESTREAM garbage collection. This is a question
Every so often (well, ok, very frequently) my internal list of ‘I must blog about that’ gets too big and I have an almost
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.