EuanG

• Euan Garden - Tour of SQL Server team (Part IV)

  Dec 09, 2004 at 11:19 PM

  As Robert said, these are the last in the current round of SQl Server videos, we did some very early in the life of Channel9, you can find them here;
  
  http://channel9.msdn.com/ShowPost.aspx?PostID=6089
  http://channel9.msdn.com/ShowPost.aspx?PostID=6187
  http://channel9.msdn.com/ShowPost.aspx?PostID=6308
  http://channel9.msdn.com/ShowPost.aspx?PostID=6469
  http://channel9.msdn.com/ShowPost.aspx?PostID=6857
  http://channel9.msdn.com/ShowPost.aspx?PostID=6998
  http://channel9.msdn.com/ShowPost.aspx?PostID=7098
  

• Euan Garden - Tour of SQL Server team (Part IV)

  Dec 09, 2004 at 2:24 PM

  We did a lot of testing for SQL Server 2000 and the Suprtdome machine was originally used for testing and benchmarkign SQL Server 2000. We have come up with many new an innovative ways to test SQL Server 2005, but it some ways what is most impressive is not the actual testing, but the technique we use to fix the bugs, Soner and Edmund talk about this.

• Euan Garden - Tour of SQL Server team (Part IV)

  Dec 08, 2004 at 10:33 AM

  Remember this box does not run all the time, when it does run its very busy but the rest of the time it is relaxing so I am not sure our workload is real. I'll check wih the engineers on the disk failure thing. I do know that last time we got all new disks for it they came on pallets that we had all over the building for storage.

• Euan Garden - Tour of SQL Server team (Part IV)

  Dec 07, 2004 at 6:21 PM

  When we did the TPC benchmark with this machine it was $5.1 mill, you can get the disclosure doc here:
  
  http://tpc.org/tpcc/results/tpcc_result_detail.asp?id=103082701
  
  However this was 18 months ago, prices have come down for most stuff, but the box now handles 1TB of memory instead of 1/2 TB of memory. The procs are now 2GHz instead of 1.5Ghz but you get the idea

• Euan Garden - Tour of SQL Server Team (Part II)

  Dec 07, 2004 at 2:25 PM

  I think when SQLMail came out it was a ground breaking feature, but we failed to keep it up to date in SQL Server 2000 so that has caused some of the bad experiences. We are really trying to fix that in SQL Server 20005.

• Euan Garden - Tour of SQL Server team (Part IV)

  Dec 07, 2004 at 2:19 PM

  Here is a link to Jamie's site:
  
  http://www.sqlserverdatamining.com/DMCommunity/

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

  Dec 06, 2004 at 7:49 PM

  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.

• Euan Garden - Tour of SQL Server Team (Part II)

  Dec 06, 2004 at 7:42 PM

  Just so everyone gets the links;
  
  http://www.sqlservercentral.com
  http://www.sqlteam.com
  http://www.sqljunkies.com
  http://www.sqldev.net
  http://www.sswwug.com
  http://www.sqlserverfaq.com/

• Euan Garden - Tour of SQL Server Team (Part III)

  Dec 06, 2004 at 7:30 PM

  Taskerr,
  
  In terms of architecture I think it is just a reflection of where we are seeing the workloads that we support heading that Soner wants to go in this direction. Remember we had no idea about adding XML, Service Broker or SQLCLR to the egnine when it was being re-designed for SQL7 back in the 96/97 timeframe and we have been able ot add all of those in this release. I think it has evolved very effectively.
  
  In terms of a managed database its a great question, not in the near term but maybe longer term, yes. One of the most important assets in the database is memory and its management, one of the reasons we need the Whidbey version of the CLR for hosting is that we get more control of memory allocation and garbage collection than we do with VS2002/3, we need that in the database to make sure we get the right performance characteristics. SQL Server has its own memory, thread and disk management, we need to be able to have that level of control to be able to truly perform.

• Euan Garden - Tour of SQL Server Team (Part III)

  Dec 05, 2004 at 6:58 PM

  There is nothing more coming in this round of channel9 but I'll see what I can set up

See more comments…