Browse by Tags

• boston
• Conferences
• debugging
• DevTecah
• ETL
• installer
• internals
• kalen delaney
• lock escalation
• logging
• MCM
• MERGE
• New England
• OUTPUT
• PASS
• Performance
• Query Tuning
• Speaking
• SQL Server 2005
• SQLCLR
• training

• SQL Server 2008: Lock Escalation, INSERTs, and a Potential Bug

  Lock escalation is a funny thing. I've found myself on numerous occasions waging war against its concurrency-sapping existence, and rarely have I found myself wishing that it would work more aggressively. But there is a time and place for everything, Read More... Posted Friday, October 30, 2009 10:10 AM by Adam Machanic | 11 Comments Filed under: Performance, sql server 2008, lock escalation

• Dr. OUTPUT or: How I Learned to Stop Worrying and Love the MERGE

  It would be fair to say that there aren't a huge number of programmability features added to SQL Server 2008 that will have a great impact on most of our day-to-day lives as SQL Server developers. The release was clearly manageability themed rather than Read More... Posted Monday, August 24, 2009 4:31 PM by Adam Machanic | 14 Comments Filed under: Performance, sql server 2008, MERGE, logging, OUTPUT, ETL

• [New England] Kalen Delaney Internals and Query Tuning - in the Boston area October 12-16

  In case you missed Kalen's post , we're excited to announce that she will be joining us here on the East Coast in October to deliver her SQL Server 2005/2008 Internals and Query Tuning seminar. This is, to my knowledge, the most advanced public SQL Server Read More... Posted Thursday, July 23, 2009 11:16 AM by Adam Machanic | 4 Comments Filed under: Query Tuning, SQL Server 2005, sql server 2008, New England, boston, training, kalen delaney, internals

• Speaking Season About to Begin: MCM, Roadshow, PASS, and SQLCLR Precon at DevTeach

  Fall is now in full swing, and after a relatively quiet several months my speaking schedule is about to jump into fairly-packed mode. Following is a list of where I'll be headed over the next couple of months: Next week I'm really excited to be teaching Read More... Posted Tuesday, October 21, 2008 5:20 PM by Adam Machanic | 3 Comments Filed under: Conferences, SQLCLR, sql server 2008, Speaking, MCM, DevTecah, PASS

• SQL Server 2008: Return of the Debugger

  A lot of people will be interested to know that at the launch event in LA it was announced that the T-SQL debugger is returning to Management Studio in SQL Server 2008 . Personally, this is not a feature I've been lamenting the loss of; I never used it Read More... Posted Friday, February 29, 2008 8:06 AM by Adam Machanic | 6 Comments Filed under: sql server 2008, debugging

• In case you don't read our Roller... Breaking news on RTM release date

  And I quote... final Release to manufacturing (RTM) of SQL Server 2008 expected in Q3. Thanks to Jason Massie for the pointer (via our Roller , of course!) Read More... Posted Friday, January 25, 2008 5:27 PM by Adam Machanic | 7 Comments Filed under: sql server 2008

• SQL Server 2008 CTP5 VHD Now Available

  Lazy developer that I am, I just hate running installers to set up VHDs for the SQL Server 2008 CTPs. So I was overjoyed when Microsoft did the work for me and released a pre-installed VHD image for CTP4. CTP5, alas, did not ship with a VHD, forcing me Read More... Posted Wednesday, December 05, 2007 11:46 AM by Adam Machanic | 8 Comments Filed under: sql server 2008, installer