Loading user information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading user information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

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

17 minutes, 58 seconds


Right click “Save as…”

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.


Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation
  • Mike Blaszczak taught me MFC 4.0!  This guy has been around.

  • Does anyone know what they use for the UI testing ?
  • Mike SampsonSampy And I come back to you now - at the turn of the tide
    I almost interned on SQL a couple years ago but went with the VB team instead.
  • rhmrhm
    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
  • 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
  • Part 2!!!!!!

    Where is Part 2????

  • TaskerrTaskerr This ones a Gem!

    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.

  • 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.
  • 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!!

  • SimoSimo With me it's a full-time job.
    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 


    and Ander's musings on where C# 3.0 is going.
  • 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.
  • Does Mike have a blog?
  • 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
  • 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

Remove this comment

Remove this thread


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.