2014.04.01

   

SQL

   

• Types of MSSQL Joins

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/types-of-mssql-joins.aspx

     

• The Primary Filegroup Cannot be Backed Up as a File Backup

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/the-primary-filegroup-cannot-be-backed-up-as-a-file-backup.aspx

   

• Database Master Key Error After Database Restore

  http://www.sqlservercentral.com/articles/Database+Master+Key/107787/

     

• SQL Server Quickie #12 ? Nested Loop Operator

  http://www.sqlpassion.at/archive/2014/03/31/sql-server-quickie-12-nested-loop-operator

     

• Default nullability of a new column

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/default-nullability-of-a-new-column.aspx

     

• Refactoring T-SQL with Windowing Functions        

  http://www.brentozar.com/archive/2014/03/refactoring-t-sql-windowing-functions/

     

• SSIS Web Service Task

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/ssis-web-service-task.aspx

     

• Calculate Distinct Count in a Group By operation in Power Query #powerquery #powerbi

  http://sqlblog.com/blogs/marco_russo/archive/2014/03/31/calculate-distinct-count-in-a-group-by-operation-in-power-query-powerquery-powerbi.aspx

     

LINKS

   

• Last Weeks Top "Reading" Links #77

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/last-weeks-top-reading-links-77.aspx

     

Other

   

• Tips to check and improve your storage IO performance with MongoDB

  http://edgystuff.tumblr.com/post/81219256714/tips-to-check-and-improve-your-storage-io-performance

     

• SQL Alias PowerShell scrip

  http://blogs.technet.com/b/sqlpfeil/archive/2014/03/31/sql-alias-powershell-scrip.aspx

     

• Password expiration policy in MySQL Server 5.7

  http://mysqlblog.fivefarmers.com/2014/03/31/password-expiration-policy-in-mysql-server-5-7/