Category: Uncategorized

I was listening to the announcement of SQL Server 2008 R2 yesterday on a call from Microsoft. It was released to manufacturing, downloadable on May 3. While listening and making notes, I wandered over to the Microsoft SQL site and was surprised to find a video montage of the Tweet-up I attended in Bellevue a couple of weeks ago.

It was an interesting event and I’d like to do it again.  I almost didn’t go after a crazy month of March for travel, but I was curious what was worth Microsoft flying 8 of us to Bellevue for a day.

It turned out to be a fun event. A wine tasting mixed with an R2 briefing and discussion of the product. Donald Farmer and Dan Jones led the briefing, while we tended to joke and make fun of them, but also talked about the product. We were tweeting like mad while this was happening, in between sips of wine, of course, and it was fun.

But it was too late in the day. Starting at 5pm PST, most of the East coast had gone home, so we had very little interaction from outside the room. We heard a few things later on from others, but the spontaneous nature of the event was lost a bit.

I think it was an interesting idea, and I would like to do it again, perhaps even at something like the PASS Summit or TechEd.

Microsoft scheduled a conference call this morning, and I jumped on since I was laid up in bed with a pinched nerve in my neck. What else did I have to do?

Actually I had work to do, but I was in pain much of the night and this morning, so I listened in on the call on the, iPhone, using the semi-multitasking capability to tweet while it was on speaker.

I had suspected this was the announcement, and it was true. They announced the RTM of SQL Server 2008 R2, which made sense since the launch was supposed to happen with the PASS Europe Summit this week. I had suspected delays after hearing the date announced as May 21 at UK Tech Days, but apparently that wasn’t the case.

I saw a blog on ZDNet that mentioned they actually finished last week, but held off until this week to make the announcement.

You can read the press release (boring) or check out the SQL site at Microsoft (more interesting) for more information. One neat announcement that I liked was the growth in the size of Express databases to 10GB. Since most dbs are apparently under 2GB, this is great news for many companies that can use this version for small, departmental apps.

In the past, when I’ve set up log shipping, it was primarily as a DR device, designed to get copies of logs to another server ASAP. The idea being that if we had an issue on the production server, we could switch to the secondary server quickly and lose minimal working time for the company.

To that end me, and most everyone I knew, restored those logs ASAP. If you ran log backups every minute, you didn’t want more than a couple of minutes before you could bring the secondary online and start moving clients over.

That’s a good process, though to a large extent it has been superseded by database mirroring for quick recovery on another server. Mirroring also includes the ability to automatically direct clients to the mirror server, which isn’t something log shipping can do.

However you don’t always want to restore those logs immediately. Not all disasters require you, or even force you, to switch servers. Consider those “accidental” disasters. What do you do if a user deletes all customers, or the DBA accidently sets all orders to the same quantity because they forgot a WHERE clause?

If you restore immediately, those changes are likely applied on the secondary server before you can even contact the DBA, or make a remote connection to the secondary server and shut off the log shipping process.

If, however, you have, say a 3rd database, one that delays restoring logs for an hour or two, you’ll still have that original data on that server. Even if you’ve made some changes in the last few hours, you could “catch up” all the logs except for the one where you made the mistake, and then move that data over with an SSIS Wizard package.

That might save you a lot of time, or explanations, when you do make a mistake. And rest assured, sooner or later you will.

I feel like I have some bad digital karma lately. In the past week I’ve had these downed systems:

• iPod iTouch
• Lenovo Laptop
• Acer laptop
• Windows Home Server

To be fair the Windows Home Server died just before we went to the UK and I hadn’t had time to mess with it. But it seems that almost everything I touch lately is dying.

Sometimes that’s how it goes with hardware.

It’s a little better now. Both laptops are working, and the Home Server is back online. The iPod is working, though it’s still at OS 2.1.2 instead of 3.1.3, which was my hope. Oh well, I think a Genius Bar call is in order next week.

The Home server consumed a few hours as I tried to diagnose which drive was down. I pulled them all out, dropped them in my external SAT harness and the 1TB was readable. That was cool, and I copied off my data. However the 2TBs weren’t.

I tried both laptops, x64 and x86, and neither of them would read the drive. I mucked around a bit before giving up and just putting them back in one at a time to see which one was working.

The iPod was more annoying. I tried the upgrade and it bricked. It wouldn’t restore on that machine, so I used a second machine to restore it as a new iPod, then tried the upgrade again. Same result. It’s unbricked, and synced again, but not upgraded, and that annoys me. I’ll call Apple next week.

The laptops are more interesting. I was trying to clone a drive and get an SSD into one of them, so I was moving around drives between laptops. I managed to get in a state where neither of them would boot, but I put everything back and managed to get them working.

I also got the SSD installed, with a post coming up on that experience.