2013.02.05

SQL

   

• SQL Server Baselines Series on SQLServerCentral.com

  http://www.sqlskills.com/blogs/erin/sql-server-baselines-series-on-sqlservercentral-com/

   

• Getting Started with Extended Events in SQL Server 2012

  http://www.simple-talk.com/sql/database-administration/getting-started-with-extended-events-in-sql-server-2012/

     

• NOEXPAND query hint returns wrong results – CU fix now available

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/02/04/noexpand-query-hint-returns-wrong-results-cu-fix-now-available.aspx

     

• Could not find prepared statement with handle – Msg 8179

  http://www.sqlserver-dba.com/2013/02/could-not-find-prepared-statement-with-handle-msg-8179.html

     

• Database Deployment: The Bits - Versioning

  http://www.simple-talk.com/sql/database-administration/database-deployment-the-bits---versioning/

     

• Capturing Baselines on SQL Server: Wait Statistics

  http://www.sqlservercentral.com/articles/baselines/96270/

     

• Using the Data Profiling SQL Server Integration Services SSIS task

  http://www.mssqltips.com/sqlservertip/2854/using-the-data-profiling-sql-server-integration-services-ssis-task/

     

• Can a table have no columns?

  http://sqlblog.com/blogs/greg_low/archive/2013/02/04/can-a-table-have-no-columns.aspx

     

• Using Policy Based Management for checking SQL Server Versions

  http://www.mssqltips.com/sqlservertip/2860/using-policy-based-management-for-checking-sql-server-versions/