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/

SQL

• Performance Testing Methodologies: Discovering a New Way

  http://www.sqlperformance.com/2014/03/t-sql-queries/perf-test-methodologies

• sp_updatestats Is Not Smart

  http://www.scarydba.com/2014/03/11/sp_updatestats-is-not-smart/

     

• In Search of... #SQLServer stats maintenance model(s) Part I: Trace Flag 2388

  http://sql-sasquatch.blogspot.kr/2014/03/in-search-of-sqlserver-stats.html

     

• T-SQL Tuesday: Stop Tuning with Wait Stats Percentages

  http://www.brentozar.com/archive/2014/03/t-sql-tuesday-stop-tuning-wait-stats-percentages/

     

• Buffer Pool Extensions in SQL Server 2014

  http://www.sqlpassion.at/archive/2014/03/11/buffer-pool-extensions-in-sql-server-2014

     

• T-SQL Tuesday #052 ? Why Back Up System Databases?

  http://blogs.lessthandot.com/index.php/uncategorized/t-sql-tuesday-052-why-back-up-system-databases/

     

• Rapid SQL Server Database Deployment

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

     

• Changing the 1000 separator in Power View

  http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/changing-the-1000-separator-in-power-view/

     

• Scans are better than Seeks. Really.

  http://www.sqlserver.co.uk/index.php/scans-are-better-than-seeks-really/

     

Other

• Socket.IO 스터디 노트

  http://bcho.tistory.com/878

     

• Node.js에서 주로 사용되는 모듈

  http://bcho.tistory.com/877

     

• OK캐쉬백 앱용 HTML5 게임 개발기

  http://readme.skplanet.com/?p=7243

SQL

• How to read and interpret the SQL Server log

  http://rusanu.com/2014/03/10/how-to-read-and-interpret-the-sql-server-log/

     

• Handle conversion between time zones in SQL Server - part 2

  http://www.mssqltips.com/sqlservertip/3174/handle-conversion-between-time-zones-in-sql-server--part-2/

• Applying The Scientific Method to SQL Server Performance Tuning

  https://www.simple-talk.com/sql/performance/applying-the-scientific-method-to-sql-server-performance-tuning/

     

• Why I Developed SQL Code Guard: A Fairy Tale from a DBA

  http://sqlcodeguard.blogspot.co.uk/2014/02/why-i-developed-sql-code-guard-fairy.html

     

• AlwaysOn Availability Groups - What Not to do when Adding Databases

  https://www.simple-talk.com/sql/database-administration/alwayson-availability-groups---what-not-to-do-when-adding-databases/

     

• How Agile esProc Syntax Facilitates Hadoop Coding

  http://beyondrelational.com/modules/2/blogs/925/posts/19847/how-agile-esproc-syntax-facilitates-hadoop-coding.aspx

     

• #0325 - SQL Server - fn_trace_gettable - Get database name change history from default trace

  http://beyondrelational.com/modules/2/blogs/77/Posts/19844/0325-sql-server-fntracegettable-get-database-name-change-history-from-default-trace.aspx

     

LINKS

• LAST WEEKS TOP "READING" LINKS #74

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

     

Other

• New mydumper 0.6.1 release offers performance and usability features

  http://www.mysqlperformanceblog.com/2014/03/10/new-mydumper-0-6-1-release-offers-several-performance-and-usability-features/

     

• NoSQL Job Trends: February 2014

  http://java.dzone.com/articles/nosql-job-trends-february-2014

SQL

• SQL Server Diagnostic Information Queries for March 2014

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

• DIRTY_PAGE_POLL and how to avoid it

  http://www.sqlserver-dba.com/2014/03/dirty_page_poll-and-how-to-avoid-it.html

• Adding SQL Server AlwaysOn to existing Failover Clusters

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

     

• Automate Sliding Window Partition Management: Part I

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

     

• Building a Workstation for SQL Server 2014 Development and Testing

  http://www.sqlskills.com/blogs/glenn/building-a-workstation-for-sql-server-2014-development-and-testing

• Comparison of SSMS and Visual Studio for Development

  http://sqlblog.com/blogs/john_paul_cook/archive/2014/03/07/comparison-of-ssms-and-visual-studio-for-development.aspx

• Top 2 Features of Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/08/top-2-features-of-power-query.aspx

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

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

     

LINKS

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

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

     

• Friday Followup For March 7, 2014

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

     

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

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

     

Other

• MySQL ? Generating Row Number for Each Row using Variable

  http://www.sqlserver.co.uk/index.php/mysql-generating-row-number-for-each-row-using-variable/

     

• [입 개발] Redis 가 멀티스레드라구요?

  http://charsyam.wordpress.com/2014/03/07/redis-%EA%B0%80-%EB%A9%80%ED%8B%B0%EC%8A%A4%EB%A0%88%EB%93%9C%EB%9D%BC%EA%B5%AC%EC%9A%94/

SQL

• Setting max server memory

  http://sqlblog.com/blogs/tibor_karaszi/archive/2014/03/06/setting-max-server-memory.aspx

  최대 메모리 설정을 T-SQL Script로 바로 볼 수 있네요

     

• Two New TPC-E Benchmark Results for Intel Xeon Ivy Bridge-EX Processors

  http://www.sqlskills.com/blogs/glenn/two-new-tpc-e-benchmark-results-for-intel-xeon-ivy-bridge-ex-processors

     

• SQL Server 2012 AlwaysOn Groups and FCIs Part 2

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

     

• Different approaches of counting number of rows in a table

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/06/different-approaches-of-counting-number-of-rows-in-a-table.aspx

• On Handling Dates in SQL

  https://www.simple-talk.com/sql/t-sql-programming/on-handling-dates-in-sql/

     

• SQL Server Audit Walkthrough

  http://www.sql-server-performance.com/2014/walkthrough-sql-server-audit/

     

• The Worst Database User

  http://www.brentozar.com/archive/2014/03/the-worst-database-user/

     

• Many-table joins in MySQL 5.6

  http://www.mysqlperformanceblog.com/2014/03/06/many-table-joins-mysql-5-6/

     

• AMD Improves Operational Agility with SQL Server 2014 Business Intelligence Solution

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/03/06/amd-improves-operational-agility-with-sql-server-2014-business-intelligence-solution.aspx

     

• Virtual Lab ? Adapter Setup

  http://voiceofthedba.wordpress.com/2014/03/06/virtual-lab-adapter-setup/

SQL

• Need High Availability for SQL Server? Use Windows Server 2012.

  http://www.brentozar.com/archive/2014/03/need-high-availability-sql-server-windows-server-2012/

• ROLLBACK damn you!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/05/rollback-damn-you.aspx

     

• Do you clean up your Database Mail log tables?

  http://blog.sqlblog.com/blogs/tibor_karaszi/archive/2014/03/05/do-you-clean-up-your-database-mail-log-tables.aspx

     

• SQL Server Logical Reads ? What do they really tell us?

  http://www.sql-server-performance.com/2014/logical-reads/

     

• Creating a Kerberos Delegation Table for SQL Server Access

  http://www.mssqltips.com/sqlservertip/3177/creating-a-kerberos-delegation-table-for-sql-server-access/

     

• An updated Plan Explorer demo kit

  http://www.sqlperformance.com/2014/03/t-sql-queries/updated-plan-explorer-demo-kit

• SQL ? Backup Report

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/05/sql-backup-report.aspx

     

• Capturing query and IO statistics using Extended Events

  http://www.sqlserver.co.uk/index.php/capturing-query-and-io-statistics-using-extended-events/

• Top 3 Features I'm Excited About in SQL Server 2014

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/03/05/top-3-features-i-m-excited-about-in-sql-server-2014.aspx

     

• Removing trailing spaces in SSMS or Visual Studio

  http://sqlblog.com/blogs/john_paul_cook/archive/2014/03/05/removing-trailing-spaces-in-ssms-or-visual-studio.aspx

     

     

SQL

• Handle conversion between time zones in SQL Server - part 1

  http://www.mssqltips.com/sqlservertip/3173/handle-conversion-between-time-zones-in-sql-server--part-1/

• SSAS Tabular: Calculating the actual compression rate

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/04/ssas-tabular-calculating-the-actual-compression-rate.aspx

     

• Yes! You Can be a DBA Too

  http://www.johnsansom.com/yes-you-can-be-a-dba/

     

Other

• Getting started with Windows Azure PowerShell

  http://miteshc.wordpress.com/2014/03/04/getting-started-with-windows-azure-powershell/

SQL

• The SQL TABLE Type: Beyond Table-Valued Parameters

  http://www.sqlservercentral.com/articles/SQL+TABLE+TYPE/106602/

     

• Using the SQL Server 2014 Database Compatibility Level without the New CE

  http://www.sqlskills.com/blogs/joe/using-the-sql-server-2014-database-compatibility-level-without-the-new-ce

     

• Tips on TempDB

  http://www.pythian.com/blog/tips-on-tempdb-2/

• TRUNCATE TABLE Does NOT Preclude A Point-In-Time Recovery

  http://shaunjstuart.com/archive/2014/03/truncate-table-does-not/

     

• SSRS Top N and Bottom N reporting with Duplicates

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/03/ssrs-top-n-and-bottom-n-reporting-with-duplicates.aspx

     

• TRUNCATE TABLE Does NOT Preclude A Point-In-Time Recovery

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/03/truncate-table-does-not-preclude-a-point-in-time-recovery.aspx

     

• Managing Windows Azure SQL Database's newest feature ? Premium Database

  http://www.sqlskills.com/blogs/bobb/managing-windows-azure-sql-databases-newest-feature-premium-database/

     

• SSDT ? Fast deploy

  http://dataidol.com/davebally/2014/03/01/ssdt-fast-deploy/

     

• SQL SERVER ? Listing Foreign Key Relationships of Table with Stored Procedure sp_fkeys

  http://www.sqlserver.co.uk/index.php/sql-server-listing-foreign-key-relationships-of-table-with-stored-procedure-sp_fkeys/

     

• Bigger Database Servers Get Faster

  http://www.sqlskills.com/blogs/glenn/bigger-database-servers-get-faster/

     

• Amazingly Useful SQL Server Articles on SQLPerformance.com

  http://sqlblog.com/blogs/kevin_kline/archive/2014/03/03/amazingly-useful-sql-server-articles-on-sqlperformance-com.aspx

     

• Video: SQL Server 2014 - In Memory OLTP (Data Durability)

  http://www.connectsql.com/2014/03/video-sql-server-2014-in-memory-oltp.html

     

• Video: SQL Server 2014 - In Memory OLTP (MultiVersion Concurrency Control)

  http://www.connectsql.com/2014/02/video-sql-server-2014-in-memory-oltp.html

     

• sp_reset_connection ? Rate Usage (Don't fight over the grapes)

  http://blogs.msdn.com/b/psssql/archive/2014/03/03/sp-reset-connection-rate-usage-don-t-fight-over-the-grapes.aspx

     

• SQL Server Backup and Recovery: Staying Clear of Differential Base and Log Chain Disasters

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/03/03/inventory-sql-ssas-ssrs-excel-output-email.aspx

     

• SQL SERVER ? 28 Links for Learning SQL Wait Stats from Beginning

  http://www.sqlserver.co.uk/index.php/sql-server-28-links-for-learning-sql-wait-stats-from-beginning/

     

• Allocation in Power Query, Part 2

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

     

• Azure Scheduler 103 - Kevin Lam on the internals and details behind scheduled jobs

  http://channel9.msdn.com/Shows/Windows-Azure-Friday/Azure-Scheduler-103-Kevin-Lam-on-the-internals-and-details-behind-scheduled-jobs

     

LINKS

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

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

• Friday Followup For February 28, 2014

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

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

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

• Last Weeks Top "Reading" Links #73

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

• 구루의 기술뉴스 ? GitHub가 만든 차세대 에디터 Atom 외 20건

  http://xguru.net/1884

     

• Sysadmin Sunday 168

  https://blog.serverdensity.com/sysadmin-sunday-168

     

• Recommended reading from mrdenny for February 28, 2014

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

     

Other

• Oracle's Mats Kindahl to weave MySQL Fabric into Percona Live session

  http://www.mysqlperformanceblog.com/2014/03/03/oracles-mats-kindahl-weave-mysql-fabric-percona-live-session/

     

• How to avoid common (but deadly) MySQL development mistakes

  http://www.mysqlperformanceblog.com/2014/02/28/avoid-common-deadly-mysql-development-mistakes/

     

• 오픈소스 시대의 공부하는 방식의 변화

  http://bcho.tistory.com/873

     

• How rows_sent can be more than rows_examined?

  http://www.mysqlperformanceblog.com/2014/02/28/rows_sent-can-rows_examined/