[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 2008s 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"
鏤