SQL

• Database Backup with Memory-Optimized Tables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/02/05/database-backup-with-memory-optimized-tables.aspx

     

• Untold Secrets of SQL Server: What if?

  http://www.pythian.com/blog/untold-secrets-of-sql-server-what-if/

     

• Statistics Matter on Temp Tables, Too

  http://www.brentozar.com/archive/2014/02/statistics-matter-on-temp-tables-too/

     

• Transactions: What commands aren't allowed?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/05/transactions-what-commands-aren-t-allowed.aspx

     

• SQL SERVER ? Retrieve All the Data from VARCHAR(MAX) Column

  http://www.sqlserver.co.uk/index.php/sql-server-retrieve-all-the-data-from-varcharmax-column/

     

• Conditional Aggregates

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/conditional-aggregates.aspx

     

• Are your backups enough?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/are-your-backups-enough.aspx

     

• As The World Turns: SQL Server NUMA Memory Node and the Operating System Proximity

  http://blogs.msdn.com/b/psssql/archive/2014/02/04/as-the-world-turns-sql-server-numa-memory-node-and-the-operating-system-proximity.aspx

     

• AlwaysOn Availability Groups: Comparing On-Premises Deployments and Azure VM Deployments

  http://blogs.msdn.com/b/sqlcat/archive/2014/02/04/alwayson-availability-groups-comparing-on-premises-deployments-and-azure-vm-deployments.aspx

     

• Forum Etiquette: How to post Reporting Services problems

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/106306/

     

Other

• 16000 active connections ? Percona Server continues to work when others die

  http://www.mysqlperformanceblog.com/2014/02/04/16000-active-connections-percona-server-continues-work-others-die/

SQL

• Top SQL Server Forums of 2014

  http://www.johnsansom.com/top-sql-server-forums-2014/

• 5 MORE QUESTIONS FOR INTERVIEWING A DATABASE ADMINISTRATOR

  http://thomaslarock.com/2014/02/5-more-questions-for-interviewing-a-database-administrator        

     

• SQL Server versions ? Should you upgrade to the next release?

  http://www.pythian.com/blog/sql-server-versions-should-you-upgrade-to-the-next-release/

     

• AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

  http://blogs.msdn.com/b/sqlcat/archive/2014/02/03/alwayson-availability-groups-listener-named-instances-port-numbers-etc.aspx

     

• Generating a trusted TDE Certificate in the proper format from a Certificate Authority

  http://blogs.msdn.com/b/sql_pfe_blog/archive/2014/02/04/generating-a-trusted-tde-certificate-in-the-proper-format-from-a-certificate-authority.aspx

     

• Merge Replication Identity Range Management ? An Identity Disorder? Part 2

  http://www.pythian.com/blog/merge-replication-identity-range-management-an-identity-disorder-part-2/

     

• Using sys.objects When Scripting Permissions? You're Missing Something!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/using-sys-objects-when-scripting-permissions-you-39-re-missing-something.aspx

     

• Error Authenticating Proxy | SQL and UPNs

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/error-authenticating-proxy-sql-and-upns.aspx

     

• 3 Tips for Getting Gold Medal Performance out of Your SQL Server Installation

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/3-tips-for-getting-gold-medal-performance-out-of-your-sql-server-installation.aspx

     

• SQL SERVER ? Multiple ways to convert Datetime to Varchar

  http://raresql.com/2014/02/04/sql-server-multiple-ways-to-convert-datetime-to-varchar/

     

• Conditional Aggregates

  http://mattsql.wordpress.com/2014/02/04/conditional-aggregates/

     

• PowerShell Script for SQL Server 2012/2008 Cluster/StandAlone unattended Install and uninstall

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/powershell-script-for-sql-server-2012-2008-cluster-standalone-unattended-install-and-uninstall.aspx

     

• Loading Power Query M Code From Text Files

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/loading-power-query-m-code-from-text-files.aspx

     

• SSAS: Synchronize

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/04/ssas-synchronize.aspx

     

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

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

     

LINKS

• LAST WEEKS TOP "READING" LINKS #69

  http://www.jasonstrate.com/2014/02/last-weeks-top-reading-links-69/

     

Other

• Which is the best MongoDB GUI?

  http://blog.mongodirector.com/which-is-the-best-mongodb-gui/

     

• Iaas, Paas, SaaS 개념

  http://sqlmvp.kr/140206089976

     

• [Redis] Scan/SScan/ZScan/HScan 이야기…

  http://charsyam.wordpress.com/2014/02/04/redis-scansscanzscanhscan-%EC%9D%B4%EC%95%BC%EA%B8%B0/

     

• NoSQL trends: MongoDB, Cassandra, Couch & Riak

  http://java.dzone.com/articles/nosql-trends-mongodb-cassandra

     

• [번역] 좋은 엔지니어와 나쁜 엔지니어의 리더십

  http://www.mimul.com/pebble/default/2014/02/04/1391490935022.html

SQL

• Avoiding Knee-Jerk Performance Troubleshooting

  http://www.sqlperformance.com/2014/02/sql-performance/knee-jerk-performance-troubleshooting

• Heaps - Tables without a clustered index

  http://www.sqlserver-dba.com/2014/02/heaps-tables-without-a-clustered-index.html

     

• How Google Backs Up The Internet Along With Exabytes Of Other Data

  http://highscalability.com/blog/2014/2/3/how-google-backs-up-the-internet-along-with-exabytes-of-othe.html

     

• Verdasys Digital Guardian and SQL Server

  http://spaghettidba.com/2014/02/03/verdasys-digital-guardian-and-sql-server-setup/

     

• How to Configure Transactional Replication-Mirroring Failover

  http://www.pythian.com/blog/how-to-configure-transactional-replication-mirroring-failover/

     

• SQL SERVER ? 9 Things You Should be Doing with Your Backups

  http://blog.sqlauthority.com/2014/02/03/sql-server-9-things-you-should-be-doing-with-your-backups/

     

• Managed Service Accounts (MSA) and SQL 2012: Practical Tips

  http://blogs.msdn.com/b/arvindsh/archive/2014/02/03/managed-service-accounts-msa-and-sql-2012-practical-tips.aspx

     

• Understanding how ISNUMERIC function works

  http://beyondrelational.com/modules/2/blogs/70/posts/19819/understanding-how-isnumeric-function-works.aspx

     

• Data Mining Introduction Part 8: Microsoft Sequence Cluster

  http://www.sqlservercentral.com/articles/Microsoft/102728/

     

SSIS ? Using Kill with SP_Who to Break locks

http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/03/ssis-using-kill-with-sp-who-to-break-locks.aspx

   

• How to improve SQL statements performance using SQL Plan Baselines

  http://www.pythian.com/blog/how-to-improve-sql-statements-performance-using-sql-plan-baselines/

   

Other

• QR CODES KILL KITTENS. WHAT HAPPENS NEXT WILL SHOCK YOU.

  http://thomaslarock.com/2014/02/qr-codes-kill-kittens-happens-next-will-shock
  
  

• 구루의 기술뉴스 ? 고성능 모바일앱 개발을 더욱 쉽게! 페이스북 Bolts 외 21건

  http://xguru.net/1879

SQL

• Best approaches for grouped running totals

  http://www.sqlperformance.com/2014/01/t-sql-queries/grouped-running-totals

     

• Thin Black Lines: SQL Server 2014 - In Memory OLTP (Overview)

  http://connectsql.blogspot.kr/2014/01/thin-black-lines-sql-server-2014-in.html

     

• UPDATE STATISTICS: the Secret IO Explosion

  http://www.brentozar.com/archive/2014/01/update-statistics-the-secret-io-explosion/

     

• Satya Slips a SQL Server Standard Secret?

  http://www.brentozar.com/archive/2014/02/satya-slipped-sql-server-standard-secret/

     

• In-Memory OLTP Index Troubleshooting, Part II

  http://www.sqlserver.co.uk/index.php/in-memory-oltp-index-troubleshooting-part-ii/

     

• Transactions: Creating a single restore point across multiple databases.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/02/transactions-creating-a-single-restore-point-across-multiple-databases.aspx

     

• Shortcut to Script Individual Columns from a Table-Valued Function in SSMS

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/02/01/shortcut-to-script-individual-columns-from-a-table-valued-function-in-ssms.aspx

     

• Ready, Set, Hike! Or is it Omaha?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/31/ready-set-hike-or-is-it-omaha.aspx

     

• The SQL Server 2012 Fast Track Data Warehouse reference architecture

  http://searchsqlserver.techtarget.com/tip/The-SQL-Server-2012-Fast-Track-Data-Warehouse-reference-architecture

     

• Auditing Database Snapshots: Free Lunch!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/31/auditing-database-snapshots-free-lunch.aspx

     

• Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/29/using-sys-dm-exec-sql-text-to-figure-out-blocking-is-sometimes-flawed.aspx

     

• Master Data Services (Second Edition) ? Review

  http://blogs.lessthandot.com/index.php/datamgmt/master-data-services-second-edition-review/

     

• SQL SERVER ? Synchronize Schema across Multiple Environment ? How to Overcome Database Migration Challenge

  http://www.sqlserver.co.uk/index.php/sql-server-synchronize-schema-across-multiple-environment-how-to-overcome-database-migration-challenge/

     

• What happens next? SQL with Windows login / multiple groups…

  http://blogs.msdn.com/b/arvindsh/archive/2014/01/30/what-happens-next-sql-with-windows-login-multiple-groups.aspx

     

• VLDB and Zeroing out

  http://www.sqlserver-dba.com/2014/01/vldb-and-zeroing-out.html

     

• Increasing Buffer Pool in SQL Server 2014

  http://www.mssqltips.com/sqlservertip/3156/increasing-buffer-pool-in-sql-server-2014/

     

• PDW and SSAS

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/31/pdw-and-ssas.aspx

     

• Different ways to get random data for SQL Server data sampling

  http://www.mssqltips.com/sqlservertip/3157/different-ways-to-get-random-data-for-sql-server-data-sampling/

     

• Getting Starting with Change Data Capture (CDC) in SQL Server ? Part 1

  http://www.databasejournal.com/features/mssql/getting-starting-with-change-data-capture-cdc-in-sql-server-part-1.html

     

• What Do You Ask the Leaving DBA?

  http://www.brentozar.com/archive/2014/01/what-do-you-ask-the-leaving-dba/

     

• Reduce Time for SQL Server Index Rebuilds and Update Statistics

  http://www.mssqltips.com/sqlservertip/3100/reduce-time-for-sql-server-index-rebuilds-and-update-statistics/

     

• Data Science Laboratory System ? Object-Oriented Databases

  https://www.simple-talk.com/cloud/data-science/data-science-laboratory-system-%E2%80%93-object-oriented-databases/

     

• Backup to the right location, by default.

  https://www.simple-talk.com/blogs/2014/01/13/backup-to-the-right-location-by-default/

     

• Stairway to Advanced T-SQL Level 2: Writing Subqueries

  http://www.sqlservercentral.com/articles/Stairway+Series/104517/

     

• SQL Server Quickie #10 ? Forwarding Records

  http://www.sqlpassion.at/archive/2014/01/29/sql-server-quickie-10-forwarding-records

     

• SQL SERVER ? Virtualized SQL Server Performance and Storage System ? Notes from the Field #013

  http://www.sqlserver.co.uk/index.php/sql-server-virtualized-sql-server-performance-and-storage-system-notes-from-the-field-013/

     

• [SQL Snacks Video] Importance of COPY_ONLY Backups

  http://thesqlpro.com/2014/01/28/sql-snacks-video-importance-of-copy_only-backups

     

• HAVE YOU STUDIED SQL SERVER ENOUGH?

  http://www.jasonstrate.com/2014/01/have-you-studied-sql-server-enough/

     

• Database Design training ? for free?

  http://www.sqlserver.co.uk/index.php/database-design-training-for-free/

     

• Distributed Replay in SQL Server 2012 with Boris Hristov

  http://www.runasradio.com/default.aspx?ShowNum=353

     

• Backing Up Your SQL Server Database to Windows Azure Blob Storage

  http://joedantoni.wordpress.com/2014/01/29/backing-up-your-sql-server-database-to-windows-azure-blob-storage/

     

LINKS

• Windows Azure 새로운 소식 - 2014년 1월

  http://redju.tistory.com/385

     

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

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

     

• (SFTW) SQL Server Links 31/01/14

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

     

• Friday Followup For January 31, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/31/friday-followup-for-january-31-2014.aspx

     

Other

• Percona Server: Thread Pool Improvements for Transactional Workloads

  http://www.mysqlperformanceblog.com/2014/01/29/percona-server-thread-pool-improvements/

     

• Analyzing WordPress MySQL Queries with Query Analytics

  http://java.dzone.com/articles/analyzing-wordpress-mysql

     

• MySQL ? Download MySQL Workbench Shortcut in PDF

  http://www.sqlserver.co.uk/index.php/mysql-download-mysql-workbench-shortcut-in-pdf/

• MYSQL ? Could not Drop Object [Content] ('Cannot delete or update a parent row: a foreign key constraint fails', 1217) DROP DATABASE DatabaseName

  http://www.sqlserver.co.uk/index.php/mysql-could-not-drop-object-content-cannot-delete-or-update-a-parent-row-a-foreign-key-constraint-fails-1217-drop-database-databasename/

SQL

• Reporting in Production: SQL Server (video)

  http://www.brentozar.com/archive/2014/01/reporting-production-sql-server-video/

     

• Disaster recovery 101: restore master or rebuild master

  http://www.sqlskills.com/blogs/paul/disaster-recovery-101-restore-master-rebuild-master

     

• OLAP performance tuning

  http://www.sqlserver-dba.com/2014/01/olap-performance-tuning.html

     

• Exploring the Magic of the Plan Cache

  http://www.brentozar.com/archive/2014/01/exploring-the-magic-of-the-plan-cache/

     

• SQL Server Data Tools (SSDT) ? January 2014 update

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/28/sql-server-data-tools-ssdt-january-2014-update.aspx

     

• SQL Server Deadlocks by Example

  http://www.sqlservercentral.com/redirect/articles/106378/

     

• SSAS: Remote Partitions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/28/ssas-remote-partitions.aspx

     

• MaTT: The MARS framework for DBA's

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/28/matt-the-mars-framework-for-dba-s.aspx

     

• Collect Your SQL Server Auditing and Troubleshooting Information Automatically

  https://www.simple-talk.com/sql/database-administration/collect-your-sql-server-auditing-and-troubleshooting-information-automatically/

     

• Forum Etiquette: How to post Reporting Services problems

  http://www.sqlservercentral.com/articles/Reporting+Services/106306/

     

• Writing Triggers in the Right Way

  http://aboutsqlserver.com/2014/01/28/writing-triggers-in-the-right-way/

     

• Inside the Statistics Histogram & Density Vector

  http://www.sqlpassion.at/archive/2014/01/28/inside-the-statistics-histogram-density-vector

     

• Reading a snapshot ? Are there performance implications ?

  http://dataidol.com/davebally/2014/01/03/reading-a-snapshot-are-there-performance-implications/

     

• SQL Server Analysis Services Discretization

  http://www.mssqltips.com/sqlservertip/3155/sql-server-analysis-services-discretization/

     

• TSQL Smells in SSDT ? The monster lives

  http://dataidol.com/davebally/2014/01/28/tsql-smells-in-ssdt-the-monster-lives/

     

• Know When it's Good Enough

  http://www.dbnewsfeed.com/2014/01/28/know-when-its-good-enough/

     

     

Other

• Vert.x Worker Concept

  http://bcho.tistory.com/854

     

• 50 UNIX / Linux Sysadmin Tutorials

  http://www.thegeekstuff.com/2010/12/50-unix-linux-sysadmin-tutorials

SQL

• StarJoinInfo in Execution Plans

  http://www.sqlperformance.com/2014/01/sql-plan/starjoininfo-in-execution-plans

     

• Combining multiple CONTAINS predicates in SQL Server 2012

  http://www.sqlskills.com/blogs/joe/combining-multiple-contains-predicates-sql-server-2012

• Negative session_ids

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/negative-session-ids.aspx

     

• Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs

  http://www.sqlserver.co.uk/index.php/vote-on-connect-items-for-sql-server-20082008-r2-and-2012-service-packs/

     

• Nesting Levels in SQL

  https://www.simple-talk.com/sql/sql-training/nesting-levels-in-sql/

     

• Tweet-up: The Top Gotchas of SQL Server Administration and Development ? and How to Overcome Them.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/tweet-up-the-top-gotchas-of-sql-server-administration-and-development-and-how-to-overcome-them.aspx

• Transact-SQL (T-SQL) query to return the status and detail information for all SQL Server Full-Text Catalogs on an SQL Server instance

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/transact-sql-t-sql-query-to-return-the-status-and-detail-information-for-all-sql-server-full-text-catalogs-on-an-sql-server-instance.aspx

• PowerShell ? Memory Details GUI Tool

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/powershell-memory-details-gui-tool.aspx

     

• Managing SSIS Security with Database Roles

  http://www.mssqltips.com/sqlservertip/3153/managing-ssis-security-with-database-roles/

     

• Comparing Columns In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/27/comparing-columns-in-power-query.aspx        

     

LINKS

• LAST WEEKS TOP "READING" LINKS #68

  http://www.jasonstrate.com/2014/01/last-weeks-top-reading-links-68/

SQL

• SQL Server Hekaton (XTP) in-memory tables: Choosing the correct BUCKET_COUNT for a Hash Index

  http://dataidol.com/tonyrogerson/2014/01/25/sql-server-hekaton-xtp-in-memory-tables-choosing-the-correct-bucket_count-for-a-hash-index/

• Final Service Packs for SQL Server 2008 and SQL Server 2008 R2

  http://www.sqlskills.com/blogs/glenn/final-service-packs-for-sql-server-2008-and-sql-server-2008-r2/

     

• SQL SERVER ? Writing SQL Queries Made Easy with dbForget SQL Complete

  http://www.sqlserver.co.uk/index.php/sql-server-writing-sql-queries-made-easy-with-dbforget-sql-complete/

     

• Parameterization and filtered indexes (part 2)

  http://sqlblog.com/blogs/hugo_kornelis/archive/2014/01/24/parameterization-and-filtered-indexes-part-2.aspx

     

• SQL SERVER ? Standard Reports

  http://raresql.com/2014/01/24/sql-server-standard-reports/

• The SQL Server Sqliosim Utility

  http://www.sqlservercentral.com/redirect/articles/106205/

     

• It's all about Restoring.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/24/it-39-s-all-about-restoring.aspx

     

• Watch Brent Tune Queries

  http://www.brentozar.com/archive/2014/01/watch-brent-tune-queries/

     

• SQL SERVER ? Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server

  http://www.sqlserver.co.uk/index.php/sql-server-query-plan-analysis-of-pivot-and-unpivot-with-profiler-of-dbforge-studio-for-sql-server/

     

• Review of the book SQL Server 2012 Reporting Services Blueprints

  http://www.sqlserver.co.uk/index.php/review-of-the-book-sql-server-2012-reporting-services-blueprints/

     

• Merge Replication Identity Range Management,an identity disorder? Part 1

  http://www.pythian.com/blog/merge-replication-identity-range-managementan-identity-disorder-part-1/

     

• A Versioning system for SSRS

  http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/94119/

     

• Eight key SQL Server 2014 features

  http://searchsqlserver.techtarget.com/tip/Eight-key-SQL-Server-2014-features

     

LINKS

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

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

• Friday Followup For January 24, 2014

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/24/friday-followup-for-january-24-2014.aspx

     

• (SFTW) SQL Server Links 24/01/14

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

     

     

Other

• Monitoring the Performance of Multi-Tiered Windows Azure Applications

  http://cloud.dzone.com/articles/monitoring-performance-multi

• Vert.x 노트

  http://bcho.tistory.com/852

     

• MySQL server memory usage troubleshooting tips

  http://www.mysqlperformanceblog.com/2014/01/24/mysql-server-memory-usage-2/

     

• R을 프로덕션 레벨에서 사용하자!

  http://freesearch.pe.kr/archives/4016

     

• 10 Tips to Improve MongoDB Security

  http://java.dzone.com/articles/10-tips-improve-mongodb

SQL

• Merge Operation in Memory-Optimized Tables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/01/22/merge-operation-in-memory-optimized-tables.aspx

• Did Microsoft Stop Releasing SQL Server Service Packs?

  http://www.brentozar.com/archive/2014/01/did-microsoft-stop-releasing-sql-server-service-packs/

• What's new in SQL Server 2014? Is it worth the upgrade?

  http://www.mssqltips.com/sqlservertip/3120/whats-new-in-sql-server-2014-is-it-worth-the-upgrade/

     

• Transaction Log buffers; How is write latency hurting SQL Server? Draft

  http://sql-sasquatch.blogspot.kr/2014/01/transaction-log-buffers-how-is-write.html

     

• For the last time, NO, you can't trust IDENT_CURRENT()

  http://www.sqlperformance.com/2014/01/t-sql-queries/ident-current

     

• SQL Server Agent in Express Edition

  http://spaghettidba.com/2014/01/23/sql-server-agent-in-express-edition/

     

• Statistics Starters Presentation: Scripts, the Database, and Some Answers

  http://www.sqlskills.com/blogs/erin/statistics-starters-presentation-scripts-the-database-and-some-answers/

     

• State Transition of Checkpoint Files in Databases with Memory-Optimized Tables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/01/23/state-transition-of-checkpoint-files-in-databases-with-memory-optimized-tables.aspx

• Script to Collect Database Information Quickly

  http://www.pythian.com/blog/script-to-collect-database-information-quickly/

     

• Generating Concurrent Activity

  http://michaeljswart.com/2014/01/generating-concurrent-activity/

• SQL SERVER ? Tools for Proactive DBAs ? Policy Based Management ? Notes from the Field #012

  http://www.sqlserver.co.uk/index.php/sql-server-tools-for-proactive-dbas-policy-based-management-notes-from-the-field-012/

     

• Search multiple SQL Server Error Logs at the same time

  http://www.mssqltips.com/sqlservertip/3135/search-multiple-sql-server-error-logs-at-the-same-time/

     

• 6 Desktop BI Tools

  http://beyondrelational.com/modules/2/blogs/925/posts/19817/6-desktop-bi-tools.aspx

     

• "Could not add cluster access…" during SQL 2012 Failover Cluster Instance setup

  http://blogs.msdn.com/b/arvindsh/archive/2014/01/23/could-not-add-cluster-access-error-when-installing-sql-2012-failover-cluster-instance.aspx

     

     

Other

• Introducing Windows Azure WebJobs

  http://www.hanselman.com/blog/IntroducingWindowsAzureWebJobs.aspx

     

• 10 MySQL Settings to Tune After Installation

  http://java.dzone.com/articles/10-mysql-settings-tune-after

     

• Percona Server: Improve Scalability with Percona Thread Pool

  http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scalability-percona-thread-pool/

SQL

• Introduction to SQL Server 2012 Parallel Data Warehouse

  http://henkvandervalk.com/introduction-to-sql-server-2012-parallel-data-warehouse

• Merge Operation in Memory-Optimized Tables

  http://www.sqlserver.co.uk/index.php/merge-operation-in-memory-optimized-tables/

• Exotic spinlocks: XTS_MGR

  http://blogs.msdn.com/b/arvindsh/archive/2014/01/22/exotic-spinlocks-xts-mgr.aspx

     

• Full Scans/sec Doesn't Mean What You Think

  http://www.brentozar.com/archive/2014/01/full-scanssec-doesnt-mean-what-you-think/

     

• The "most_recent_sql_handle" column

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/22/the-most-recent-sql-handle-column.aspx

     

• SQL SERVER ? How to Survive on Free Tools for Month ? Database Comparison Done Easily with ApexSQL Diff ? The ApexSQL Diff Tool

  http://www.sqlserver.co.uk/index.php/sql-server-how-to-survive-on-free-tools-for-month-database-comparison-done-easily-with-apexsql-diff-the-apexsql-diff-tool/

     

• Converting Points to a Path

  http://sqlblog.com/blogs/rob_farley/archive/2014/01/22/converting-points-to-a-path.aspx

     

• Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script

  http://basitaalishan.com/2014/01/22/get-sql-server-physical-cores-physical-and-virtual-cpus-and-processor-type-information-using-t-sql-script/

     

• Add new articles in existing publication without Reinitialize All Subscriptions - SQL Server Replication

  http://beyondrelational.com/modules/2/blogs/88/Posts/19809/add-new-articles-in-existing-publication-without-reinitialize-all-subscriptions-sql-server-replicati.aspx

     

• COPY_ONLY backups and Log Shipping

  http://spaghettidba.com/2014/01/22/copy_only-backups-and-log-shipping/

     

• Analysing Voting In the Power BI Competition ? With Power BI!

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/22/analysing-voting-in-the-power-bi-competition-with-power-bi.aspx

     

• An Overview of Project Conversion - Level 14 of the Stairway to Integration Services

  http://www.sqlservercentral.com/articles/Stairway+Series/106266/

     

• Utilizing PowerShell With 2012 SSIS Deploys

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/22/utilizing-powershell-with-2012-ssis-deploys.aspx

     

SQL

• SQL Server Hekaton (XTP) in-memory Tables: Range Indexes and Row Chains

  http://dataidol.com/tonyrogerson/2014/01/21/sql-server-hekaton-xtp-in-memory-tables-range-indexes-and-row-chains/

     

• Selecting a Processor for SQL Server 2014 ? Part 1

  http://www.sqlperformance.com/2014/01/system-configuration/selecting-a-processor-for-sql-server-2014-1

• Myths and Misconceptions about Transaction Isolation Levels

  http://www.sqlpassion.at/archive/2014/01/21/myths-and-misconceptions-about-transaction-isolation-levels

     

• Compiled T-SQL? Don't throw away all your SQLCLR code just yet

  http://www.sqlskills.com/blogs/bobb/compiled-t-sql-dont-throw-away-all-your-sqlclr-code-just-yet/        

     

• Improving the Performance of Backups

  http://www.brentozar.com/archive/2014/01/improving-the-performance-of-backups/

     

• Regular SQL Server Backup Review

  http://www.sqlserver-dba.com/2014/01/regular-sql-server-backup-review.html

     

• Table Hierarchy updated

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/21/table-hierarchy-updated.aspx

     

• SSAS: Partition Slicing

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/21/ssas-partition-slicing.aspx

     

• Hortonworks Makes HDP 2.0 for Windows Server Generally Available

  http://www.sqlserver.co.uk/index.php/hortonworks-makes-hdp-2-0-for-windows-server-generally-available/

     

• Mastering Dimensions of Time

  http://www.sqlservercentral.com/articles/Data+Warehouse/106149/

     

• Check SQL Server Database Consistency and Backups Without Impacting Performance

  http://www.mssqltips.com/sqlservertip/3147/check-sql-server-database-consistency-and-backups-without-impacting-performance/

     

• Migrating SQL Server Databases to Windows Azure by Leveraging BACPAC Files

  http://www.databasejournal.com/features/mssql/migrating-sql-server-databases-to-windows-azure-by-leveraging-bacpac-files.html

     

• 10 SQL Server Metrics that are Telling you Something…By Rudy Panigas

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/21/10-sql-server-metrics-that-are-telling-you-something-by-rudy-panigas.aspx

     

LINKS

Other

• Beware of MySQL 5.6 server UUID when cloning slaves

  http://www.mysqlperformanceblog.com/2014/01/21/beware-mysql-5-6-server-uuid-cloning-slaves/

     

• [OpenStack Class] 제4강 블록 스토리지와 오브젝트 스토리지

  http://naleejang.tistory.com/92