SQL Server 2008 R2 Service Pack 2 is available

Today Microsoft has released Service Pack 2 for SQL Server 2008 R2. http://www.microsoft.com/en-us/download/details.aspx?id=30437 The build number is 10.50.4000.0 and it includes fixes from 2008 R2 SP1 Cumulative Updates 1, 2, 3, 4 and 5. The fixes from Cumulative Updates 6 and 7 will be published in a subsequent cumulative update, […]

SQL Sentry is sponsoring a new blog : SQLPerformance.com

This week, SQL Sentry has launched a new performance-related SQL Server blog: SQLPerformance.com. I'm very excited about this new project, and I'm looking forward to some good information flow in both directions. The goal is to present new and interesting solutions to some common problems, and to explore both old […]

July 2012 : Cumulative Updates for SQL Server 2008 are available

Today Microsoft has released two new cumulative updates for SQL Server 2008. Cumulative Update #11 for SQL Server 2008 Service Pack 2 Knowledge Base Article: KB #2715951 At the time of writing, there are two fixes listed The build number is 10.00.4333 Relevant for @@VERSION between 10.00.4000 and 10.00.4332 Cumulative […]

A new era begins : Welcome, Kevin Kline, to SQL Sentry!

 It is with great pleasure that I welcome Kevin Kline to his new role as Director of Engineering Services at SQL Sentry. In Internet terms, Kevin and I go "way back." We've been at several MVP Summits together, of course, as well as various PASS-related and other community events – […]

Connect Digest : 2012-07-06

I've filed a few Connect items recently that I think are important. In #752210, I complain that the documentation for DDL triggers suggests that they can prevent certain DDL from being run, which is not the case at all.      http://web.archive.org/web/*/https://connect.microsoft.com/SQLServer/feedback/details/752210/doc-ddl-trigger-topic-suggests-that-rollbacks-run-before-action In #745796, I complain that scripting datetime data […]