Jan 312013

2013-11-26 – UPDATE – SQL Server 2012 CU 7 -or- SQL Server 2012 SP1 CU4 addresses the indexing recommendations. See KB 2829948 for more details.

I’ve been sitting on this content for about a year now, and due to external pressure (Thanks Matthew!) I’ve decided to put this into writing. One of the reasons I’ve been sitting on this content is that I didn’t want to share it publicly because the recommendations (after the break) can put you into a state of unsupportability with Microsoft. So with that, you take on the sole risk by implementing my recommendations. After you review them, you’ll see they are pretty basic, much needed, and well vetted. Jamie Thomson has written about these indexes (or rather mentions that they are available) as they have helped with his reporting pack Codeplex project. All-in-all, I now feel pretty safe documenting these, as others are starting to use them and talk about them publicly. With that, here goes.

Continue reading »

Jul 122011

After much waiting, what is perhaps the most complete release to-date of the next version of SQL Server, code named “Denali” has been released. This is Community Technology Preview #3 (CTP 3) and will be well worth your time to experiment with. If you’ve worked with CTP 1, throw it away and move toward CTP 3. It should pretty much contain all of the features you’ve heard of – AlwaysOn, SSIS enhancements, etc…

Read the announcement here: http://blogs.technet.com/b/dataplatforminsider/archive/2011/07/11/sql-server-code-name-denali-ctp3-is-here.aspx