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

    What Has 2 Thumbs & Is Excited About Windows 7?

    • 3 Comments
    Answer: This guy! I’ve been following very closely the press and reviews on the early peaks of Windows 7. I’m not as big of a Vista hater as some people out there. In fact I like the OS. I recently had to reinstall XP on another machine and was absolutely...
  • 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

    Using PowerShell to Get Data & Log File Sizes

    • 3 Comments
    I was playing around with PowerShell today (yes I’m was geeking out on Saturday afternoon) to learn how to access Performance Counters using PowerShell. My mission was to write a script that would return the Data File and Log File sizes for each database...
  • 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

    What kind of DBA are you?

    • 3 Comments
    Buck Woody likes to joke there are two types of people in the world: those who believe there are two types of people and those who don’t. Rim shot please. All joking aside there are two types of DBAs: those who are myopic and those who are leaders. This...
  • 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

    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

    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

    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

    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

    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

    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

    Not Everyone is an Expert

    • 2 Comments
    In my day to day work I interact mostly with experts in the field of database technology and database administration. Every once in a while I get a gentle reminder that not everyone is an expert. Those reminders often come from forum questions from newbie...
  • 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

    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 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

    Disclosure of Security Threats/Vulnerabilities

    • 2 Comments
    I've been having an interesting open dialog with Steve Jones (SQL Server Central) on the issue of disclosing security vulnerabilities. You can read the thread here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=267111...
  • 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

    CD vs DVD

    • 2 Comments
    When you take a look inside a software develop project it's amazing how many decisions are made on a daily basis, how many of those decisions take so long to make, and how passionate people can become about those decisions. During the development of SQL...
  • Dan's Blog

    SQL Server 2008 July CTP

    • 2 Comments
    The July CTP for SQL Server 2008 is no available here . To see what's new in the CTP go here . Download it, start using it and submit your feedback here .
  • Dan's Blog

    Fun with Oracle

    • 2 Comments
    This is a fun and fast read: http://techrepublic.com.com/5254-6257-0.html?forumID=99&threadID=184332&messageID=2080400&id=2926438
  • Dan's Blog

    Goodbye Steve

    • 2 Comments
    I was a fan of the show the Crocodile Hunter and more so of Steve Irwin – if you can really separate the two. I've long admired Steve for following his passion for conservationism and not letting life get in the way. I suppose it's somewhat poetic to...
  • Dan's Blog

    DMF: What's New In The November CTP

    • 2 Comments
    Now that the November CTP is released let's take a look at the new capabilities in DMF. The first thing you'll probably notice is the Policy dialog received a facelift. We spent some focused time on the GUI to fine tune it and make it more user friendly...
Page 3 of 9 (203 items) 12345»