| -- End Ad Box ---> | | | | can find the full text search feature, the DBCC and. |
| A SQL (Structured Query Language) server is a | | | | the backup and restore processes. |
| complete system designed for the purpose of | | | | The last version of Microsoft SQL server was |
| database management, development and | | | | released in 2005 and it was, of course, called Microsoft |
| administration. With the help of the SQL server | | | | SQL server 2005. This version is quite faster than |
| software, users are able to create and handle large | | | | SQL server 2000 and in the five years that passed |
| relational or structural databases and develop | | | | since the first one was released a lot of new |
| applications that increase the effectiveness of their | | | | improvements and enhancements have been done. |
| business. | | | | SQL server 2005 is not only a database administration |
| Microsoft SQL Server has always been the best | | | | tool, it also contains Messaging technologies, OLAP |
| database platform. It provides secure storage and | | | | and Server integration services. It has a large variety |
| when it comes to working with large databases no | | | | of management tools integrated also and its security |
| other product can be compared with SQL server. It is | | | | and database encryption systems have been seriously |
| also very closely related to Visual Studio and The | | | | improved. |
| office suite, so it's perfect for both database | | | | T-Sql has been implemented in order to handle errors |
| administrators and people who work with smaller and | | | | better and the XML integration has gone deeper, now |
| simpler databases | | | | allowing XML to be stored in databases. |
| SQL servers have a large number of powerful tools | | | | The new features of SQL 2005 are too many to |
| that facilitate database maintenance, and administration. | | | | enumerate, so we'll just take a look at a few of the |
| Among the most important ones are the Enterprise | | | | most important ones: |
| Manager, the Service Manager and the Query | | | | Database mirroring - if a database fails, the application |
| analyzer. | | | | connects to another database from a secondary |
| The Enterprise Manager allows its user to manage all | | | | server, and transfer isn't interrupted Snapshots - if loss |
| the SQL server installations on a network and control | | | | of data occurs or someone just made a mistake and |
| all the databases from it. The Service Manager is | | | | modified some important data everything can be |
| responsible for controlling the processes and services | | | | recovered because SQL server periodically takes |
| of an SQL server Finally, the Query analyzer | | | | 'snapshots' of the database and uses them to restore |
| processes all the queries against any of the SQL | | | | the data Support for 64 bit processors Business |
| databases. | | | | Intelligence features built into SQL Server Analysis |
| The first version of Microsoft SQL server was | | | | Services and Reporting Services Significant security |
| released in 1993, the same time Windows NT 3.1 came | | | | upgrades Enhanced encryption capabilities .NET CLR, |
| out on the market, and after a few years, Microsoft | | | | and Visual Studio integration |
| SQL server 2000 was released. Compared to its | | | | ..and many more other useful features |
| previous versions, SQL server 2000 brings a lot of | | | | SQL server 2000 and SQL server 2005 are the best |
| improvements and interesting new features, like XML | | | | and the most complex database management tools |
| support, functions that can be defined by the users | | | | on the market, and they can do much more than just |
| themselves, indexed views and new data types. Also, | | | | managing and administrating databases, so they are |
| some of the features that existed in the previous | | | | the best choice if your company needs database |
| versions were enhanced in Microsoft SQL server | | | | administration and maintenance. |
| 2000. Among the features that were enhanced you | | | | |