2014.05.22

   

SQL

   

• Dude, who owns that #temp table?

  http://sqlperformance.com/2014/05/t-sql-queries/dude-who-owns-that-temp-table

     

• Capping CPU using Resource Governor ? The Concurrency Mathematics

  http://blogs.msdn.com/b/psssql/archive/2014/05/21/capping-cpu-using-resource-governor-the-concurrency-mathematics.aspx

     

• Backups, Restores, Corruption, and You: How Strong are You?

  http://www.brentozar.com/archive/2014/05/now-available-backup-recovery-advanced/

     

• Implementing Transactions in SQL Server ? Part II

  http://www.sql-server-performance.com/2014/implementing-transactions-sql-server/

   

• PowerShell ? OS Inventory and Disk Info ? Consolidated Excel File ? EMAIL

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/21/powershell-os-inventory-and-disk-info-consolidated-excel-file-email.aspx

   

• Expanding All Columns In A Table In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/05/21/expanding-all-columns-in-a-table-in-power-query.aspx

     

• Dell Doubles Application Speeds, Processes Transactions 9X Faster with In-Memory OLTP

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/05/21/dell-doubles-application-speeds-processes-transactions-9x-faster-with-in-memory-oltp.aspx

     

Other

   

• MySQL ? Scalability on Amazon RDS: Scale out to multiple RDS instances

  http://www.sqlserver.co.uk/index.php/mysql-scalability-on-amazon-rds-scale-out-to-multiple-rds-instances/