Microsoft SQL Server Developer

Monday, March 22, 2010 7:50:21 PM

1,233 Views
All Training Areas

Contains links and hints to find the best resources for writing SQL statements, stored procedures, and user defined functions.

Data Manipulation Language (DML)
Data Manipulation Language (DML) is the language used to retrieve, insert, modify and delete data from the database using the commands SELECT, INSERT, UPDATE and DELETE, respectively.
SELECT Statement
INSERT Statement
UPDATE Statement
DELETE Statement
MERGE Statement

Transact-SQL (T-SQL)
Transact-SQL (T-SQL for short) is the means of communicating with an instance of SQL Server. It provides commands that control the flow of execution of T-SQL statements, statement blocks and stored procedures. It also provides useful built-in functions and error handling commands.
Built-in Functions
DML Triggers
Error Handling
Cursors
User-Defined Functions
Stored Procedures
Full-Text Search Queries

SSIS - SQL Server Integration Services
All topics related to SSIS, transforms/data flow, control flow, and other related topics.
Overview of SSIS in SQL Server

SQL Server XML
All topics related to XML in SQL Server
Parsing XML in Microsoft Sql Server
XML Data Types in SQL Server

SQL Server Replication
All topics and FAQs related to SQL Server Replication
* The editors are constructing topics for SQL Server Replication.

SQL Service Broker
Topics about SQL Server Service Broker
* The editors are constructing topics for SQL Service Broker.

SQL Server and XML
XML has been part of SQL Server since SQL Server 2000 with the FOR XML clause of the SELECT statement and the OPENXML function for reading XML data. It has further been integrated into all components in SQL Server with the introduction of the XML data type in SQL Server 2005 with the ability to use an XQuery query against the XML data stored in columns and/or variables of XML data type.
XML Data Type
OPENXML
SELECT FOR XML
SQLXML Bulk Load

Data Mining
All topics and topics related to data-mining in SQL Server
* The editors are constructing topics for Data Mining.

SSRS - SQL Server Reporting Services
Report Server, Report Designer, Report Builder, and other reporting-related topics.
* The editors are constructing topics for SSRS - SQL Server Reporting Services.

SQL Server Analysis Services
Topics relating to MDX and other Analysis Services or OLAP topics
* The editors are constructing topics for SQL Server Analysis Services.

.NET Framework inside SQL Server
Writing CLR code targeting SQL Server. This topic is all about the .NET Framework and stored procedures inside the SQL Server CLR.
* The editors are constructing topics for .NET Framework inside SQL Server.

SQL Server Data Access
topics and FAQs about data access to SQL Server using SQL Native Client, OLEDB, ODBC, ADO, WDAC/MDAC, JDBC, or SOAP/HTTP.
* The editors are constructing topics for SQL Server Data Access.

SQL Server SMO/DMO
Any topics on SMO/DMO and how they are used with SQL Server
* The editors are constructing topics for SQL Server SMO/DMO.

SQL Server Security
Any Security related topics on SQL Server
* The editors are constructing topics for SQL Server Security.

SQL Azure
Topics and FAQs on the different incubations of SQL Azure services
* The editors are constructing topics for SQL Azure.

Spatial Data
SQL Server 2008 introduced two new data types, the GEOGRAPHY and GEOMETRY data types, which allow you to store spatial data directly in a SQL Server 2008 database. The GEOMETRY data type supports planar, or Euclidean (flat-earth), data while the GEOGRPAHY data type stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates.
Spatial Data
GEOMETRY Data Type
GEOGRAPHY Data Type
Spatial Indexing

Transact-SQL (T-SQL) Performance Tuning
Provides tips and tricks on how to create well performing queries (SELECT) and fast running data manipulation statements (INSERT, UPDATE and DELETE).
SQL Query Performance Tuning

SQL Server Database Engine
Any topics relating to the SQL Server Database Engine, performance, features, Full-text Search, linked servers, etc.
Performance Tuning in SQL Server Database
SQL Server Database components and Table limitations

SQL Server Setup & Upgrade
General Setup topics, upgrade advisor, Best Practices Analyzer
* The editors are constructing topics for SQL Server Setup & Upgrade.

SQL Server Disaster Recovery and Availability
Any topics around using backup/restore, DBCC, recovering from hardware issues, planning disaster recovery or high-availability strategies.
* The editors are constructing topics for SQL Server Disaster Recovery and Availability.

SQL Server Notification Services
Topics, answers, and FAQs on using SQL Server Notification Services
* The editors are constructing topics for SQL Server Notification Services.

SQL Server Compact
SQL Server Compact/Mobile Edition Technical Topics
* The editors are constructing topics for SQL Server Compact.

SQLEXPRESS -SQL Server Express
Topics related to SQL Server Express, SQL Server Express with Advanced Services, and MSDE upgrade topics.
* The editors are constructing topics for SQLEXPRESS -SQL Server Express.

SQL Server Data Warehousing
Help with using SQL Server for data warehousing, Change Data Capture, or decision support.
* The editors are constructing topics for SQL Server Data Warehousing.