SQL Server Overview

Microsoft® SQL Server™ is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. In this wiki, you will find articles on database and database application design, as well as examples of the uses that SQL Server can be put to. You can find the full SQL Server Help documentation on the TechNet Library.

SQL Server 2012, the latest version, includes enhanced XML support, integration of .NET Framework objects in databases, improved integration with Microsoft Visual Studio and the Microsoft Office System, as well as improved analysis, reporting, and data integration services. See SQL Server Versions.

---

SQL Server Wiki Articles

• SQL Server Versions  

  • Microsoft SQL Server 2012 Release Notes 
  • Microsoft SQL Server Code-Named "Denali" CTP3 Release Notes 
  • Microsoft SQL Server Code-Named "Denali" CTP1 Release Notes
  • Microsoft SQL Server 2008 R2 SP2 Release Notes
  • Microsoft SQL Server 2008 SP3 Release Notes
  • Microsoft SQL Server 2005 SP4 Release Notes

• Best Practices and Guidelines

  • Database Engine Security Checklist: Database Engine Security Configuration
  • Database Engine Security Checklist: Enhancing the Security of Database Engine Connections
  • Database Engine Security Checklist: Limiting Access to Data
  • Database Engine Security Checklist: Encrypting Sensitive Data
  • How to Design, Create and Maintain a SQL Server Database

• [[articles:SQL Server Analysis Services|SQL Server Analysis Services (SSAS)]]

  • Unified Dimensional Model
  • Event ID and Event Descriptions
  • Explaining the GetClusterCharacteristics Stored Procedure for Sequence Clustering Models
  • Explaining the State Transitions Viewer for Sequence Clustering

• SQL Server Integration Services (SSIS)

  • What's New in SSIS
  • Processing Active Directory Information in SSIS
  • Automatic Restart of SSIS packages after Failover or Failure

• SQL Server Data Quality Services (DQS)

  • [[articles:Data Quality Services (DQS) FAQ]]
  • [[articles:Troubleshoot Installation and Configuration Issues in Data Quality Services (DQS)]]
  • [[articles:Troubleshoot Operational Issues in Data Quality Services (DQS)]]
  • [[articles:Upgrade DQS: SQL Server Code-Named “Denali” CTP3 to SQL Server 2012 RC0]]
  • [[articles:Monitor Data Exchange between DQS and Reference Data Service Providers]]
  • [[articles:Accessing your Data on Remote Servers for DQS Operations by Linking Servers]]
  • [[articles:SQL Server 2012 Data Quality Services (DQS) for Testing Teams]]
  • [[articles:Using DQS: Cleansing complex data using composite domains]] 

• SQL Server Master Data Services (MDS)

  • Exporting Master Data from Master Data Services
  • Display the Master Data Services Web Application in SharePoint
  • Many-to-Many Mapping in Master Data Services
  • Mapping Multiple Systems with Master Data Services
  • Troubleshoot Installation and Configuration Issues (Master Data Services in SQL Server 2012)
  • Troubleshoot Master Data Manager Security (Master Data Services)
  • Troubleshoot the Staging Process (Master Data Services)
  • Troubleshoot Model Deployment (Master Data Services)
  • Troubleshooting Email Notifications (Master Data Services)
  • Troubleshoot Master Data Services Database Restore
  • Working with Data in the Master Data Services (MDS) Add-in for Excel
  • Troubleshooting the Master Data Services (MDS) Add-in for Excel

• SQL Server Reporting Services (SSRS)

  • Resources for help and support
  • Reporting Services Samples on CodePlex
  • SSRS 2008 R2 Atom Data Feeds for PowerPivot

• [[articles:SQL Server Replication Technologies|SQL Server Replication Technologies]]

  • [[General Replication Topics]]
  • [[Snapshot Replication]]
  • [[Transactional Replication]]
  • [[Peer-2-Peer Replication]]
  • [[Merge Replication]]

• Introduction to Development with SQL Server

  • SQL Server Developer Resources
  • How to Design, Create and Maintain a SQL Server Database (en-US)
  • How to Embed SQL Server Express in an Application
  • How to Use ASP.NET with SQL Server (en-US)
  • How to use PHP with SQL Server (en-US)

• SQL Server Express

  • [[SQL Server Express Installation Resources]]
  • How to Embed SQL Server Express in an Application

• SQL Server Management Studio

  • Keyboard Shortcuts
  • Shell and Keyboard Accelerators

• SQL Server Maintenance

• Transact-SQL Programming Language

  • How To Examples of Selected T-SQL Programming Constructs

    • Data Related Queries

      [[Find the First Available Timeslot for Scheduling]]

    • Maintenance Queries  

  [[SQL Server Backup, Integrity Check and Index Optimization]]

  • Programming Best Practices and Guidelines

• SQL Server Management Pack for System Center Operations Manager

  • Configuring and deploying RunAs Accounts

• SQL Server Product Documentation 

  • Delivery and Structure of SQL Server Documentation Has Changed for Denali

---

SQL Server Library How-To Topics

• SQL Server Replication Technologies
  • Configuring, Modifying, and Disabling Publishing and Distribution 
  • Creating, Modifying, and Deleting Publications and Articles 
  • Creating, Modifying, and Deleting Subscriptions 
  • Securing a Replication Topology 
  • Synchronizing Subscriptions 
  • Administration 
  • Monitoring 

SQL Server Maintenance

• Administration 
• Designing and Implementing Structured Storage 
• Performance Monitoring and Tuning 

---

See Also

• Wiki: List of Technologies and Related Topics
• PowerPivot: Overview

---

External Links

• SQL Server Help on the TechNet Library
• SQL Server Development MSDN page
• SQL Server TechNet page

---