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

즐거운 급여일이네요~~ 오늘도 화이팅하시구요~++

SQL

• Avoid using NOLOCK on SQL Server UPDATE and DELETE statements

  http://www.mssqltips.com/sqlservertip/3172/avoid-using-nolock-on-sql-server-update-and-delete-statements/

• Tracking TEMPDB internal object space usage in SQL 2012

  http://blogs.msdn.com/b/arvindsh/archive/2014/02/24/tracking-tempdb-internal-object-space-usage-in-sql-2012.aspx

• What's the difference between a temp table and a table variable?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/24/what-s-the-difference-between-a-temp-table-and-a-table-variable.aspx

     

• A Quick Tour of sp_ExecuteSQL

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

     

• Rapid SQL Server Database Deployment

  https://www.simple-talk.com/sql/sql-tools/rapid-sql-server-database-deployment/

     

• Step-by-Step: File Server Disaster Recovery in the Clouds with Windows Azure and Windows Server 2012 R2

  http://java.dzone.com/articles/step-step-file-server-disaster

     

• Standard Deviations with CTE in SQL

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/24/standard-deviations-with-cte-in-sql.aspx

     

• How to pass a #DAX query to DAX Formatter

  http://sqlblog.com/blogs/marco_russo/archive/2014/02/24/how-to-pass-a-dax-query-to-dax-formatter.aspx

     

• 31 DAYS OF SSIS ? THE INTRODUCTION(SQL Server 2008 R2)

  http://www.jasonstrate.com/2011/01/31-days-of-ssis-the-introduction/

     

• Create/write to an Excel 2007/2010 spreadsheet from an SSIS package

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

     

• Allocation in Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/24/allocation-in-power-query.aspx

     

• PowerShell ? Export SQL Data to Excel with Powershell

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/24/powershell-export-sql-data-to-excel-with-powershell.aspx

     

LINKS

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

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

• Last Weeks Top "Reading" Links #72

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

     

Other

• The MySQL ARCHIVE storage engine ? Alternatives

  http://www.mysqlperformanceblog.com/2014/02/24/the-mysql-archive-storage-engine-alternatives/

     

• 리눅스 시스템 모니터링 시스템 최적화

  http://blog.rubi.kr/%EB%A6%AC%EB%88%85%EC%8A%A4-%EC%8B%9C%EC%8A%A4%ED%85%9C-%EB%AA%A8%EB%8B%88%ED%84%B0%EB%A7%81-%EC%8B%9C%EC%8A%A4%ED%85%9C-%EC%B5%9C%EC%A0%81%ED%99%94/

• [오픈소스컨설팅AWS 서비스 구성 및 관리 가이드-2014.02기준        

  http://www.slideshare.net/ienvyou/aws-v1

SQL

• Using Natively Compiled Stored Procedures in SQL Server 2014

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/21/using-natively-compiled-stored-procedures-in-sql-server-2014.aspx

• Extended Events for Tracking Code Improvements (video)

  http://www.brentozar.com/archive/2014/02/extended-events-tracking-code-improvements-video/

• Using Natively Compiled Stored Procedures in SQL Server 2014

  http://www.sqlserver.co.uk/index.php/using-natively-compiled-stored-procedures-in-sql-server-2014/

     

• Defining half a dozen daily SQL Server DBA responsibilities

  http://searchsqlserver.techtarget.com/tip/Defining-half-a-dozen-daily-SQL-Server-DBA-responsibilities

     

• SQL SERVER ? Fix ? Error ? The File location cannot be opened. Either access is not enabled or you do not have permissions for the same.

  http://raresql.com/2014/02/21/sql-server-fix-error-the-file-location-cannot-be-opened-either-access-is-not-enabled-or-you-do-not-have-permissions-for-the-same/

     

• Adding SQL Server AlwaysOn to existing Failover Clusters

  http://www.mssqltips.com/sqlservertip/3150/adding-sql-server-alwayson-to-existing-failover-clusters/

     

• Troubleshooting Clusters

  http://www.sqlserver.co.uk/index.php/troubleshooting-clusters/

• How to determine who deleted a SQL Server database

  http://www.sqlserver-dba.com/2014/02/how-to-determine-who-deleted-a-sql-server-database.html

     

• SQLAuthority News ? Two Whitepapers from AzureCAT Team on SQL Database

  http://blog.sqlauthority.com/2014/02/23/sqlauthority-news-two-whitepapers-from-azurecat-team-on-sql-database/

     

• Fix: Incorrect status output in the SSIS Data Quality transform

  http://sqlblog.com/blogs/greg_low/archive/2014/02/22/fix-incorrect-status-output-in-the-ssis-data-quality-transform.aspx

     

• Removing part of string before and after specific character using Transact-SQL string functions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/23/removing-part-of-string-before-and-after-specific-character-using-transact-sql-string-functions.aspx

     

• Copying and Pasting File Paths

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/21/copying-and-pasting-file-paths.aspx

     

LINKS

• Recommended reading from mrdenny for February 21, 2014

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

     

• Friday Followup For February 21, 2014

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

     

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

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

     

Other

• Node.js vs Vert.x 비교

  http://bcho.tistory.com/870

     

• Before every release: A glimpse into Percona XtraDB Cluster CI testing        

  http://www.mysqlperformanceblog.com/2014/02/21/before-every-release-a-glimpse-into-percona-xtradb-cluster-ci-testing/

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/