2014.03.04

   

   

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/