Tip : Find unused SQL Server indexes with Policy Based Management

Tip : More intuitive tool for reading SQL Server execution plans

I take a look at THROW, new error handling functionality in SQL Server 2012.

I explain how partially contained databases work and what problems they intend to solve.

I highlight some issues with the 2012 release of Books Online, the documentation set for SQL Server.

I talk about an enhancement introduced in SSMS 2012 that will make it simpler to troubleshoot an offline instance.

I take a quick look at a featured emulated from Oracle : SEQUENCE.

SQL Server 2012 introduces OFFSET and FETCH NEXT clause to help simplify pagination.

Discover a potentially breaking change to how object_id values are assigned to #temp tables starting with SQL Server 2012.

For this T-SQL Tuesday, I talk about how you don't have to be a Jedi to use The Force.