2013.02.15

SQL

   

• Geek City: Join With Me! - Kalen Delaney

  http://sqlblog.com/blogs/kalen_delaney/archive/2013/02/14/index-intersection.aspx

     

• Hardware 301 Presentation - Glenn Berry's

  http://sqlserverperformance.wordpress.com/2013/02/14/hardware-301-presentation/

  여기 문서좀 다운로드 해서 업로드 해주세요 ㅠㅠ... 울 회사 다운로드 안돼..

     

• Speaking at PASS Database Administration Virtual Chapter

  http://sqlserverperformance.wordpress.com/2013/02/08/speaking-at-pass-database-administration-virtual-chapter/

  Glenn 아저씨가 pass에서 virtual 강의하신다네요. 아 가고 싶당 ㅠㅠ...

     

• Recommended SQL Server 2012 SP1 Hotfix available for msiexec issue (KB2793634)

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/14/recommended-sql-server-2012-sp1-hotfix-available-for-msiexec-issue-kb2793634.aspx

     

• Drop Connections with ROLLBACK IMMEDIATE to allow a Detach database

  http://www.sqlserver-dba.com/2013/02/drop-connections-with-rollback-immediate-to-allow-a-detach-database.html

  자주 쓰는 구문이네요^^

     

• Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies        

  http://www.sqlsoldier.com/wp/sqlserver/day28of31daysofdisasterrecoveryrecoveringsqlifthetempdbdrivedies

  masterdb 문제가 되었을 때 조치하는거네요^^ /f, /t3608로 sql을 시작하고, sqlcmd로 경로를 변경한다.

     

• If you are using indexed views and MERGE, please read this!

  http://www.sqlperformance.com/2013/02/t-sql-queries/another-merge-bug

     

• Script Replication with PowerShell

  http://sqlserver365.blogspot.kr/2013/02/script-replication-with-powershell.html

     

• Full Text Searches on Documents in FileTables

  http://www.simple-talk.com/sql/database-administration/full-text-searches-on-documents-in-filetables/

     

• MDX Guide for SQL Folks: Part III - Advanced Analysis

  http://www.sqlservercentral.com/articles/MDX/95065/

     

• Customized SQL Agent Job Notifications

  http://www.mssqltips.com/sqlservertip/2863/customized-sql-agent-job-notifications/

     

• SQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server

  http://blog.sqlauthority.com/2013/02/14/sql-server-development-productivity-tool-dbforge-studio-for-sql-server/

  쩝.. 유료 툴이네여~?

     

• Has the term "big data" completely lost meaning yet?

  http://sqlblog.com/blogs/greg_low/archive/2013/02/10/has-the-term-big-data-completely-lost-meaning-yet.aspx

     

• SQL SERVER – Primary Key and NonClustered Index in Simple Words

  http://blog.sqlauthority.com/2013/02/10/sql-server-primary-key-and-nonclustered-index-in-simple-words/

     

• Find the database owner name from the owner_sid - t-sql and suser_sname

  http://www.sqlserver-dba.com/2013/02/find-the-database-owner-name-from-the-owner_sid-t-sql-and-suser_sname.html

     

• What Does Big Data Mean to You?

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/08/what-does-big-data-mean-to-you.aspx

     

• Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted

  http://sqlcat.com/sqlcat/b/msdnmirror/archive/2013/02/08/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted.aspx

     

• Recommended reading from mrdenny for February 08, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-february-08-2013/

     

• Using QUERYTRACEON in plan guides

  http://spaghettidba.com/2013/02/08/using-querytraceon-in-plan-guides/

  아하~^^

     

• WSFC Failure Threshold and Automatic Failovers

  http://sqlsalt.com/wsfc-failure-threshold-and-automatic-failovers/

     

• Manual Log Shipping with PowerShell

  http://spaghettidba.com/2013/02/08/manual-log-shipping-with-powershell/

     

• Database backup does not cause blocking

  http://www.sqlserver-dba.com/2013/02/database-backup-does-not-cause-blocking.html

     

• SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD

  http://blog.sqlauthority.com/2013/02/08/sql-server-backup-and-restore-database-using-command-prompt-sqlcmd/

     

기타

   

• L4/L7 스위치의 대안, 오픈 소스 로드 밸런서 HAProxy

  http://helloworld.naver.com/helloworld/textyle/284659

  와~~

     

• Windows shell: commands - John Paul

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/13/windows-shell-commands.aspx

     

• [Redis] Slowlog

  http://dol9.tistory.com/215

  http://dol9.tistory.com/214

     

추천

   

• http://ola.hallengren.com/

  DBA라면 한번씨 보시면 좋을 듯.. 관리를 위한 좋은 스크립트가 많네요