SQL Server Experts - Site Home - TechNet Blogs

SQL Server Experts

  • 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...
  • 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...
  • 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...
  • 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" -...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • Getting Started with SQL Azure

    I’ve been using SQL Azure for several months now both for messing around (kicking the tires if you will) and for hosting a real database. I have a database with research data running in SQL Azure and I use Excel to connect to the database. I even share...
  • 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,...
  • PowerPivot passes a landmark in downloads

    In the middle of May, just about 6 weeks ago, the SQL Server BI team launched PowerPivot. This weekend, we have we passed an important milestone: 100,000 downloads of the Excel add-in. For a BI application, this really is a huge number. I guess it truly...
  • 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...
  • What’s the Best?

    I monitor a number of different database discussion forums and you can always find a healthy debate on the best database platform. The problem with this question is the answer is always, it depends. It depends on the business and technical requirements...
  • Who is PowerPivot for?

    Ann All recently posted an interesting article at IT Business Edge: Microsoft’s Schizophrenic Approach to Business Intelligence . I’m not too insulted: I tend to agree with Janet Long that, “Part of being sane, is being a little bit...
  • 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...
  • He cares! He really cares!

    I first met Sean McCown when I worked on the team developing SQL Server Integration Services. Sean was simultaneously one of our most active supporters and one of our most trenchant critics. He can very – what’s the word? – very forthright...
  • 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...
  • Going to TechEd - Are You?

    I hope you’re able to join me next week at TechEd 2010 U.S. In New Orleans, Louisiana. I love taking this time each year to learn in an environment where I’m “out of my element”. What I mean by that is I have not only SQL Server...
  • SQL Server 2008 R2 & Office 2010: Better Together

    Mary-Jo Foley recently wrote a blog post about being better together. At Microsoft this is something we take seriously. In her blog post she includes some snippets of an interview with Donald Famer. Donald discussed how we exchanged some team members...
  • The SQL Server Roadmap

    I've mentioned elsewhere that you should be thinking about a "data roadmap". A way of thinking about how you intend to leverage all of that data you're collecting. And in that post I mentioned that Microsoft has a "roadmap" for SQL Server. We...
  • What are your Five?

    "Five" seems to be a big number these days - is it compression to have a "top-5" instead of a "top-ten"? :) Over at Network world they've posted a quick slide deck of "Five things we love about SQL Server R2" . They even include...the Start Menu? OK ...
  • SQL Azure Now Supports Data-tier Applications

    As announced a few weeks ago on the SQL Azure blog , SQL Azure now supports Data-tier Applications which are introduced with Visual Studio 2010 and SQL Server 2008 R2. Here’s a quick tour of the feature. Here’s what I did: Launch Visual Studio 2010 and...
  • Big Bad SQL Server for Small Innocent Businesses?

    Though short, this article in PC World makes an important point: the PowerPivot feature in SQL Server 2008 R2 is incredibly valuable to small businesses. I mentioned in a previous post that in another “life”, in enterprise IT for a Fortune 10 company...