2013.08.26

   

SQL

   

• New Article on SQLPerformance.com: "Exploring SQL Server 2014 SELECT INTO Parallelism"

  http://www.sqlskills.com/blogs/joe/new-article-on-sqlperformance-com-exploring-sql-server-2014-select-into-parallelism

  SQL2014에서 SELECT … INTO를 Parallel으로 실행하네요. 옷~

     

• Myth: Select * is bad

  http://use-the-index-luke.com/blog/2013-08/its-not-about-the-star-stupid

   

• How To Avoid Orphaned Database Users with SQL Server Authentication

  http://www.sqlskills.com/blogs/glenn/how-to-avoid-orphaned-database-users-with-sql-server-authentication/

     

• Test Your SQL Server Backups with PowerShell

  https://www.simple-talk.com/sql/database-administration/test-your-sql-server-backups-with-powershell/

     

• (SFTW) SQL Server Links 23/08/13

  http://www.johnsansom.com/sql-server-links-230813/

     

• Microsoft SQL Server Parallel Data Warehouse (SQL Server PDW)

  http://searchsqlserver.techtarget.com/definition/Microsoft-SQL-Server-Parallel-Data-Warehouse-SQL-Server-PDW

     

• Controlling Growth of a msdb Database

  http://www.sql-server-performance.com/2013/controlling-growth-msdb-database/

     

• Teach Business Users How To Create Power View Reports With SQL Server Data Sources

  http://www.mssqltips.com/sqlservertip/3005/teach-business-users-how-to-create-power-view-reports-with-sql-server-data-sources/

     

• SQL Server Reporting Services Tips and Tricks to Improve the End User Experience

  http://www.mssqltips.com/sqlservertip/3023/sql-server-reporting-services-tips-and-tricks-to-improve-the-end-user-experience/

     

Other

   

• Log Buffer #334, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-334-a-carnival-of-the-vanities-for-dbas/

   

• DB2 10.5 BLU testing

  http://www.sqlpanda.com/2013/08/db2-105-blu-testing.html

     

• Windows7에서 Apache2 + Tomcat 연동

  http://naleejang.tistory.com/82