http://sqlserverfinebuild.codeplex.com/

무료 툴로 한번 클릭으로 아래와 같이 설치 및 커스트 마이징 가능 하다.. 
와우 한번 테스트 해봐야겠네...
얼얼.. 좋은 툴이 많아..

One-click Install of SQL Server

• The standard builds include Service Pack, Cumulative Update hotfix, community tools, and best-practice configuration.
• The builds can be deployed manually or by a distribution tool such as Altiris.

SQL

• SQL Server Diagnostic Information Queries for January 2014

  http://sqlserverperformance.wordpress.com/2014/01/14/sql-server-diagnostic-information-queries-for-january-2014/

• How to throttle your Storage with Resource Governor in SQL Server 2014

  http://www.sqlpassion.at/archive/2014/01/14/how-to-throttle-your-storage-with-resource-governor-in-sql-server-2014

     

• HOW TO: RESTORE THE MASTER DATABASE IN SQL SERVER 2012

  http://thomaslarock.com/2014/01/restore-the-master-database-in-sql-server-2012

     

• Correlating SQL Server 2014 cardinality events and query plan

  http://www.sqlskills.com/blogs/bobb/correlating-sql-server-2014-cardinality-events-and-query-plan/

• Extending automation of SQL recoveries using Ola Hallengren's backup solution

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/extending-automation-of-sql-recoveries-using-ola-hallengren-s-backup-solution.aspx

     

• Top Support Solutions for Microsoft SQL Server

  http://blogs.technet.com/b/topsupportsolutions/archive/2013/11/06/top-support-solutions-for-microsoft-sql-server.aspx

     

• Delayed Durability

  http://www.sqlstash.com/2014/01/14/delayed-durability/

     

• Gatting started with Windows Azure PowerShell        

  http://miteshc.wordpress.com/2014/01/14/gatting-started-with-windows-azure-powershell-3/

     

• Operations team and sql server permissions

  http://www.sqlserver-dba.com/2014/01/operations-team-and-sql-server-permissions.html

     

• PowerShell ? Change SQL Server Login Password

  http://www.johnsansom.com/powershell-change-sql-server-login-password/

     

• Write-BlogPost

  http://sqlblog.com/blogs/rob_farley/archive/2014/01/14/write-blogpost.aspx

     

• T-SQL Tuesday #050: Automating Database Restores

  http://jasonbrimhall.info/2014/01/14/t-sql-tuesday-050-automating-database-restores

     

• T-SQL Tuesday #50: Automation, how much of it is the same?

  http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/t-sql-tuesday-50-automation/

     

• T-SQL Tuesday #50 ? Automating Your Installs

  http://blogs.lessthandot.com/index.php/datamgmt/dbadmin/mssqlserveradmin/t-sql-tuesday-50-automating-your-installs/

     

• Automation? Think Causation, not Correlation

  http://sqlblog.com/blogs/merrill_aldrich/archive/2014/01/14/automation-think-causation-not-correlation.aspx

     

• Sometimes It's A Dirty Job ? #TSQL2sDAY #50

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/sometimes-it-s-a-dirty-job-tsql2sday-50.aspx

     

• SSIS & DQS: The Knowledgebase does not exist

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/ssis-amp-dqs-the-knowledgebase-does-not-exist.aspx

     

• "My Power BI" Sites

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/my-power-bi-sites.aspx

     

• Generate two-dimensional QR Code® bar codes in an SSRS report

  http://www.sqlservercentral.com/articles/QR+Code/105388/

     

Other

• nBase-ARC: Redis Cluster

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

• InnoDB file formats: Here is one pitfall to avoid

  http://www.mysqlperformanceblog.com/2014/01/14/innodb-file-formats-here-is-one-pitfall-to-avoid/

• EVERYDAY POSTGRES: SPECIFYING ALL YOUR INSERT COLUMNS

  http://www.chesnok.com/daily/2014/01/14/everyday-postgres-specifying-all-your-insert-columns

     

• Independent consultant: How to find work

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/14/independent-consultant-how-to-find-work.aspx

SQL

• What Does a Good Mentor Do for You?

  http://kevinekline.com/2014/01/13/what-does-a-good-mentor-do-for-you/

• SQL Server 2014 Columnstore Index Update Internals

  http://joedantoni.wordpress.com/2014/01/13/sql-server-2014-columnstore-index-update-internals/

     

• SQL Server 2014 ? Delayed Durability

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/sql-server-2014-delayed-durability.aspx

     

• SQL Server Backup and Recovery: Simple, Full and Bulk Recovery

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/sql-server-backup-and-recovery-simple-full-and-bulk-recovery.aspx

     

• T-SQL to check Data and Log Files are on same drive or not.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/t-sql-to-check-data-and-log-files-are-on-same-drive-or-not.aspx

     

• Guid vs Identity columns (Ints)

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/guid-vs-identity-columns-ints.aspx

     

• SQL Server ? Difference between @@CONNECTIONS and @@MAX_CONNECTIONS

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/sql-server-difference-between-connections-and-max-connections.aspx

     

• Using Powershell with SQL Server Clusters ? Getting Information

  http://www.seangallardy.com/2014/01/using-powershell-with-sql-server-clusters-getting-information

     

• My Favourite SSMS productivity tips

  http://mattsql.wordpress.com/2014/01/13/my-favourite-ssms-productivity-tips/

     

• SSAS ? Using the Euro or Pound currency Symbol in a measure Format String

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/ssas-using-the-euro-or-pound-currency-symbol-in-a-measure-format-string.aspx

     

• Understanding Peer-to-Peer Transactional Replication, Part 1

  http://www.sqlservercentral.com/articles/Replication/104652/

     

• Justifying the new Mac Pro

  http://www.sqlperformance.com/2014/01/system-configuration/justifying-the-new-mac-pro

• Monitor SQL Server Disk Space Using PowerShell

  http://www.mssqltips.com/sqlservertip/3109/monitor-sql-server-disk-space-using-powershell/

LINKS

• Last Weeks Top "Reading" Links #66

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/last-weeks-top-reading-links-66.aspx

     

Other

• Video: Name Resolution and Port Queries

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/13/video-name-resolution-and-port-queries.aspx

     

• Webinars: Common (but deadly) MySQL mistakes

  http://www.mysqlperformanceblog.com/2014/01/13/webinars-common-but-deadly-mysql-mistakes/

     

• Running Your Startup's Sign Up Form on AWS Elastic Beanstalk

  http://cloud.dzone.com/articles/running-your-startups-sign

SQL

• Top SQL Server blogs from MSSQLWIKI

  http://mssqlwiki.com/2014/01/11/top-sql-server-blogs-from-mssqlwiki/

  캬.. 엄청난 아티클들... 내공이 보여~~

     

• In-memory OLTP ? read_set, write_set, and scan_set

  http://www.sqlskills.com/blogs/bobb/in-memory-oltp-read_set-write_set-and-scan_set/

     

• Clustered Indexes vs. Heaps

  http://blog.kejser.org/2014/01/12/clustered-indexes-vs-heaps/

     

• Dynamic Sorting

  http://www.brentozar.com/archive/2014/01/dynamic-sorting/

     

• First release of my own personal T-SQL Code Library on github

  http://sqlblog.com/blogs/jamie_thomson/archive/2014/01/12/first-release-of-my-own-personal-t-sql-code-library-on-github.aspx

     

• Who Owns SQL Backups?

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

     

• SQL SERVER 2012 ? Fix ? Error :11526 ? The metadata could not be determined because statement '%.*ls' in procedure '%.*ls' uses a temp table.

  http://raresql.com/2014/01/10/sql-server-2012-fix-error-11526-the-metadata-could-not-be-determined-because-statement-ls-in-procedure-ls-uses-a-temp-table/

     

• SQL Server 2012: Installing and configuring Distributed Replay

  http://www.pythian.com/blog/sql-server-2012-installing-and-configuring-distributed-replay/

     

• T-SQL ? Monitoring DiskSpace of Multiple Servers

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/10/t-sql-monitoring-diskspace-of-multiple-servers.aspx

     

• 2013 ? Review of Writing

  http://blogs.lessthandot.com/index.php/2014/01/sql-server-2013-onpnt/

     

• SQL Set Operators. Set? Really?

  http://sqlblog.com/blogs/dejan_sarka/archive/2014/01/10/sql-set-operators-set-really.aspx

     

• TempDB - setting the initial size

  http://www.sqlserver-dba.com/2014/01/tempdb-setting-the-initial-size.html

     

• A New Solution for Monitoring SQL Server

  http://blogs.lessthandot.com/index.php/2013/12/a-new-solution-for-monitoring/

     

• SQL Agent Monitoring ? Long Running Job Queries

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/10/sql-agent-monitoring-long-running-job-queries.aspx

     

• Adding or removing the IDENTITY property

  http://sqlscope.wordpress.com/2014/01/10/adding-or-removing-the-identity-property/

     

• Resources to Study for Exam 70-461

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/12/resources-to-study-for-exam-70-461.aspx

     

• Meteorite Findings Analysis with PowerBI

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/12/meteorite-findings-analysis-with-powerbi.aspx

     

• How to Install a Clustered SQL Server 2012 Instance ? Step-by-step ? Part 4

  http://www.pythian.com/blog/how-to-install-a-clustered-sql-server-2012-instance-step-by-step-part-4/

     

• Comparing Tables In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/11/comparing-tables-in-power-query.aspx

     

• SSRS ? Identify a scheduled SSRS Report

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/10/ssrs-identify-a-scheduled-ssrs-report.aspx

     

• SQL Server Backup and Recovery: Instant File Initialization

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/09/sql-server-backup-and-recovery-instant-file-initialization.aspx

     

• The PoSh DBA - Reading and Filtering Errors

  https://www.simple-talk.com/sql/database-administration/the-posh-dba---reading-and-filtering-errors/

     

     

LINKS

• Log Buffer #354, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-354-a-carnival-of-the-vanities-for-dbas/

• Log Buffer #353, A Carnival of the Vanities for DBAs

  http://www.pythian.com/blog/log-buffer-353-a-carnival-of-the-vanities-for-dbas/

     

• (SFTW) SQL Server Links 10/01/14

  http://www.johnsansom.com/sftw-sql-server-links-100114/

     

Other

• 5 WAYS TO VERIFY WHAT YOUR BIG DATA IS TELLING YOU

  http://thomaslarock.com/2014/01/5-ways-to-verify-what-your-big-data-is-telling-you/        

http://www.dbnewsfeed.com/2013/02/26/sql-server-videos/

굿굿...

SQL

• Creating a DBA's Library

  http://www.mssqltips.com/sqlservertip/3142/creating-a-dbas-library/

• SQL Server DMVs that Lie

  http://www.brentozar.com/archive/2014/01/sql-server-dmvs-that-lie/

     

• SQL Server 2014 Backup Basics

  https://www.simple-talk.com/sql/backup-and-recovery/sql-server-2014-backup-basics/

     

• SQL Server 2014 CTP2 ? Memory Optimization Advisor

  http://www.pythian.com/blog/sql-server-2014-ctp2-memory-optimization-advisor/

     

• SQL Server 2014 memory-optimized table variables ? metadata and garbage collection

  http://www.sqlskills.com/blogs/bobb/sql-server-2014-memory-optimized-table-variables-metadata-and-garbage-collection/

     

• Finding a Deadlocked SQL Server Agent Job Name

  http://www.sqlskills.com/blogs/joe/finding-a-deadlocked-sql-server-agent-job-name

     

• Why Are You Still Using SQL Server 2005?

  http://www.brentozar.com/archive/2014/01/why-are-you-still-using-sql-server-2005/

     

• Why Transaction Log Auto Growths are degrading your performance

  http://www.sqlpassion.at/archive/2014/01/07/why-transaction-log-auto-growths-are-degrading-your-performance

     

• Transactions: What are they?

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/08/transactions-what-are-they.aspx

     

• Cleaning up the Buffer Pool

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/08/cleaning-up-the-buffer-pool.aspx

     

• SQL Server 2014 Hybrid Cloud Scenarios: Migrating On-Premises SQL Server to Windows Azure Virtual Machines

  http://blogs.technet.com/b/dataplatforminsider/archive/2013/12/10/sql-server-2014-hybrid-cloud-scenarios-migrating-on-premises-sql-server-to-windows-azure-virtual-machines.aspx

     

• Relational database or graph database? Why not have both?

  http://www.sqlservercentral.com/articles/NoSQL/105585/

     

• Hidden Formatting Troubles with STR() (SQL Spackle)

  http://www.sqlservercentral.com/articles/T-SQL/71565/

     

• Using SQL Metadata to Create NULL Handling SSIS Expressions

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/01/using-sql-metadata-to-create-null-handling-ssis-expressions.aspx

     

• Apply SP1 to SQL Server 2012 on active/active Windows Server 2012 cluster.

  http://mattsql.wordpress.com/2014/01/08/apply-sp1-to-sql-server-2012-on-activeactive-windows-server-2012-cluster/

     

• Things I Learned in 2013

  http://www.dbnewsfeed.com/2014/01/02/things-i-learned-in-2013

     

Other

• [OpenStack Class] 제3강 클라우드의 핵심! 하이퍼바이저

  http://naleejang.tistory.com/91

     

• How to recover table structure from .frm files with MySQL Utilities

  http://www.mysqlperformanceblog.com/2014/01/02/recover-table-structure-frm-files-mysql-utilities/

     

• [왜 클로저(Clojure)인가?] 4. 단순한 코드와 복잡한 코드

  http://www.techsuda.com/archives/2849

SQL

• Indexed Views and Statistics - Paul White

  http://www.sqlperformance.com/2014/01/sql-plan/indexed-views-and-statistics

• SQL Server 2014 In Memory OLTP: Memory-Optimized Table Types and Table Variables

  http://blogs.technet.com/b/dataplatforminsider/archive/2014/01/07/sql-server-2014-in-memory-oltp-memory-optimized-table-types-and-table-variables.aspx

• SQL Server 2014 In-Memory OLTP (Hekaton) Limitations

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/07/sql-server-2014-in-memory-oltp-hekaton-limitations.aspx

     

• How SQL Server 2014 improves Online Operations that aren't Online Operations

  http://www.sqlpassion.at/archive/2014/01/02/how-sql-server-2014-improves-online-operations-that-arent-online-operations

     

• Determing BUCKET_COUNT for Hash indexes for Memory-Optimized tables in SQL Server

  http://www.mssqltips.com/sqlservertip/3104/determing-bucketcount-for-hash-indexes-for-memoryoptimized-tables-in-sql-server/

     

• Unwinding Table Spools

  http://aboutsqlserver.com/2014/01/07/unwinding-table-spools/

     

• What's the Best Path to Becoming a DBA?

  http://www.johnsansom.com/whats-the-best-path-to-becoming-a-dba/

     

• Understanding SQL Server Query Optimization ? Part 4

  http://www.sql-server-performance.com/2014/understanding-sql-server-query-optimization-4/

     

• Clustered vs. Nonclustered Index Internal Structures (video)

  http://voluntarydba.com/post/2014/01/07/Clustered-vs-Nonclustered-Index-Internal-Structures.aspx

     

• SQL Schedulers disabled

  http://www.sqlserver-dba.com/2014/01/sql-schedulers-disabled.html

• How to receive Deadlock information automatically via email

  http://www.sqlservercentral.com/articles/deadlock/71374/

     

• PowerShell Data Basics: XML

  https://www.simple-talk.com/sysadmin/powershell/powershell-data-basics-xml/

     

• Aggregating By Local Groups In Power Query

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/03/aggregating-by-local-groups-in-power-query.aspx

     

• Getting started with Windows Azure PowerShell

  http://miteshc.wordpress.com/2014/01/07/gatting-started-with-windows-azure-powershell-2/

     

• SSIS: Understanding BufferTempStoragePath

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/07/ssis-understanding-buffertempstoragepath.aspx

     

• An AlwaysOn Bug with Service Broker Transmission Queue

  http://www.sqlservercentral.com/articles/Service+Broker/105446/

     

• Transfer files from Linux to Windows or vice versa using SSIS

  http://www.mssqltips.com/sqlservertip/3068/transfer-files-from-linux-to-windows-or-vice-versa-using-ssis/

     

Other

• Some More MySQL Tuning

  http://java.dzone.com/articles/some-more-mysql-tuning

• Increasing slow query performance with the parallel query execution

  http://www.mysqlperformanceblog.com/2014/01/07/increasing-slow-query-performance-with-parallel-query-execution/

• Learning postgreSql: serialization failures with SERIALIZABLE

  http://sqlblog.com/blogs/alexander_kuznetsov/archive/2014/01/06/learning-postgresql-serialization-failures-with-serializable.aspx

     

Links

• http://www.johnsansom.com/sftw-sql-server-links-030114/        

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

신년 잘 보내셨나요~ 리플래쉬 휴가와 신년이 겹쳐서 Daily Links를 많이 쉬게 되었네요^^ SQLTAG 회원님들~ 새해 복 많이 받으세요~

SQL

• SQL Server Diagnostic Information Queries for January 2014

  http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-january-2014

• Trace Flag 4199: Complex Risk Assessment Part I

  http://sql-sasquatch.blogspot.kr/2014/01/trace-flag-4199-complex-risk-assessment.html

     

• Trace Flag 4199: Complex Risk Assessment: Part II

  http://sql-sasquatch.blogspot.kr/2014/01/trace-flag-4199-complex-risk-assessment_6.html

     

• Reliably Dropping a Database in a T-SQL Script is Too Hard

  http://sqlblog.com/blogs/greg_low/archive/2014/01/06/reliably-dropping-a-database-in-a-t-sql-script-is-too-hard.aspx

• SQL Server Quickie #9 ? Clustered Indexes

  http://www.sqlpassion.at/archive/2014/01/06/sql-server-quickie-9-clustered-indexes

     

• SQL SERVER ? How to get the list of all triggers using sp_MSforeachtable

  http://raresql.com/2014/01/05/sql-server-how-to-get-the-list-of-all-triggers-using-sp_msforeachtable/

• Fraud Detection with the SQL Server Suite Part 5

  http://sqlblog.com/blogs/dejan_sarka/archive/2014/01/06/fraud-detection-with-the-sql-server-suite-part-5.aspx

     

• SQL Simplicity Methods

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/sql-simplicity-methods.aspx

     

• Transactions: Rolling back a transaction inside a stored procedure.

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/transactions-rolling-back-a-transaction-inside-a-stored-procedure.aspx

     

• Day 11 ? Purging syspolicy

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/04/day-11-purging-syspolicy.aspx

     

• SQL Server ? Different ways to check Recovery Model of a database

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/sql-server-different-ways-to-check-recovery-model-of-a-database.aspx

     

• Clarity in T-SQL: Adjoining Socks

  http://www.midnightdba.com/Jen/2014/01/clarity-in-t-sql-adjoining-socks/

     

• Proactive Performance Management for the New Year

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/proactive-performance-management-for-the-new-year.aspx

     

• Organize Those Holiday Photos with PowerShell

  http://sqlblog.com/blogs/merrill_aldrich/archive/2014/01/05/organize-those-holiday-photos-with-powershell.aspx

     

• PowerShell ? Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/powershell-find-os-architecture-32-bit-or-64-bit-of-local-or-remote-machines-using-powershell.aspx

• Steps to recover access/reset SA Password to SQL Server Instance without downtime

  http://sqldbpool.com/2014/01/06/steps-to-recover-accessreset-sa-password-to-sql-server-instance-without-downtime/        

     

• SSAS Dynamic KPI from a table

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2014/01/06/ssas-dynamic-kpi-from-a-table.aspx

     

Other

• 대용량 세션을 위한 로드밸런서

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

SQL

• Script to get articles detail - SQL Server Replication

  http://beyondrelational.com/modules/2/blogs/88/Posts/19770/script-to-get-articles-detail-sql-server-replication.aspx

• Using DQS with SQL Server AlwaysOn AG

  http://blogs.msdn.com/b/blogdoezequiel/archive/2013/12/23/using-dqs-with-sql-server-alwayson-ag.aspx

     

• How to Cache Stored Procedure Results

  http://www.brentozar.com/archive/2013/12/how-to-cache-stored-procedure-results/

     

• 12 Days of Christmas 2013 Day 2

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/26/12-days-of-christmas-2013-day-2.aspx

     

• Entity Data Modeling with Visual Studio

  http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/26/entity-data-modeling-with-visual-studio.aspx

     

• #0313 - SQL Server - sp_help returns double the field length for Unicode characters

  http://beyondrelational.com/modules/2/blogs/77/Posts/19761/0313-sql-server-sphelp-returns-double-the-field-length-for-unicode-characters.aspx

• SQL Server could not spawn FRunCommunicationsManager thread

  http://www.mssqltips.com/sqlservertip/3114/sql-server-could-not-spawn-fruncommunicationsmanager-thread/

     

• LAST WEEKS TOP "READING" LINKS #63

  http://www.jasonstrate.com/2013/12/last-weeks-top-reading-links-63/

     

Other

• 2 cases for MySQL server overload

  http://www.mysqlperformanceblog.com/2013/12/26/two-cases-mysql-server-overload/

     

• TDD에 관한 비용적인 관점

  http://mimul.com/pebble/default/2013/12/26/1388037319240.html

     

• [MOOC추천] Statistical Learning (스탠포드대학)

  http://zeronova.kr/2013/12/26/mooc-statistical-learning/