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/

SQL

• The ACID Properties of Statements & Transactions - Paul White

  http://www.sqlperformance.com/2014/02/t-sql-queries/confusion-caused-by-trusting-acid

• What is the most worrying wait type?

  http://www.sqlskills.com/blogs/paul/worrying-wait-type/

• How to Use Partitioning to Make kCura Relativity Faster

  http://www.brentozar.com/archive/2014/02/partitioning-kcura-relativity-audithistory-table/

     

• Issue with sys.dm_db_index_usage_stats in SQL Server 2012

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/27/issue-with-sys-dm-db-index-usage-stats-in-sql-server-2012.aspx

     

• DBAs Checklist for Designing and Reviewing SQL Server System Architectures

  http://www.mssqltips.com/sqlservertip/3166/dbas-checklist-for-designing-and-reviewing-sql-server-system-architectures/

     

• Identify the Backup used to Restore the Database

  http://www.sqlservercentral.com/articles/Backup+Restore/106622/

     

• Virtual Lab ? Setting up a new VM

  http://voiceofthedba.wordpress.com/2014/02/27/virtual-lab-setting-up-a-new-vm/

     

• PowerShell ? SSRS Inventory ? Automatic ? Excel File ? EMAIL

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/27/powershell-ssrs-inventory-automatic-excel-file-email.aspx

     

     

Other

• Gaming on AWS요약

  http://wapj.postach.io/gaming-on-awsyoyag

     

• DBA 101: Sometimes forgotten functionality in the MySQL client

  http://www.mysqlperformanceblog.com/2014/02/27/dba-101-sometimes-forgotten-functionality-mysql-client/

     

• Where Are All the DBAs in NoSQL?

  http://java.dzone.com/articles/where-are-all-dbas-nosql

SQL

• Impersonating a server level permissions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/26/impersonating-a-server-level-permissions.aspx

• SQL Server Query Performance Guidelines Tutorial

  http://www.mssqltips.com/sqlservertip/3186/sql-server-query-performance-guidelines-tutorial/

• SQL Server 2014: Encryption for Backups

  http://www.sql-server-performance.com/2014/sql-server-2014-encryption-backups/

     

• Indexes - The downside

  http://www.sqlserver-dba.com/2014/02/indexes-the-downside.html

• Back Up Transaction Logs Every Minute. Yes, Really.

  http://www.brentozar.com/archive/2014/02/back-transaction-logs-every-minute-yes-really/

• Caching

  http://voiceofthedba.wordpress.com/2014/02/26/caching/

• Does SQL Server database size affect performance?

  http://searchsqlserver.techtarget.com/tip/Does-SQL-Server-database-size-affect-performance

     

• Data Visualizations

  http://www.sqlserver.co.uk/index.php/data-visualizations/

     

LINKS

Other

• How to monitor ALTER TABLE progress in MySQL

  http://www.mysqlperformanceblog.com/2014/02/26/monitor-alter-table-progress-innodb_file_per_table/

SQL

• How to analyse SQL Server performance

  http://rusanu.com/2014/02/24/how-to-analyse-sql-server-performance/

• Lock Escalations

  http://www.sqlpassion.at/archive/2014/02/25/lock-escalations

     

• Understanding Graphical Execution Plans - Part 3: Analyzing the Plan

  http://www.sqlservercentral.com/articles/Execution+Plans/105810/

     

• Identify SQL Server databases that are no longer in use

  http://www.mssqltips.com/sqlservertip/3171/identify-sql-server-databases-that-are-no-longer-in-use/

     

• Database size limitation in SQL Express

  http://blogs.msdn.com/b/arvindsh/archive/2014/02/25/database-size-limitation-in-sql-express.aspx

     

• Seven SQL Server Under-Used Utilities

  https://www.simple-talk.com/sql/database-administration/seven-sql-server-under-used-utilities/

• SQL SERVER ? sp_refreshview ? How to update the metadata of view

  http://raresql.com/2014/02/25/sql-server-sp_refreshview-how-to-update-the-metadata-of-view/

     

• AlwaysOn Availability Groups and Automation

  http://joedantoni.wordpress.com/2014/02/25/alwayson-availability-groups-and-automation/

     

• Achieving High SQL Server Availability: RPO and RTO Strategy

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/25/achieving-high-sql-server-availability-rpo-and-rto-strategy.aspx

     

• Excel: Using Inquire

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/25/excel-using-inquire.aspx

     

• What is HDInsight?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/25/what-is-hdinsight.aspx