Euan Garden - Tour of SQL Server Team (part I)

Sign in to queue

Description

Building 35 is a mysterious place.

Hundreds of Microsoft employees. Thousands of computers.

What's cool about building 35? It's where they make SQL Server!

So, we wanted to get a tour of building 35 and meet some of the geeks who work on the SQL Server team.

Here Euan Garden gives us a tour around building 35.

You'll see a different part of the team every day over the next week.

If you're a SQL Server MVP watch for some suprises.

In this video you get to tour the first of four of SQL Server's labs and you get to meet Mike Blaszczak, architect on the SQL Server team. Mike is pretty humble here, but he's known around the world for being one of the world's top database designers.

Tag:

SQL Server

Embed

Download

Download this episode

The Discussion

  • User profile image
    sparky
    Mike Blaszczak taught me MFC 4.0!  This guy has been around.

  • User profile image
    Aaron
    Does anyone know what they use for the UI testing ?
  • User profile image
    Sampy
    I almost interned on SQL a couple years ago but went with the VB team instead.
  • User profile image
    rhm
    Hey, there's one team that doesn't need Visual Studio Team System - they've got a whiteboard in the corridor!   Old school.

    Seriously though, that was just one of the machine rooms full of testing hardware? Unbelievable. I'm just waiting for some open source jerk to pipe up and say "they've got all those resources and it's still slower than mysql" Smiley
  • User profile image
    EuanG
    Aaron,
    We use a custom UI Testing framework built in the SQL Server team that is written in C# and uses Microsoft Active Accesibility to access the controls
  • User profile image
    bdelahunty
    Part 2!!!!!!

    Where is Part 2????


  • User profile image
    Taskerr

    Good stuff! Lets have more.

    The SQL developer teams have stuck to scripting over the versions. With Express being released to the non specialist world. Should we see more emphasis on GUI tool production to assist development?

    It seems that what we have now is a job for the boys scenario. Is it time to move on? If Server 2003 has reduced the overall TCO what will be the comparable acheivement on the next release of SQL?

    Perhaps such tools could live above the scripting model whilst keeping all the existing functionality.

    The worry for me is that badly designed EXpress databases will end up in the Enterprise environment simply because the developers at that level did not have the requisite scripting skills or tools.

  • User profile image
    EuanG
    We are comitted to supporting GUI tools in Express and all the other SKUs. We have started working on best practice guidance via the SQL Server Best Practices Tool but I agree we can always do more, and we will.
  • User profile image
    raptor3676
    Wow! Nice piece of work

    In upcoming parts ('cause there's got to be more) I'd like to know more about the way the CLR 2.0 is embedded into SQL Server,perhaps how the Namespace System.Data.SqlServer is implemented by the SQL Server engine or some performace tid bits

    Anyway, you 9ner guys should keep the good stuff coming!!

    Raptor.
  • User profile image
    Simo
    I earn half my living from using Sql Server so for ne anything like this is really, really cool.

    Would like to hear Euan & Mike's view on MS Research's cω study 

    http://channel9.msdn.com/ShowPost.aspx?PostID=23476#23476

    and Ander's musings on where C# 3.0 is going.
  • User profile image
    EuanG
    I think what you are seeing with what Anders is doing and also MSR (plus some other internal projects) is us striving to modernise the way you interact with databases.

    With the addition of SQLCLR into SQL Server 2005 we are providing a modern, high performance and rich extensibility model with a ton of leverage of existing skills and tools, but thats really just the start.

    We now need to change the way you interact with databases, the SQl Language and its integration into the middle and client tiers has not really changed in years, I remember using VB3 Database Edition much the same way as we are now, to build client server apps. This is an area where MSR and AndersH are doing their work.

    The final area is the actual building of queries, QBE has basically not changed in 10 years, but the capabilities of the language have very much evolved and we need to allow folks to write GOOD sql who are concerned about writing it today. As a result we are also doing work on new conceptual query builders. In fact in many ways thats one of the key features of the new reportbuilder and UDM in SQL2005. Once a technically skilled user has built the semantic layer over the database then end users can derive business queries from that layer. We still have a lng way to go in this space but we are doing a ton of thinking.
  • User profile image
    SuperBK
    Does Mike have a blog?
  • User profile image
    mikeblas
    I don't keep a technology blog. I sarted one, but the legal department decided I was too cynical and shut me down.

    I've kept a travel log since before they were called "blogs". You can read about my travels at http://www.mooseboy.com/ , or the easier-to-read original model at http://www.nwlink.com/~mikeblas/

    I keep a race log at http://www.screwylizardracing.com/

    .B ekiM
  • User profile image
    mikeblas
    sparky wrote:
    Mike Blaszczak taught me MFC 4.0!  This guy has been around.



    Thanks for remembering, Sparky. It seems my last stop is the cutout bin -- "21 used & new from $1.14"?

    It just hurts, sometimes.

    .B ekiM

Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.