Home > Articles > Data > SQL Server

SQL Server

179 Items

Sort by Date | Title

SQL Server 2000 and the XDR Schema
Sep 21, 2001
Schemas, Microsoft's version of XML schemas, create XML views of relational data which can then be queried via XPath expressions. This article looks at XDR Schemas and how they work with SQL Server 2000.
Alison's SQL Server 2000 Tips
Aug 6, 2001
Alison Balter provides tips on returning multiple records sets and executing the "first and last after trigger" in SQL Server 2000.
Alison's SQL Server 2000 Tricks
Aug 6, 2001
Learn a few SQL Server 2000 tricks from expert Alison Balter.
Benefits of Using SQL Server Stored Procedures with Visual Basic and Web Applications
Aug 6, 2001
Alison Balter highlights the benefits of using SQL Server stored procedures with Visual Basic and Web Applications stored procedures.
What's New in SQL Server 2000
Aug 6, 2001
Expert Alison Balter highlights SQL Server 2000’s notable new features.
Server and Client Configuration and Troubleshooting
Jun 22, 2001
This sample chapter covers SQL Server 7's startup, some of its configuration options, and its interaction with NT. Also discussed is server troubleshooting and client setup and configuration. Finally, this chapter shows you a few SQL Server tricks.
Linked Servers: Configuration and Application
Jun 1, 2001
Database expert Sean Geiger explains how to use linked servers to share data between multiple data sources.
InformIT Visual Tutorial 1: The Big Picture
Jun 1, 2001
In this article, Nick and Nancy V. Flor explain how HTML forms, databases, SQL, and Active Server Pages work together in interactive applications.
SQL Server Search Configuration
Jun 1, 2001
Using the Microsoft Search service with SQL Server, part 1: Improving your database's search capabilities.
Using Full-Text Search Catalogs
Jun 1, 2001
Using the Microsoft Search service with SQL Server, part 2: Working with full-text catalogs.
Creating Custom Functions in SQL Server 2000
May 11, 2001
In previous versions of SQL Server, functions were defined by system developers and couldn't be modified. Now in SQL Server 2000, developers can create custom functions that return any type of value. Learn here how to create and use these functions.
The Evolution of SQL Server
Feb 15, 2001
Learn the history of SQL Server as well as what's new in Version 2000.
Making Virtual Spies—Creating Spy Net in SQL Server 2000
Jan 10, 2001
In this sample chapter from SQL Server 2000 Database Development From Scratch, learn how to create the SQL Spy Net application database and application tables, discuss important database concepts such as normalization and integrity, and draw an entity ...
Creating and Optimizing Views in SQL Server
Dec 13, 2000
In this chapter from Microsoft® Access Developer's Guide to SQL Server, learn how to define, create, and modify views, and how to perform index analysis and optimize performance in SQL Server.
DTS and the Flow of Data Through the Enterprise
Dec 12, 2000
This chapter from Microsoft® SQL Server™ 2000 Data Transformation Services examines the flow of data through an organization, and presents DTS as a powerful and flexible tool for meeting such data transformation needs.
Adding a User to a Database
Nov 6, 2000
Everything you do in SQL Server is authenticated, including creation of the databases and files. Understanding SQL Server security is critical to the successful operation of your SQL Server.
Backup Considerations
Nov 6, 2000
Perhaps the most important but least glamorous aspect of supporting a relational database is backup and recovery. No matter how much work you do to make your database secure and your data available, data protection is the most critical aspect of your ...
Creating a Database in SQL Server 2000
Nov 6, 2000
When you create a new database, you are really just making a copy of the model database. Remember that everything in the model database, including any database options that you may have set, will show up in any new databases you create. After you create ...
Statement Permissions
Nov 6, 2000
Statement permissions allow a database user, database role, or Windows user or group to perform various tasks such as creating databases, creating objects, or backing up the database. Statement permissions allow a user to run a particular command (or ...

<< < Prev Page 5 6 7 8 9