Minimizing the impact of DBCC CHECKDB
I discuss several aspects of DBCC CHECKDB and offer suggestions to minimize the impact this crucial operation can have.
Monthly Archive: November 2012
SQL Server 2012 Service Pack 1 Cumulative Update #1 is available!
Waited to deploy SQL Server 2012 until Service Pack 1 was released? Then held off because Service Pack 1 did not include important updates from Cumulative Update #3 and Cumulative Update #4? You're running...
Cumulative Update #8 for SQL Server 2008 SP3 is available
Today Microsoft has released a new cumulative update for SQL Server 2008 SP3. KB article: KB #2771833 There are 9 fixes listed at the time of writing The build number is 10.00.5828.00 Relevant for...
SQL Server 2012 Service Pack 1 is available – this time for sure!
Last week I mentioned in passing that Service Pack 1 is now available, while I was blogging from the PASS Summit keynote. I wanted to put up an official post instead of having it...
T-SQL Tuesday #36 : Reflections on the PASS Summit and our community
Last week I attended the PASS Summit in Seattle. I blogged from both keynotes (Keynote #1 and Keynote #2), as well as the WIT Luncheon – which SQL Sentry sponsored. I had a fantastic...
Blogging from the PASS Summit : WIT Luncheon
SQLSentry is very proud to sponsor the 10th annual Women in Technology Luncheon at the PASS Summit. Probably 700 people in here – pretty crowded house. This luncheon is growing year over year and...
Blogging from the PASS Summit : Nov. 8th keynote
Douglas McDowell talks about day 1, the video montage featuring folks here from all over the world, and the fiscal year. The important point I took from this is that PASS is a not-for-profit...
Blogging from the PASS Summit : Nov. 7th keynote
Bill Graziano takes the stage at 8:15. He talks about how 3,894 attendees (and 5,611 total registrants) represent 57 countries at the 14th summit. There are over 127,000 members worldwide. Note that you can...
PASS Summit '12, Day One
I had an incredibly interesting experience getting to Seattle this week. I flew out of Providence through Philadelphia. Apparently there was some smoke in one of the towers at PHL, so our flight was...
An important change to Extended Events in SQL Server 2012
Extended Events becomes much more usable in Management Studio.
Bad cardinality estimates coming from SSMS execution plans
A lot of work went into improving estimates shown by an execution plan in Plan Explorer.
Auditing when Triggers are Disabled or Enabled for SQL Server
Tip : Auditing when Triggers are Disabled or Enabled for SQL Server