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.
I discuss several aspects of DBCC CHECKDB and offer suggestions to minimize the impact this crucial operation can have.
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...
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...
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...
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...
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...
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...
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...
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...
Extended Events becomes much more usable in Management Studio.
A lot of work went into improving estimates shown by an execution plan in Plan Explorer.
Tip : Auditing when Triggers are Disabled or Enabled for SQL Server