SQL

• Express Edition revisited, focus on SSMS

  http://sqlblog.com/blogs/tibor_karaszi/archive/2013/01/30/express-edition-revisited-focus-on-ssms.aspx

• AppDomain unloading messages flooding the SQL Server error log

  http://blogs.msdn.com/b/psssql/archive/2013/01/30/appdomain-unloading-messages-flooding-the-sql-server-error-log.aspx

• Forcing "Custom Properties" of a Data Flow Transformation to support DTS Expression

  http://sqlblog.com/blogs/davide_mauri/archive/2013/01/30/forcing-custom-properties-of-a-data-flow-transformation-to-support-dts-expression.aspx

• The Okapis of SQL Server Indexes

  http://www.brentozar.com/archive/2013/01/the-okapis-of-sql-server-indexes/

• Different ways to find End of the month

  http://beyondrelational.com/modules/2/blogs/70/posts/18723/different-ways-to-find-end-of-the-month.aspx

  월의 마지막일을 구하는 script

• SQL Server Performance Tuning – Index Tuning

  http://www.sql-server-performance.com/2013/sql-server-index-tuning/

• Using WITH ROWCOUNT and PAGECOUNT option of SQL Server UPDATE STATISTICS

  http://www.mssqltips.com/sqlservertip/2870/using-with-rowcount-and-pagecount-option-of-sql-server-update-statistics/

ETC

• Git에 대한 생각..

  http://beyondj2ee.wordpress.com/2013/01/30/git%EC%97%90-%EB%8C%80%ED%95%9C-%EC%83%9D%EA%B0%81/

SQL

• SQL2012 보안가이드 PDF - 최인규 이사님, 이장래 수석님

  http://www.sqlroad.com/62 내용이 알차고 좋습니다 @.@

  

     

• [SQL2012BI]5. MSSQL 2012 DW 셋팅 - 김상수님
  http://www.sqler.com/539653#5
  DW 환경 SQL 세팅올려 주셨는데 DW 환경에서 고려해야 할 사항들입니다. DW 가이드라인으로 쓰면 아주 좋을 것 같네요 ~

     

• How Does the Cloud Change a Database Administrator's Job?

  http://sqlblog.com/blogs/buck_woody/archive/2013/01/29/how-does-the-cloud-change-a-database-administrator-s-job.aspx

• SQL Server – How to use READ_COMMITED_SNAPSHOT isolation level

  http://www.sqlserver-dba.com/2013/01/sql-server-how-to-use-read_commited_snapshot-isolation-level.html

     

• Providing SQL Agent Job Log Data for Developers

  http://www.mssqltips.com/sqlservertip/2858/providing-sql-agent-job-log-data-for-developers/

     

• Day 23 of 31 Days of Disaster Recovery: Restoring Differential Backups With New Files

  http://www.sqlsoldier.com/wp/sqlserver/day-23-of-31-days-of-disaster-recovery-restoring-differential-backups-with-new-files 연재식으로 재해복구를 31일간 올려주네요~ 내용도 알차요 ㅎ.ㅎ

     

• Visualizing Data File Layout III

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/28/visualizing-data-file-layout-iii.aspx

     

• Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using T-SQL

  http://www.mssqltips.com/sqlservertip/2869/configure-sql-server-2012-alwayson-availability-groups-readonly-routing-using-tsql

SQL

• Common Table Expressions (CTEs), Window Functions, and Views

  http://www.sqlskills.com/blogs/jonathan/ctes-window-functions-and-views/

• Optimizing T-SQL queries that change data

  http://sqlblog.com/blogs/paul_white/archive/2013/01/26/optimizing-t-sql-queries-that-change-data.aspx

• Column store solutions

  http://sqlscope.wordpress.com/2013/01/27/column-store-solutions/

  Column Store Index는 ent 버젼만 사용하게 되었는데 다음 버젼에서는 해제된다는 내용입니다. 또한 추가적으로

  nonclustered index 생성 가능, 부모테이블 및 파티션 테이블의 읽기 전용으로만 사용되는 부분도 기능 업글된다는 내용이네요.

• Continuous deployment of SSDT database projects to Windows Azure using Team Foundation Service

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/01/27/continuous-deployment-of-ssdt-database-projects-to-windows-azure-using-team-foundation-service.aspx

• Backup TO DISK, TAPE and now URL - Backup On-Premises SQL Server Databases to Azure Storage

  http://sqlblog.com/blogs/greg_low/archive/2013/01/27/backup-to-disk-tape-and-now-url-backup-on-premises-sql-server-databases-to-azure-storage.aspx

  SQL애져 환경에서 URL을 통한 백업이가능하네요. http://blogs.msdn.com/b/windowsazure/archive/2013/01/24/sql-server-backup-and-restore-to-cloud-simplified.aspx

• Undoing a change will now undo a check-out in Visual Studio 2012        

  http://sqlblog.com/blogs/jamie_thomson/archive/2013/01/26/undoing-a-change-will-now-undo-a-check-out-in-visual-studio-2012.aspx

• SQL Server – Min Memory Per query and performance

  http://www.sqlserver-dba.com/2013/01/sql-server-min-memory-per-query-and-performance.html

• SQL Server 2008 Service Pack 3 Cumulative Update 9

  http://sqlserverperformance.wordpress.com/2013/01/25/sql-server-2008-service-pack-3-cumulative-update-9/

  2008/2008R2 지원 서비스는 2014.1.14로 끝나네요. 2008 시스템 쓰시는 분들은 어서 업그레이드 하세요~

• Database Backup Integrity Checks with PowerShell

  http://sqlsalt.com/backup-integrity-checks-with-powershell/

• SQL Server - Find Default Data location and Default Log Location

  http://www.sqlserver-dba.com/2013/01/sql-server-find-default-data-location-and-default-log-location-.html

• Replication Latency

  http://sqlserver365.blogspot.kr/2013/01/replication-latency.html

• SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query

  http://blog.sqlauthority.com/2013/01/25/sql-server-basic-explanation-of-query-hint-nowait-how-to-not-wait-on-locked-query/

ETC

• TimingWheel을 이용한 타이머 구현

  http://helloworld.naver.com/helloworld/textyle/267396

SQL

• SQL Server Management Studio Query Designer

  http://www.mssqltips.com/sqlservertip/1086/sql-server-management-studio-query-designer/

• Choosing the Right SQL Server Version: It's Trickier than You'd Think

  http://www.brentozar.com/archive/2013/01/choosing-the-right-sql-server-version-its-trickier-than-youd-think/

• Capturing Baselines on SQL Server: Where's My Space?

  http://www.sqlservercentral.com/articles/baselines/96059/

• Troubleshooting SQL Server RESOURCE_SEMAPHORE Waittype Memory Issues

  http://www.mssqltips.com/sqlservertip/2827/troubleshooting-sql-server-resourcesemaphore-waittype-memory-issues/
  이전에도 올렸던 것 같은데~ 흠..

• SQL Server - How much resource is a SQL database using - memory, disk, IOPS,CPU

  http://www.sqlserver-dba.com/2013/01/sql-server-how-much-resource-is-a-sql-database-using-memory-disk-iopscpu.html

• Visualizing Data File Layout I

  http://sqlblog.com/blogs/merrill_aldrich/archive/2013/01/22/visualizing-data-file-layout-i.aspx

  내부 데이터 파일을 볼 수 있는 툴 소개입니다~
   

ETC

• 추천 시스템 분석 – 어떻게 아마존과 넷플릭스가 당신의 취향을 예상하는가?

  http://dev.kthcorp.com/2013/01/23/deconstructing-recommender-systems/

Update

• Cumulative Update #9 for SQL Server 2008 SP3 is available

  http://sqlblog.com/blogs/aaron_bertrand/archive/2013/01/22/cumulative-update-9-for-sql-server-2008-sp3-is-available.aspx

  
  

SQL

• CTEs with Multiple Recursive Members - Itzik Ben-Gan

  http://www.sqlmag.com/article/tsql/sqlserver-ctes-multiple-recursive-members-144510

• "UPSERT" Race Condition With MERGE - Dan Guzman's Blog

  http://weblogs.sqlteam.com/dang/archive/2009/01/31/UPSERT-Race-Condition-With-MERGE.aspx

  Merge에 대한 동시성 결함테스트 입니다. 헐~..

     

• Trimming More Transaction Log Fat

  http://www.sqlperformance.com/2013/01/io-subsystem/trimming-more-transaction-log-fat

• VMware HA is Not Database Server High Availability

  http://www.brentozar.com/archive/2013/01/vmware-ha-is-not-database-server-high-availability/

• How to manual failover mirroring without affecting replication-SQL Server

  http://beyondrelational.com/modules/2/blogs/88/Posts/18732/how-to-manual-failover-mirroring-without-affecting-replication-sql-server.aspx

• SQLServerCentral Runs sp_Blitz - Performance Part 1

  http://www.sqlservercentral.com/articles/Performance/96072/

• Hypothetical Indexes on SQL Server - Fabiano Amorim

  http://www.simple-talk.com/sql/database-administration/hypothetical-indexes-on-sql-server/

  헐.. 인덱스를 이렇게도 만들 수 있군요~
   

  CREATE INDEX ixOrderDate ON Sales.SalesOrderHeader (OrderDate) WITH STATISTICS_ONLY = -1

• Troubleshooting SQL Server Replication

  http://www.mssqltips.com/sqlservertip/2853/troubleshooting-sql-server-replication/

     

• Performance Impact of Using SELECT COUNT(*) In Queries

  http://www.sql-server-performance.com/2013/performance-select-count-queries

     

• SQL Server - Powershell - Get FQDN – Hostname and IP address

  http://www.sqlserver-dba.com/2013/01/sql-server-powershell-get-fqdn-hostname-and-ip-address.html

     

ETC

• TPC-VMS BENCHMARK TO COMPARE VIRTUAL WORKLOADS

  http://thomaslarock.com/2013/01/tpc-vms-benchmark-to-compare-virtual-workloads/

  TPC-VMS 벤치마크 툴이 릴리즈 되었네요.(TPC-VMS specification)

• Redis 클라우드 서비스 업체

  http://charsyam.wordpress.com/2013/01/22/redis-%ED%81%B4%EB%9D%BC%EC%9A%B0%EB%93%9C-%EC%84%9C%EB%B9%84%EC%8A%A4-%EC%97%85%EC%B2%B4/

     

• How Does the Cloud Change a Systems Architect's Job?

  http://sqlblog.com/blogs/buck_woody/archive/2013/01/22/how-does-the-cloud-change-a-systems-architect-s-job.aspx

     

• Getting Started with Data Science

  http://www.hilarymason.com/blog/getting-started-with-data-science/

MSSQL

• How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks)

  http://blogs.msdn.com/b/psssql/archive/2012/12/13/how-it-works-sql-server-numa-local-foreign-and-away-memory-blocks.aspx
  민석형님이 봐주시면 좋을 듯?
   

• SQL Server Quickie #5 – Bookmark Lookup Deadlocks

  http://www.sqlpassion.at/blog/PermaLink,guid,0536d65c-1f3b-41ec-b309-297c100eb951.aspx

  산타모자 쓰시고 나와서 데드락 설명을 하시네요 발음이~

     

• Azure SQL Database Import/Export Service - Change always brings both challenges and benefits

  http://blogs.msdn.com/b/psssql/archive/2012/12/14/azure-sql-database-import-export-service-change-always-brings-both-challenges-and-benefits.aspx

     

• Instant Index Insight: How to Use sp_BlitzIndex (video)

  http://www.brentozar.com/archive/2012/12/instant-index-insight-how-to-use-sp_blitzindex-video/

  sp_BlitzIndex 괜찮은 스크립트인것 같아요. 개인적으로 그랜 아저씨 스크립트가 더 환상적이라고 생각됩니다. 이 스크립트를 사용하는 방법 동영상입니다.

     

• #0221 - SQL Server - SSMS - Database Properties - Number of Users value

  http://beyondrelational.com/modules/2/blogs/77/Posts/18553/0221-sql-server-ssms-database-properties-number-of-users-value.aspx?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+beyondrelationalmain+%28Technology+stream+from+beyondrelational.com%29

     

• Querying SQL Server Agent Job History Data

  http://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/

     

• SQL Server SP_Congifure 변경 사항 캡처

  http://sqlmvp.kr/140175032346

     

MySQL

• Full table scan vs full index scan performance

  http://architects.dzone.com/articles/full-table-scan-vs-full-index?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+zones%2Farchitects+%28Architects+Zone%29

http://www.mysqlperformanceblog.com/2012/12/14/the-optimization-that-often-isnt-index-merge-intersection/

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