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

    Naming Conventions

    • 1 Comments
    This article on naming conventions - http://www.sqlservercentral.com/columnists/bknight/2687.asp - provides excellent best practice for naming database objects. Do you (or your company) have a set of naming standards that you follow? If so, I'd love it...
  • Dan's Blog

    SQL Server 2008 June CTP Bug

    • 3 Comments
    There is a bug in the SQL Server 2008 June CTP that causes Declarative Management to be inoperable. The fix is very simple. Launch a command line and run the following command: C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\sn.exe -Vr Microsoft...
  • 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

    Maintenance Plans in SQL2K5 SP2

    • 1 Comments
    If you use Maintenance Plans and have upgraded or plan to update to SQL2K5 SP2 you need to read this blog post .
  • Dan's Blog

    Testing from Office 2007 Beta 2

    • 0 Comments
    I recently installed Office 2007 Beta 2. It has a cool feature to post to blogs directly from within Word. I decided to give it a shot. Setting the blog registration was straight forward – there was a little user error on my part to get it to work but...
  • Dan's Blog

    SQL2K8 Express with Advanced Services and Express with Tools Now Available

    • 3 Comments
    Two Express editions came on-line today. Express with Advanced Services and Express with Tools. You can download them from the Microsoft Download site. Here are the links: SQL Server 2008 Express with Advanced Services (ENU): http://www.microsoft.com...
  • 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

    Oracle Security Once Again in the Spotlight

    • 0 Comments
    I've posted several times about Oracle and its effort to produce a more secure database product. Today I received a couple of emails on this very topic. First is this one: http://www.databasesecurity.com/dbsec/comparison.pdf . There are two points from...
  • Dan's Blog

    What’s In Your Database?

    • 3 Comments
    How many different database objects are there? I don’t know the answer either but off the top of my head I’d guess somewhere between 50 and 100, depending on how you count them. Yes, I could go count them but I’m writing this on a Saturday and between...
  • 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

    Lost Network Connectivity on a Dell Precision 470 Running Vista

    • 1 Comments
    I ran into an interesting situation on my older Dell Precision 470 running Vista. For some reason a few days after I installed Vista it wouldn’t maintain network connectivity. I’d get a little yellow triangle – the warning icon – stating that I’m not...
  • Dan's Blog

    SQLServer 2005 SP2 CTP

    • 0 Comments
    SQL Server 2005 SP2 CTP is here! You can find out the details here: http://www.microsoft.com/sql/ctp.mspx . I'm super excited about this SP – I know I know you're thinking this guy needs to get out more often if an SP gets him excited. When you see all...
  • Dan's Blog

    Policy History Table Exception Columns

    • 0 Comments
    I was recently asked what the exception_message and exception columns in the msdb.dbo.syspolicy_policy_execution_history_internal table are used for. There are situations where the policy evaluate can throw an exception. For example, if the policy references...
  • Dan's Blog

    Katmai

    • 0 Comments
    This past week information regarding the next release of SQL Server, codenamed Katmai, was made publically available. Check out this article on Computer World. The article mentions something called Declarative Management Framework - a new way...
  • 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

    IntelliSense & Debugger Support

    • 4 Comments
    A question came up at the launch event: will T-SQL Intellisense and the T-SQL Debugger support SQL2K5 and/or SQL2K. The situation involves connecting to these server versions from Management Studio 2008. The answer is no, in order to enjoy IntelliSense...
  • Dan's Blog

    Windows Live Writer

    • 1 Comments
    Do we really need another utility to write blog entries? I don't know the answer to that question. I do know that other people seem to think so. Hence the latest edition to pack: Windows Live Writer. It's currently in Beta and can be downloaded from here...
  • Dan's Blog

    Improving SQL Server Books Online

    • 1 Comments
    Check out Simon's blog about Books Online . SQL Server Books Online (BOL) is a treasure of information. But it isn't always correct or complete. You can help fix this. Your BOL feedback is reviewed by the SQL Server technical writing staff and incorporated...
  • 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

    Zero is a Nice Number

    • 0 Comments
    Check out this article by Steve Jones over at SQL Server Central. Equally interesting are the responses. I still fail to understand why anyone would put confidential data in Oracle. Also, some questioned why Microsoft doesn't shout from the roof tops...
  • Dan's Blog

    Does CTP == Reimage?

    • 3 Comments
    Since we started doing CTP with the prerelease of SQL Server 2005 I've been a huge fan. It allows the product team to get a build of the product in the hands of users quicker and more often. It means the feedback loop from user to product group is shorter...
  • Dan's Blog

    TechEd North America Session Videos

    • 5 Comments
    In shameless self promotion the video of the talk I did on PowerShell and SQL Server has been posted to the web. I haven't watched this as I just can't bring myself to sit and watch myself for an hour but the session evaluations were pretty good. Therefore...
  • Dan's Blog

    The SQL Server Flag Flies @ Half Mast

    • 1 Comments
    I got word today the SQL Server family has lost another. Ken Henderson passed away last night. I have so much inside that I want to say about Ken but for some reason it's not ready to come out. Ken was a SQL Server living legend. Now, he's a SQL Server...
  • Dan's Blog

    The New SQL Server Incremental Servicing Model

    • 0 Comments
    The SQL Server team has released a new service model called: Incremental Servicing Model. You can get the details here . IMHO this has two key benefits for customers: 1) more predictability for the delivery of fixes and 2) higher quality fixes – the standard...
  • Dan's Blog

    SQL Server 2005 SP2 RTM

    • 0 Comments
    This morning we announced availability of SQL Server 2005 SP2. You can download it here . SP2 is an amazing release and I encourage you to download it immediately. Some of the highlights from my area (management tools) include: custom reporting in Management...
Page 5 of 9 (203 items) «34567»