About Microsoft SQL Server management, database administration, and how to get things done.
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: 8 [...]
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 just told [...]
A lot of cool things are happening at PDC this year, and Amazon’s already showing their cards: Amazon EC2 will offer Windows hosting.
That means you can turn on a brand new Windows machine - or ten - and pay by the hour according to the capacity you’re using. Less than a dollar an hour in [...]
I don’t have much insight to add here, but it’s something my readers are probably into: Oracle now supports running on Amazon EC2. They’ve got prebuilt EC2 instances that you can just turn on, a cloud management portal, and licensing options.
This is such a cool time to be a database administrator. I can’t wait for [...]
I blogged about why database administrators should use Twitter, and I personally loved that tool. It helped people build faster personal connections with each other, and it helped you get a picture of what the brilliant people were thinking at any given time. Take Brian Knight, a SQL Server guru, for example - I love [...]
I'm the Editor-in-Chief at SQLServerPedia, a SQL training resource. You can read my resume, but all you really need to know is that I have a SQL license plate.
