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

    Oracle Unbreakable == Oxymoron

    • 2 Comments
      And I ask once again… why do people run Oracle? http://www.businessinsider.com/yikes-oracle-issues-emergency-fix-for-a-big-fat-security-problem-2012-1?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+businessinsider+%28Business...
  • 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

    SQL PASS PowerShell Session Materials

    • 1 Comments
      The presentation and scripts can be found here . Two questions came up which I couldn’t answer on the spot: 1) what is the load precedence of profiles and 2) what PowerShell books would I recommend.   Profile Load Precedence http://msdn.microsoft...
  • Dan's Blog

    Be a Virtual SQL Server Team Member

    • 3 Comments
    I’ve been blogging here and here about testing Denali CTP3. Here is a recent picture of the SQL Server team – though it’s not everyone on the team. These are the people behind the magic of SQL Server. By downloading Denali CTP3, testing, and filing bugs...
  • Dan's Blog

    Have you Downloaded SQL Server Denali CTP3?

    • 2 Comments
    At the end of August we released CTP3 (Community Technology Preview) of the next release of SQL Server codenamed Denali. You can download it here . This is a feature rich CTP and is deserving of your attention, though I can’t discuss where this falls...
  • Dan's Blog

    Help Make SQL Server “Denali” The Best Release Yet!

    • 3 Comments
    Bugs reported by the community have played a huge role in the amazing quality of past releases of SQL Server. In SQL Server 2008 we fixed over 1,000 bugs submitted by the SQL Server community prior to release. And in SQL Server 2008 R2 we fixed over 300...
  • Dan's Blog

    SQL Server codename “Denali”–“Product Update”

    • 0 Comments
    There’s a great new feature in the next release of SQL Server (codename “Denali”) which integrates the latest product updates into the initial installation experience. This feature came online in the CTP3 release. We need your help testing this feature...
  • Dan's Blog

    Day 13 on the Job

    • 2 Comments
    Today is my 13th day in the new job as the community lead for the Business Platform Division. It has been a filled 13 days – in a very good way. I’ve been working closely with my team to get educated on community and to begin to formulate our community...
  • Dan's Blog

    MVPs: Evangelists in Sheep’s Clothing?

    • 5 Comments
    I was recently talking to a co-worker and I characterized MVPs as evangelists, among other things. I got a very strong reaction - negative. I know full well this posting is going to rub some MVPs the wrong way – like petting a cat against the grain! However...
  • Dan's Blog

    Pilot Projects

    • 2 Comments
    I spent the first eight years of my career in enterprise IT for a Fortune 15 company. Back then IT was a vibrant work environment. Money was flowing into IT to fund resources, software, hardware and vendors. Today it’s a different story. The mantra for...
  • Dan's Blog

    SQL Server Code Name “Denali” – Supported OSes and Upgrade Paths

    • 45 Comments
    We are looking for feedback on three items for SQL Server Code Name “Denali”. First, are the supported OSes . Second, are the supported upgrade paths . Third, is the way the installer handles unsupported OSes and upgrade paths . Specifically we want to...
  • Dan's Blog

    Forgot Your Password?

    • 1 Comments
    I’ve seen three basic patterns for handling forgotten web site passwords: Send a change password link to the email address on file Ask one or more challenge questions (or personal information) to unlock the change password screen Send the password, in...
  • Dan's Blog

    Best Practice Policies for Policy-Based Management

    • 1 Comments
    Policy-Based Management (PBM) was introduced with SQL Server 2008 – it’s a declarative system for ensuring the system configuration hasn’t drifted from the original configuration intent.  You can read more about Policy-Based Management in SQL Server...
  • Dan's Blog

    Loading SQL Server Snapins into your PowerShell Session

    • 4 Comments
    Caveat: I don’t write code for a living. But I do know how to get things done, usually using brute force. SQLPS.exe is a decent environment, but sometimes I want to work in the default PowerShell environment. But if I want to work with SQL Server in the...
  • Dan's Blog

    Oy vey – Poor Security Habits Highlighted Again

    • 0 Comments
    The March 2011 issues of Database Trends and Application has an article that highlights the results of a new survey of DBAs and DBA Managers that reveals complacency results in lax oversight of sensitive information. You can read the article here . While...
  • Dan's Blog

    Changing Service Account & Service Account Password

    • 2 Comments
    I recently botched an answer about why one should use SQL Configuration Manager (SQLCM) over Service Control Manager (SCM) to change service accounts and/or service account passwords for SQL Server. Let me attempt to redeem myself. If your running SQL...
  • Dan's Blog

    SQL Server Express: Dev or Prod?

    • 1 Comments
    Most people I’ve spoken to have at least heard of the Express edition. The next question I ask is where they’re running it: development or production? The answer is usually both . But when I drill into the production use it turns out that most of the...
  • 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

    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

    Database Schema Help

    • 2 Comments
    I’m testing out some new stuff and I need your help.Do you have a schema that has a bunch of complex dependencies between objects such that it’s a real pain when you need to alter it – you have to figure out the dependencies, unhook them, make your change...
  • Dan's Blog

    SQL PASS Summit Focus Groups

    • 0 Comments
    This year during the PASS Summit we (Microsoft) will be conducting a bunch of focus groups. This is a great opportunity to meet face-to-face with folks from the SQL Server team and impart your knowledge on them. You can find a list of Focus Groups here...
  • Dan's Blog

    Project “Houston” Grows up to become Database manager for SQL Azure

    • 0 Comments
    I’ve blogged before on Project “Houston” ( here and here ). at PDC this past week we announced that as part of the Developer Portal refresh Project “Houston” will be known as “Database manager for SQL Azure”. Database manager is a Silverlight client ...
  • 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

    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

    Moving Databases Between SQL Azure Servers

    • 5 Comments
    This week I had to move a couple of databases between two SQL Azure accounts. I needed to decommission one account and thus get the important stuff out before nuking it. My goal was straight forward: move two databases from one SQL Azure server (and account...
Page 1 of 9 (203 items) 12345»