SQL Server Experts - Site Home - TechNet Blogs

SQL Server Experts

  • My Top Ten SQL Server Bloggers of 2009

    I think I may have set myself an all-but-impossible task: to choose ten bloggers who write about SQL Server, and who have been outstanding in the last year. Nearly impossible, not because I can't find ten, but because there are so many more worthy of...
  • SQL Server 2008 and Windows Server 2008 – A Love Story

    Some things just really work well together. Peanut butter and chocolate. Abbot and Costello. Coffee and...well...anything. You get the idea. But there are some real advantages in using SQL Server 2008 (and of course the upcoming SQL Server 2008 R2...
  • Reviewing SQL Server 2008 R2 RTM

    This past week we released SQL Server 2008 R2 to manufacturing. This is a huge accomplishment for the team and our customers are anxious to get their hands on it. I came across one blog post that expressed disappointment that the only thing they could...
  • SQL Server 2008 R2 Launches!

    It's here! The latest version of SQL Server is out, and it's a big release. This is an exciting time for us - this release is an "R2" - a first for SQL Server. No, it isn't a service pack, and no, we didn't change the product so much that it affects...
  • Virtually Unstoppable

    A friend insists that we'll only know the recession is over when software vendors no longer start every whitepaper with the phrase "In these tough economic times ..." It may be as reliable an indicator as any. Meanwhile, in these tough economic...
  • 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 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" -...
  • 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...
  • Active Thankfulness and SQL Server Professionals

    A few countries around the world have a day set aside for giving thanks - and some do it all year long. We stop to give thanks to those who have made us what we are, and those in the past and present who have given us the benefits that we enjoy. From...
  • New Stuff

    I’ve always loved getting new things. And when it comes to software it’s no exception. I enjoy exploring a new release of my favorite app – see how things have changed and advanced and discovering new features. There are two new things that I want to...
  • Three suggestions for SQL Server DBAs in 2010

    One of these days I really should blog about "dumb questions I have been asked at customer briefings." There's a danger in that, of course: namely, that a customer could equitably blog about "dumb answers I received from Donald Farmer." Nevertheless,...
  • SQL Server Makes the Cover of the Economist

    OK, sort of. I've been a fan of the Economist magazine since a friend of mine in Florida introduced me to it years ago. Imagine my shock when I check out the latest issue and find a story about - Big Data! This is the kind of thing we think about all...
  • The Microsoft / HP Announcement - How does this affect the Data Professional?

    I've been watching with interest the reactions to the new Microsoft/HP alliance that was announced here this week. Being an old-timer DBA, I rarely implement the latest technology, jump on the new bandwagon or react to the latest news quickly. I try...
  • Welcome from Lynn Langit: Who I Am and What I Do Around Here

    I wanted to first introduce myself to the community as an upcoming contributor for the BIEB (Because Its Everyone's Business) blog. My name is Lynn Langit and I have been a Developer Evanglist in Southern Califonia for about 3 years. Prior I ran my...
  • T-SQL Words You Need to Stop Misspelling

    For the last few days my inbox, Twitter and Facebook feeds have been full of advice about which words I should stop misspelling. To be fair, in English, I have relatively little problem, and any misspellings I do make may be sloppy, but rarely result...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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,...
  • 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...