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

안녕하세요. 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/