Dan's Blog

I am Principal Program Manager at Microsoft leading the Business Platform Division's (BPD) community team. BPD includes SQL Server, SQL Azure, BizTalk, AppFabric, and other technologies and services.
  • Dan's Blog

    Central Management Servers => Shared Connection Favorites

    • 3 Comments
    Back in SQL Server 2008 my team implemented the Central Management Server (CMS) feature. If you work as part of a DBA team and you haven’t tried it out I encourage you to do so. It’s available on all editions, even Express. In short, the CMS allows you...
  • Dan's Blog

    Bye-bye beta, bye-bye... That was all she wrote...

    • 5 Comments
    http://www.microsoft-watch.com/article2/0,2180,1938275,00.asp This is absolutely awesome. As someone who loves customer feedback, the CTP process rocks! It requires us to keep the quality of main extremely high. It provides a rapid feedback loop so...
  • Dan's Blog

    82 - The Magic Number

    • 0 Comments
    Check out this posting: http://blogs.washingtonpost.com/securityfix/2006/01/oracle_issues_w.html There are so many comments I want to make but I'm going to refrain. I'm just flabbergasted that anyone still runs Oracle.
  • Dan's Blog

    SQL Server Project “Houston” & SQL Azure

    • 0 Comments
    In this video from TechEd 2010, Group Program Manager Patric McElroy demos some new and future SQL Azure capabilities. It’s worth watching the entire 80 minute video but if you only have 6 or 7 minutes then the piece you won’t want to miss is Project...
  • Dan's Blog

    Vendor Lock In or Ignorant Design?

    • 3 Comments
    I often hear people say '”I’m not going to use Microsoft stuff because the don’t want to become victim of vendor lock in.” They often chose “open source” alternatives for pieces of the stack (web server and database to name a few). This isn’t necessarily...
  • Dan's Blog

    Best Practice: Naming Constraints

    • 3 Comments
    Within SQL Server there are a number of different types of constraints: CHECK DEFAULT FOREIGN KEY PRIMARY KEY UNIQUE The reference for CREATE TABLE can be found here . Now what’s interesting about constraints is when creating a constraint the name is...
  • Dan's Blog

    Scenario-based Design Makes the Product

    • 1 Comments
    The May 2006 issues of Business 2.0 has a few interesting stories that while on the surface don’t seem to be related are in fact incredibly related. However, first, there is good news for all those DBAs out there. One of the articles in this edition is...
  • Dan's Blog

    Scrum Rocks

    • 0 Comments
    This week we held our first full blown scrum planning meeting. This was a 4 hour meeting with almost the entire team (Dev, PM, Test, UE, and UX). I say almost because test wasn’t fully represented. See we now utilize a centralized test group – resources...
  • Dan's Blog

    What's A Customer and How Should We Connect?

    • 0 Comments
    Doug Barney recently wrote in the magazine Redmond that “[Microsoft] should formally and publicly engage customer in the design process - sort of an open source front-end to a commercial project.” He also wrote, “does Microsoft listen to customers? Absolutely...
  • Dan's Blog

    SQL Server 2008 Launch T -1 Day

    • 5 Comments
    Tomorrow is the big day. I have the demos about 95% locked and loaded. Unfortunately one of the cool features isn't going to make the demo. It's just not ready - BUMMER! But two others look like they'll make it. One is a nice thing and will likely get...
  • Dan's Blog

    SANS Top 20 is Sans SQL Server

    • 3 Comments
    Far be it from me to poke the sleeping bear, but when I hear good news about the product I work on I just have to share it. I think common folk call what I'm feeling "pride". I'm happy to go with that. So what's this good news I speak of? SQL Server didn...
  • Dan's Blog

    Rock the Launch!

    • 1 Comments
    Yeah Baby! The launch event was fantastic; so much energy; so much excitement; so much buzz. One of the most important aspects of a launch event is the live entertainment. Remember, the Windows 95 launch? The Rolling Stones played live. That was pretty...
  • Dan's Blog

    Bad Oracle Administrator

    • 0 Comments
    http://www.zdnet.com.au/news/security/soa/Oracle_no_longer_a_bastion_of_security_Gartner/0,2000061744,39234277,00.htm I guess I now know why Oracle customers aren't up in arms over the lack of fixing security holes. Even when Oracle does get around...
  • Dan's Blog

    The Power of Internal Tools

    • 2 Comments
    Why is it that people let limitations in internally developed tools prevent progress? Yes, that’s more of a rhetorical question than anything else. But there is a part of me that would love the definitive answer to this question. When a team goes through...
  • Dan's Blog

    Designing for Security

    • 2 Comments
    I just finished reading this article on NoSQL security. It raised a couple of concerns: 1. Systems require security. Hard stop. no if’s and’s or but’s about it. Designing security from the start is a hard task. At Microsoft there are several practices...
  • Dan's Blog

    Where to go next...

    • 0 Comments
    I've been meaning to post for some time, however, I've really been struggling with where to go next. I'm sitting in a transition between Setup/Upgrade and Manageability. I have a bunch of setup knowledge I could share, including some topics like: ...
  • Dan's Blog

    SQL Server 2005 Launch T -3 Days

    • 1 Comments
    The SQL Server 2005 Launch kick-off event is just a few days away. You can view all of the launch details, including venues and cities at http://www.microsoft.com/events/2005launchevents/default.mspx . I couldn’t be more excited for this launch. I joined...
  • Dan's Blog

    Welcome

    • 0 Comments
    Welcome to my blog. I'm a lead PM on the SQL Server team so my focus will be on SQL Server. Initially the content will focus on setup and installation. However, I recently transitioned on to the manageability team and will be focusing my efforts on SQL...
  • Dan's Blog

    Zero Tolerance for Ignorance, Laziness and Unprofessionalism

    • 2 Comments
    How many databases in the world do you think are storing your personal information? Tens? Hundreds? Thousands? I have no clue what the answer is but my guess is it’s closer to thousands than tens. Why is this an interesting question? In my line of work...
  • Dan's Blog

    Launching Vanilla PowerShell from SSMS

    • 0 Comments
    One of the criticisms of our PowerShell implementation is the integration with Management Studio launches our custom minishell. With just a few simple key strokes you can add a custom tool menu item and toolbar button. To do this select "External...
  • Dan's Blog

    SQL Server 2005 Launch Site

    • 0 Comments
    The SQL Server 2005 launch site is now available: http://www.microsoft.com/windowsserversystem/applicationplatform/launch2005/default.mspx . There are great resources here for SQL Server 2005, Visual Studio 2005, and Biz Talk 2006. You can find a launch...
  • Dan's Blog

    SQL Server MVPs–Thank you for what you do!

    • 5 Comments
    I follow the blog and/or Twitter of many of the SQL Server MVPs and to be blunt this is a truly amazing group of professionals. Their passion for SQL Server is undeniable. Their desire to expand their already deep knowledge of the product is unsurpassed...
  • Dan's Blog

    SQL Server Express Could Earn you $100

    • 2 Comments
    Seems like it's a good time to start using SQL Server Express. Want a chance to show off a cool project you’ve created using Visual Studio or SQL Server Express? We’re looking for your stories! Tell us about something that makes your life easier or...
  • Dan's Blog

    Scripting DBA Actions

    • 4 Comments
    Last Thursday morning @ the PASS Summit I participated in a panel discussion on automating DBA tasks. It was a great discussion and I was humbled by the other panel members. During the discussion I jotted down a few notes that I didn’t get to mention...
  • Dan's Blog

    “SQL Server 2005 is secure!”

    • 3 Comments
    This is a great interview with David Litchfield. I was recently in a review with Bob Muglia, Senior VP for the Server and Tools business, where the SQL team presented there had yet to be a security GDR for SQL2K5. Bob asked if it was because the product...
Page 3 of 9 (203 items) 12345»