2014.02.24

   

   

   

SQL

   

• Using Natively Compiled Stored Procedures in SQL Server 2014

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/21/using-natively-compiled-stored-procedures-in-sql-server-2014.aspx

   

• Extended Events for Tracking Code Improvements (video)

  http://www.brentozar.com/archive/2014/02/extended-events-tracking-code-improvements-video/

   

• Using Natively Compiled Stored Procedures in SQL Server 2014

  http://www.sqlserver.co.uk/index.php/using-natively-compiled-stored-procedures-in-sql-server-2014/

     

• Defining half a dozen daily SQL Server DBA responsibilities

  http://searchsqlserver.techtarget.com/tip/Defining-half-a-dozen-daily-SQL-Server-DBA-responsibilities

     

• SQL SERVER ? Fix ? Error ? The File location cannot be opened. Either access is not enabled or you do not have permissions for the same.

  http://raresql.com/2014/02/21/sql-server-fix-error-the-file-location-cannot-be-opened-either-access-is-not-enabled-or-you-do-not-have-permissions-for-the-same/

     

• Adding SQL Server AlwaysOn to existing Failover Clusters

  http://www.mssqltips.com/sqlservertip/3150/adding-sql-server-alwayson-to-existing-failover-clusters/

     

• Troubleshooting Clusters

  http://www.sqlserver.co.uk/index.php/troubleshooting-clusters/

   

• How to determine who deleted a SQL Server database

  http://www.sqlserver-dba.com/2014/02/how-to-determine-who-deleted-a-sql-server-database.html

     

• SQLAuthority News ? Two Whitepapers from AzureCAT Team on SQL Database

  http://blog.sqlauthority.com/2014/02/23/sqlauthority-news-two-whitepapers-from-azurecat-team-on-sql-database/

     

• Fix: Incorrect status output in the SSIS Data Quality transform

  http://sqlblog.com/blogs/greg_low/archive/2014/02/22/fix-incorrect-status-output-in-the-ssis-data-quality-transform.aspx

     

• Removing part of string before and after specific character using Transact-SQL string functions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/23/removing-part-of-string-before-and-after-specific-character-using-transact-sql-string-functions.aspx

     

• Copying and Pasting File Paths

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/21/copying-and-pasting-file-paths.aspx

     

LINKS

   

• Recommended reading from mrdenny for February 21, 2014

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-february-21-2014/

     

• Friday Followup For February 21, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/21/friday-followup-for-february-21-2014.aspx

     

• (SFTW) SQL Server Links 21/02/14

  http://www.johnsansom.com/sftw-sql-server-links-210214/

     

Other

   

• Node.js vs Vert.x 비교

  http://bcho.tistory.com/870

     

• Before every release: A glimpse into Percona XtraDB Cluster CI testing        

  http://www.mysqlperformanceblog.com/2014/02/21/before-every-release-a-glimpse-into-percona-xtradb-cluster-ci-testing/