2014.02.03

   

   

   

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/