About the time Windows NT was released, Sybase and Microsoft parted ways and each pursued their own design and marketing schemes. Microsoft negotiated exclusive rights to all versions of SQL Server written for Microsoft operating systems. Later, Sybase changed the name of its product to Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server. Until 1994, Microsoft's SQL Server carried three Sybase copyright notices as an indication of its origin.
Since parting ways, several revisions have been done independently. SQL Server 7.0 was a rewrite from the legacy Sybase code. It was succeeded by SQL Server 2000, which was the first edition to be launched in a variant for the IA-64 architecture.
In the eight years since release of Microsoft's previous SQL Server product (SQL Server 2000), advancements have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005. These include: an ETL tool (SQL Server Integration Services or SSIS), a Reporting Server, an OLAP and data mining server (Analysis Services), and several messaging technologies, specifically Service Broker and Notification Services.
Source : http://en.wikipedia.org/wiki/Microsoft_SQL_Server
Below are general list of topics that can be download in order to learn more detail about SQL server
- Syllabus
- 01. Database Creation
- 02. DDL (Data Definition Language)
- 03. DML (Data Manipulation Language)
- 04a. DTS (Data Transformation Services)
- 04b. DTS Lanjutan
- 05. SQL (Structured Query Language)
- 06. SQL More
- 07. View
- 08. T-SQL (Transact SQL)
- 09. Store Procedure
- 10. Trigger
- 11. Cursor
- 12. Transaction & Lock
- 13. Index
No comments:
Post a Comment