Thinking at the Database Level

With SQL Azure, you’re no longer in charge of the Instance of SQL Server that you’re running on. You’re dropped into your environment at a database level. Also, the size of those databases are more restricted than you might be used to for your on-premise system (Keep in mind that SQL Azure has a set…

0

SQL Azure and On-Premise Solutions – Weighing your Options

Since the introduction of SQL Azure, there has been some confusion about how it should be used. Some think that the primary goal for SQL Azure is simply “SQL Server Somewhere Else”. They evaluate a multi-terabyte database in their current environment, along with the maintenance, backups, disaster recovery and more and try to apply those…

2

A Cloudy Day In My Life

Since my team started work on Project Houston hardly a day goes by I’m not in some discussion about the Cloud. It also hits me when I go through my RSS feeds each day: cloud this and cloud that. There is obviously a significant new trend here, it may even qualify as a wave; as…

0

SQL Azure Marches On

I follow the Database Trends and Applications magazine because it is pretty platform independent, with a section for Oracle, SQL Server and DB/2. I found it interesting that when I turned there yesterday and today, among the top stories are “Cloud” – front and center. It’s easy to see why. When we think about technology…

2

Migrating to SQL Azure

As Mary Jo Foley recently reported migrating to SQL Azure just got a little easier with the latest version of the SQL Server Migration Assistant (SSMA), released on August 12. Included in the update are the typical cast of source databases: Oracle, Sybase, and Access. But there are two new things. First, MySQL was added…

0

SQL Server 2008 R2 Overview and Whitepaper

I know, SQL Server 2008 R2 was released some time back, but with so much content out there I thought I might simplify it a bit. I’ve written a complete overview that you can read through in about 10 minutes, and there’s a great new whitepaper on one of the main features, PowerPivot. Thought I’d…

0

Introducing Project Houston

At this point there should be no question that Microsoft is fully embracing the cloud. Windows Azure and SQL Azure launched earlier this year and have been receiving positive feedback. I’ve been happily using SQL Azure for several months. One of the great aspects of SQL Azure is the integration with the standard tooling, e.g….

0

Giving Back

Most of us have some help we can provide back to the community. Even if you’re new, you can write down some of the things you’ve learned. And there are several easy ways to to that – you can certainly jump in on the forums (http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/) and answer any questions you know the answer for…

0

The SQL Server Best Practices Analyzer and Policy Based Management

The SQL Server Best Practices Analyzer (BPA) came out for SQL Server 2008 R2 recently, and I’ve been asked what the difference is between the BPA and Policy Based Management (PBM) that was introduced in SQL Server 2008. While it’s true both of these tools can do similar things, each has strengths and weaknesses. The…

0

The "Dallas" information marketplace

Today I’m here in Washington DC, demo-ing in Bob Muglia’s keynote at our Worldwide Partner Conference. This time, I’m showing something quite new – not just a new product, but a new concept in data – Microsoft’s premium information marketplace codenamed “Dallas.” “Dallas” may be better known as a village of 200 or so people…

0