SQL

• Types of MSSQL Joins

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/types-of-mssql-joins.aspx

     

• The Primary Filegroup Cannot be Backed Up as a File Backup

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/the-primary-filegroup-cannot-be-backed-up-as-a-file-backup.aspx

• Database Master Key Error After Database Restore

  http://www.sqlservercentral.com/articles/Database+Master+Key/107787/

     

• SQL Server Quickie #12 ? Nested Loop Operator

  http://www.sqlpassion.at/archive/2014/03/31/sql-server-quickie-12-nested-loop-operator

     

• Default nullability of a new column

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/default-nullability-of-a-new-column.aspx

     

• Refactoring T-SQL with Windowing Functions        

  http://www.brentozar.com/archive/2014/03/refactoring-t-sql-windowing-functions/

     

• SSIS Web Service Task

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/31/ssis-web-service-task.aspx

     

• Calculate Distinct Count in a Group By operation in Power Query #powerquery #powerbi

  http://sqlblog.com/blogs/marco_russo/archive/2014/03/31/calculate-distinct-count-in-a-group-by-operation-in-power-query-powerquery-powerbi.aspx

     

LINKS

• Last Weeks Top "Reading" Links #77

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

     

Other

• Tips to check and improve your storage IO performance with MongoDB

  http://edgystuff.tumblr.com/post/81219256714/tips-to-check-and-improve-your-storage-io-performance

     

• SQL Alias PowerShell scrip

  http://blogs.technet.com/b/sqlpfeil/archive/2014/03/31/sql-alias-powershell-scrip.aspx

     

• Password expiration policy in MySQL Server 5.7

  http://mysqlblog.fivefarmers.com/2014/03/31/password-expiration-policy-in-mysql-server-5-7/

SQL

• The SQL Server 2008 Datetimeoffset Data Type

  http://www.sqlservercentral.com/articles/SQL+Server+2008/72758/

• SSIS Do I Union All or Merge??

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/26/ssis-do-i-union-all-or-merge.aspx

• T4 Support in SSDT

  http://dataidol.com/davebally/2014/03/29/t4-support-in-ssdt/

     

LINKS

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

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

• Friday Followup For March 28, 2014

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

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

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

     

Other

• Innodb redo log archiving

  http://www.mysqlperformanceblog.com/2014/03/28/innodb-redo-log-archiving/

     

• Data Science는 과학이 아니다

  http://agbird.egloos.com/5807485

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

• Working with Web Services in Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/26/working-with-web-services-in-power-query.aspx

     

• SQL Server Indexing Questions We Were Too Shy To Ask

  https://www.simple-talk.com/sql/performance/sql-server-indexing-questions-we-were-too-shy-to-ask/

     

• Stairway to XML: Level 1 - Introduction to XML

  http://www.sqlservercentral.com/articles/Stairway+Series/Introduction+to+XML/92780/

     

• Collect Database and Table Index Grow Statistics for all SQL Servers Using PowerShell

  http://www.mssqltips.com/sqlservertip/3192/collect-database-and-table-index-grow-statistics-for-all-sql-servers-using-powershell/

     

• SQL SERVER ? SSIS Execution Control Using Precedence Constraints ? Notes from the Field #021

  http://www.sqlserver.co.uk/index.php/sql-server-ssis-execution-control-using-precedence-constraints-notes-from-the-field-021/

     

• Backup and Restore of an Analysis Services Database

  http://www.sql-server-performance.com/2014/backup-analysis-services-database/

     

• SQL Server buffer pool

  http://searchsqlserver.techtarget.com/definition/buffer-pool

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