| Show Shopping Cart |
| Register |
| Help | Index |
| New | Specials |
| Quick Sell |
| Clearance Sale |
| Policies | Feedback |
| Discounts | Services |
| Resources | Support |
| Community | News |
| Contact Us |
| Info | FAQs |
| Up |
| Deal of the Day | » |
| MiTAC Mio DigiWalker C320 GPS Navigation System... Only $113.99 |
| Featured Products | » |
| Black Lite-On DH-4O1S-11 SATA Blu-ray Reader, 4x BD -R/R... Only $89.99 | |
| Black AOC 19in Widescreen Computer LCD Monitor, 300 cd/m... Only $119.99 |
| Crazy Prices | » |
| Clearance Sale | » |
| Home >> Resources | Support >> Computer Programming Tutorials >> |
SQL Server 2000 Tutorial/Guide/HelpThe Structured Query Language (SQL) is the language of databases. All modern relational databases, including Access, FileMaker Pro, Microsoft SQL Server and Oracle use SQL as their basic building block. Microsoft SQL Server 2000 is a full-featured relational database management system (RDBMS) that offers a variety of administrative tools to ease the burdens of database development, maintenance and administration.Enterprise Manager is the main administrative console for SQL Server installations. It provides you with a graphical "birds-eye" view of all of the SQL Server installations on your network. You can perform high-level administrative functions that affect one or more servers, schedule common maintenance tasks or create and modify the structure of individual databases. Query Analyzer offers a quick and dirty method for performing queries against any of your SQL Server databases. It's a great way to quickly pull information out of a database in response to a user request, test queries before implementing them in other applications, create/modify stored procedures and execute administrative tasks. SQL Profiler provides a window into the inner workings of your database. You can monitor many different event types and observe database performance in real time. SQL Profiler allows you to capture and replay system "traces" that log various activities. It's a great tool for optimizing databases with performance issues or troubleshooting particular problems. Service Manager is used to control the MSSQLServer (the main SQL Server process), MSDTC (Microsoft Distributed Transaction Coordinator) and SQLServerAgent processes. An icon for this service normally resides in the system tray of machines running SQL Server. You can use Service Manager to start, stop or pause any one of these services. Data Transformation Services (DTS) provide an extremely flexible method for importing and exporting data between a Microsoft SQL Server installation and a large variety of other formats. The most commonly used DTS application is the "Import and Export Data" wizard found in the SQL Server program group. |
Customer Feedback through Yahoo!
| Top Articles |
| Hot Products | » |
| Intel DX58SO LGA 1366 ATX Motherboard BOXDX58SO (E30149-... Only $279.99 | |
| Patriot 64GB Xporter Magnum USB Flash Drive, Ultra-fast ... Only $169.99 | |
| Seagate Barracuda 7200.11 3.5in 1.5TB SATA Hard Drive, ... Only $154.99 | |
| *Free UPS Ground Shipping* Black LG SATA Blu-Ray / HD-DV... Only $139.99 | |
| All-in-1 Compact External USB 2.0 Card Reader/Writer wit... Only $4.99 | |
| Antec EarthWatts 650W ATX12V & EPS12V Computer Power Sup... Only $52.99 |
| Promotions | » |
| Free Generic PS/2 Keyboard with Purchase over $499 , Spa | |
| Free Beige Aron Ergonomic PS/2 Numeric Keypad with Esc, | |
| Free I/O Shield for Some Standard ATX Motherboards for o | |
| Free Inner 5.25" Drive Bay Cover for InWin and Other cas | |