MENU
Backgrounds
Tools
Tutorials
What Is
About
 


CopyScape

What Is Microsoft Sql Server

   
Other Categories In What Is
Adobe
Apng
C
Csi
Dom
Flex
Http
Java
Jsp
Mysql
Owl
Pls
Python
Ruby
Soap
Svg
Vbscript
Xforms
Xml
Xquery
Xslt
Adobe A I R
Asp
Cdf
Css
Esi
Gif
Https
Java Script
Math M L
Network
Perl
Png
Quirks Mode
Silverlight
Sqlite
Tcl
Voicexml
Xhtml
Xpath
Xsl
Ajax
Bmp
Cfml
Dhtml
Flash
Html
Iframe
Jpeg
Microsoft Sql Server
Oracle Database
Php
Postgre S Q L
Rdf
Smil
Ssi
Tiff
Wsdl
Xlink
Xpointer
Xsl-fo

The Microsoft SQL Server developed using the MS-SQL and T-SQL querying languages and is a relational database system. It was back in 1989 when the database management system was first released on the OS/2 platform. For half a decade it would not be updated or even worked on until the release of Windows NT in 1993. Developed as a direct competitor to that of Oracle  and then later against Sybase, Microsoft SQL Server has continued to be the server of choice for development based on the Microsoft Operating System platforms.

At the time of its initial 1989 release, SQL Server 1.0 was the equivalent to Sybase 3.0 and by 1992 with the release of version 4.1 on the Windows 3.1 NT platform was made available. It was not until the release of version 6.0 that it would be specifically developed for the Windows NT Platform though.

Initially, Sybase and Windows worked together on their developments, but they would eventually part in their ways and work on their own systems separately. Furthermore, after Microsoft went after proprietary rights to SQL Server, Sybase opted to change the name of theirs to that of the Adaptive Server Enterprise so as not to allow any confusion between the two, now separate developments. It was after this separation that the two systems would become competitors as prior to this they were in fact based on the same developments.

The last release of Microsoft SQL Server occurred in 2000 and they would not release another version for nearly 8 years. However, there have been numerous improvements to the core development of the SQL Serve since that release. Today, the SQL Server 2005 comes packaged with a number of helpful tools, reporting systems and a whole lot more. Unfortunately, while Microsoft continues its work towards development of the database management system, more and more web developers have found that MySQL is the preferred way to go.

Much like any of the developments coming out of Microsoft, for one to use the SQL Server, one has to deal with the proprietary issues associated with it. Unlike MySQL which can be called from a number of languages with ease and is also completely free, SQL Server requires a Windows powered server and the use of another proprietary language, ASP, in order to communicate effectively with the database. While it is possible for other internet languages to communicate with a SQL Server database, it is much more difficult to do; much like anything which is associated with Microsoft and the internet.

This of course does not make the database management system worthless, as it is more secure in comparison to that of MySQL, but you do get what you pay for. If it is security one is looking for in a web development, then coding the site in ASP or ASP.NET and making use of the Microsoft SQL Server may be just what you need. Developing in ASP for the SQL Server in comparison to the beast Oracle which is by far the most secure way to go is like the difference between coding HTML and PHP for someone who does not know either.

Original Authors: Nick
Edit Update Authors: M.A.Harris
Updated On: 09/02/2009


Program Software Development © Globel Limited UK LOGON