Four years ago I wrote about the DBA Plate, which was a reference to the food plate that replaced the food pyramid right about the time the U.S. Congress declared pizza to be a vegetable. I had every intention of keeping the plate updated annually but never got around to doing so because reasons. Well, today is the day. You’re welcome.
I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience? We already know that great judgment comes from great experience, and great experience comes from bad judgment. That means … Read more
Did you know table and index statistics are the most important piece of metadata for your database? The reason for this has to do with how SQL Server (and other database engines) build query execution plans. The query optimizer builds an execution plan based upon the statistical data available at the time. If you have … Read more
When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.
Just a quick post for some Friday fun. If you want to know how to do database mirroring right, start with this MSDN link: http://msdn.microsoft.com/en-us/library/ms189852.aspx And if you are thinking of buying yourself a nice book on Christmas on database mirroring, I’d recommend this one: Pro SQL Server 2008 Mirroring
Tomorrow is Thanksgiving here in the USA. It’s a day where we are supposed to be thankful for what we have been given and instead we mostly use it as an excuse to eat obscene amounts of food, watch 10 hours of NFL action, and force retail workers to work longer hours in the name of … Read more
