Paul White (@SQL_Kiwi) details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should read this.
Continue Reading »Jul 302014
Jul 012014
Paul White (@SQL_Kiwi) has put together a fantastic series on concurrency, the ACID properties of statements and transactions, and isolation levels in SQL Server.
Continue Reading »Nov 132013
SQL Sentry's Aaron Bertrand (@AaronBertrand) investigates a deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.
Continue Reading »Sep 182013
Joe Sack (@josephsack) looks into some new locking behavior, involving rebuilds and partition switching, available in SQL Server 2014.
Continue Reading »Aug 172012
As lots of you know already, Kevin Kline (blog|@KEKline) has joined us here at SQL Sentry. I’ve followed Kevin myself for a good while, so I’m really excited to have him here with us.
One of the first things Kevin asked of me was to list the top 5 technical issues we see while providing customer service for SQL Sentry. For our Client Services team, technical support is far more than just supporting our own software products or managing licenses. Everyone on the team is deeply trained in SQL Server, Windows and Microsoft .NET. In fact, in general, any member trained on our Client Services team should be able to walk into the role of a Windows sysadmin, SQL Server DBA or .NET Application Developer with very little adjustment effort.
Continue Reading »