![[-]](/moniwiki/imgs/plugin/arrup.png "[-]")
![[+]](/moniwiki/imgs/plugin/arrdown.png "[+]")
[edit]
1 Microsoft SQL Server Article #
![[http]](/moniwiki/imgs/http.png)
Geek City: sp_cacheobjects for SQL Server 2012
- sp_prepexec and nHibernate
- SQL Server 2008 R2 Update for Developers Training Kit
- Generating SQL Server Test Data with Visual Studio 2010
- What's New (SQL Server "Denali")
- SQL Server code-named 'Denali' - Community Technology Preview 1 (CTP1)
- How It Works: Extended Event (sqlos.wait_info*)
- Standardize data storage for geography spatial data type in SQL Server
- Excel with Stored Procedures
- Using Dynamic Management Objects to Monitor I/Os Against an Instance of SQL Server
SharePoint 2010 개발 환경 구축 가이드
- High Availability with SQL Server 2008
- SQL Server Consolidation Guidance
- Consolidation Using SQL Server 2008
- SQL Unplugged: 괴물 이야기
- CheckList
- Access variables values from Trigger
- A Google-like Full Text Search
- Handling SQL Server Errors
- 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.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
- Mission Critical-SQL Server 2008 General Maintenance
- Using Resource Monitor In Windows Server 2008 to Look at I/O Performance for SQL Server 2008
- Microsoft ships the first technology preview for Project code-named “Madison”
- How to change path of system databases on SQL 2005
- Linked server with mirrored database
- Microsoft Business Intelligence Project Booster Kit
- Lock logging and fast recovery
- The SQL Server Wait Type Repository…
- Index Management
- How to Dynamically and Iteratively Populate An Excel Workbook from SQL Server
- Poor Man's Enterprise Feature - Lock Pages in Memory
- MSDE – Database Size Limit
- Physical CPU Count
- Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
- A Unified Approach to Multi-DataBase Query Templates
- Python for the SQL Server DBA
- How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?
- You may not see the data you expect in Extended Event Ring Buffer Targets…
- Fun with Locked Pages, AWE, Task Manager, and the Working Set…
- Ten Common SQL Programming Mistakes
- Checking the Job Status on Multiple Servers
- Best Practices - Using Windows Groups for SQL Server Logins
- Disaster Recovery for SQL Server Databases
- Building Code that Promotes Plan Re-usage
- Using Twitter and PowerShell to Find Technical Information and Join a Community
- Trouble printing out long VARCHAR(MAX) strings?
- A Deadlock Occurrence and Resolution
- Using Memory-Mapped Files in .NET 4.0
- Create a Web-Based CRUD Automation Framework with Python
- Map IP Address to a Geographical Location
- 엔터프라이즈 데이터베이스의 변경 내용 추적
- SQL Server 2008 확장 이벤트를 사용한 고급 문제 해결
- Data Profiling Column Functional Dependency T-SQL
- The New Reality of an Audit Trail
- Context Switching or Database Impersonation using EXEC AS
- Using Indexes to Reduce Blocking in Concurrent Transactions
- Disabling Indexes in SQL Server 2005 and SQL Server 2008
- Distributed Caching On The Path To Scalability
- Remote BLOB Store Provider Library Implementation Specification
- Oracle for the SQL Server Guy - Instances and Databases
- Generating Insert Statements
- Automating tests for T-SQL code
- Deploying Databases From Visual Studio Team System Database Edition
- Ownership chaining in SQL Server security feature or security risk
- Capturing I/O patterns using Process Monitor
- Copy Only Backup for SQL 2005 and SQL 2008
- Practical Database Change Management (Part 1)
- Practical Database Change Management (Part 2)
- Synchronize Metadata Across SQL Server Database Copies
- Dynamic SQL execution on remote SQL Server using EXEC AT
- Creating a recycle bin for SQL Server 2005\2008
- Introduction to SQL Server 2008 Extended Events
- Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part II
- Performance Testing SQL 2008’s Transparent Data Encryption
- Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005
- Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO
- Using the Script Component With Multiple Outputs
- CLR Assembly RegEx Functions for SQL Server by Example
- Connecting Oracle BI Publisher to SQL Server
- Deploying Scripts with SQLCMD
- Processing an Analysis Service Cube using Windows PowerShell and SQL Server 2008 AMO
- SQL Server 2008 Ring Buffer Entries
- Data Profilng Column Functional Dependency T-SQL
- Introducing Microsoft SQL Server 2008
- How To Get Active Directory Users and Groups Using SQL Server Integration Services SSIS 2005
- Performance Testing – SQL Server 2008 versus SQL Server 2005
- SQL Server (2005 and 2008) Trace Flag 1118 (-T1118) Usage
- Understanding the MERGE DML Statement in SQL Server 2008
- Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
- SQL Server Preproduction Tasks
- Investigating the new Spatial Types in SQL Server 2008 - Part 1
- Powerful Geographical Visualisations made easy with SQL 2008 Spatial - Part 2
- A Sudoku solution with set based T-SQL utilizing binary operators
- A Google-like Full Text Search
- SQL Server 버전 알아내기
- Resource Governor
- How Change Data Capture Can be Used
- Using DBCC PAGE to Examine SQL Server Table and Index Data
- Administrator & Monitoring Change Data Capture in SQL Server 2008
- Insert data from Excel to SQL Server 2005 by using copy and paste commands
- Model Your Data Hierarchies With SQL Server 2008
- Server and Database Auditing in SQL Server 2008
- ADO Connection String
- Administrator & Monitoring Change Data Capture in SQL Server 2008
- http://codeplex.com/SqlServerSamples
- Accessing SQL Server Databases with PHP
- Management Studio Improvements in SQL Server 2008
- SQL Server 2008 Jump Start
- Correlated Joins Using 'Apply'
- Using SQL Management Objects to create and restore SQL Databases
- Creating a PDF from a Stored Procedure
- Changing Collation
- SQL Server 보안분석
- SQL Server and the Windows Server 2008 Firewall
- SQL Server 2008 새로운 데이터 형식
- SQL Server 2008 데이터웨어하우스 쿼리 성능
- Scaling Up Reporting Services 2008 vs. Reporting Services 2005
- Find Mismatched Views and Stored Procs
- usp_createsnapshot
- Build a Generic Histogram Generator for SQL Server
- Owning the Spelling Suggestion Feature
- Configure Filestream in SQL Server 2008
- Share Database Knowledge with Office and SQL Server
- Graphical Execution Plans for Simple SQL Queries
- Excel에서 SQL Server로 데이터를 가져오는 방법
- Write query results to Excel using a linked server and T-SQL
- Part 1: Querying an Excel Worksheet
- Part 2: Querying an Excel Worksheet Without Header and With Mixed Column Data Type
- Part 3: Importing an Excel Worksheet
- 2007 Office system 드라이버: 데이터 연결 구성 요소
- http://codeplex.com/SqlServerSamples
- SQL Server 2005에서 CLR 통합 사용
- List of the bugs that are fixed in SQL Server 2005 Service Pack 3
- Download SQL Server 2005 SP3
- Try/Catch를 이용한 데드락의 해결
- Blocking Users by IP
- Displaying and Customizing Images from a Database
- DMV를 통해 인덱스 힌트를 사용한 SP 찾기
- Open DBDiff for SQL Server 2008(두 DB의 차이 비교)
- SQL Script Generation Programmatically with SMO
- T-SQL Black Belt - 페이징 구현하기(코드가 좀 꾸질하다)
- Concatenating Row Values in Transact-SQL
- MS-SQL Server Featured Database Articles
- Exporting to Excel Using a CLR Stored Procedure
- Forecasting with SQL
- Recursive Queries in SQL 1999 and SQL Server 2005
- Creating a User Defined Aggregate with SQL Server 2005 다운로드
- SQL Server Matrix Workbench
![[https]](/moniwiki/imgs/https.png)
VC++로 SP호출하기(ADO) Upload new Attachment "ADOVC.zip"