Documentation and Books

Recent site activity

Databases‎ > ‎

Microsoft SQLServer

What is Microsoft SQLServer?


My tutorials :

None

3rd party tutorials :

None

Software and downloads :

LiteSpeed for SQL Server
LiteSpeed for SQL Server's low impact, high-performance compression technology enables organizations to reduce storage costs and SQL backup and recovery windows—while maintaining complete control over the backup and recovery process. The LiteSpeed for SQL Server backup engine compresses data up to 95 percent, in half the time required by other backup solutions. LiteSpeed speeds up restore times through its ability to recover individual database objects and encapsulate complete database restores into a single file.

SQLScheduler
SQLScheduler is a fully functional client/server application written in C# that allows administrators to schedule various SQL jobs for SQL Server Express and other versions of SQL Server.

Toad
With Quest you can simplify the manual, time-intensive tasks associated with SQL Server design, development, code optimization, performance and availability.

SwisSQL
Tool to migrate tables and data from/to all popular databases. Supports Oracle, SQL Server, MySQL, DB2 and Sybase.

General questions and answers :

Common problems and solutions :


Techniques and common solutions:

The explanations below are kept simple on purpose, for more advanced features of these statements take a look at the original documentation. (references to the original documentation are included with the simple explanations)

DML ( Data Manipulation Language (Wikipedia) )

None

DDL ( Data definition language (Wikipedia) )

Project site & reference documentation: