Viewing Articles with the tag: sql-server
Document Scheduled Jobs with Google Calendar
27.Aug.08 | Leave a Comment
I’ve literally spent years trying to come up with a rational and simple way to document the scheduled jobs that I have running on multiple servers.
My jobs tend not to be anything fancy – in fact, Windows Task Scheduler and the scheduler in SQL Server tend to satisfy my requirements just fine. But lordy, I [...]
Encrypting SQL Server 2005 Backups
11.Jul.08 | 4 Comments
There just doesn’t seem to be an elegant way to encrypt SQL Server 2005 backups. It certainly isn’t a built-in option and I’ve been spending time this week trying to think up something “elegant” to accomplish this.
Allow me to share today’s journey with you.
First Take
Many moons ago I didn’t bother with encrypting my database backups. [...]
Tuesday Misc.
20.Mar.07 | Leave a Comment
Did you catch the new Firefox 2.0.0.3 release today? Based on the release notes, it seems the primary focus was on security. I’ll have to track down the other changes — it seems to be running much better on my work machine since the upgrade (by better, I mean fewer CPU spikes that [...]
… Sometimes You’re the Goat
08.Mar.07 | Leave a Comment
I’ve spent a lot of time during the past couple weeks planning for some SQL Server 2005 upgrades. I’ve set up virtual servers, I’ve mirrored my dev and prod environments. Gone through the upgrades repeatedly. Taken notes on the processes and recruited regression testers. Everything was (if I dare say [...]
Things I’ve learned this week
22.Feb.07 | Leave a Comment
I’ve been tasked with planning and testing a series of infrastructure changes and upgrades. To make some of the testing easier and less disruptive, I’ve been using a couple of VMware products. Sure, I’ve mentioned them here before, but I’ve never spent this much time with them and I’ve really grown to appreciate [...]
