[edit]
1 Microsoft SQL Server Article #
![[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)
- CheckList
- 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/)
- 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.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
- 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 2008s 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)
- http://codeplex.com/SqlServerSamples
- 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)
- http://codeplex.com/SqlServerSamples
- 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"