2014.02.27

   

SQL

   

• Impersonating a server level permissions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/26/impersonating-a-server-level-permissions.aspx

   

• SQL Server Query Performance Guidelines Tutorial

  http://www.mssqltips.com/sqlservertip/3186/sql-server-query-performance-guidelines-tutorial/

   

• SQL Server 2014: Encryption for Backups

  http://www.sql-server-performance.com/2014/sql-server-2014-encryption-backups/

     

• Indexes - The downside

  http://www.sqlserver-dba.com/2014/02/indexes-the-downside.html

   

• Back Up Transaction Logs Every Minute. Yes, Really.

  http://www.brentozar.com/archive/2014/02/back-transaction-logs-every-minute-yes-really/

   

• Caching

  http://voiceofthedba.wordpress.com/2014/02/26/caching/

   

• Does SQL Server database size affect performance?

  http://searchsqlserver.techtarget.com/tip/Does-SQL-Server-database-size-affect-performance

     

• Data Visualizations

  http://www.sqlserver.co.uk/index.php/data-visualizations/

     

LINKS

   

Other

   

• How to monitor ALTER TABLE progress in MySQL

  http://www.mysqlperformanceblog.com/2014/02/26/monitor-alter-table-progress-innodb_file_per_table/