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

    Refreshing the IntelliSense Cache

    • 18 Comments
    There are cases where the local cache used by IntelliSense becomes stale. Refreshing the cache is easy but not necessarily obvious. There are two ways to refresh the cache: 1) Go to Edit -> IntelliSense -> Refresh Local Cache and 2) Hit Ctrl+Shift...
  • Dan's Blog

    SQL Server Management Studio Startup Time

    • 30 Comments
    Note: This posting only applies to Management Studio 2005. We have corrected the behavior for Management Studio 2008 thus there is no special configuration necessary. One of my co-workers recently responded to a problem a user was having with SQL Server...
  • Dan's Blog

    The New SQL Server Branding

    • 8 Comments
    When it comes to branding and images I'm incredibly critical. IMHO or is that IMCO (In My Critical Opinion) the new SQL Server Branding is fantastic. It is much better than the orange blocks found in the SQL2K5 branding - yuck! My understanding is it...
  • 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

    Where The Heck is Activity Monitor?

    • 11 Comments
    You're sitting at your desk rocking out to great music, you've just installed Management Studio 2008, you expand the Management node and start to click on Activity Monitor... Wait a second, What the %&*$#@, where's Activity Monitor? Did those goofs...
  • Dan's Blog

    The SQLPS Firestorm

    • 11 Comments
    Within the PowerShell community there's a firestorm raging over SQLPS.exe our mini-shell that we're introducing in SQL2K8. In his blog Michiel does a good job explaining the mini-shell and provides a script you can use to register the SQL Server provider...
  • Dan's Blog

    Where the Heck is DMO?

    • 4 Comments
    You've installed SQL Server 2008 on a clean machine and your vb script that uses DMO doesn't work. You're asking yourself: What the heck happened? Did those goofballs over @ MS hose me? Deprecation of DMO was announced in SQL Server 2005, but SQL Server...
  • 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

    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

    Getting Your "Favorite" SQL Server Bug Fixed

    • 10 Comments
    As a PM in SQL Server I read through just about every bug entered for the components my team owns. Given the surface area of what my team owns this translates into a lot of bugs. I don't characterize it that way to disrespect the team or the quality of...
  • Dan's Blog

    PowerShell vs. T-SQL or Why Did We Add PowerShell Support in SQL2K8

    • 11 Comments
    The following write-up was originally an email I sent to Allan White (SQL Server MVP) in the context of a discussion on PowerShell and some of the PowerShell community postings questioning why SQL Server needed PowerShell support @ all given the strength...
  • Dan's Blog

    New SCOM Management Pack for SQL Server 2005, 2008, 2008 R2

    • 0 Comments
    Last week we released an updated, almost completely revamped, System Center Operations Manager Management Pack for SQL Server 2005, 2008, and 2008 R2. You can find all the details on the download page here .
  • 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

    SQL2K Side-By-Side with SQL2K5

    • 4 Comments
    I've seen this question come up a lot in the newgroups: "I already have SQL Server 2000 installed, can I install SQL Server 2005 side-by-side with SQL Server 2000?" The short answer is yes. SQL Server is a multi-instanced product which means that with...
  • Dan's Blog

    SQL Server 2008 Launch - The Day After

    • 14 Comments
    Wow! Let me say that again: Wow! What a day it was yesterday. Here are some general comments about the launch. If you just want to know what the 3 surprise features were that I showed yesterday (actually I could only demo two) scroll to the end... There...
  • 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

    Application & Multi-Server Management

    • 0 Comments
    @ the SQL PASS Summit on 11/20 we announced our plans to release new capabilities for improving the collaboration between Data-Tier Developers and DBA and to address Multi-Server (or multi-instance) manageability for SQL Server. Anthony Carrabino has...
  • Dan's Blog

    SQL2K5 SP1 Is Now Available

    • 4 Comments
    SP1 has been released! The release includes Management Studio Express, Express Edition with Advanced Services (Full-text Search and Reporting Services) and Express Edition Toolkit (necessary for building reports for Express Edition with Advanced Services...
  • 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...
  • Dan's Blog

    Management Studio & More

    • 10 Comments
    In SQL Server 2005 we rewrote Enterprise Studio into what is now called Management Studio. One of the major pieces of work was the consolidation of the administration of all services (Database Services, Analysis Services, Reporting Services, and Integration...
  • Dan's Blog

    Lenovo Thinkpad X301

    • 7 Comments
    A few weeks ago I got a new laptop – a Lenovo x301. As is the case with all new machines it came loaded with a bunch of utilities and trial software. Most of the time I just nuke the machine right away and lay down a clean image of the OS. This time I...
  • Dan's Blog

    Is the Slipage in the SQL2K8 Release Date a Big Deal?

    • 19 Comments
    A few weeks ago we annouced an adjustment to the release date for SQL2K8. Many blog postings made a big deal about this. There were several consipiracy theories floating around. I'm not really sure why. If you spent more than a minute and thought about...
  • Dan's Blog

    PCI Compliance and SQL Server 2008

    • 1 Comments
    Today compliance is a huge focus area for IT. Since compliance is written by lawyers for lawyers it takes a fair amount of translation to get it to the point where IT can understand what processes, policies, and configuration to implement to meet the...
  • Dan's Blog

    Custom Reports in SQL Server 2005 SP2

    • 0 Comments
    We introduced a cool new feature in SP2 of SQL Server 2005 that lets users access their own reports from within Management Studio. This adds tremendous value to the environment letting users create custom views. People have started using this feature...
  • Dan's Blog

    How We Developed SQL2K8

    • 12 Comments
    I've been wanting to write this blog entry for some time now and just have never found the time to sit down and do it. Well today seem like as good a day as any to do it. I'm not focusing on the entire SQL server development process but rather give you...
Page 1 of 9 (203 items) 12345»