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…


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

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

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…


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…


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…


SQL Server Resources: The Developer’s Training Kit (Not just for Developers!)

One of the great things about using SQL Server is the amount of resources you can find for it. One of those resources is the Developer’s Training Kit – and there’s a new version of it that you can download and learn from. This kit is full of  videos, demonstrations, labs and sample code that you can…


Community and the SQL Server Presence

You’ve probably seen some press lately about how pervasive Microsoft is in lots of areas (here, here and here). We’ve also seen SQL Server show up in more and more enterprises – you can read lots of case studies here. There are lots of reasons that you’re seeing SQL Server numbers grow – we’re less…


SQL Server 2008 R2 Review

I like it when *other* people review Microsoft software. I still volunteer as a DBA, so I still use multiple versions of our own products (and comptetitors, by the way) in the “real world”. That’s how I normally present, that’s how I teach at the University of Washington, and how I work with my Microsoft…


TechEd 2010 (US) Recap – New Orleans, LA

Well, I’ve almost recovered from TechEd this year. I had a fantastic time – learning, teaching and most of all, interacting. I’m really glad that Microsoft stuck with New Orleans – they’ve had a tough go of it since Katrina, but the city didn’t show a trace. It was clean, positive and vibrant. Lil’ Buck…

1