MS SQL SERVER is a relational database management system and its make use of SQL and propritery T-SQL, T-SQL are SQL with an extent to more like a programming language (Branch, Decision, And Recursif, Etc)
The original code of MS SQL Server was sold by Sysbase SQL Server to Microsoft, and it was the beginning microsoft going into the enterprise level database market, with a competitor like Oracle, DB2 and etc.
Microsoft then develop SQL Server Product with many advancement in performance, Client IDE tools, and ETL tools (SQL Server Integration Services), a reporting server, OLAP and data mining (SQL Server Analysis Services), and some messaging technology specifically service broker and notification services.
The newest version of SQL Server are MS SQL Server 2008 R2 with some update, the update typically called Cumulative Update (CU).
SQL Server Installation also come with Management Studio, you can do almost many DBA related job in some what Easy even for new people who learning SQL SERVER, the GUI is very windows like, so if any of you used windows, you will know what i say.
No comments:
Post a Comment