#title Microsoft SQL Server Article [[TableOfContents]] ==== Microsoft SQL Server Article ==== * [http://sqlblog.com/blogs/kalen_delaney/archive/2013/07/31/sp-cacheobjects-for-sql-server-2012.aspx Geek City: sp_cacheobjects for SQL Server 2012] * [http://www.sqlservercentral.com/articles/sp_prepexec/76511/ sp_prepexec and nHibernate] * [http://www.microsoft.com/downloads/en/details.aspx?FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d SQL Server 2008 R2 Update for Developers Training Kit] * [http://www.mssqltips.com/tip.asp?tip=2190&home Generating SQL Server Test Data with Visual Studio 2010] * [http://msdn.microsoft.com/en-us/library/bb500435(SQL.110).aspx What's New (SQL Server "Denali")] * [http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9 SQL Server code-named 'Denali' - Community Technology Preview 1 (CTP1)] * [http://blogs.msdn.com/b/psssql/archive/2010/10/20/how-it-works-extended-event-sqlos-wait-info.aspx How It Works: Extended Event (sqlos.wait_info*)] * [http://www.mssqltips.com/tip.asp?tip=2117 Standardize data storage for geography spatial data type in SQL Server] * [http://www.sqlservercentral.com/articles/Stored+Procedures/63537/ Excel with Stored Procedures] * [http://www.databasejournal.com/features/mssql/article.php/3895221/article.htm Using Dynamic Management Objects to Monitor I/Os Against an Instance of SQL Server] * [attachment:MicrosoftSQLServerArticle/SharePoint_2010.pdf SharePoint 2010 개발 환경 구축 가이드] * [http://msdn.microsoft.com/en-us/library/ee523927(v=SQL.100).aspx High Availability with SQL Server 2008] * [http://msdn.microsoft.com/en-us/library/ee819082(v=SQL.100).aspx SQL Server Consolidation Guidance] * [http://msdn.microsoft.com/en-us/library/ee692366(v=SQL.100).aspx Consolidation Using SQL Server 2008] * [http://video.kr.msn.com/watch/video/sql-unplugged-sql-unplugged-%EA%B4%B4%EB%AC%BC-%EC%9D%B4%EC%95%BC%EA%B8%B0/16etpqzq9 SQL Unplugged: 괴물 이야기] * CheckList * [http://www.bradmcgehee.com/2010/06/sql-server-instance-checklist/#more-1643 SQL Server Instance Checklist] * [http://www.bradmcgehee.com/2010/01/dba-checklist-updated/ DBA Checklist Updated] * [http://www.bradmcgehee.com/2010/06/sql-server-operating-system-checklist/ SQL Server Operating System Checklist] * [http://www.bradmcgehee.com/2010/05/sql-server-monitoring-checklist/ SQL Server Monitoring Checklist] * [http://www.simple-talk.com/sql/database-administration/brads-sure-dba-checklist/ DBA Best Practices Checklist] * [http://www.bradmcgehee.com/2010/06/sql-server-hardware-checklist/ SQL Server Hardware Checklist] * [http://www.sqlservercentral.com/articles/trigger/70233/ Access variables values from Trigger] * [http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/ A Google-like Full Text Search] * [http://www.sqlteam.com/article/handling-sql-server-errors Handling SQL Server Errors] * [http://www.sqlservercentral.com/articles/Replication/69663/ Scaling Out the Distribution Database] * A High Level Comparison Between Oracle and SQL Server * http://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx * http://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_ii_p1.aspx * http://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_iii_p1.aspx * http://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_iv_p1.aspx * [http://www.simple-talk.com/sql/database-administration/mission-critical-sql-server-2008-general-maintenance/?utm_source=simpletalk&utm_medium=email&utm_content=GeneralMaintenanceChecklist-20100222&utm_campaign=SQL Mission Critical-SQL Server 2008 General Maintenance] * [http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!2290.entry Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008] * [http://blogs.technet.com/dataplatforminsider/archive/2009/08/24/microsoft-ships-the-first-technology-preview-for-project-code-named-madison.aspx Microsoft ships the first technology preview for Project code-named “Madison”] * [http://www.sp-configure.com/how-to-change-path-of-system-databases-on-sql-2005/ How to change path of system databases on SQL 2005] * [http://www.sqler.com/128735 Linked server with mirrored database] * [http://www.sqlservercentral.com/articles/SSIS/68341/ Microsoft Business Intelligence Project Booster Kit] * [http://www.sqlskills.com/BLOGS/PAUL/post.aspx?id=6c91f4ea-20e1-48b1-998d-96c54dc4a074 Lock logging and fast recovery] * [http://blogs.msdn.com/psssql/archive/2009/11/03/the-sql-server-wait-type-repository.aspx The SQL Server Wait Type Repository…] * [http://www.sqlservercentral.com/articles/68079/ Index Management] * [http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61542/ How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server] * [http://www.sqlservercentral.com/articles/Lock+Pages+in+Memory/67975/ Poor Man's Enterprise Feature - Lock Pages in Memory] * [http://www.sqlservercentral.com/blogs/sqldownsouth/archive/2009/10/8/msde-database-size-limit.aspx MSDE – Database Size Limit] * [http://www.sql-server-pro.com/physical-cpu-count.html Physical CPU Count] * [http://www.sqlservercentral.com/articles/T-SQL/63681/ Cross Tabs and Pivots, Part 1 – Converting Rows to Columns] * [http://www.simple-talk.com/dotnet/.net-tools/a-unified-approach-to-multi-database-query-templates/ A Unified Approach to Multi-DataBase Query Templates] * [http://www.simple-talk.com/sql/database-administration/python-for-the-sql-server-dba/?utm_source=simpletalk&utm_medium=email&utm_content=Python20090809&utm_campaign=SQL Python for the SQL Server DBA] * [http://blogs.msdn.com/psssql/archive/2009/09/17/how-it-works-what-are-the-ring-buffer-resource-monitor-telling-me.aspx How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?] * [http://blogs.msdn.com/psssql/archive/2009/09/17/you-may-not-see-the-data-you-expect-in-extended-event-ring-buffer-targets.aspx You may not see the data you expect in Extended Event Ring Buffer Targets…] * [http://blogs.msdn.com/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx Fun with Locked Pages, AWE, Task Manager, and the Working Set…] * [http://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/ Ten Common SQL Programming Mistakes] * [http://www.sqlservercentral.com/articles/Monitoring/67972/ Checking the Job Status on Multiple Servers] * [http://www.mssqltips.com/tip.asp?tip=1831 Best Practices - Using Windows Groups for SQL Server Logins] * [http://www.simple-talk.com/sql/backup-and-recovery/disaster-recovery-for-sql-server-databases-/ Disaster Recovery for SQL Server Databases] * [http://www.databasejournal.com/features/mssql/article.php/3833336/Building-Code-that-Promotes-Plan-Re-usage.htm Building Code that Promotes Plan Re-usage] * [http://www.simple-talk.com/exchange/exchange-articles/using-twitter-and-powershell-to-find-technical-information-and-join-a-community/?utm_source=simpletalkExchange&utm_medium=email&utm_content=Twitter-20090803&utm_campaign=Exchange Using Twitter and PowerShell to Find Technical Information and Join a Community] * [http://www.sqlservercentral.com/articles/varchar(max)/67057/ Trouble printing out long VARCHAR(MAX) strings?] * [http://www.sqlservercentral.com/articles/deadlock/64315/ A Deadlock Occurrence and Resolution] * [http://www.developer.com/net/article.php/3828586 Using Memory-Mapped Files in .NET 4.0] * [http://www.devx.com/dbzone/Article/42015 Create a Web-Based CRUD Automation Framework with Python] * [http://www.sqlservercentral.com/articles/SQL+Server/67215/ Map IP Address to a Geographical Location] * [http://technet.microsoft.com/ko-kr/magazine/cc987538.aspx 엔터프라이즈 데이터베이스의 변경 내용 추적] * [http://technet.microsoft.com/ko-kr/magazine/dd314391.aspx SQL Server 2008 확장 이벤트를 사용한 고급 문제 해결] * [http://www.sqlservercentral.com/articles/Data+Profiling/65615/ Data Profiling Column Functional Dependency T-SQL] * [http://www.sqlservercentral.com/articles/Auditing/67224/ The New Reality of an Audit Trail] * [http://www.sql-server-performance.com/articles/dba/context_switching_impersonation_p1.aspx Context Switching or Database Impersonation using EXEC AS] * [http://www.sqlservercentral.com/articles/Performance+Tuning/67134/ Using Indexes to Reduce Blocking in Concurrent Transactions] * [http://www.sqlservercentral.com/articles/Performance+Tuning/67134/ Disabling Indexes in SQL Server 2005 and SQL Server 2008] * [http://msdn.microsoft.com/en-us/magazine/dd942840.aspx#id0430022 Distributed Caching On The Path To Scalability] * [http://technet.microsoft.com/en-us/library/cc905212.aspx Remote BLOB Store Provider Library Implementation Specification] * [http://www.sqlservercentral.com/articles/SQL+Server/67007/ Oracle for the SQL Server Guy - Instances and Databases] * [http://www.sqlservercentral.com/articles/T-SQL/66987/ Generating Insert Statements] * [http://www.sqlservercentral.com/articles/unit+tests/67050/ Automating tests for T-SQL code] * [http://www.sqlservercentral.com/articles/visual+studio/65746/ Deploying Databases From Visual Studio Team System Database Edition] * [http://www.mssqltips.com/tip.asp?tip=1778 Ownership chaining in SQL Server security feature or security risk] * [http://www.sqlservercentral.com/articles/I/O/66420/ Capturing I/O patterns using Process Monitor] * [http://www.mssqltips.com/tip.asp?tip=1772 Copy Only Backup for SQL 2005 and SQL 2008] * [http://www.sql-server-performance.com/articles/dba/change_management_p1.aspx Practical Database Change Management (Part 1)] * [http://www.sql-server-performance.com/articles/dba/database_change_management_2_p1.aspx Practical Database Change Management (Part 2)] * [http://www.sqlmag.com/Articles/Index.cfm?ArticleID=101901 Synchronize Metadata Across SQL Server Database Copies] * [http://www.mssqltips.com/tip.asp?tip=1757 Dynamic SQL execution on remote SQL Server using EXEC AT] * [http://www.sqlservercentral.com/articles/DDL+trigger/66552/ Creating a recycle bin for SQL Server 2005\2008] * [http://www.sqlteam.com/article/introduction-to-sql-server-2008-extended-events Introduction to SQL Server 2008 Extended Events] * [http://www.sqlservercentral.com/articles/XML/66518/ Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part II] * [http://www.databasejournal.com/features/mssql/article.php/3815501/article.htm Performance Testing SQL 2008’s Transparent Data Encryption] * [http://www.mssqltips.com/tip.asp?tip=1733 Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005] * [http://www.databasejournal.com/features/mssql/article.php/3812126/Detach-and-attach-Analysis-Service-Database-using-Windows-PowerShell-and-SQL-Server-2008-AMO.htm Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO] * [http://www.sqlservercentral.com/articles/SSIS/66136/ Using the Script Component With Multiple Outputs] * [http://www.simple-talk.com/sql/t-sql-programming/clr-assembly-regex-functions-for-sql-server-by-example/ CLR Assembly RegEx Functions for SQL Server by Example] * [http://www.databasejournal.com/features/oracle/article.php/3810266/Connecting-Oracle-BI-Publisher-to-SQL-Server.htm Connecting Oracle BI Publisher to SQL Server] * [http://www.sqlservercentral.com/articles/SQLCMD/66183/ Deploying Scripts with SQLCMD] * [http://www.databasejournal.com/features/mssql/article.php/3809606/article.htm Processing an Analysis Service Cube using Windows PowerShell and SQL Server 2008 AMO] * [http://blogs.msdn.com/psssql/archive/2009/03/13/sql-server-2008-ring-buffer-entries.aspx SQL Server 2008 Ring Buffer Entries] * [http://www.sqlservercentral.com/articles/Data+Profiling/65615/ Data Profilng Column Functional Dependency T-SQL] * [http://csna01.libredigital.com/?urss1q2we6 Introducing Microsoft SQL Server 2008] * [http://www.mssqltips.com/tip.asp?tip=1657 How To Get Active Directory Users and Groups Using SQL Server Integration Services SSIS 2005] * [http://www.databasejournal.com/features/mssql/article.php/3792476/article.htm Performance Testing – SQL Server 2008 versus SQL Server 2005] * [http://blogs.msdn.com/psssql/archive/2008/12/17/sql-server-2005-and-2008-trace-flag-1118-t1118-usage.aspx SQL Server (2005 and 2008) Trace Flag 1118 (-T1118) Usage] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/64365/ Understanding the MERGE DML Statement in SQL Server 2008] * [http://www.sqlservercentral.com/articles/cross+tab/65048/ Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs] * [http://www.sqlservercentral.com/articles/Administration/64732/ SQL Server Preproduction Tasks] * [http://www.sqlservercentral.com/articles/SQL+Server+2008/64601/ Investigating the new Spatial Types in SQL Server 2008 - Part 1] * [http://www.sql-server-performance.com/articles/dev/Powerful_Geographical_Visualisations_SQL_2008_Spatial_Part2_p1.aspx Powerful Geographical Visualisations made easy with SQL 2008 Spatial - Part 2] * [http://www.sqlservercentral.com/scripts/T-SQL/62978/ A Sudoku solution with set based T-SQL utilizing binary operators] * [http://www.sqlservercentral.com/articles/Full-Text+Search+(2008)/64248/ A Google-like Full Text Search] * [http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx SQL Server 버전 알아내기] * [http://www.sqlservercentral.com/articles/Resource+Governor/64034/ Resource Governor] * [http://www.sql-server-performance.com/articles/dba/How_Change_Data_Capture_Can_Be_Used_p1.aspx How Change Data Capture Can be Used] * [http://www.mssqltips.com/tip.asp?tip=1578 Using DBCC PAGE to Examine SQL Server Table and Index Data] * [http://www.sql-server-performance.com/articles/dba/Change_Data_Capture_in_SQL_Server_2008_p1.aspx Administrator & Monitoring Change Data Capture in SQL Server 2008] * [http://www.mssqltips.com/tip.asp?tip=1430 Insert data from Excel to SQL Server 2005 by using copy and paste commands] * [http://msdn.microsoft.com/en-us/magazine/cc794278.aspx Model Your Data Hierarchies With SQL Server 2008] * [http://www.sql-server-performance.com/articles/dba/Server%20and%20Database%20Auditing%20in%20SQL%20Server%202008_p1.aspx Server and Database Auditing in SQL Server 2008] * [http://www.codeproject.com/database/connectionstrings.asp?print=true ADO Connection String] * [http://www.sql-server-performance.com/articles/dba/Change_Data_Capture_in_SQL_Server_2008_p1.aspx Administrator & Monitoring Change Data Capture in SQL Server 2008] * http://codeplex.com/SqlServerSamples * [http://technet.microsoft.com/en-us/library/cc793139(SQL.90).aspx Accessing SQL Server Databases with PHP] * [http://www.simple-talk.com/sql/learn-sql-server/management-studio-improvements-in-sql-server-2008/ Management Studio Improvements in SQL Server 2008] * [http://sqlserver2008jumpstart.microsofttraining.com SQL Server 2008 Jump Start] * [http://www.sqlservercentral.com/articles/T-SQL/63115/ Correlated Joins Using 'Apply'] * [http://www.sqlservercentral.com/articles/SMO/63126/ Using SQL Management Objects to create and restore SQL Databases] * [http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/ Creating a PDF from a Stored Procedure] * [http://www.sqlservercentral.com/scripts/Miscellaneous/30471/ Changing Collation] * [http://sqlsecurity.com/Tools/FreeAnalysis/tabid/66/Default.aspx SQL Server 보안분석] * [http://blogs.msdn.com/sqlsecurity/archive/2008/07/01/sql-server-and-the-windows-server-2008-firewall.aspx SQL Server and the Windows Server 2008 Firewall] * [http://technet.microsoft.com/ko-kr/magazine/cc434692(TechNet.10).aspx SQL Server 2008 새로운 데이터 형식] * [http://technet.microsoft.com/ko-kr/magazine/cc434693(TechNet.10).aspx SQL Server 2008 데이터웨어하우스 쿼리 성능] * [http://sqlcat.com/technicalnotes/archive/2008/07/09/scaling-up-reporting-services-2008-vs-reporting-services-2005-lessons-learned.aspx Scaling Up Reporting Services 2008 vs. Reporting Services 2005] * [http://www.sqlservercentral.com/scripts/Development/63270/ Find Mismatched Views and Stored Procs] * [http://www.sqlservercentral.com/scripts/Database+Snapshots/63243/ usp_createsnapshot] * [http://www.devx.com/dbzone/Article/38511 Build a Generic Histogram Generator for SQL Server] * [http://www.sqlservercentral.com/articles/T-SQL/63404/ Owning the Spelling Suggestion Feature] * [http://www.sql-server-performance.com/articles/dba/Configure_Filestream_in_SQL_Server_2008_p1.aspx Configure Filestream in SQL Server 2008] * [http://www.sqlservercentral.com/articles/Full-Text+Search/63876/ Share Database Knowledge with Office and SQL Server] * [http://www.simple-talk.com/sql/performance/graphical-execution-plans-for-simple-sql-queries/ Graphical Execution Plans for Simple SQL Queries] * [http://support.microsoft.com/kb/321686 Excel에서 SQL Server로 데이터를 가져오는 방법] * [http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1057989,00.html?bucket=ETA&topic=301370 Write query results to Excel using a linked server and T-SQL] * [http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx Part 1: Querying an Excel Worksheet] * [http://www.sql-server-helper.com/tips/read-import-excel-file-p02.aspx Part 2: Querying an Excel Worksheet Without Header and With Mixed Column Data Type] * [http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx Part 3: Importing an Excel Worksheet] * [http://www.microsoft.com/downloads/details.aspx?displaylang=ko&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891 2007 Office system 드라이버: 데이터 연결 구성 요소] * http://codeplex.com/SqlServerSamples * [http://www.microsoft.com/korea/msdn/SQL/2005/servprog/default.aspx?pull=/korea/msdn/library/ko-kr/dnsql90/html/sqlclrguidance.asp#sqlclrguidance_topic2 SQL Server 2005에서 CLR 통합 사용] * [http://support.microsoft.com/?kbid=955706 List of the bugs that are fixed in SQL Server 2005 Service Pack 3] * [http://go.microsoft.com/fwlink/?LinkId=135960 Download SQL Server 2005 SP3] * [http://www.microsoft.com/korea/msdn/SQL/default.aspx?pull=/korea/msdn/library/ko-kr/dnsqlpro05/html/sp05e10.asp Try/Catch를 이용한 데드락의 해결] * [http://www.sqlservercentral.com/articles/Security/66151/ Blocking Users by IP] * [http://www.developer.com/net/article.php/3818161 Displaying and Customizing Images from a Database] * [http://hyoksong.tistory.com/entry/DMV를-통해-인덱스-힌트를-사용한-SP-찾기 DMV를 통해 인덱스 힌트를 사용한 SP 찾기] * [http://www.databasejournal.com/features/mssql/article.php/3842326/article.htm Open DBDiff for SQL Server 2008(두 DB의 차이 비교)] * [http://www.mssqltips.com/tip.asp?tip=1833 SQL Script Generation Programmatically with SMO] * [http://technet.microsoft.com/ko-kr/library/cc700725.aspx T-SQL Black Belt - 페이징 구현하기(코드가 좀 꾸질하다)] * [http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/ Concatenating Row Values in Transact-SQL] * [http://www.databasejournal.com/features/mssql/ MS-SQL Server Featured Database Articles] * [http://www.sqlservercentral.com/articles/SQLCLR/68842/ Exporting to Excel Using a CLR Stored Procedure] * [http://www.sqlservercentral.com/articles/T-SQL/69334/ Forecasting with SQL] * [http://www.sqlservercentral.com/links/564292/43630 Recursive Queries in SQL 1999 and SQL Server 2005] * [http://www.novicksoftware.com/Articles/sql-2005-product-user-defined-aggregate.htm Creating a User Defined Aggregate with SQL Server 2005] [attachment:MicrosoftSQLServer/sql-2005-udagg-proudct.zip 다운로드] * [http://www.simple-talk.com/sql/t-sql-programming/sql-server-matrix-workbench/ SQL Server Matrix Workbench] * [https://www.dbguide.net/dbqa/dbqa120001.jsp?mode=view&divcateno=244&divcateno_=244&pg=1&idx=862 VC++로 SP호출하기(ADO)] attachment:ADOVC.zip