September 2005

  • full-text database

    A full-text database is a compilation of documents or other information in the form of a database in which the complete text of each referenced document is available for online viewing, printing, o...

  • Importing Oracle database tables

    Data migration and interoperability between SQL Server and Oracle can be tricky. Expert Kevin Kline discusses what to be mindful of when importing data.

  • Renaming SQL Server

    Having to rename SQL Server is a common dilemma DBAs face. Monitoring and Administration expert Kevin Kline offers a resource to help.

  • Undocumented SQL Server stored procedures

    T-SQL commands should not be used to manipulate the file system for security reasons, but some undocumented SQL Server stored procedures can help you work with directories, files and drives.

  • Benefits of upgrading to SQL Server 2005

    SQL Server 2005 expert Adam Machanic discusses the benefits of upgrading to SQL Server 2005.

  • SQL Server 2000 Query Analyzer: 10 tricks for simple querying

    Many improvements can be made to the raw performance of your SQL Server statements, as well as to your job performance as a DBA or developer, by simply using SQL Server 2000's Query Analyzer -- a t...

  • Change privilege levels for SQL Server 2000 services

    SQL Server 2000 users are able to access operating system features in the context of the accounts where the server process runs -- making the database vulnerable to attackers looking to play admini...

  • IIS error when installing SQL Server 2000 on XP

    Troubleshoot problems installing SQL Server 2000 on Windows XP with help from Monitoring and Administration expert Kevin Kline.

  • Index types in SQL Server 2005

    While SQL Server 2005 does not introduce any new index types, it does include indexing enhancements. SQL Server 2005 expert Adam Machanic discusses these enhancements in this tip.

  • Row versioning with SNAPSHOT isolation level

    Using "dirty" reads is a thing of the past. SQL Server 2005 expert Adam Machanic discusses SQL Server 2005's new snapshot feature.

  • Granting permissions in SQL Server 2005

    New security features in SQL Server 2005 make it easier to manage and grant permissions on a more granular basis. Learn more from site expert Adam Machanic here.

  • Compare load balancing options for SQL Server 2000

    If you have more than several hundred concurrent users, you should balance the load among multiple database servers. Contributor Baya Pavliashvili outlines your five load-balancing options for SQL ...

  • data preprocessing

    Data preprocessing describes any type of processing performed on raw data to prepare it for another processing procedure.

  • Versioned Object Base (VOB)

    A Versioned Object Base (VOB) is a centralized database that stores version information about the files and folders in a software configuration management (SCM) system.

  • record standardization

    In data management, record standardization is a process in which files are first parsed (assigned to appropriate fields in a database record) and then translated to a common format.

  • normalization

    In creating a database, normalization is the process of organizing it into tables in such a way that the results of using the database are always unambiguous and as intended.

  • database management system (DBMS)

    A database management system (DBMS), sometimes just called a database manager, is a program that lets one or more computer users create and access data in a database.

  • T-SQL (Transact-SQL)

    T-SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error...

  • library

    In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, ...

  • transcription error

    A transcription error is a specific type of data entry error that is commonly made by human operators or by optical character recognition (OCR) programs.