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

Free ebook 정보가 올라왔네요^^ 빨간색 책들을 제외하고는 모두 sample 용도로 한개에서 두개정도면 올라왔네요.. 나머지는 돈 주고 사야죠 머~~

http://blogs.msdn.com/b/mssmallbiz/archive/2012/07/27/large-collection-of-free-microsoft-ebooks-for-you-including-sharepoint-visual-studio-windows-phone-windows-8-office-365-office-2010-sql-server-2012-azure-and-more.aspx

Moving to Microsoft Visual Studio 2010  VS2005 PDF  VS2005 XPS  VS2008 PDF  VS2008 XPS	Programming Windows 8 Apps  PDF	Managing SQL Servers and Policy-Based Management
	Introducing Windows Server 2012  PDF  EPUB  MOBI	Introducing Microsoft SQL Server 2012  PDF  EPUB  MOBI	Introducing Microsoft SQL Server 2008 R2  PDF  XPS
SQL Server 2012 Tutorials: Analysis Services - Tabular Modeling  PDF  EPUB  MOBI	Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery  PDF  EPUB  MOBI	Transact-SQL Data Manipulation Language (DML) Reference  PDF  EPUB  MOBI	QuickStart: Learn DAX Basics in 30 Minutes   PDF  EPUB  MOBI
SQL Server 2012 Tutorials: Analysis Services - Data Mining  PDF  EPUB  MOBI	Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide  PDF  EPUB  MOBI	Data Analysis Expressions (DAX) Reference  PDF  EPUB  MOBI	SQL Server 2012 Upgrade Technical Guide PDF  EPUB  MOBI
Backup and Restore of SQL Server Databases   PDF  EPUB  MOBI	SQL Server 2012 Tutorials: Analysis Services - Multidimensional Modeling  PDF  EPUB  MOBI	Master Data Services Capacity Guidelines   PDF  EPUB  MOBI

몽고DB와 RDBMS와 결합^^.... 요즘에 이렇게들 많이 쓰네요. 

참고 링크

http://www.mongodb.org/display/DOCS/Monitoring+and+Diagnostics#MonitoringandDiagnostics-HostedMonitoring
http://gurjarmehul.wordpress.com/2011/12/27/monitoring-mongodb/

몽고DB를 모니터링하기 위한 방법은 다양하다.

1. 툴을 이용한 모니터링

• munin
• Server stats: this will retrieve server stats (requires python; uses http interface)
• Collection stats, this will display collection sizes, index sizes, and each (configured) collection count for one DB (requires python; uses driver to connect)

• Ganglia:
• ganglia-gmond
• mongodb-ganglia

• cacti
• Mikoomi provides a MongoDB plugin for Zabbix
• Nagios
• Motop - Realtime monitoring tool for several MongoDB servers. Shows current operations ordered by durations every second.

• mtop - A top like utility for Mongo

• Mongo Live - A Chrome extension that provides a real-time server status view (uses the rest interface).

2. Shell Command

• db.serverStatus() : 일반적인 서버 상태 정보
• serverStatus Command

• db.stats() : 선택된(use) 데이타베이스 상태 정보
• db.foo.find().explain() : 쿼리 실행 계획
• db.users.stats() : collection 통계
• 프로파일러
• db.setProfilingLevel(2) ;  profile enable
• db.system.profile.find() : slow query see
• db.setProfilingLevel(0) ;  profile disable

3. Utility

• mongostat

mongostat --host 127.0.0.1:27017 30 --noheaders > perflog.txt

30초마다 헤더정보 없이 mongostat의 결과 정보를 peflog.txt에 기록해라.

• Mongotop
• read/write의 성능 정보(sec/per)

• Query profiler(Slow query 분석)
• Http console

http://localhost:28017

DBA에게 필수!! 설치 이후 설정 및 기능 확인하는 경우가 많은데 이런 Script를 Amit Banerjee라는 분이 공유하셨네요. 이것을 응용해서 이런 저런거 만들어 놔야징.ㅋㅋ

■ SQL Feature Discovery Script

http://troubleshootingsql.com/2012/06/27/sql-feature-discovery-script/

■ Initial Data Collection Script

http://troubleshootingsql.com/2010/01/21/initial-data-collection-script/

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

SQL2012 11.0.2325 버전을 사용중입니다.  SQL 개체 스크립팅을 사용하려고 했는데 그중 특정 옵션만 활성화만 시키게 되면 저장프로시져 Script의 주석문 및 Script 정보가 변경되어 있는 것을 확인하였습니다.

테스트 방법 

도구>옵션>SQL Server 개체 탐색기>스크립트>테이블 및 뷰 옵션

"사용자 정의 데이터 형식을 기본 형식"를 enable하게 되면 저장프로시져의 주석문이안 나오는 문제가 있습니다. 이것이 버그일까요? 

1.  아래의 옵션을 활성화 하였습니다.

2. 테스트 하려는 프로시져를 생성하고 저장된 정보를 확인 한다.

3. 프로시져를 선택하여 수정하기를 했을 때 스크립트된 결과

    - 주석문이 제거 됨.

    - WITH EXECUTE AS CALLER 옵션 추가

memSQL 공부해야 하나?? 왜 자꾸 변하는겨?

"멤SQL은 초당 8만쿼리를 처리해, 3천500쿼리를 다루는 마이SQL 성능을 23배 가량 앞선다. " 이게 가능한겨? MSSQL에서도 초당 Request수도 5000이상 보기 어려운디..

메모리 기반 RDBMS, MemSQL을 알아봅시다

http://dev.kthcorp.com/2012/07/04/memory-based-rdbms-memsql/

참고 링크

http://misoin.wordpress.com/2012/06/05/redis-%EB%B3%B5%EC%A0%9C-masterslaves/

Redis를 Windows 설치 하기

http://judydba.tistory.com/201

1. 설정 파일 생성

C:\Redis\Config 디렉토리에 redis.conf 파일을 복사하여 redis_master.conf, redis_slave.conf 파일을 생성. 

2. 윈도우 서비스 등록

3. 로그 확인

## master Server

[6624] 07 Jun 16:58:40 # Windows does not support daemonize. Start Redis as service

[6624] 07 Jun 16:58:40 * Server started, Redis version 2.4.5

[6624] 07 Jun 16:58:40 * DB loaded from disk: 0 seconds

[6624] 07 Jun 16:58:40 * The server is now ready to accept connections on port 7379

[6624] 07 Jun 16:58:45 * Slave ask for synchronization

[6624] 07 Jun 16:58:45 * Starting BGSAVE for SYNC

[6624] 07 Jun 16:58:45 * Foregroud saving started by pid 6624

[6624] 07 Jun 16:58:45 * DB saved on disk

[6624] 07 Jun 16:58:45 * Background saving terminated with success

[6624] 07 Jun 16:58:45 * Synchronization with slave succeeded

## Slave Server

[1044] 07 Jun 16:58:45 * The server is now ready to accept connections on port 8379

[1044] 07 Jun 16:58:45 * Connecting to MASTER...

[1044] 07 Jun 16:58:45 * MASTER <-> SLAVE sync started

[1044] 07 Jun 16:58:45 * Non blocking connect for SYNC fired the event.

[1044] 07 Jun 16:58:45 * MASTER <-> SLAVE sync: receiving 10 bytes from master

[1044] 07 Jun 16:58:45 * MASTER <-> SLAVE sync: Loading DB in memory

[1044] 07 Jun 16:58:45 * MASTER <-> SLAVE sync: Finished with success

https://github.com/dmajkic/redis/downloads

Redis 연구노트

http://kerocat.tistory.com/1

Redis Windows

https://github.com/kcherenkov/redis-windows-service

http://suretalent.blogspot.kr/2011/11/installing-redis-database-as-windows.html

https://github.com/kcherenkov/redis-windows-service/downloads

http://maxivak.com/getting-started-with-redis-and-asp-net-mvc-under-windows/

1. 디렉토리 생성

2. 설정 파일 이동

c:\Redis\Config로 redis.conf 파일을 복사하여 이동 

redis.conf: 수정 내용

3. 서비스 실행 파일 다운로드

https://github.com/kcherenkov/redis-windows-service/downloads

위의 경로를 통하여 실행 파일을 다운로드 받아 c:\redis\ 폴더에 저장

4. 윈도우 서비스 등록

Where:

%name% -- name of service instance, ex. redis-instance;

%binpath% -- path to this project exe file, ex. C:\Program Files\redis\RedisService.exe;

%configpath% -- path to redis configuration file, ex. E:\Redis\redis.conf;

5. 윈도우 서비스 삭제