Hi Anthony, I was talking about setting up one on the host operating system (in this case Windows 8).

Hi Satha, No, as Robert pointed out in his comment, you can't use standby in that situation. Regards, Greg

I have to say that I continue to be frustrated with finding out how to do things in Windows 8. Here's another one and it's recorded so it might help someone else. I've also documented what I tried so that if anyone from the product group ever reads this, they'll understand how I searched for it and might try to make it easier. I wanted to add a ...

Yes, have always thought so. One looks like it's using an index, the other doesn't.

Hi Megha, It just sounds like the first one isn't getting sent before the data gets updated. That's what the delay was for. In your case it might not be long enough. Regards, Greg

If you have followed any of the Azure website forums, you'd realize that having SSL available was one of the highest rated requests. That's hardly surprising given the number of clients that want to use these sites for eCommerce work. So it's really good to see that Scott Guthrie and the team have been listening and that SSL is now available. The ...

I'm really pleased to see the number of courses that we're offering is increasing. By popular demand, we've extended our Query Performance Tuning and Advanced T-SQL class to Sydney. Previously, we've only been running this course in Melbourne but demand in Sydney for it has continued to grow. For those that might like a Sydney-based offering, ...

One of the things that I've been busy with lately is reviewing a series of upcoming whitepapers from Microsoft. The SQLCAT team today launched one of those whitepapers. It's a performance guide for SQL Server when working with Azure VMs (Virtual Machines). It's great to see that it's been released and you'll find it here: ...

Too true Dan. This was a case of getting back functioning (no-one else around) until I could get the account updated in the morning. The minimum required for a SQL Server service account is: Log on as a service (SeServiceLogonRight) Replace a process-level token (SeAssignPrimaryTokenPrivilege) Bypass traverse checking ...

Yesterday I was at a site where they decided to change the service account for the SQL Server services on a set of systems. After changing the service accounts, SQL Server restarted just fine on all machines except one. I had used the SQL Server Configuration Manager to make the changes (important to not just use the Services applet ...