SQL

• Cost Threshold for Parallelism

  http://sqlserver365.blogspot.kr/2013/02/cost-threshold-for-parallelism.html

• Statistics on Ascending Keys

  http://www.benjaminnevarez.com/2013/02/statistics-on-ascending-keys/

     

• Temp table caching improvement for table valued parameters in SQL Server 2012

  http://blogs.msdn.com/b/psssql/archive/2013/02/26/temp-table-caching-improvement-for-table-valued-parameters-in-sql-server-2012.aspx

     

• Discovering resultset definition of DBCC commands in SQL Server 2012

  http://spaghettidba.com/2013/02/26/discovering-resultset-definition-of-dbcc-commands-sql-server-2102/

     

• O'Reilly Strata: Busting Big Data Adoption Myths–Part 1

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/26/o-reilly-strata-busting-big-data-adoption-myths-part-1.aspx

     

• Full Text Searches on Documents in FileTables

  https://www.simple-talk.com/sql/database-administration/full-text-searches-on-documents-in-filetables/

     

• Detect SQL Server CPU Pressure

  http://www.mssqltips.com/sqlservertip/2890/detect-sql-server-cpu-pressure/

     

• SET STATISTICS IO – What is Scan count?

  http://sqlwithmanoj.wordpress.com/2013/02/16/set-statistics-io-what-is-scan-count/

     

• SQL SERVER – Beginning SQL 2012 – Aggregation Functions – Abstract from Joes 2 Pros Volume 2

  http://blog.sqlauthority.com/2013/02/26/sql-server-beginning-sql-2012-aggregation-functions-abstract-from-joes-2-pros-volume-2/

     

• SQL Server 2012–what it is and what it isn't

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/25/sql-server-2012-what-it-is-and-what-it-isn-t.aspx

     

• Cleaning Up Reporting Services Snapshots

  http://itknowledgeexchange.techtarget.com/sql-server/cleaning-up-reporting-services-snapshots/

     

• ORIGINAL_LOGIN() and SUSER_SNAME() functions

  http://sqldbpool.com/2013/02/25/original_login-and-suser_sname-functions/

     

기타

• NoSQL for NoDBA

  http://architects.dzone.com/articles/nosql-nodba

• Why do we care about MySQL Performance at High Concurrency?

  http://www.mysqlperformanceblog.com/2013/02/26/why-do-we-care-about-performance-at-high-concurrency/        

• ZooKeeper를 활용한 Redis Cluster 관리

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

  제가 관심 있어야하는 redis로 이롷게까지 만들다뉘~ 대단하세요.

     

• NoSQL Job Trends for February 2013

  http://architects.dzone.com/articles/nosql-job-trends-february-2013

  헐.. mongodb가 압도적이네요. 2위는 카산드라, 3위는 hbase, 내 사랑 레디스가 4위

SQL

• THE ACCIDENTAL ARCHITECT

  http://thomaslarock.com/2013/02/the-accidental-architect/        

     

• Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test

  http://www.sqlsoldier.com/wp/sqlserver/day29of31daysofdisasterrecoveryusingdatabasesnapshotstorestorereplicateddatabasesintest

  이 시리즈들은 최고^^

     

• Script to get the Last Backup Date of database full and t-log backup

  http://sqldbpool.com/2013/02/25/script-to-get-the-last-backup-date-of-database-full-and-t-log-backup/

• SQL Server SINGLE – MULTI – RESTRICTED USER

  http://www.sqlserver-dba.com/2013/02/sql-server-single-multi-restricted-user.html

     

• LAST WEEKS TOP 10 "READING" LINKS #21

  http://www.jasonstrate.com/2013/02/last-weeks-top-10-reading-links-21

     

• Querying with DAX video available on Project Botticelli #dax #ssas #powerpivot

  http://sqlblog.com/blogs/marco_russo/archive/2013/02/25/querying-with-dax-video-available-on-project-botticelli-dax-ssas-powerpivot.aspx

     

• Managing the Database Administrator

  http://www.databasejournal.com/features/db2/managing-the-database-administrator.html

     

• Data Profiling with T-SQL

  http://www.sqlservercentral.com/articles/Data+Profiling/96398/

     

• Backing Up SQL Server Databases Participating In Availability Groups

  http://www.mssqltips.com/sqlservertip/2880/backing-up-sql-server-databases-participating-in-availability-groups/

     

기타

• Hortonworks and Microsoft Bring the Hortonworks Data Platform to Windows

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/25/hortonworks-and-microsoft-bring-the-hortonworks-data-platform-to-windows.aspx

     

• Node.js and MongoLab on Windows Azure

  http://blog.mongolab.com/2013/02/node-js-and-mongolab-on-windows-azure/

     

• A (short) List of Data Science Blogs

  http://www.hilarymason.com/blog/a-short-list-of-data-science-blogs/

     

• Print screen for Remote Desktop

  http://beyondrelational.com/modules/1/justlearned/tips/19033/print-screen-for-remote-desktop.aspx

     

• You can't rollback Redis transactions

  http://openmymind.net/You-Cant-Rollback-Redis-Transaction/

SQL

• Transaction Log Configuration Issues - 폴

  http://www.sqlperformance.com/2013/02/system-configuration/transaction-log-configuration

  트랜잭션 로그 특성에 대해서 잘 정리해 두셨네요^^

     

• Comparing multiple rows insert vs single row insert with three data load methods

  https://www.simple-talk.com/sql/performance/comparing-multiple-rows-insert-vs-single-row-insert-with-three-data-load-methods/

     

• Recommended reading from mrdenny for February 22, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-february-22-2013/

     

• SQL Server Encryption

  http://www.sqlmag.com/article/sql-server/sql-server-encryption-144904

     

• Unable to register .NET framework assembly not in the supported list

  http://blogs.msdn.com/b/psssql/archive/2013/02/23/unable-to-register-net-framework-assembly-not-in-the-supported-list.aspx

• Add an extra SQL Transaction log file – ALTER DATABASE ADD LOG

  http://www.sqlserver-dba.com/2013/02/add-an-extra-sql-transaction-log-file-alter-database-add-log.html

• CTEs with Multiple Recursive Members, Part 2

  http://www.sqlmag.com/article/tsql/tsql-cte-multiple-recursive-members-144833

     

• SQL SERVER – T-SQL Script to Keep CPU Busy

  http://blog.sqlauthority.com/2013/02/22/sql-server-t-sql-script-to-keep-cpu-busy/

     

ETC

• NoSQL for the MSSQL Soul

  http://www.developer.com/db/nosql-for-the-mssql-soul.html

     

• Video: The Difference Between Graph and Relational Databases

  http://architects.dzone.com/articles/video-difference-between-graph

     

• CentOS 5 users: your UTF-8 data is in peril with Perl MySQL

  http://www.mysqlperformanceblog.com/2013/02/22/centos-5-users-your-utf-8-data-is-in-peril-with-perl/

SQL

• FIVE VIRTUAL LABS FOR THE SQL SERVER 2012 DBA

  http://www.jasonstrate.com/2013/02/five-virtual-labs-for-the-sql-server-2012-dba/

     

• SQL Server 2008 Interview Questions & Answers – Part I

  http://sqldbpool.com/2010/02/20/sql-server-2008-interview-questions-answers/

  압축 관련 질답?

     

• Link List: Becoming a Data Professional

  http://sqlblog.com/blogs/buck_woody/archive/2013/02/21/link-list-becoming-a-data-professional.aspx

  괜찮은 링크가 많네요^^ 오호~~ 제가 관심 있어하는 자료들이에요~!

     

• Rolling Averages in SQL Server

  http://www.brentozar.com/archive/2013/02/rolling-averages-in-sql-server/

     

• SQL Server 2012 Integration Services - Introduction to PowerShell-based Management of SSIS

  http://www.databasejournal.com/features/mssql/ssis-2012-introduction-to-powershell-based-management-of-ssis.html

     

• Filtered Indexes - Simple Partitioning without Enterprise Edition?

  http://www.sqlservercentral.com/articles/Partitioning/96247/

     

• Resource Governor in SQL Server 2012

  http://technet.microsoft.com/en-us/library/jj573256.aspx

     

• How to Partition an existing SQL Server Table

  http://www.mssqltips.com/sqlservertip/2888/how-to-partition-an-existing-sql-server-table/

     

• SQL SERVER – Shortcut to SELECT only 1 Row from Table

  http://blog.sqlauthority.com/2013/02/21/sql-server-shortcut-to-select-only-1-row-from-table/

     

• Halloween Protection – The Complete Series

  http://sqlblog.com/blogs/paul_white/archive/2013/02/21/halloween-protection-the-complete-series.aspx

     

ETC

• MySQL 5.5 and 5.6 default variable values differences

  http://www.mysqlperformanceblog.com/2013/02/21/mysql-5-5-and-5-6-default-variable-values-differences/

     

• Solving RPM installation conflicts

  http://www.mysqlperformanceblog.com/2013/02/21/solving-rpm-installation-conflicts/

SQL

• The Halloween Problem – Part 4

  http://www.sqlperformance.com/2013/02/sql-plan/halloween-problem-part-4

• Inline UDFs do not prevent parallel execution plans

  http://sqlblog.com/blogs/alexander_kuznetsov/archive/2013/02/20/inline-udfs-do-not-prevent-parallel-execution-plans.aspx

  정말? 그렇네요.

  

     

• How Does SQL Server Store Data?

  http://www.brentozar.com/archive/2013/02/how-does-sql-server-store-data/

  동영상까지 제공해주네요^^

     

• SQL Performance tuning - Drilling into the problem

  http://www.sqlserver-dba.com/2013/02/sql-performance-tuning-drilling-into-the-problem.html

     

ETC

• Mystery Performance Variance with MySQL Restarts

  http://www.mysqlperformanceblog.com/2013/02/20/mystery-performance-variance-with-mysql-restarts/

  성능 수치 테스트 할 때는 조심해야겟어요.

     

• 자연언어 처리와 오피니언 마이닝 플랫폼 소개

  http://readme.skplanet.co.kr/?p=3749

Update

• SQL Server 2008 R2
  • Cumulative Update 11 per SQL Server 2008 R2 SP1

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/18/cumulative-update-11-for-sql-server-2008-r2-service-pack-1.aspx

       

  • Cumulative Update 5 per SQL Server 2008 R2 SP2

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/18/cumulative-update-5-for-sql-server-2008-r2-service-pack-2.aspx

• SQL Server 2012
  • Cumulative Update 6 per SQL Server 2012

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/19/cumulative-update-6-for-sql-server-2012.aspx

SQL

• SQL Performance tuning - Asking the right question

  http://www.sqlserver-dba.com/2013/02/sql-performance-tuning-asking-the-right-question.html

• 7 Things Developers Should Know About SQL Server

  http://www.brentozar.com/archive/2013/02/7-things-developers-should-know-about-sql-server/

  개발자들이 읽어야 할 내용들인데 좋은 내용이 많네요.

     

• A SQL-Based Universal Currency Formatter

  https://www.simple-talk.com/sql/learn-sql-server/a-sql-based-universal-currency-formatter/

     

• Testing the StreamInsight Service for Windows Azure

  https://www.simple-talk.com/cloud/platform-as-a-service/testing-the-streaminsight-service-for-windows-azure/

     

• Getting Started with Extended Events in SQL Server 2012

  https://www.simple-talk.com/sql/database-administration/getting-started-with-extended-events-in-sql-server-2012/

     

• An in-depth look at change detection in SQL Server - Part 02

  http://www.sqlservercentral.com/articles/SQL+Server/95931/

     

• How to move a SQL Server Log Shipped Secondary Database to Different SQL Server

  http://www.mssqltips.com/sqlservertip/2873/how-to-move-a-sql-server-log-shipped-secondary-database-to-different-sql-server/

     

• FEBRUARY 2013 – MONTHLY SQL SERVER CHECKLIST

  http://www.jasonstrate.com/2013/02/february-2013-monthly-sql-server-checklist

     

• LAST WEEKS TOP 10 "READING" LINKS #19

  http://www.jasonstrate.com/2013/02/last-weeks-top-10-reading-links-19

     

ETC

• MongoDB and Hadoop: A Step-by Step Tutorial

  http://blog.mongodb.org/post/43495291219/mongodb-and-hadoop-a-step-by-step-tutorial

     

• Analyzing Slow Query Table in MySQL 5.6

  http://www.mysqlperformanceblog.com/2013/02/18/slow-query-table-in-mysql-5-6/

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

아 춥다 추워~~

Update

• SQL Server 2012 RTM Cumulative Update #6 is available!

  http://sqlblog.com/blogs/aaron_bertrand/archive/2013/02/18/sql-server-2012-rtm-cumulative-update-6-is-available.aspx

• KB article: http://support.microsoft.com/kb/2728897
• Build # is 11.0.2401
• This build has 22 fixes

SQL

• Implement SSAS MD cell security using dimension security with blazing performance

  http://sqlblog.com/blogs/jorg_klein/archive/2013/02/18/implement-ssas-md-cell-security-using-dimension-security-with-blazing-performance.aspx

     

• The Halloween Problem – Part 3

  http://www.sqlperformance.com/2013/02/sql-plan/halloween-problem-part-3

  MERGE 이슈들을 다루고 있네요.

     

• Getting Started with SSAS Multidimensional - Part 8: Aggregations, Partitions and Perspectives

  http://beyondrelational.com/modules/12/tutorials/799/tutorials/18127/getting-started-with-ssas-multidimensional-part-8-aggregations-partitions-and-perspectives.aspx

     

• Sometimes It's The Little Things That Get You

  http://shaunjstuart.com/archive/2013/02/sometimes-its-the-little-things/

     

• SQL Server 2012: Debugging Deadlocked Schedulers

  http://troubleshootingsql.com/2013/02/18/sql-server-2012-debugging-deadlocked-schedulers/

     

• List SQL Server DBCC commands using trace 2520 – documented and undocumented commands

  http://www.sqlserver-dba.com/2013/02/list-all-sql-server-dbcc-commands-using-trace-2520-documented-and-undocumented-commands.html

dbcc traceon(2520)

dbcc help ('?')

GO

• Merge statement with TOP clause - SQL Server                

  http://beyondrelational.com/modules/2/blogs/88/Posts/18979/merge-statement-with-top-clause-sql-server.aspx        

• Stored Procedures and SQL Injection

  http://www.sqlservercentral.com/articles/Security/96328/

     

• Troubleshooting and Fixing SQL Server Page Level Corruption        

  http://www.mssqltips.com/sqlservertip/2871/troubleshooting-and-fixing-sql-server-page-level-corruption

  오호~~ hex editor로 변경을 하고~ 룰루~~.

     

• Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

  http://www.mssqltips.com/sqlservertip/2883/using-the-sql-server-merge-statement-to-process-type-2-slowly-changing-dimensions/

     

• When will my SQL Server Evaluation Edition expire?

  http://sqlblog.com/blogs/sqlos_team/archive/2013/02/17/when-will-my-sql-server-evaluation-edition-expire.aspx

  오호 평가판 잔여일 뽑는 것도 있네~~

     

• Kerberos With an AlwaysOn Availability Group Listener

  http://sqlsalt.com/kerberos-with-an-alwayson-availability-group-listener/        

• Stored procedures and temporary tables - Scope, Modification and some fun

  http://beyondrelational.com/modules/2/blogs/77/Posts/18571/0222-sql-server-stored-procedures-and-temporary-tables-scope-modification-and-some-fun.aspx

     

     

기타

• Is MySQL 5.6 slower than MySQL 5.5 ?

  http://www.mysqlperformanceblog.com/2013/02/18/is-mysql-5-6-slower-than-mysql-5-5/        

     

• SHA1 + salt로 패스워드 보안 이슈 회피가 가능한가?

  http://www.mimul.com/pebble/default/2013/02/18/1361189648941.html

     

• The Cloudcast - Cloud-Enabling Memcached and Redis for NoSQL

  http://cloud.dzone.com/articles/cloudcast-cloud-enabling

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

날씨가 포근하네요~~ 이번주는 SQL Summit주네요 ~~ 재미난 이슈들 많을 듯...

힘찬 월요일을 만듭시다. 아자아자~~

SQL

• MVP Summit 2013 - Arrivo a Bellevue

  http://blogs.dotnethell.it/suxstellino/MVP-Summit-2013-Arrivo-a-Bellevue__19058.aspx

  아... 나도 가고싶다.. 사진에 닌자고 시리즈와 아래 사진에 이름은 먼지 모르지만 성욱씨랑 이미지가 비슷하넹.ㅋㅋ

     

• Fun with dates

  http://sqlserver365.blogspot.kr/2013/02/fun-with-dates.html

     

• SQL SERVER – Fix : Error – sqljdbc_auth.dll Issue – com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed

  http://blog.sqlauthority.com/2013/02/17/sql-server-fix-error-sqljdbc_auth-dll-issue-com-microsoft-sqlserver-jdbc-sqlserverexception-the-tcpip-connection-to-the-host-localhost-port-1433-has-failed/

     

• PASS BAC PREVIEW SERIES: SQL Professionals and the World of Self-service BI and Big Data

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/15/pass-bac-preview-series-sql-professionals-and-the-world-of-self-service-bi-and-big-data.aspx

• The Halloween Problem – Part 2

  http://www.sqlperformance.com/2013/02/t-sql-queries/halloween-problem-part-2

     

• Columnstore Segment Population Skew

  http://www.sqlskills.com/blogs/joe/columnstore-segment-population-skew/

  parallel nonclustered Columnstore index creations 일때 문제가 있네요.

     

• Table Distribution Across Data Files

  http://sqlsalt.com/table-distribution-across-data-files/

  DataFile 정보 결과가 이쁘게 나오네요^^

     

• Could not find the Distributor or the distribution database for the local server-Error while posts a tracer token in Replication

  http://beyondrelational.com/modules/2/blogs/88/Posts/18945/could-not-find-the-distributor-or-the-distribution-database-for-the-local-server-error-while-posts-a.aspx

     

• Database Security Countermeasures against hacker attacks

  http://www.sqlserver-dba.com/2013/02/database-security-countermeasures-against-hacker-attacks.html

  해커님 왔을 때 어떻게 해야 하나요? 이거네요^^

     

• T-SQL Gotcha

  http://sqlserver365.blogspot.kr/2013/02/t-sql-gotcha.html

     

기타

• memcache on SSD

  https://github.com/twitter/fatcache

  인민에어 오면 테스트 해봐야징..ㅎㅎ 트윗터에서 발행하는거네요.

     

• InnoDB에서 Auto_Increment를 맹신하지 말자.

  http://gywn.net/2013/02/mysql-innodb-auto-increment/

  학... 어쩐지 중복값이 나오더라니~ 썅~

     

• Using MySQL Sandbox with Percona Server

  http://www.mysqlperformanceblog.com/2013/02/16/using-mysql-sandbox-with-percona-server/

     

• Replication checksums in MySQL 5.6

  http://www.mysqlperformanceblog.com/2013/02/15/replication-checksums-in-mysql-5-6/

SQL

• Geek City: Join With Me! - Kalen Delaney

  http://sqlblog.com/blogs/kalen_delaney/archive/2013/02/14/index-intersection.aspx

     

• Hardware 301 Presentation - Glenn Berry's

  http://sqlserverperformance.wordpress.com/2013/02/14/hardware-301-presentation/

  여기 문서좀 다운로드 해서 업로드 해주세요 ㅠㅠ... 울 회사 다운로드 안돼..

     

• Speaking at PASS Database Administration Virtual Chapter

  http://sqlserverperformance.wordpress.com/2013/02/08/speaking-at-pass-database-administration-virtual-chapter/

  Glenn 아저씨가 pass에서 virtual 강의하신다네요. 아 가고 싶당 ㅠㅠ...

     

• Recommended SQL Server 2012 SP1 Hotfix available for msiexec issue (KB2793634)

  http://blogs.msdn.com/b/sqlreleaseservices/archive/2013/02/14/recommended-sql-server-2012-sp1-hotfix-available-for-msiexec-issue-kb2793634.aspx

     

• Drop Connections with ROLLBACK IMMEDIATE to allow a Detach database

  http://www.sqlserver-dba.com/2013/02/drop-connections-with-rollback-immediate-to-allow-a-detach-database.html

  자주 쓰는 구문이네요^^

     

• Day 28 of 31 Days of Disaster Recovery: Recovering SQL if the Tempdb Drive Dies        

  http://www.sqlsoldier.com/wp/sqlserver/day28of31daysofdisasterrecoveryrecoveringsqlifthetempdbdrivedies

  masterdb 문제가 되었을 때 조치하는거네요^^ /f, /t3608로 sql을 시작하고, sqlcmd로 경로를 변경한다.

     

• If you are using indexed views and MERGE, please read this!

  http://www.sqlperformance.com/2013/02/t-sql-queries/another-merge-bug

     

• Script Replication with PowerShell

  http://sqlserver365.blogspot.kr/2013/02/script-replication-with-powershell.html

     

• Full Text Searches on Documents in FileTables

  http://www.simple-talk.com/sql/database-administration/full-text-searches-on-documents-in-filetables/

     

• MDX Guide for SQL Folks: Part III - Advanced Analysis

  http://www.sqlservercentral.com/articles/MDX/95065/

     

• Customized SQL Agent Job Notifications

  http://www.mssqltips.com/sqlservertip/2863/customized-sql-agent-job-notifications/

     

• SQL SERVER – Development Productivity Tool – dbForge Studio for SQL Server

  http://blog.sqlauthority.com/2013/02/14/sql-server-development-productivity-tool-dbforge-studio-for-sql-server/

  쩝.. 유료 툴이네여~?

     

• Has the term "big data" completely lost meaning yet?

  http://sqlblog.com/blogs/greg_low/archive/2013/02/10/has-the-term-big-data-completely-lost-meaning-yet.aspx

     

• SQL SERVER – Primary Key and NonClustered Index in Simple Words

  http://blog.sqlauthority.com/2013/02/10/sql-server-primary-key-and-nonclustered-index-in-simple-words/

     

• Find the database owner name from the owner_sid - t-sql and suser_sname

  http://www.sqlserver-dba.com/2013/02/find-the-database-owner-name-from-the-owner_sid-t-sql-and-suser_sname.html

     

• What Does Big Data Mean to You?

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/02/08/what-does-big-data-mean-to-you.aspx

     

• Windows Azure SQL Database and SQL Server - Performance and Scalability Compared and Contrasted

  http://sqlcat.com/sqlcat/b/msdnmirror/archive/2013/02/08/windows-azure-sql-database-and-sql-server-performance-and-scalability-compared-and-contrasted.aspx

     

• Recommended reading from mrdenny for February 08, 2013

  http://itknowledgeexchange.techtarget.com/sql-server/recommended-reading-from-mrdenny-for-february-08-2013/

     

• Using QUERYTRACEON in plan guides

  http://spaghettidba.com/2013/02/08/using-querytraceon-in-plan-guides/

  아하~^^

     

• WSFC Failure Threshold and Automatic Failovers

  http://sqlsalt.com/wsfc-failure-threshold-and-automatic-failovers/

     

• Manual Log Shipping with PowerShell

  http://spaghettidba.com/2013/02/08/manual-log-shipping-with-powershell/

     

• Database backup does not cause blocking

  http://www.sqlserver-dba.com/2013/02/database-backup-does-not-cause-blocking.html

     

• SQL SERVER – Backup and Restore Database Using Command Prompt – SQLCMD

  http://blog.sqlauthority.com/2013/02/08/sql-server-backup-and-restore-database-using-command-prompt-sqlcmd/

     

기타

• L4/L7 스위치의 대안, 오픈 소스 로드 밸런서 HAProxy

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

  와~~

     

• Windows shell: commands - John Paul

  http://sqlblog.com/blogs/john_paul_cook/archive/2013/02/13/windows-shell-commands.aspx

     

• [Redis] Slowlog

  http://dol9.tistory.com/215

  http://dol9.tistory.com/214

     

추천

• http://ola.hallengren.com/

  DBA라면 한번씨 보시면 좋을 듯.. 관리를 위한 좋은 스크립트가 많네요

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

설 연휴동안에 너무 쉬었더니~ 아직도 엄청 남았네요^^ 부랴부랴 올려야겠어요.

SQL

• Buffer pool disfavoring - 폴

  http://www.sqlskills.com/blogs/paul/buffer-pool-disfavoring/

     

• Breaking Down 18065 - CSS SQL SERVER Engineers

  http://blogs.msdn.com/b/psssql/archive/2013/02/13/breaking-down-18065.aspx

     

• Graphically Viewing Extended Events Deadlock Graphs - Jonathan Kehayias

  http://www.sqlskills.com/blogs/jonathan/graphically-viewing-extended-events-deadlock-graphs/

• DBCC SHOW_STATISTICS Works With SELECT Permission - Benjamin Nevarez

  http://www.benjaminnevarez.com/2013/02/dbcc-show_statistics-works-with-select-permission/

• The Halloween Problem – Part 1 - Paul White

  http://www.sqlperformance.com/2013/02/t-sql-queries/halloween-problem-part-1

     

• DBA Best Practices - A Blog Series: Episode 3 - Use a Wiki for Documentation

  http://sqlblog.com/blogs/argenis_fernandez/archive/2013/02/13/dba-best-practices-a-blog-series-episode-3-use-a-wiki-for-documentation.aspx

  제가 요즘 고민하는 것들이 올라오네요? 문서를 위한 위키~~ 저도 이거 고민중에요^^

     

• Day 25 of 31 Days of Disaster Recovery: Improving Performance of Backups and Restores

  http://www.sqlsoldier.com/wp/sqlserver/day25of31daysofdisasterrecoveryimprovingperformanceofbackupsandrestores

  backup시 buffer 관련도 야그가 나왔네요.

     

• How to get list of all available parameter of .EXE file ?

  http://mssqlfun.com/2013/02/13/how-to-get-list-of-all-available-parameter-of-exe-file/

     

• Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above

  http://mssqlfun.com/2013/02/11/refresh-intellisense-in-ssmssql-server-management-studio-2008-above/

  인테릴젼스 리플래쉬 기능 이런 기능도 있군요??

     

• Move or Relocate the files of Resoruce Database in SQL Server 2005

  http://mssqlfun.com/2013/02/07/move-or-relocate-the-files-of-resoruce-database-in-sql-server-2005/

  master, resource db는 같은 경로에 있어야 한다는군요.

     

• How to find/modify SQLServer Agent logfile location?

  http://mssqlfun.com/2013/01/31/how-to-findmodify-sqlserver-agent-logfile-location/

     

• SQL Server Silent unattended installation using configuration file

  http://mssqlfun.com/2013/01/29/sql-server-silent-unattended-installation-using-configuration-file/

  예전, 주언형님 책에 나와있던 내용이네요^^ 설치 간편하게 하는 방법.. 200백대~300백대는 그냥 껌이죵~~

     

• Extracting DACPACs from all databases with Powershell        

  http://spaghettidba.com/2013/02/13/extracting-dacpacs-from-all-databases-with-powershell/

• Cannot execute as the database principal

  http://www.sqlserver-dba.com/2013/02/cannot-execute-as-the-database-principal.html

     

     

ETC

• SQL and NoSQL Symbiosis

  http://architects.dzone.com/articles/sql-and-nosql-symbiosis

• Using R — .Call("hello")

  http://architects.dzone.com/articles/using-r-%E2%80%94-call%E2%80%9Chello%E2%80%9D

  우리도 R 공부해 보아요..