2013.05.29

   

SQL

   

• SECURITY QUESTIONS: AUTHENTICATION PERFORMANCE

  http://www.jasonstrate.com/2013/05/security-questions-authentication-performance

   

• Extra Bytes Per Row With AlwaysOn Availability Groups

  http://itknowledgeexchange.techtarget.com/sql-server/extra-bytes-per-row-with-alwayson-availability-groups/

     

• Troubleshooting SQL Server CPU Performance Issues

  http://www.sqlperformance.com/2013/05/io-subsystem/cpu-troubleshooting

     

• SMO vs Invoke-Sqlcmd in Azure

  http://www.scarydba.com/2013/05/28/smo-vs-invoke-sqlcmd-in-azure/

     

• Mix and Match Databases: Dealing with Data Types

  http://www.brentozar.com/archive/2013/05/mix-match-databases-dealing-data-types/

     

• SQL Server 2012 Integration Services - Using PowerShell to Configure Project Environments

  http://www.databasejournal.com/features/mssql/ssis-2012-using-powershell-to-configure-project-environments.html

     

• Increment a variable in the SET clause of an UPDATE statement [T-SQL]

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/05/28/increment-a-variable-in-the-set-clause-of-an-update-statement-t-sql.aspx

     

• Managing Slowly Changing Dimension with MERGE Statement in SQL Server

  http://www.databasejournal.com/features/mssql/managing-slowly-changing-dimension-with-merge-statement-in-sql-server.html

     

• Uploading Data to Windows Azure SQL Database

  https://www.simple-talk.com/cloud/cloud-data/uploading-data-to-windows-azure-sql-database/

     

     

Other