2014.02.19

   

SQL

   

• How to count the number of rows in a table in SQL Server

  http://www.brentozar.com/archive/2014/02/count-number-rows-table-sql-server/

   

• Introduction to SQL Server Service Broker (video)

  http://voluntarydba.com/post/2014/02/18/Introduction-to-SQL-Server-Service-Broker.aspx

   

• How to check for last SQL Server backup

  http://timradney.com/2014/02/17/how-to-check-for-last-sql-server-backup/

     

• Understanding Graphical Execution Plans - Part 1: Explaining the Plan        

  http://www.sqlservercentral.com/articles/Execution+Plan/105771/

     

• SQL Supper Notes

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/18/sql-supper-notes.aspx

     

• The CASE Statement and Performance

  http://www.scarydba.com/2014/02/18/the-case-statement-and-performance/

   

• SSAS: Currency Conversion

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/18/ssas-currency-conversion.aspx

     

• SSPI Handshake Failed

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/18/sspi-handshake-failed.aspx

     

• Improving SQL Server Performance by using Instant File Initialization

  http://www.sqlpassion.at/archive/2014/02/18/improving-sql-server-performance-by-using-instant-file-initialization

     

LINKS

   

   

Other

   

• Data-intensive Applications in the Cloud Computing World

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/18/data-intensive-applications-in-the-cloud-computing-world.aspx

   

• Windows Azure Storage magic with Shared Access Signatures

  http://java.dzone.com/articles/windows-azure-storage-magic