SQL Server Experts - Site Home - TechNet Blogs

SQL Server Experts

  • 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...
  • Buck Woody - Microsoft's "Real World DBA"

    Hello, I'm Buck Woody - Microsoft's "Real World DBA". I go by that title not because I'm a DBA here (we do have a lot of those, though) but because for over 25 years I've worked as a Data Professional. I've worked at organizations from NASA facilities...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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,...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • SQL Server 2008 R2 Free Book from Microsoft Press

    Ross Mistry, a noted author on many Microsoft topics, has his latest book out, and it's on SQL Server 2008 R2. We're able to make that available to you for free in electronic form - just go here to pick up your copy: http://blogs.msdn.com/microsoft_press...
  • 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...
  • Great Example of a Simple Cost-Benefit Analysis

    I saw a post the other day that you should definitely go check out. It’s a cost/benefit decision, and although the author gives it a quick treatment and doesn’t take all points in the decision into account, you should focus on the process he follows....
  • 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...
  • 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...
  • 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,...
  • 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 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...
  • Where Do Your DBAs Spend Their Time?

    In a recent episode of The Big Bang Theory , Sheldon was excited to spend the evening reinstalling the OS and apps on his laptop. My wife asked me if I would find that fun. I had to admit that it wouldn’t suck but there were a number of other things that...
  • 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...
  • 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...