2013.06.10

안녕하세요. 주디아줌마입니다.

징검다리 연휴 잘 보내셨나요~? 4일 연휴 내내 두 아들을 데리고 돌아다니느라 bb.. 애들은 상처 투성이에 온몸이 삭신이 쑤시네요. 금주에는 SQL2014에 대한 야그가 많네요~^^ 좋은 가격으로 빠른성능을 보여주었으면 좋겠는데~~

   

   

SQL

   

The Accidental DBA

   

• The Accidental DBA (Day 5 of 30): Virtualization Considerations

  http://www.sqlskills.com/blogs/jonathan/the-accidental-dba-day-5-of-30-vm-considerations

   

• The Accidental DBA (Day 6 of 30): Backups: Understanding RTO and RPO

  http://www.sqlskills.com/blogs/paul/the-accidental-dba-day-6-of-30-backups-understanding-rto-and-rpo

   

• The Accidental DBA (Day 7 of 30): Backups: Recovery Models and Backup Types

  http://www.sqlskills.com/blogs/paul/the-accidental-dba-day-7-of-30-backups-recovery-models-and-backup-types

   

• The Accidental DBA (Day 8 of 30): Backups: Planning a Recovery Strategy

  http://www.sqlskills.com/blogs/paul/the-accidental-dba-day-8-of-30-backups-planning-a-recovery-strategy

   

• The Accidental DBA (Day 9 of 30): Backups: Essential BACKUP Options

  http://www.sqlskills.com/blogs/paul/the-accidental-dba-day-9-of-30-backups-essential-backup-options

   

• What does the RCSI overhead mean?

  http://itknowledgeexchange.techtarget.com/sql-server/what-does-the-rcsi-overhead-mean/

     

• SQL Server CREATE TABLE syntax diagrams

  https://www.simple-talk.com/sql/t-sql-programming/sql-server-create-table-syntax-diagrams/

   

CTE

   

• Introduction to Recursive CTEs

  http://stevestedman.com/2013/06/introduction-to-recursive-ctes/

     

• Expanding on Recursive Dates CTE

  http://stevestedman.com/2013/06/expanding-on-recursive-dates-cte/

     

• Recursive CTE for Dates In A Year

  http://stevestedman.com/2013/06/recursive-cte-for-dates-in-a-year/

   

• CTE Scope

  http://stevestedman.com/2013/06/cte-scope/

   

SQL2014

   

• SQL Server 2014 Announced

  http://stevestedman.com/2013/06/sql-server-2014-announced/

     

• Geek City: SQL Server 2014 In-Memory OLTP ("Hekaton") Whitepaper

  http://sqlblog.com/blogs/kalen_delaney/archive/2013/06/05/hekaton-whitepaper.aspx

     

• SQL SERVER – 2014 Announced and SQL Server 2014 Datasheet

  http://blog.sqlauthority.com/2013/06/09/sql-server-2014-announced-and-sql-server-2014-datasheet/

     

• SQL Server 2014: A Closer Look

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/05/sql-server-2014-a-closer-look.aspx

   

• Disabling and Enabling Indexes – Why You Should Consider Rebuilding Your NonClustered Indexes?

  http://www.sqlserverpath.org/2013/06/08/disabling-and-enabling-indexes-%E2%80%93-why-you-should-consider-rebuilding-your-nonclustered-indexes

     

• MSSQL: Plan guides to address ascending key problem, or increased stats attention?

  http://sql-sasquatch.blogspot.kr/2013/06/mssql-plan-guides-to-address-ascending.html

     

• SQL Server backup compression

  http://sql-sasquatch.blogspot.kr/2013/06/sql-server-backup-compression.html

     

• COPY_ONLY Backups with SQL Server

  http://www.mssqltips.com/sqlservertip/1075/copyonly-backups-with-sql-server/

     

• Error 3254 – The volume on device BACKUP_PATH is empty

  http://www.sqlserver-dba.com/2013/06/error-3254-the-volume-on-device-backup_path-is-empty.html

     

• Microsoft SQL Server Business Intelligence - What, Why and How - Part 1

  http://www.mssqltips.com/sqlservertip/2967/microsoft-sql-server-business-intelligence--what-why-and-how--part-1/

     

• SQL SERVER – QUOTED_IDENTIFIER ON/OFF Explanation and Example – Question on Real World Usage

  http://blog.sqlauthority.com/2013/06/07/sql-server-quoted_identifier-onoff-explanation-and-example-question-on-real-world-usage/

     

• INDEXING FUNDAMENTALS FOR MICROSOFT SQL SERVER

  http://www.jasonstrate.com/2013/06/my-teched-presentation-indexing-fundamentals-for-microsoft-sql-server

     

• Adding new files to a log-shipped database (SQL Spackle)

  http://www.sqlservercentral.com/articles/Log+Shipping/99047/

     

• The Nuance of DBCC CHECKIDENT That Drives Me Crazy

  http://www.sqlskills.com/blogs/erin/the-nuance-of-dbcc-checkident-that-drives-me-crazy

     

• Changing a column that is already populated into a column that uses a sequence

  http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/changing-a-column-that-is

     

• SQL Puzzle.. Sorting results without using ORDER BY

  http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/sql-puzzle-sorting-results-without

     

• Mirror Mirror on the Server, Who is the Principal of Us All? [video]

  http://www.brentozar.com/archive/2013/06/mirror-mirror-on-the-server-who-is-the-principal-of-us-all-video/

     

• SQL Server Transactions and Locking – Part 2

  http://www.sql-server-performance.com/2013/sql-server-transactions-and-locking-part-2

     

• Paging Data with TSQL

  http://www.databasejournal.com/features/mssql/paging-data-with-tsql.html

     

• SQL Server Backup Paths and File Management

  http://www.mssqltips.com/sqlservertip/2960/sql-server-backup-paths-and-file-management/

     

• Tech Ed Demos for "Manage SQL Server System and Performance Data with PowerShell"

  http://sqlblog.com/blogs/allen_white/archive/2013/06/04/tech-ed-demos-for-manage-sql-server-system-and-performance-data-with-powershell.aspx

     

Other

   

• A Beginners Look at Hadoop

  http://www.sqlservercentral.com/articles/Hadoop/99135/

   

• Learn More About AWS

  http://cloud.dzone.com/articles/learn-more-about-aws

     

• Choosing a MySQL HA Solution – Post-Webinar Q&A

  http://www.mysqlperformanceblog.com/2013/06/07/choosing-a-mysql-ha-solution-post-webinar-q-and-a/

     

• Career in DBA

  http://www.sqlserver-dba.com/2013/06/career-in-dba.html

     

• Paper: Memory Barriers: A Hardware View For Software Hackers

  http://highscalability.com/blog/2013/6/6/paper-memory-barriers-a-hardware-view-for-software-hackers.html