sql server database tutorial

Sql Server Script 1
Sql Server Script 1 is a utility for database developers to transfer MS SQL Server data into SQL script. more>>
Sql Server Script 1 is a utility for database developers to transfer MS SQL Server data into SQL script. Application is very fast and easy to use. You can script SQL Server Data from individual table and from all tables in database.
SQL Server Utilities 3.0i
The SQL Server Utilities are required if you want to use Network Inventory Manager 3.0.11.5 with an MSDE or MS SQL Server 7.0 more>>
This suite includes 2 useful applications: the NIM Attach DB 3.0, which enables you to create databases and VsqlW 1.0.3, a SQL Query Tool.
SQL Server Compare 2.2
SQL Server Compare is an easy-to-use tool to compare 2 SQL Server database schemas more>>
SQL Server Compare does not change the database in any way, and it can not execute any SQL statements - it only compares the schema. Requires SQL server or client installed.
SQL Server Monitor 1.0
A small utility that will allow you to graphically monitor SQL Server performance in real time. more>> A small utility that will allow you to graphically monitor SQL Server performance in real time.
The SQL Server Monitor application was designed to be a small utility that will allow you to graphically monitor SQL Server performance in real time.
The application essentially uses the same techniques as the sp_monitor stored procedure to monitor important information at predetermined intervals. Because it is regularly running a query against the database it will inevitably put a load on that database and server so do adjust the sampling interval to be sympathetic to the server!

SQL Server Surveyor 1.2.5.11
SQL Server Surveyor is a tool which allows database administrators to easily create reports of their SQL Servers for the purposes of documentation, auditing, comparison with other servers, etc more>> <<less

SQL Server Management Studio Express -
Microsoft SQL Server Management Studio Express is graphical management tool more>> Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services. SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.<<less

SQL Server DMV Client 1
SQL Server DMV Client is developed to be a helpful program which makes it easier for you to browse SQL Server DMVs (Dynamic Management Views) and quickly view user session performance information without having to run any SQL code more>>
SQL Server DMV Client 1 is developed to be a helpful program which makes it easier for you to browse SQL Server DMVs (Dynamic Management Views) and quickly view user session performance information without having to run any SQL code. Locate long running sessions, blocked queries, queries with large I/O, CPU, or Memory activity.
Requirements:
- Windows 2000/XP/2003 Server/Vista
- .NET Framework 2.0 x

SQL Server Dumper 3.0.2
SQL Server Dumper enables you to dump/export selected SQL Server database tables into SQL statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. more>>
SQL Server Dumper enables you to dump/export selected SQL Server database tables into SQL INSERT statements, that are saved as local .sql files and contain all the data required to create a duplicate table, or to be used for backup purposes. You can choose to create an individual .sql file for each table, or combine all selected tables into a single file.
This program implements several features and have multiple dumping/export options that allows you to have more control.
System Requirements: .NET Framework 2.0
<<lessSQL Server Tables and Exchange Web Services 1
SQL Server Tables and Exchange Web Services is designed to be a useful sample which demonstrates an effective integration of Microsoft Exchange Server 2007 more>> <<less
SQL Server 2008 Screensaver 1.0
A screensaver for your personal computer. more>> A screensaver for your personal computer.
SQL Server 2008 Screensaver is a simple to use and install screensaver for your personal computer.
<<lessSQL Server Version Checker 1.0.5
Determine SQL Server version and service pack level more>>
Determine SQL Server version and service pack level. Determine the version and service pack level for a given SQL Server database installationMicrosoft SQL Server 2000 Patch: Inappropriate Log
Prevents a login from having inappropriate data access rights more>> Logins that use the SQL Server Authentication (Standard) security mode with a particular query method used to access data from an OLE-DB data source may allow rights that the login might not normally have.<<less
Enumerate SQL Server instances 1.0
Enumerate SQL Server instances is a useful tool that searches for installed SQL Server instances on the local network more>>
There are other ways of enumerating the list of installed SQL Server instances, but this method is relatively fast and consistently returns the list registered instances.
NOTE: If you are using MSDE, you must set EnableNetworkProtocols to on before your MSDE instance can be found using this method. In MSDE SP3, this option is turned off by default for security reasons.
Microsoft SQL Server Service Pack 2 sp2
patches and hotfixes for SQL Server 7 more>> SQL Server Service Pack 2 (SP2) addresses specific issues that were discovered in SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0 since their ship date. Because SQL Server Service Packs are cumulative, SP2 includes all fixes from Service Pack 1 (SP1) and can be applied to an original installation or to one where SP1 was previously applied. It is recommended that you include SP2 in all new SQL Server 7.0 and MSDE 1.0 installations. SP2, for SQL Server 7.0 and MSDE 1.0, is in two parts to reduce the size of downloads: Database Components and OLAP Services Components. Database ComponentsSP2 updates for the database components of SQL Server 7.0 and MSDE 1.0 include: Data engine. Database client utilities, such as SQL Server Enterprise Manager and osql for SQL Server 7.0. Database client connectivity components, such as the OLE DB Provider for SQL Server, the SQL Server Open Database Connectivity (ODBC) driver, and the client Net-Libraries. OLAP Services ComponentsSP2 updates for the online analytical processing (OLAP) services components of SQL Server 7.0 include: OLAP Services. OLAP client components, such as OLAP Manager and the OLE DB Provider for OLAP Services. Database client connectivity components, such as the OLE DB Provider for SQL Server, the SQL Server ODBC driver, and the client Net-Libraries. Note: SQL Server 7.0 sites can use the SP2 Database Components to upgrade their database components without upgrading their OLAP Services components and vice versa. To upgrade both database components and OLAP Services components for your SQL Server 7.0 site, you must apply both parts of the service pack. Use only the SP2 Database Components to upgrade MSDE 1.0 components.<<less
SiteMech Database Manager 1.1.2
SiteMech Database Manager is a useful tool for backup and exchange data between Microsoft SQL Server and MySQL databases more>>
SiteMech Database Manager is a part of SiteMech Web Development Framework. This is a small and useful tool for backup and exchange data between Microsoft SQL Server and MySQL databases.
SiteMech Database Manager allows to export entire database or particular tables to XML file. Later you can import saved file to a local or remote database. The software allows direct data transfer between MSSQL and MySQL databases.
SiteMech Database Manager supports database connection string favorites allowing to reconnect to often used databases quickly. For MSSQL database, binary full-database backup is supported.