Archives: July 2013
I’ve got a couple days off, starting today after my webinar on Preparing for When Disaster Strikes. I’ve got some family in town, and since I haven’t taken vacation in some time, I’m looking forward to being unwired for a couple days.
On Thursday my daughter and I head… Read more
I’ve been a big fan of nuclear energy ever since I worked at a power plant. Before that I was terrified and didn’t think it was a good idea, but I learned quite a bit about how it works and while there are issues, I think it’s a good source… Read more
Next week I travel to Sacramento, CA for the SQL in the City Seminar – Stairway to Deployment on Friday, July 26, 2013. It’s a half day event where Grant Fritchey and I will look to lead you through the idea of implementing continuous integration and continuous deployment for databases… Read more
One of the things that’s bothered me is the way the charms bar frequent popping out as my mouse moves to the upper or lower right. I do this as I’m trying to reach the “x” to close a window or adjust time zones. The bar pops out and it’s… Read more
I saw a post recently where someone noted they had moved tempdb like this:
USE master; GO ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = 'c:\tempdb.mdf'); GO ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = 'c:\templog.ldf')
This gives you the… Read more
It’s just two weeks until my next trip. It feels like I just got back from London, and one again I’m prepping to leave again. This is my only trip in July, which I appreciate. It’s been a busy year so far, with lots of travel for me and I… Read more
Test your restores: he first tip in my Hard Earned Lessons of a DBA piece.
I can’t emphasize this enough. I’ve been called in as an employee and consultant to companies that never had tested a restore. Quite a few of those times there has been data loss.
It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate, write a post on the topic and publish it on the second Tuesday of the month. If you’d like to host, contact Adam.
This month the topic is hosted by… Read more