2013.05.23

   

SQL

   

• Querying the VMware vCenter Database (VCDB) for Performance and Configuration Information - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/querying-the-vmware-vcenter-database-vcdb-for-performance-and-configuration-information

     

• Read-Only Access to Virtual Center for DBAs - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/read-only-access-to-virtual-center-for-dbas/

  VMWare 환경에서 Database 성능 쿼리 튜닝 공부 해놔야겟네요. ㅡ.ㅡ , Cloud, VMWare 등등

     

• Performance and Stability-Related Fixes in All SQL Server 2008 SP2 Cumulative Updates

  http://www.sqlskills.com/blogs/glenn/performance-and-stability-related-fixes-in-all-sql-server-2008-sp2-cumulative-updates/

   

• Database index design and optimization: Some guidelines

  http://searchsqlserver.techtarget.com/tip/Database-index-design-and-optimization-Some-guidelines

     

• SQL Server Transactions and Locking (Part 1)

  http://basitaalishan.com/2013/05/22/sql-server-transactions-and-locking-part-1/

     

• INDEX ANALYSIS MAY UPDATE

  http://www.jasonstrate.com/2013/05/index-analysis-may-update

     

• DBCC OutputBuffer

  http://stevestedman.com/2013/05/dbcc-outputbuffer/

     

• How do I map a differential/transaction log backup to its full backup without using MSDB?

  http://blogs.msdn.com/b/sqlserverfaq/archive/2013/05/22/how-do-i-map-a-differential-transaction-log-backup-to-its-full-backup-without-using-msdb.aspx

     

• SQL Puzzle: RIGHT without using the RIGHT function

  http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/sql-puzzle-right-without-using

     

• How to Manage Vendor Databases [Video]

  http://www.brentozar.com/archive/2013/05/how-to-manage-vendor-databases-video/

     

• Data Mining Introduction Part 5: the Neural Network Algorithm

  http://www.sqlservercentral.com/articles/Data+Mining/98729/

     

• Paging Data with TSQL

  http://www.databasejournal.com/features/mssql/paging-data-with-tsql.html

     

• Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right

  http://www.mssqltips.com/sqlservertip/2950/disaster-recovery-planning-for-microsoft-sql-server--getting-backups-and-restores-right/

     

• Migrating SQL Server Databases – The DBA's Checklist (Part 3)

  http://www.sql-server-performance.com/2013/migrating-databases-checklist-part3/

     

Other

   

• How to setup a Load Balanced Web Farm of Virtual Machines (Linux or otherwise) on Windows Azure (command line)

  http://www.hanselman.com/blog/HowToSetupALoadBalancedWebFarmOfVirtualMachinesLinuxOrOtherwiseOnWindowsAzureCommandLine.aspx

   

• Replication in MySQL 5.6: GTIDs benefits and limitations – Part 1

  http://sql.dzone.com/articles/replication-mysql-56-gtids

     

• MySQL and the SSB – Part 2 – MyISAM vs InnoDB low concurrency

  http://www.mysqlperformanceblog.com/2013/05/22/mysql-and-the-ssb-part-2-myisam-vs-innodb-low-concurrency/

     

• Android의 HTTP 클라이언트 라이브러리

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