SQL

• Don't Rely On a Static IP Address for Your SQL Database

  http://blogs.msdn.com/b/psssql/archive/2014/03/27/don-t-rely-on-a-static-ip-address-for-your-sql-database.aspx

     

• Configuring Service Broker for Asynchronous Processing

  http://www.sqlperformance.com/2014/03/sql-performance/configuring-service-broker

     

• Transactional Replication and the Ballooning Log File

  http://www.sqlservercentral.com/articles/Replication/107698/

     

     

Other

• MySQL 5.6.17 ? now with better encryption

  http://mysqlblog.fivefarmers.com/2014/03/27/mysql-5-6-17-now-with-better-encryption/

     

• A conversation with 5 Facebook MySQL gurus

  http://www.mysqlperformanceblog.com/2014/03/27/a-conversation-with-5-facebook-mysql-gurus/

     

• 확률적 자료구조를 이용한 추정 - 유일한 원소 개수(Cardinality) 추정과 HyperLogLog

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

SQL

• How to Add Nonclustered Indexes to Clustered Columnstore Indexes

  http://www.brentozar.com/archive/2014/03/add-nonclustered-indexes-clustered-columnstore-indexes/

• SSAS Tabular: Internal Physical Files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/25/ssas-tabular-internal-physical-files.aspx        

     

• Creating a Disaster Recovery Plan

  http://www.sqlserver-dba.com/2014/03/creating-a-disaster-recovery-plan.html

     

• The Illusion of Updateable Clustered ColumnStore Indexes

  http://www.sqlpassion.at/archive/2014/03/25/the-illusion-of-updateable-clustered-columnstore-indexes

     

• Implementing SQL Server Transaction Retry Logic for failed transactions

  http://www.mssqltips.com/sqlservertip/3188/implementing-sql-server-transaction-retry-logic-for-failed-transactions/

     

• Using EXCEPT to Determine Row Differences

  http://www.sqlservercentral.com/articles/EXCEPT/107520/

     

• Making the Case for INSTEAD OF Triggers ? Part 1

  http://www.sqlperformance.com/2014/03/t-sql-queries/instead-of-triggers-1

     

LINKS

• Last Weeks Top "Reading" Links #76

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

SQL

• How to Do Some Very Basic SQL Server Monitoring

  http://www.sqlskills.com/blogs/glenn/how-to-do-some-very-basic-sql-server-monitoring/

• SQL Server Application Role

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/24/sql-server-application-role.aspx

     

• Amway sees 100 percent availability with hybrid data-recovery solution

  http://www.sqlserver.co.uk/index.php/amway-sees-100-percent-availability-with-hybrid-data-recovery-solution/

• Validate the contents of large dynamic SQL strings in SQL Server

  http://www.mssqltips.com/sqlservertip/3185/validate-the-contents-of-large-dynamic-sql-strings-in-sql-server/

     

• Error 5171 ? mdf is not a primary database file

  http://www.sqlserver-dba.com/2014/03/error-5171-mdf-is-not-a-primary-database-file.html

• Language components of Structured Query Language (SQL)

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/24/language-components-of-structured-query-language-sql.aspx

     

• High Performance Relational Division in SQL Server

  https://www.simple-talk.com/sql/learn-sql-server/high-performance-relational-division-in-sql-server/

     

• THE PARALLAX VIEW OF YOUR CAREER

  http://thomaslarock.com/2014/03/parallax-view-career

     

LINKS

• LAST WEEKS TOP "READING" LINKS #76

  http://www.jasonstrate.com/2014/03/last-weeks-top-reading-links-76/

     

Other

• PostgreSQL introduced jsonb support

  http://data.story.lu/2014/03/24/postgresql-introduced-jsonb-support

     

• How to Backup SQL Server Directly to Azure Storage

  http://miteshc.wordpress.com/2014/03/24/how-to-backup-sql-server-directly-to-azure-storage/

     

• 빠르게 훝어 보는 node.js - #3 Event,Module,NPM

  http://bcho.tistory.com/885

     

• 구루의 기술뉴스 ? 페이스북의 PHP 사랑은 어디까지? Hack 외 15건

  http://xguru.net/1889

SQL

• How to recover a suspect msdb database in SQL Server

  http://www.mssqltips.com/sqlservertip/3191/how-to-recover-a-suspect-msdb-database-in-sql-server/

• Troubleshooting BACKUPTHREAD wait type

  http://www.sqlserver-dba.com/2014/03/troubleshooting-backupthread-wait-type.html

     

LINKS

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

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

     

• Recommended reading from mrdenny for March 21, 2014

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

     

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

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

     

• Friday Followup For March 21, 2014

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

     

• Automate Sliding Window Partition Maintenance: Part III

  http://www.sqlservercentral.com/articles/Partitioning/71657/

     

Other

• Azure IaaS Virtual Machine Creation Checklist

  http://miteshc.wordpress.com/2014/03/21/azure-vm-checklist/

SQL

• A cause of high-duration ASYNC_IO_COMPLETION waits

  http://www.sqlskills.com/blogs/paul/cause-high-duration-async_io_completion-waits

• Too many files causing RAM pressure? (a.k.a. DynCache to the rescue!)

  http://blogs.msdn.com/b/arvindsh/archive/2014/03/20/too-many-files-causing-ram-pressure-a-k-a-dyncache-to-the-rescue.aspx

• After You've Been a DBA, What Do You Do?        

  http://www.brentozar.com/archive/2014/03/dba-career-afterwards/

     

• Understanding LINQ to Join Multiple Tables Where Null Match Are Expected

  http://www.mssqltips.com/sqlservertip/3169/understanding-linq-to-join-multiple-tables-where-null-match-are-expected/

     

• SQL SERVER ? How to Identify the Locks Held by FileTables

  http://raresql.com/2014/03/20/sql-server-how-to-identify-the-locks-held-by-filetables/

     

• MSTVF Fixed Cardinality Value in SQL Server 2014

  http://www.sqlskills.com/blogs/joe/mstvf-fixed-cardinality-value-sql-server-2014

• Where's my FileTable space?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/20/where-s-my-filetable-space.aspx        

• Remaining Vigilant, my contribution to #DBAJumpStart ? Part 3

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/20/remaining-vigilant-my-contribution-to-dbajumpstart-part-3.aspx

     

• Grant EXEC on all Stored Procedures to a Role

  http://www.sqlservercentral.com/articles/Permissions/107472/

     

• Pretty Patterns With Power Query And Power Map

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/20/pretty-patterns-with-power-query-and-power-map.aspx

UPDATE

• Cumulative Update #9 for SQL Server 2012 SP1

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-9-for-sql-server-2012-sp1.aspx

     

• Cumulative Update #16 for SQL Server 2008 SP3

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/03/17/cumulative-update-16-for-sql-server-2008-sp3.aspx

SQL

• Microsoft officially announces release of SQL Server 2014 (April 1st, 2014)

  http://www.mssqltips.com/sqlservertip/3203/microsoft-officially-announces-release-of-sql-server-2014/

  http://sqlblog.com/blogs/damian_widera/archive/2014/03/19/sql-server-2014-has-come-into-the-light-the-rtm-will-be-available-on-1st-april.aspx

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/sql-server-2014-rtm-april-1st-and-that-s-no-joke.aspx

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/sql-server-2014-rtm-release-date.aspx

     

• How to determine what causes a particular wait type

  http://www.sqlskills.com/blogs/paul/determine-causes-particular-wait-type

     

• An Introduction to Asynchronous Processing with Service Broker

  http://www.sqlperformance.com/2014/03/sql-performance/intro-to-service-broker

     

• Stop the SQL Server Finger Pointing!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/stop-the-sql-server-finger-pointing.aspx

     

• A Primer on Locks, Blocks and Deadlocks

  http://michaeljswart.com/2014/03/a-primer-on-locks-blocks-and-deadlocks/

     

• What is the most worrying cause of log growth (log_reuse_wait_desc)?

  http://www.sqlskills.com/blogs/paul/worrying-cause-log-growth-log_reuse_wait_desc

     

• Performance improvements in SQL Server 2014

  http://www.sqlpassion.at/archive/2014/03/18/performance-improvements-in-sql-server-2014

     

• Parallel Data Warehouse (PDW) benefits made simple

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/parallel-data-warehouse-pdw-benefits-made-simple.aspx

     

• Rollback: What happens when you KILL a session?

  http://www.brentozar.com/archive/2014/03/happens-issue-kill/

     

• Review Your BUCKET_COUNT Statistics with DMV

  http://www.databasejournal.com/features/mssql/review-your-bucketcount-statistics-with-dmv.html

     

• Creating a Date Range from Multiple Rows Based on a Single Date

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

     

• Finding One Problem Query With Extended Events

  http://www.brentozar.com/archive/2014/03/finding-one-problem-query-extended-events/

     

• Where is my Availability Group?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/where-is-my-availability-group.aspx

     

• Troubleshooting Error: 18452, Severity: 14, State: 1

  http://www.sqlserver-dba.com/2014/03/troubleshooting-.html

     

• Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective

  http://www.sql-server-performance.com/2014/natural-surrogate-keys/

     

• Collation: Definition

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/19/collation-definition.aspx

     

• Remaining Vigilant, my contribution to #DBAJumpStart ? Part 1

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/18/remaining-vigilant-my-contribution-to-dbajumpstart-part-1.aspx

     

• Remaining Vigilant, my contribution to #DBAJumpStart ? Part 2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/19/remaining-vigilant-my-contribution-to-dbajumpstart-part-2.aspx

     

     

Other

• JBoss Infinispan 온라인 웨비나 내용 노트

  http://bcho.tistory.com/883

SQL

• Troubleshooting PREEMPTIVE_OS_LOOKUPACCOUNTSID wait type

  http://www.sqlserver-dba.com/2014/03/troubleshooting-preemptive_os_lookupaccountsid-wait-type.html

• SQL Swiss Army Knife #13 ? Exploring the plan cache ? Part 2

  http://blogs.msdn.com/b/blogdoezequiel/archive/2014/03/16/sql-swiss-army-knife-13-exploring-the-plan-cache-part-2.aspx

     

• Using Configuration Files in SSIS

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/17/using-configuration-files-in-ssis.aspx

     

• Steps for Windows Cluster Installation on Windows Server 2008

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/17/steps-for-windows-cluster-installation-on-windows-server-2008.aspx

     

• Windows Azure SQL Database - Uploading Data by Using the bcp Utility

  http://www.databasejournal.com/features/mssql/windows-azure-sql-database-uploading-data-by-using-the-bcp-utility.html

     

• SQL Server Analysis Services ProcessAdd for a Partition

  http://www.mssqltips.com/sqlservertip/3073/sql-server-analysis-services-processadd-for-a-partition/

     

• Having fun with PARSENAME (SQL Spackle)

  http://www.sqlservercentral.com/articles/PARSENAME/106755/

     

• How to Get Your First Job as a DBA (video)

  http://www.brentozar.com/archive/2014/03/get-first-job-dba-video/

     

• SQL SERVER 2012 ? How to generate a negative serial numbers for a result set by using the Sequence Object

  http://raresql.com/2014/03/17/sql-server-2012-how-to-generate-a-negative-serial-numbers-for-a-result-set-by-using-the-sequence-object/

     

LINKS

• Last Weeks Top "Reading" Links #75

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/17/last-weeks-top-reading-links-75.aspx

     

Other

• 빠르게 훝어보는 node.js #1 - node.js 소개 및 내부구조

  http://bcho.tistory.com/881

     

• PowerShell ? System Information

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/17/powershell-system-information.aspx

SQL

• Some great news for Standard Edition customers in SQL Server 2014

  http://www.sqlperformance.com/2014/03/system-configuration/great-news-for-standard-edition
  2014 STD 최대 메모리가 64GB -> 128GB으로 늘었났네요. Buffer Pool Extensions도 초반 ENT 버젼으로 나왔는데 STD까지 사용 가능.

• Top SQL Blogs ? Windows 8 App | from MSDN, MVPs and Top Bloggers

  http://sqlwithmanoj.wordpress.com/2014/03/14/top-sql-blogs-windows-8-app-from-msdn-mvps-and-top-bloggers/

     

• Verify a success of database backups

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/16/verify-a-success-of-database-backups.aspx

     

• Uniquifiers: all rows or the duplicate keys only?

  http://spaghettidba.com/2014/03/14/uniquifiers-all-rows-or-the-duplicate-keys-only/

     

• Dive deep into SQL Server 2014 in-memory OLTP

  http://searchsqlserver.techtarget.com/tip/Dive-deep-into-SQL-Server-2014-in-memory-OLTP

     

• Disk Partition Alignment for Windows Server 2012, SQL Server 2012, and SQL Server 2014

  http://blogs.msdn.com/b/jimmymay/archive/2014/03/14/disk-partition-alignment-for-windows-server-2012-sql-server-2012-and-sql-server-2014.aspx

     

• Performance Tuning with SQL Server Dynamic Management Views

  http://sqlblog.com/blogs/sergio_govoni/archive/2014/03/14/performance-tuning-with-sql-server-dynamic-management-views.aspx

     

• Useful SQL Queries and Projects

  http://java.dzone.com/articles/useful-sql-queries-and

     

• Strange behaviour on CHECK constraint

  http://sqlblog.com/blogs/damian_widera/archive/2014/03/16/strange-behaviour-on-check-constraint.aspx

     

• PowerShell to list the packages stored in Integration Services SQL2008/SQL2008R2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/14/powershell-to-list-the-packages-stored-in-integration-services-sql2008-sql2008r2.aspx

     

• BI Beginner: Use Power Query To Get Data From Web Pages

  http://sqlblog.com/blogs/john_paul_cook/archive/2014/03/13/bi-beginner-use-power-query-to-get-data-from-web-pages.aspx

     

• Automate Sliding Window Partition Maintenance: Part II

  http://www.sqlservercentral.com/articles/Partitioning/71656/

     

• Why worry about CXPACKET

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/11/why-worry-about-cxpacket.aspx

     

• Local TempDB on SQL 2012

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/11/local-tempdb-on-sql-2012.aspx

     

• When is a Data Management Gateway Needed in Power BI?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/16/when-is-a-data-management-gateway-needed-in-power-bi.aspx

     

• Big Data Basics - Part 4 - Introduction to HDFS

  http://www.mssqltips.com/sqlservertip/3180/big-data-basics--part-4--introduction-to-hdfs/

     

• Real-time query access with PDW

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/13/real-time-query-access-with-pdw.aspx

     

LINKS

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

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

• Friday Followup For March 14, 2014

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

• Recommended reading from mrdenny for March 14, 2014

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

     

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

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

     

Other

• Everything is Data ? TEDxSNU 발표

  http://zeronova.kr/2014/03/15/everything-is-data-tedxsnu/

     

• Tools and tips for analysis of MySQL's Slow Query Log

  http://www.mysqlperformanceblog.com/2014/03/14/tools-and-tips-for-analysis-of-mysqls-slow-query-log/

     

• 실시간 빅데이터는 어떻게 분석할까

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

     

• 린분석(Lean Analytics) with 레진코믹스

  http://xguru.net/1887

SQL

• #sqlhelp

  http://voiceofthedba.wordpress.com/2014/03/13/sqlhelp/

  트위터를 통해 전세계 DBA에게 요청할 수 있는 키워드 입니다^^

     

• Hekaton and Benchmarks? - Joe Chang

  http://sqlblog.com/blogs/joe_chang/archive/2014/03/13/hekaton-and-benchmarks.aspx

     

• Tables without Clustered Indexes?        

  http://basitaalishan.com/2014/03/13/tables-without-clustered-indexes/        

     

• When Do You Fire the DBA?

  http://www.brentozar.com/archive/2014/03/fire-dba/

     

• Quick tip: Querying AD with xp_logininfo

  http://mattsql.wordpress.com/2014/03/13/quick-tip-querying-ad-with-xp_logininfo/

     

• SQL Server, SQL Articles and more!

  http://www.sqlserver.co.uk/index.php/sql-server-ssis-data-flow-troubleshooting-part1-notes-from-the-field-019/

     

• SFTP, encrypt or compress data files in SSIS using custom components

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

Other

• 4개의 테크 기업을 창업하면서 배운 90가지 유/무형의 자산들

  http://www.mimul.com/pebble/default/2014/03/13/1394701210786.html

SQL

• A True SQL OS

  http://voiceofthedba.wordpress.com/2014/03/12/a-true-sql-os/

     

• Troubleshoot Database Concurrency in SQL Server with sp_locks

  http://www.sql-server-performance.com/2014/concurrency-sp-locks/

     

• Using whoami to check for instant file initialization

  http://sqlblog.com/blogs/tibor_karaszi/archive/2014/03/12/using-whoami-to-check-for-instant-file-initialization.aspx

     

• Extended Events ? It Doesn't Have to be Hard

  http://www.brentozar.com/archive/2014/03/extended-events-doesnt-hard/

     

• SQL 2012 datetime rounding issue

  http://www.sqlserver-dba.com/2014/03/sql-2012-datetime-rounding-issue.html

     

Other

• MySQL ? How to do Straight Join in MySQL?

  http://www.sqlserver.co.uk/index.php/mysql-how-to-do-straight-join-in-mysql/