Euan Garden - Do you write code?

Download this episode

Download Video

Description

Euan, product unit manager on the SQL Server team, talked about why he still writes code every week. For instance, he needed to understand .NET because he needed to know what his team was in for (his team rewrote SQL Server's management tools in .NET).

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      UdoSchroeter
      Help! I'm getting an error message: "Windows Media Player can't find the file" or something like that (in German). Is my browser broken or is the site?
    • User profile image
      kevshaw
      Ok, I give up trying to decide for myself ... is that Homer Simpson's belly on the wall?
    • User profile image
      EuanG
      It is indeed, nice pickup.

      -Euan
    • User profile image
      Strauss
      "rewrote SQL Server's management tools in .NET"

      What about MMC?
    • User profile image
      EuanG
      We chose not to use MMC for the majority of the management UI in SQL Server 2005. We use our own SQL Shell called SQL Server Management Studio, that leverages some technologies from VS like dynamic help.

      About 90% of the UI for this tool is written in C#, our object model (SMO) is all written in C# and we have extended Profiler in some places using Managed C++ and others using C#.

      SQL Agent also uses managed code in some places and Database Tuning Advisor is all written in C#.

      -Euan
    • User profile image
      shoval
      I manage over 50 sql servers running SQL Server 2000 Enterprise Edition.

      we've installed a sql server 2005 edition at the office for testing.
      I installed the managment tools on my machine.

      sql server 2000 tools vanished...

      I found out that i can't manage sql server 2000 instances' log shipping from sql server management studio.
      i can't even view it's status.

      is there a way to accomplish that?

      if not,
      i can write tsql code to check log shipping status myself but i'd like to integrate that into the ssms ide.
      i know it's doable, cause there are other applications that have doen that, but i can't find any code samples anywhere.
      (an application that integrates with ssms can be found here: http://www.ssmsaddin.com/index.html

      is that doable?

      any help will be much appreciated

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.