2014.03.06

   

SQL

   

• Need High Availability for SQL Server? Use Windows Server 2012.

  http://www.brentozar.com/archive/2014/03/need-high-availability-sql-server-windows-server-2012/

   

• ROLLBACK damn you!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/05/rollback-damn-you.aspx

     

• Do you clean up your Database Mail log tables?

  http://blog.sqlblog.com/blogs/tibor_karaszi/archive/2014/03/05/do-you-clean-up-your-database-mail-log-tables.aspx

     

• SQL Server Logical Reads ? What do they really tell us?

  http://www.sql-server-performance.com/2014/logical-reads/

     

• Creating a Kerberos Delegation Table for SQL Server Access

  http://www.mssqltips.com/sqlservertip/3177/creating-a-kerberos-delegation-table-for-sql-server-access/

     

• An updated Plan Explorer demo kit

  http://www.sqlperformance.com/2014/03/t-sql-queries/updated-plan-explorer-demo-kit

   

• SQL ? Backup Report

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/05/sql-backup-report.aspx

     

• Capturing query and IO statistics using Extended Events

  http://www.sqlserver.co.uk/index.php/capturing-query-and-io-statistics-using-extended-events/

   

• Top 3 Features I'm Excited About in SQL Server 2014

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/03/05/top-3-features-i-m-excited-about-in-sql-server-2014.aspx

     

• Removing trailing spaces in SSMS or Visual Studio

  http://sqlblog.com/blogs/john_paul_cook/archive/2014/03/05/removing-trailing-spaces-in-ssms-or-visual-studio.aspx