Last fall, I spoke at the SSWUG Virtual Conference and had a really good time with it, so I signed up again to do the Spring SSWUG Virtual Conference too. Here's how it works: I fly out to Tucson to record my sessions in
Last fall, I spoke at the SSWUG Virtual Conference and had a really good time with it, so I signed up again to do the Spring SSWUG Virtual Conference too. Here's how it works: I fly out to Tucson to record my sessions in
Ah, spring - that time of year when young men's thoughts turn to T-SQL. The next SSWUG V-Conference will be April 22-24th, and I'll be giving a few sessions: Log Shipping To The Cloud (300-level) In an ideal world, we'd have a standby SQL Server in a disaster recovery datacenter, but we can't always afford that ...
This week I presented at the SSWUG Virtual Conference on how to benchmark your storage performance with Microsoft's SQLIO utility. Last week I talked about running SQL Server in the cloud on Amazon EC2. Take those two things together, and we've got storage benchmarking on Amazon EC2 servers: Maximum write speed: 68 MBs/sec Maximum read speed: ...
Sometimes you need an offsite database server in case something goes wrong, but you can't afford a full-blown disaster recovery datacenter. Or maybe you've got some ideas that you'd like to try out with a big SQL Server 2005 box, but you don't have the hardware sitting around idle. Or maybe you'd just like to ...
You can now spin up a virtual server in Amazon's datacenter with Windows running. Even better, you can spin up a fresh new SQL Server for around $1 per hour. Amazon Web Services Blog announcement on Windows support Amazon EC2 description with Windows and SQL Server pricing And of course, this comes on a day when I ...
A few months back, Microsoft gave MVPs a few MSDN Ultimate subscriptions to pass on to community members, no strings attached. I quietly gave mine to a few deserving folks who I thought could be future MVPs, but Arnie Rowland (Blog – @ArnieRowland) had a better idea. Arnie’s Project Phoenix encourages developers to propose a [...]
Read More »A few months ago, I had The Idea. I wanted to conduct SQL Server training on a cruise ship. I emailed a few buddies and offered to start a company called SQLCruise with them, and out of three friends, only one could say yes. I don’t have anything against the two who said no. I [...]
Read More »Most SQL Server DBAs don’t even like MySQL, let alone NoSQL. They cringe when they hear people say things like, “I don’t need transactions” or “The data will eventually be consistent” or “Indexes will be supported in the next version.” SQL Server and Oracle people are constantly trying to out-feature each other, and the abject [...]
Read More »In August 2008, Lady Gaga released her premier album The Fame. This 13-track work produced several hit singles including Just Dance, Poker Face, and Paparazzi – but it also produced plenty of controversy. Her exaggerated use of fashion, musical cliches, and sex gave her plenty of media attention – both good and bad. If you’ve [...]
Read More »Pop quiz: should you be worried if your SQL Server’s page life expectancy is averaging 214? There’s only one correct answer: it depends.
Performance tuning is all about finding the RIGHT bottleneck, focusing on it, and fixing it to the application owner’s satisfaction. Learn what happens if you don’t do it right.
Read More »