Archives: May 2013
We are bringing Red Gate, through the free SQL in the City event, to the United States again this year.
This event has been hosted in London multiple times, Los Angeles, New York, Austin, San Francisco, Chicago and Boston. It’s a fun day of training, presentations, and networking, all done… Read more
I’m working on a series of Powershell scripts for the pre-conference seminars on Windows Azure SQL Database that I’m going to be giving at TechEd and the PASS Summit. One of the things I want to do is script out a full backup process (one that’s consistent with transactions)… Read more
You know how we’ve always heard that sp_msforeachtable and other similar undocumented functions may not be supported in future versions of SQL Server? Have you tried running something like this on any of your Windows Azure SQL Databases yet:
EXEC sp_msforeachtable 'select ''?'', count(*) from ?'
Try it out.
No, this isn’t some complaint about PASS or the Summit. This is an announcement that not only will I be speaking at the PASS Summit, but I’m speaking about Azure… a lot.
First up, I’m going to be doing an all-day pre-conference seminar specifically aimed at getting you into Azure.… Read more
Get an invite to a Microsoft meeting? Are they using the new Lync interface? And, you don’t have a paid Office365 account do you? So, you click the link, figure it’ll open a web browser and off you go, right?
Instead it opens up a Lync app that you… Read more
Or, I guess it might be more appropriate to say that Powershell does Azure. Regardless, there are a set of commandlets for Azure and Azure SQL Database. Here’s the link to get you started and the basic documentation. After that, it’s a little tricky to know for sure what’s required.… Read more
I’m trying to improve.
That’s at just about everything too. I know I don’t know enough or have enough skills to always get things done in an efficient manner, so I’m trying to learn more. One way is by reading, a lot. I’ve read a number of management and leadership… Read more
The very concept of the Windows Azure SQL Database (WASD) is predicated on the up-time created by having three active copies of your database. Should there be a hardware or software failure that would cause the primary replica to go down, your database gets moved to one of the secondary… Read more