MSSQL

• Trending Database Growth From Backups
  http://www.sqlskills.com/blogs/erin/post/trending-database-growth-from-backups.aspx
  DB 백업에 대한 월별 백업 사이즈 및 압축 사이즈, 압축 비율 script

• Databases With Large Tables Should Use Auto Stats Async Update Feature
  http://itknowledgeexchange.techtarget.com/sql-server/databases-with-large-tables-should-use-auto-stats-async-update-feature/
  SQL2008 R2 SP1 이후 추가된 기능으로 20% 500행 변경시 자동 통계 변경 알고리즘(슬라이딩 스케일) 이 기능은 flag2371 활성화해야만 사용할 수 있다. 대형DB에서는 비동기 자동 업데이트 통계 설정하는게 좋다.
   
• Bob Dylan Explains TempDB (Video)
  http://www.brentozar.com/archive/2012/12/bob-dylan-explains-tempdb-video/
  SQLPASS2012에 25분짜리 tempdb 관련 동영상입니다. 한번 보시면 좋을 것 같네요.ㅎㅎ 이 분ㅇㄴ 좀 웃기네요~ㅋㅋ
   
• Index Create Memory Setting for SQL Server
  http://www.mssqltips.com/sqlservertip/2815/index-create-memory-setting-for-sql-server/
  인덱스 생성시 필요 메모리 세팅, 기본 0으로두면 SQL SERVER에서 자동으로 할당 합니다.

  

• VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types
  http://www.sql-server-performance.com/2012/varchar-max-nvarchar-max-ntext-data-types/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SQLServerPerformance+%28Latest+SQL-Server-Performance.com+Updates%29
   
• Documenting sp_ssiscatalog
  http://sqlblog.com/blogs/jamie_thomson/archive/2012/12/05/documenting-sp-ssiscatalog.aspx
  
   

MySQL

• Quickly finding unused indexes (and estimating their size)
  http://www.mysqlperformanceblog.com/2012/12/05/quickly-finding-unused-indexes-and-estimating-their-size/

     

안녕하세요. 주디아줌마입니다.
오늘 눈이 온다고 하던데~~ 하늘은 반짝반짝하는데~ 머징머징 ㅎㅎㅎㅎ. 

MSSQL

• SQLskills holiday gift to you: all 2011 Insider videos on YouTube

  http://www.sqlskills.com/blogs/paul/post/sqlskills-holiday-gift-to-you-all-2011-insider-videos-on-youtube.aspx

  정말 파울 아저씨는 대단하세요^^ 정리해서 올려주는 센수~^^

  동영상과 데모코드까지 공유해주시는 센쑤^^.

진짜 쥑이는 동영상들~

• #1 March 2011: RESTART option for RESTORE commands (video | demo code)
• #2 March 2011: Logging during SELECT-INTO operations (video | demo code)
• #3 April 2011: Undocumented DBCC commands (video | demo code)
• #4 April 2011: Log file performance analysis (video | demo code)
• #5 May 2011: Nested transactions (video | demo code)
• #6 May 2011: Checkpoint tracking (video | demo code) 
• #7 May 2011: Trusting the tools - Kimberly (video)
• #8 June 2011: Tempdb latch contention (video | demo code) 
• #9 June 2011: Wait stats for a single operation (video | demo code)
• #10 July 2011: Database snapshots (video | demo code)
• #11 July 2011: Undroppable log files (video | demo code)
• #12 August 2011: Tail-of-the-log backups (video | demo code)
• #13 August 2011: Error log management (video) 
• #14 September 2011: Inconsistent analysis (video | demo code)
• #15 October 2011: Fully logged operations (video | demo code) 
• #16 October 2011: Tempdb space tracking (video | demo code)
• #17 October 2011: Deadlock analysis - Joe (video | demo code)
• #18 November 2011: Query timeout debugging (video | demo code)
• #19 December 2011: Deadlock debugging  - Joe (video | demo code) 

• Making the Case for a SQL Server Platform Refresh

  http://www.simple-talk.com/sql/database-administration/making-the-case-for-a-sql-server-platform-refresh/

  그렌 아저쒸 정말 대단하심. 새로운 하드웨어 이슈 정보가 가득하네요.

• HOW I PASSED THE SQL SERVER 2008 MCM EXAMS

  http://thomaslarock.com/2012/12/how-i-passed-the-sql-server-2008-mcm-exams/

• Free Tools for the DBA: PAL Tool

  http://www.simple-talk.com/sql/sql-tools/free-tools-for-the-dba-pal-tool/

  성능 로그 분석 무료 툴 소개이네요.

• Backups Gone Bad: The Danger of Differentials

  http://www.brentozar.com/archive/2012/12/backups-gone-bad-the-danger-of-differentials/

• Fluffy in an Availability Group Failover Scenario

  http://troubleshootingsql.com/2012/12/04/fluffy-in-an-availability-group-failover-scenario/

• Using SSIS to export data from a 64 bit server to Excel 2007

  http://www.sqlservercentral.com/articles/SQL+Server+Integration+Services/93895/

• SQL Server Execution Plans, Second Edition by Grant Fritchey

  http://www.sqlservercentral.com/articles/books/94937/

• SQL Server Temp Table vs Table Variable Performance Testing

  http://www.mssqltips.com/sqlservertip/2825/sql-server-temp-table-vs-table-variable-performance-testing/

BigData & NoSQL & Cloud

• Using Hadooop (HDInsight) with Microsoft - Two (OK, Three) Options

  http://sqlblog.com/blogs/buck_woody/archive/2012/12/04/using-hadooop-hdinsight-with-microsoft-two-ok-three-options.aspx

  슬슬 SQL 진영에도 하둡과 연계 자료들이 나오네요. MS 계열에서 하둡 사용 방법 정보입니다.

MySQL

• Announcing Percona XtraBackup 2.0.4

  http://www.mysqlperformanceblog.com/2012/12/04/announcing-percona-xtrabackup-2-0-4/

• A closer look at Percona XtraDB Cluster for MySQL

  http://www.mysqlperformanceblog.com/2012/12/04/a-closer-look-at-percona-xtradb-cluster-for-mysql/

SQL

• Install SQL Server 2012 Using SysPrep

  http://www.mssqltips.com/sqlservertip/2719/install-sql-server-2012-using-sysprep/

     

• Minimizing the impact of DBCC CHECKDB : DOs and DON'Ts

  http://www.sqlperformance.com/2012/11/io-subsystem/minimize-impact-of-checkdb

  요즘 DBCC CHECKDB 이슈들이 계속 나오네요. DBCC CHECKDB 옵션별로 성능 측정, 대략 PYSICAL_ONLY + TF 2549, 2562 활성화 할때 DB SIZE에 따라 틀리지만 10배(DB SIZE 7G) 이상 차이가 나네요.

     

• Auditing SQL Server 2012 Server Roles

  http://www.mssqltips.com/sqlservertip/2809/auditing-sql-server-2012-server-roles/

     

• Two New TPC-E Submissions for SQL Server 2012

  http://www.sqlskills.com/blogs/glenn/post/Two-New-TPC-E-Submissions-for-SQL-Server-2012.aspx

     

• CPU Ready Time in VMware and How to Interpret its Real Meaning

  http://www.sqlskills.com/blogs/jonathan/post/CPU-Ready-Time-in-VMware-and-How-to-Interpret-its-Real-Meaning.aspx

     

• Clustering SQL Server on Virtual Machines (Round 2)

  http://www.sqlskills.com/blogs/jonathan/post/Clustering-SQL-Server-on-Virtual-Machines-(Round-2).aspx

     

• SQL SERVER ? Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL

  http://blog.sqlauthority.com/2012/11/30/sql-server-fix-visual-studio-error-connections-to-sql-server-files-mdf-require-sql-server-express-2005-to-function-properly-please-verify-the-installation-of-the-component-or-download-from-the/

     

• Disk Partition Alignment Best Practices Whitepaper for SQL Server - 강성욱 MVP님

  http://sqlmvp.kr/140173851714

     

• 파티션 오프셋과 SQL Server에 대한 디스크 할당 단위 크기 - 강성욱 MVP님

  http://sqlmvp.kr/140173933247

     

• SQL Server 인덱스 활성 / 비활성 하기 - 강성욱 MVP님

  http://sqlmvp.kr/140174227769

     

• Read the End of a Large Error Log (에러로그 끝 부분 읽기)

  http://sqlmvp.kr/140173766910

     

• The SQL Server Community Looks to Emerging Trends in BI and Database Technologies

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/29/the-sql-server-community-look-to-emerging-trends-in-bi-and-database-technologies.aspx

  향후 SQL 트렌드 키워드.

  in-memory, big data, social network, cloud,

     

• Make life easier on yourself, get a baseline!

  http://www.sqlskills.com/blogs/paul/post/Make-life-easier-on-yourself-get-a-baseline!.aspx

     

• SQL Server 2000 non-yielding scheduler 오류 메시지

  http://laigo.kr/730

     

• SQL Server: Script to Find Tables in Stored Procedures, That Are Without NonClustered Index

  http://connectsql.blogspot.kr/2012/11/sql-server-script-to-find-tables-in.html

  nonclustered indexm 없는 table 정보를 찾아주는 script

     

• Tables without a Clustered Index

  http://sqlserver365.blogspot.kr/2012/11/tables-without-clustered-index.html

  클러스터드 인덱스가 없는 테이블 찾는 script

     

• Splitting Strings Based on Patterns

  http://www.sqlservercentral.com/articles/String+Manipulation/94365/

     

• Database Deployment: The Bits - Getting Data In

  http://www.simple-talk.com/sql/t-sql-programming/database-deployment-the-bits---getting-data-in/

     

• How To Download Free Sessions From PASS

  http://sqlblog.com/blogs/kevin_kline/archive/2012/11/28/how-to-download-free-sessions-from-pass.aspx

  SQLPASS 무료 세션 다운로드 받을 수 있는 곳.ㅋ

     

• What MAXDOP setting should be used for SQL Server

  http://www.mssqltips.com/sqlservertip/2650/what-maxdop-setting-should-be-used-for-sql-server/

     

• Table level recovery for selected SQL Server tables

  http://www.mssqltips.com/sqlservertip/2814/table-level-recovery-for-selected-sql-server-tables/

     

BigData & Cloud & NoSQL & BI

• Performance Data For LevelDB, Berkley DB And BangDB For Random Operations

  http://highscalability.com/blog/2012/11/29/performance-data-for-leveldb-berkley-db-and-bangdb-for-rando.html

     

• Getting started with Tabular Model in SQL Server 2012 - Part 1

  http://www.mssqltips.com/sqlservertip/2821/getting-started-with-tabular-model-in-sql-server-2012--part-1/

     

• 오픈소스 빅데이터 요소 기술

  http://redju.tistory.com/244

     

     

SQL

• Find Referenced Objects of a particular object
  http://www.google.co.kr/reader/view/?hl=ko&tab=wy
   
• Top 10 Learning Resources for Accidental DBAs
  http://www.sqlskills.com/blogs/glenn/post/Top-10-Learning-Resources-for-Accidental-DBAs.aspx
  DBA를 위한 참고용 자료들을 트위터, 포럼, 블로그 등등 정리해 놓았네요. 전 여기서 트위터 목록의 사람들을 모두 등록.ㅋㅋㅋㅋ

     

  SQL MVP 목록 http://wefollow.com/twitter/mvp
  SQL Server Blogger Rankings http://thomaslarock.com/rankings/ <-- 여기 자료 좋은데요.ㅋㅋ

     

• New version of Partition Management Utility supports SQL2012, ColumnStore Indexes
  http://blogs.msdn.com/b/sqlcat/archive/2012/12/03/new-version-of-partition-management-utility-supports-sql2012-columnstore-indexes.aspx
  새로운 버젼 SQL2012의 파티션 관리 유틸리티가 공유되었네요. http://sqlpartitionmgmt.codeplex.com/

• How It Works: Gotcha: *VARCHAR(MAX) caused my queries to be slower
  http://blogs.msdn.com/b/psssql/archive/2012/12/03/how-it-works-gotcha-varchar-max-caused-my-queries-to-be-slower.aspx
   
• SQL Server: SET SET, A Strange Compatibility Upgradation Issue
  http://connectsql.blogspot.kr/2012/12/sql-server-set-set-strange.html
   
• A Useful Tip For Dealing With A Full Transaction Log Drive
  http://shaunjstuart.com/archive/2012/12/a-useful-tip-for-dealing-with-a-full-transaction-log-drive/
   
• Tip: Resetting Identity Fields
  http://www.sqlservercentral.com/articles/DBCC+CHECKIDENT/94559/

     

• How to Identify and Backup the Latest SQL Server Database in a Series
  http://www.mssqltips.com/sqlservertip/2807/how-to-identify-and-backup-the-latest-sql-server-database-in-a-series/
   

Cloud & BigData & NoSQL

• ACID transaction in the NoSQL world
  http://data.story.lu/2012/12/03/acid-transaction-in-the-nosql-world
  NoSQL 계열의 ACID 트랜잭션을 지원해주는 솔루션은 Redis, Neo4J, ZODB, FoundationDB…
   
• WordPress with SQL Azure

  http://cloud.dzone.com/articles/wordpress-sql-azure
  흥미롭네요. SQL Azure로 WordPress 블로그 데이터가 운영될 수 있게 지원되다니~, MySQL 공부 끝나면 SQL Azure 공부해야지.

SQL

• DBCC CHECKDB Parallel Checks and SQL Server Edition
  http://www.sqlskills.com/blogs/erin/post/DBCC-CHECKDB-Parallel-Checks-and-SQL-Server-Edition.aspx

  Standard Edition에서 DBCC CHECKDB는 항상 단일 쓰레드로 검사 수행. Enterprise Editio에서는 max dop의 구성에 따라 영향 받는다.

     

• SQL Server vNext coming up with lot a new features | Hekaton, Polybase, PDW, and many more

  http://sqlwithmanoj.wordpress.com/2012/11/27/sql-server-vnext-coming-up-with-lot-a-new-features-hekaton-polybase-pdw-and-many-more/

  SQL2012 버전과 향후 버젼에 대한 대략적인 소개이네요. 2014~2015년도 사이에 Hekaton과 polybase 출시 예정,

     

• Unused Indexes
  http://sqlserver365.blogspot.kr/2012/11/unused-indexes.html
  사용되지 않은 인덱스 판별은 sys.dm_db_index_usage_stats DMV를 이용해서 where the user_seeks + user_scans + user_lookups = 0 의 결과로 알아볼 수 있다. System database를 제외한 사용자 db를 대상으로 인덱스 사용 현황을 매일 아침에 메일로 보내는 script를 확인할 수 있다.

     

• Performance Problems with SQL Server 2012 Enterprise Edition Under CAL Licensing
  http://www.sqlperformance.com/2012/11/system-configuration/2012-cal-problems
   
• SQL Server T-SQL Tuning -TVF and Scalar Functions
  http://www.sql-server-performance.com/2012/sql-tuning-tvf-scalar-functions/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SQLServerPerformance+%28Latest+SQL-Server-Performance.com+Updates%29
   
• Back to Basics: Capturing Baselines on Production SQL Servers
  http://www.sqlservercentral.com/articles/baselines/94656/

     

• How to Set SQL Server Max Memory for VMware
  http://www.brentozar.com/archive/2012/11/how-to-set-sql-server-max-memory-for-vmware/
  VMWare에서 SQL Server 메모리 사용하기 위해서는 확인해야 할게 많은데, guest's memory, sql server memory, vmware reservation 고려해야 한다. 요즘 대세가 VMWare 이니~ 고려해야 할게 많네요.
   

  

     

     

• Understanding the SQL Server 2012 BI Semantic Model (BISM)

  http://www.mssqltips.com/sqlservertip/2818/understanding-the-sql-server-2012-bi-semantic-model-bism/
   

• SQL SERVER – Shard No More – An Innovative Look at Distributed Peer-to-peer SQL Database
  http://blog.sqlauthority.com/2012/11/27/sql-server-shard-no-more-an-innovative-look-at-distributed-peer-to-peer-sql-database/

     

Cloud & BigData

• Crutchfield Turns to Microsoft and EMC to Help Transform SQL Server to the Private Cloud

  http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/27/crutchfield-turns-to-microsoft-and-emc-to-help-transform-sql-server-to-the-private-cloud.aspx

     

• Windows Azure Virtual Machines - Make Sure You Follow the Documentation

  http://sqlblog.com/blogs/buck_woody/archive/2012/11/27/windows-azure-virtual-machines-make-sure-you-follow-the-documentation.aspx

     

• Windows Azure Update 2012년 11월 – SQL Azure
  http://redju.tistory.com/248

     

     

     

SQL

• SQL Server Performance Statistics Using a Server Side Trace
  http://www.mssqltips.com/sqlservertip/1035/sql-server-performance-statistics-using-a-server-side-trace/

     

• How to set the default transaction isolation level server wide?
  http://blogs.msdn.com/b/ialonso/archive/2012/11/26/how-to-set-the-default-transaction-isolation-level-server-wide.aspx

     

• The Importance Of Trust
  http://shaunjstuart.com/archive/2012/11/the-importance-of-trust/
  Check constraints option의 활성화와 비 활성화에 따른 플랜.

     

• Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth
  http://www.sqlservercentral.com/articles/Stairway+Series/94579/

     

• Handling Backups for Rapid Resilience
  http://www.simple-talk.com/sql/database-administration/handling-backups-for-rapid-resilience/

     

Cloud & BigData

• SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3
  http://blog.sqlauthority.com/2012/11/26/sql-server-sends-backups-to-a-network-folder-ftp-server-dropbox-google-drive-or-amazon-s3/

   

SQL

• SQL SERVER – Find Weekend and Weekdays from Datetime in SQL Server 2012
  http://blog.sqlauthority.com/2012/11/25/sql-server-find-weekend-and-weekdays-from-datetime-in-sql-server-2012/

  

     

• Checking SQL Server Services Owner

  http://www.mssqltips.com/sqlservertip/2823/checking-sql-server-services-owner/
  SQL2012 들어오면서 dmv를 통해 많은 정보를 공유해주는구나 생각이 들더군요^^ 아래의 DMV는 서비스 상태 정보들을 확인할 수 있습니다. 또한 SC 명령을 통해서 서비스를 시작 할수 있는 script도 제공.~~ 쥑인다.ㅋㅋ

  

• Free E-book
  http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx
   

  Books Online: Backup and Restore of SQL Server Databases 

  Books Online: Data Analysis Expressions (DAX) Reference

  Books Online: Data Mining Extensions (DMX) Reference

  Books Online: Data Quality Services

  Books Online: High Availability Solutions

  Books Online: Master Data Services

  Books Online: Monitor and Tune for Performance

  Books Online: Multidimensional Expressions (MDX) Reference

  Books Online: SQL Server Distributed Replay

  Books Online: Transact-SQL Data Definition Language (DDL) Reference

  Books Online: Transact-SQL Data Manipulation Language (DML) Reference

  Books Online: XQuery Language Reference

  Introducing Microsoft SQL Server 2008 R2

  Introducing Microsoft SQL Server 2012

  Master Data Services Capacity Guidelines

  Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

  Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide

  QuickStart: Learn DAX Basics in 30 Minutes

  SQL Server 2012 Tutorials: Analysis Services - Data Mining

  SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling

  SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling

  SQL Server 2012 Tutorials: Reporting Services

  SQL Server 2012 Tutorials: Writing Transact-SQL Statements

  SQL Server 2012 Upgrade Technical Guide

     

Cloud & BigData

• Big Data(빅 데이터)
  http://redju.tistory.com/246
• Azure Table Storage: Essential Knowledge
  http://architects.dzone.com/articles/azure-table-storage-essential
  
  애저캠프2차 참여한 결과 우리가 알고 있던 SQL이 아니었습니다. 전혀 다른 접근 방법으로 공부해가야 할 것 같아요. 예를 들어 PK가 없으면 테이블이 생성이 안되고, Use database명도 안 먹힙니다. 저는 당연히 되던게 안 되니 정말 난감했었는데 SQL애저에 대한 많이 틀리더군요^^
  
  90일 사용 무료, 무료 training kit 제공합니다. 같이 공부해 보아요.ㅋ
  http://www.microsoft.com/en-us/download/details.aspx?id=8396
   
• 
• Windows Azure, SignalR & Twilio: A Phone Call from the Cloud
  http://architects.dzone.com/articles/windows-azure-signalr-twilio?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Farchitects+%28Architects+Zone%29
  
   
• d

SQL

• Oracle NoSQL Database 11gR2.2.0.22 Community Edition
  http://data.story.lu/2012/11/22/oracle-nosql-database-11gr2-2-0-22-community-edition

     

• SQL SERVER – Removing Leading Zeros From Column in Table – Part 2

  http://blog.sqlauthority.com/2012/11/22/sql-server-removing-leading-zeros-from-column-in-table-part-2/

     

• 문서화 되지 않은 sys.fn_PhysLocFormatter 함수
  http://sqlmvp.kr/140173294943

Upgrade

• Cumulative Update #8 for SQL Server 2008 Service Pack 3

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2012/11/21/cumulative-update-8-for-sql-server-2008-service-pack-3.aspx

  • CU#8 KB Article: http://support.microsoft.com/kb/2771833
  • Understanding Incremental Servicing Model for SQL Server
  • SQL Server Support Information: http://support.microsoft.com/ph/2855

     

SQL

• Reading the tea leaves from Windows Azure support

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/11/21/reading-the-tea-leaves-from-windows-azure-support.aspx

     

• SQL Server Database Security Audit (Part 1): What to expect?
  http://www.mssqltips.com/sqlservertip/2801/sql-server-database-security-audit-part-1-what-to-expect/

  보안 오딧을 위한 이슈를 정리해 놓은 팁입니다.(정리한번 해놓으면 좋을 것 같음.ㅋㅋ)

     

• SQL SERVER – Display Datetime in Specific Format – SQL in Sixty Seconds #033 – Video

  http://blog.sqlauthority.com/2012/11/21/sql-server-display-datetime-in-specific-format-sql-in-sixty-seconds-033-video/

  

     

• SQL Server 관리자 전용 연결(DAC)

  http://sqlmvp.kr/140173214035

  

     

• BI Beginner: Why to Use Excel 2013 Now

  http://sqlblog.com/blogs/john_paul_cook/archive/2012/11/20/bi-beginner-why-to-use-excel-2013-now.aspx

     

     

ETC

• The Computer Backup Rule of Three

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

     

• Windows 8, Step 0 - Turn on continuous backups via File History

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

Upgrade

• SQL Server 2012 Service Pack 1 Cumulative Update #1 is available!

  http://sqlblog.com/blogs/aaron_bertrand/archive/2012/11/20/sql-server-2012-service-pack-1-cumulative-update-1-is-available.aspx

     

  • KB article: KB #2765331
  • Build # is 11.0.3321
  • I count a whopping 44 fixes!  

SQL

• SSIS Junkie

  http://sqlblog.com/blogs/jamie_thomson/archive/2012/11/20/sp-ssiscatalog-v1-0-1-0-now-available-for-download.aspx

     

• Handling Backups for Rapid Resilience

  http://www.simple-talk.com/sql/database-administration/handling-backups-for-rapid-resilience/

     

• The Benefits of Indexing Foreign Keys
  http://www.sqlperformance.com/2012/11/t-sql-queries/benefits-indexing-foreign-keys

     

• Restoring a SQL Server 2005 Full-Text Catalog to SQL Server 2012

  http://mssqlfun.com/2012/11/19/restoring-a-sql-server-2005-full-text-catalog-to-sql-server-2012/

     

• Has tempdb grown since the last restart?
  http://www.sqlservercentral.com/articles/Administration/94128/

  Tempdb size를 결정하는 요소는 tempdb size와 model db size에 의해 결정되는데 두 개의 DB size에 따라 큰 size로 tempdb size가 결정된다

  

  Default Trace log는 자동 증가 이벤트 로그 확인 링크

  

     

     

• Performance Tuning Re-indexing and Update Statistics – A Case Study

  http://www.sql-server-performance.com/2012/performance-tuning-re-indexing-update-statistics/

  기본 Re-Indexing 동작은 DBCC DBREINDEX 명령어 입니다. 이 명령어는 DB에 대해서 전체 수행하는 것이며, 테이블에 있는 인덱스를 삭제 후 생성하는 동작입니다. 이 동작은 많은 리소스와 시간이 필요합니다. MS에서 추천하는 방식은 fragmentation level이 30% 이내라면 Re-Organize를 수행하고, 이상이면 Re-Building을 수행하는 것입니다.

     

  Re-build : 존재하는 인덱스를 삭제 후 생성하는 동작
  Re-organize : index의 leaf node 수준의 페이지를 논리적 순서로 다시 정렬하는 동작..
   

     

• SQL Server T-SQL Tuning – Temp Tables, Table Variables and Union

  http://www.sql-server-performance.com/2012/sql-server-t-sql-tuning-temp-table-union/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+SQLServerPerformance+%28Latest+SQL-Server-Performance.com+Updates%29

  Temp table, temp table 변수 사용함에 따라 i/o subsystemp resource 결함 증가 및 CPU 사용률 증가에 따라 대안을 제시. CTE, SubQuery, Phisical Table, Table Parameters(SQL 2008+)

     

• How to Identify and Backup the Latest SQL Server Database in a Series

  http://www.mssqltips.com/sqlservertip/2807/how-to-identify-and-backup-the-latest-sql-server-database-in-a-series/

     

• SQL SERVER – Using RAND() in User Defined Functions (UDF)

  http://blog.sqlauthority.com/2012/11/20/sql-server-using-rand-in-user-defined-functions-udf/

  비결정적인 함수 rand()를 UDF를 사용해서 쓰는 법입니다.
   

  

     

     

Cloud

• Long Term Backup Storage With Amazon Glacier

  http://www.brentozar.com/archive/2012/11/long-term-backup-storage-with-amazon-glacier/