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