UPDATE

• February 2014 Cumulative Update for SQL Server 2008 R2 SP2

  http://sqlblog.com/blogs/aaron_bertrand/archive/2014/02/19/february-2014-cumulative-update-for-sql-server-2008-r2-sp2.aspx

• KB Article: KB #2926028
• 12 fixes listed at time of publication
• Build number is 10.50.4302
• Relevant for @@VERSION 10.50.4000 through 10.50.4301        

SQL

• Knee-Jerk Wait Statistics : SOS_SCHEDULER_YIELD

  http://www.sqlperformance.com/2014/02/sql-performance/knee-jerk-waits-sos-scheduler-yield

• Hardware Update 2014 and Server Sizing - Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2014/02/18/hardware-update-2014-and-server-sizing.aspx

     

• MSA accounts used with SQL

  http://blogs.msdn.com/b/sqlosteam/archive/2014/02/19/msa-accounts-used-with-sql.aspx

• Fixing Cache Bloat Problems With Guide Plans and Forced Parameterization

  https://www.simple-talk.com/sql/performance/fixing-cache-bloat-problems-with-guide-plans-and-forced-parameterization/

• Understanding Graphical Execution Plans - Part 2: How to Create One

  http://www.sqlservercentral.com/articles/Execution+Plan/105772/

     

• Using sys.dm_os_ring_buffers to Troubleshoot Connectivity Issues

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/19/using-sys-dm-os-ring-buffers-to-troubleshoot-connectivity-issues.aspx

     

• Configuring the Maximum Degree of Parallelism

  http://www.sql-server-performance.com/2014/maximum-degree-parallelism/

     

• Getting a query plan

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/19/getting-a-query-plan.aspx

     

• The Evolution of SQL Server Instrumentation

  http://www.brentozar.com/archive/2014/02/evolution-sql-server-instrumentation/

     

• The Strange Story About the MERGE that Killed the Cluster

  http://www.dbnewsfeed.com/2014/02/20/the-strange-story-about-the-merge-that-killed-the-cluster

     

• Snap All the Things!

  http://sqlblog.com/blogs/merrill_aldrich/archive/2014/02/20/snap-all-the-things.aspx

     

• Send me your wait stats and get my advice and 30 days of free Pluralsight in return

  http://www.sqlskills.com/blogs/paul/send-wait-stats-get-advice-30-days-free-pluralsight-return

     

• PowerShellGUI Tools ? Disk,Memory and Process ? Modules

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/20/powershellgui-tools-disk-memory-and-process-modules.aspx

     

Other

• Virtual Lab ? Creating Differencing Disks

  http://voiceofthedba.wordpress.com/2014/02/20/virtual-lab-creating-differencing-disks/        

     

• If You Can Do Just One Lab to Learn Windows Azure, This is It

  http://java.dzone.com/articles/if-you-can-do-just-one-lab

     

• Windows Azure 무료 평가판 등록 이슈

  http://redju.tistory.com/390

SQL

• How to count the number of rows in a table in SQL Server

  http://www.brentozar.com/archive/2014/02/count-number-rows-table-sql-server/

• Introduction to SQL Server Service Broker (video)

  http://voluntarydba.com/post/2014/02/18/Introduction-to-SQL-Server-Service-Broker.aspx

• How to check for last SQL Server backup

  http://timradney.com/2014/02/17/how-to-check-for-last-sql-server-backup/

     

• Understanding Graphical Execution Plans - Part 1: Explaining the Plan        

  http://www.sqlservercentral.com/articles/Execution+Plan/105771/

     

• SQL Supper Notes

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/18/sql-supper-notes.aspx

     

• The CASE Statement and Performance

  http://www.scarydba.com/2014/02/18/the-case-statement-and-performance/

• SSAS: Currency Conversion

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/18/ssas-currency-conversion.aspx

     

• SSPI Handshake Failed

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/18/sspi-handshake-failed.aspx

     

• Improving SQL Server Performance by using Instant File Initialization

  http://www.sqlpassion.at/archive/2014/02/18/improving-sql-server-performance-by-using-instant-file-initialization

     

LINKS

Other

• Data-intensive Applications in the Cloud Computing World

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/18/data-intensive-applications-in-the-cloud-computing-world.aspx

• Windows Azure Storage magic with Shared Access Signatures

  http://java.dzone.com/articles/windows-azure-storage-magic

SQL

• Why Your Slow SQL Server Doesn't Need a SQL Consultant (or Does It?)

  http://www.brentozar.com/archive/2014/02/slow-sql-server-doesnt-need-sql-consultant/

• DBA Myths: An index on a bit column will never be used.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/17/dba-myths-an-index-on-a-bit-column-will-never-be-used.aspx

     

• Script to Database Mirroring in SQL Server

  http://beyondrelational.com/modules/2/blogs/88/Posts/19838/script-to-database-mirroring-in-sql-server.aspx

     

• Unspecified Error SSIS Excel connection manager

  http://sqljunkieshare.com/2014/02/17/unspecified-error-ssis-excel-connection-manager/

     

• Using hash values in SSIS to determine when to insert or update rows

  http://www.mssqltips.com/sqlservertip/3170/using-hash-values-in-ssis-to-determine-when-to-insert-or-update-rows/

     

LINKS

• LAST WEEKS TOP "READING" LINKS #71

  http://www.jasonstrate.com/2014/02/last-weeks-top-reading-links-71/

SQL

• SQL Server 2014 Incremental Statistics

  http://www.sqlperformance.com/2014/02/sql-statistics/2014-incremental-statistics

• SQL Server Integrity Check ? A Necessary Routine

  http://www.pythian.com/blog/sql-server-integrity-check-a-necessary-routine/

• Skewed Data ? Poor Cardinality Estimates… and Plans Gone Bad

  http://www.sqlserver.co.uk/index.php/skewed-data-poor-cardinality-estimates-and-plans-gone-bad/

• Why is Your SQL Server Slow? All-for-one and One-for-all

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

• SQL SERVER ? Multiple ways to find all the tables that do not have a primary key?

  http://raresql.com/2014/02/16/sql-server-multiple-ways-to-find-all-the-tables-that-do-not-have-a-primary-key/

     

• SQL SERVER ? Get Current TimeZone Name in SQL Server

  http://www.sqlserver.co.uk/index.php/sql-server-get-current-timezone-name-in-sql-server/

     

• Calculating Gaps Between Overlapping Time Intervals in SQL

  https://www.simple-talk.com/sql/t-sql-programming/calculating-gaps-between-overlapping-time-intervals-in-sql/

     

• Calendar Tables

  http://www.sqlservercentral.com/articles/T-SQL/70482/

     

• MDX+SSAS #38-CALL ASSP.DMV() to document cubes in SSAS 2005

  http://beyondrelational.com/modules/2/blogs/101/Posts/19835/mdxssas-38-call-asspdmv-to-document-cubes-in-ssas-2005.aspx

     

• Automating the Retrieval of SQL Backups from Windows Azure BLOB Storage

  https://www.simple-talk.com/cloud/cloud-data/automating-the-retrieval-of-sql-backups-from-windows-azure-blob-storage/

     

LINKS

• (SFTW) SQL Server Links 14/02/14

  http://www.johnsansom.com/sftw-sql-server-links-140214/

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

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

     

• Friday Followup For February 14, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/14/friday-followup-for-february-14-2014.aspx

     

Other

• Using Percona rsync repositories to set up the local CentOS mirror

  http://www.mysqlperformanceblog.com/2014/02/14/using-percona-rsync-repositories-set-local-centos-mirror/

• [입 개발] memcached slabclass 에 대해서…

  http://charsyam.wordpress.com/2014/02/16/%EC%9E%85-%EA%B0%9C%EB%B0%9C-memcached-slabclass-%EC%97%90-%EB%8C%80%ED%95%B4%EC%84%9C/

     

• Cloud Design Patterns

  http://redju.tistory.com/388

SQL

• PREEMPTIVE_OS_WRITEFILEGATHER and Instant File Initialization (IFI)

  http://www.brentozar.com/archive/2014/02/preemptive_os_writefilegather-and-instant-file-initialization-ifi/

• Guerrilla Project Management for DBAs

  https://www.simple-talk.com/sql/database-administration/guerrilla-project-management-for-dbas/

     

• SQL SERVER ? Expanding Your Skills ? Notes from the Field #015

  http://www.sqlserver.co.uk/index.php/sql-server-expanding-your-skills-notes-from-the-field-015/

     

• Transaction Isolation Levels

  http://www.sqlservercentral.com/articles/Transaction+Isolation+levels/106363/

     

• SQL Server configuration files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/13/sql-server-configuration-files.aspx

     

• SQL Server Indexed Views: The Basics

  https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/

     

• Using Windows Azure to Speed up Genome Research and Save Millions of Dollars

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/13/using-windows-azure-to-speed-up-genome-research-and-save-millions-of-dollars.aspx

• Troubleshooting Concurrency ? A Demo

  http://michaeljswart.com/2014/02/troubleshooting-concurrency-a-demo/

     

• Virtual Lab ? Design and Setup

  http://voiceofthedba.wordpress.com/2014/02/06/virtual-lab-design-and-setup/

     

• Corruption recovery using DBCC WRITEPAGE

  http://www.sqlskills.com/blogs/paul/corruption-recovery-using-dbcc-writepage

     

     

SQL

• SQL SERVER ? Fix ? Error ? 3023 ? Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized.

  http://raresql.com/2014/02/12/sql-server-fix-error-3023-backup-and-file-manipulation-operations-such-as-alter-database-add-file-on-a-database-must-be-serialized/

     

• An Overview of SSIS Parameters - Level 15 of the Stairway to Integration Services

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/106428/

     

• Discover and Manage your SQL Server environment with SQL Elements

  http://www.mssqltips.com/sqlservertip/3161/discover-and-manage-your-sql-server-environment-with-sql-elements/

     

• SQL SERVER ? SafePeak SQL Server Acceleration Software Gets an Upgrade

  http://www.sqlserver.co.uk/index.php/sql-server-safepeak-sql-server-acceleration-software-gets-an-upgrade/

     

• How Often Do I Backup my Log?

  http://voiceofthedba.wordpress.com/2014/02/12/how-often-do-i-backup-my-log/

• Make Your Storage Administrator Your Best Friend

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/11/make-your-storage-administrator-your-best-friend.aspx

     

• The Distributor. Think and Rethink every thing.

  http://www.sqlserver.co.uk/index.php/the-distributor-think-and-rethink-every-thing/

     

LINKS

• Last Weeks Top "Reading" Links #70

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/10/last-weeks-top-reading-links-70.aspx

     

Other

• 8 common (but deadly) MySQL operations mistakes and how to avoid them

  http://www.mysqlperformanceblog.com/2014/02/12/8-common-but-deadly-mysql-operations-mistakes-and-how-to-avoid-them/

SQL

• More on using Transaction SID from the transaction log

  http://www.sqlskills.com/blogs/paul/using-transaction-sid-transaction-log

• Best approaches for grouped median

  http://www.sqlperformance.com/2014/02/t-sql-queries/grouped-median

• DELETE operations on tables

  http://www.sqlpassion.at/archive/2014/02/11/delete-operations-on-tables

     

• Scratchpad: #SQLServer backup failures after enabling T1118 & T2371

  http://sql-sasquatch.blogspot.kr/2014/02/scratchpad-sqlserver-backup-failures.html

     

• Calculating the length of a hash in SQL Server

  http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/calculating-the-length-of-a-hash-in-sql-server/

     

• Using Row_Number to pick the correct entry

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/11/using-row-number-to-pick-the-correct-entry.aspx

     

• [SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server

  http://thesqlpro.com/2014/02/11/sql-snacks-video-instant-file-initialization

     

• SQL SERVER ? How to filter databases in sp_MSforeachdb

  http://raresql.com/2014/02/11/sql-server-how-to-filter-databases-in-sp_msforeachdb/

• T-SQL Tuesday #51 ? Place Your Bets

  http://voiceofthedba.wordpress.com/2014/02/11/t-sql-tuesday-51-place-your-bets/

     

• Why is Your SQL Server Slow? Here's a Hint

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

     

• Scheduled Data Refresh in Power BI #powerbi #powerpivot

  http://www.sqlserver.co.uk/index.php/scheduled-data-refresh-in-power-bi-powerbi-powerpivot/

     

• SSAS: DistinctCount

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/11/ssas-distinctcount.aspx

     

Other

• R skills attract the highest salaries

  http://blog.revolutionanalytics.com/2014/02/r-salary-surveys.html

     

• Redis 3.0.0 beta-1 is out

  http://data.story.lu/2014/02/11/redis-3-0-0-beta-1-is-out

  클러스터가 나왔군여~~ 오호~~

     

• PERFORMANCE_SCHEMA vs Slow Query Log

  http://www.mysqlperformanceblog.com/2014/02/11/performance_schema-vs-slow-query-log/

     

• WITHer Recursive Queries?

  http://www.mysqlperformanceblog.com/2014/02/11/wither-recursive-queries/

SQL

• SQL Server Diagnostic Information Queries for February 2014 - Glenn Berry

  http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-february-2014

• Looking at read_microsec in sys.dm_os_buffer_descriptors in SQL Server 2012

  http://www.sqlskills.com/blogs/jonathan/looking-read_microsec-sys-dm_os_buffer_descriptors-sql-server-2012

• SQL Server: looking for disk errors and timeouts

  http://sql-sasquatch.blogspot.kr/2014/02/sql-server-looking-for-disk-errors-and.html

     

• Best Practices SQL Server Transaction Log

  http://sqldbpool.com/2014/02/10/best-practices-sql-server-transaction-log/

     

• One Preparation that makes SSMS Crash Dumps Easy to Survive

  http://aalamrangi.wordpress.com/2011/10/25/recover-queries-after-a-sql-server-management-studio-ssms-crash/

     

• Configure Kerberos for SQL with Virtual Accounts

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/10/configure-kerberos-for-sql-with-virtual-accounts.aspx

     

• SQL Server 2012 AlwaysOn Groups and FCIs Part 1

  http://www.sqlservercentral.com/articles/AlwaysOn/98619/

     

• Enabling Data Compression ? February 2014 Update

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/10/enabling-data-compression-february-2014-update.aspx

• Recover deleted SQL Server data and tables with the help of Transaction Log and LSNs

  http://www.mssqltips.com/sqlservertip/3160/recover-deleted-sql-server-data-and-tables-with-the-help-of-transaction-log-and-lsns/

     

• SQL SERVER ? Migration of SQL Server 2012 Database Mirroring to AlwaysOn Availability Group

  http://blog.sqlauthority.com/2014/02/10/sql-server-migration-of-sql-server-2012-database-mirroring-to-always-on-availability-group/

     

• SSRS ? Creating Drill Through reports with MDX

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/10/ssrs-creating-drill-through-reports-with-mdx.aspx

     

     

LINKS

• 구루의 기술뉴스 ? 오픈소스 수퍼 루키 10선 외 23건

  http://xguru.net/1880

     

Other

• Amazon Elastic Block Store (Amazon EBS) 소개

  http://sqlmvp.kr/140206463462

     

• Generating test data for MySQL tables

  http://www.mysqlperformanceblog.com/2014/02/10/generating-test-data-mysql-tables/

SQL

• SQL Server Diagnostic Information Queries for February 2014

  http://sqlserverperformance.wordpress.com/2014/02/06/sql-server-diagnostic-information-queries-for-february-2014/

• Top 10 Process Listing By Memory Consumption ? GUI Tool

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/07/top-10-process-listing-by-memory-consumption-gui-tool.aspx

     

• Getting started with SQL Server 2014 In-Memory OLTP

  http://www.mssqltips.com/sqlservertip/3121/getting-started-with-sql-server-2014-inmemory-oltp/

• Differential Database Backup with Memory-Optimized Tables

  http://www.sqlserver.co.uk/index.php/differential-database-backup-with-memory-optimized-tables/

     

• How to Process a SSAS MOLAP cube as fast as possible ? Part 1

  http://henkvandervalk.com/how-to-process-a-ssas-molap-cube-as-fast-as-possible-part-1

     

• MDX+SSAS #37-Ignore unrelated dimension or not

  http://beyondrelational.com/modules/2/blogs/101/Posts/19830/mdxssas-37-ignore-unrelated-dimension-or-not.aspx

     

LINKS

• (SFTW) SQL Server Links 07/02/14

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/07/sftw-sql-server-links-07-02-14.aspx

• Friday Followup For February 7, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/07/friday-followup-for-february-7-2014.aspx

     

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

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

     

Other

• Java의 날짜와 시간 API

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

     

• Elasticsearch 101

  https://blog.codecentric.de/en/2014/02/elasticsearch-101/

     

• AmazonEC2 (Amazon Elastic Compute Cloud) 소개

  http://sqlmvp.kr/140206264095

안녕하세요. SQLTAG 회원 여러분~~

오늘은 즐거운 금요일입니다.

얼마 전 The Database Administrator is dead 블로그 내용 보셨는지요..

참으로 세상의 기술이 많이 변한 세상이구나 생각이 드네요..

http://voiceofthedba.wordpress.com/2014/01/29/the-dba-is-dead/

SQL

• How to move databases configured for SQL Server AlwaysOn

  http://blogs.msdn.com/b/sqlserverfaq/archive/2014/02/06/how-to-move-databases-configured-for-sql-server-alwayson.aspx

     

• Using SQL Server's Table Valued Parameters

  http://www.brentozar.com/archive/2014/02/using-sql-servers-table-valued-parameters/

     

• The Evolution of the DBA

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/06/the-evolution-of-the-dba.aspx

     

• New Free Video On The MDX CurrentMember Function

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/06/new-free-video-on-the-mdx-currentmember-function.aspx

     

• Sending a Variable Number of Elements in a Parameter

  http://www.sqlservercentral.com/articles/T-SQL/106298/

     

• SQL SERVER ? Learning SSIS ? Where Do I Start? ? Notes from the Field #014

  http://www.sqlserver.co.uk/index.php/sql-server-learning-ssis-where-do-i-start-notes-from-the-field-014/

     

• HOW TO: Connect To A Windows Azure VM Using SQL Server Management Studio

  http://thomaslarock.com/2014/02/connect-to-a-windows-azure-vm-using-sql-server-management-studio