|
SQL Server Technology Center |
|
|
|
Using or researching Microsoft SQL Server? This is a clearinghouse of resources to help you deploy, maintain, and support SQL Server.
Please contact us with comments and suggestions.
|
Highlights |
|
Join a Discussion with Other IT Professionals about SQL Server
These discussion groups are frequented by TechNet’s Certified Answer Team who may answer many of the questions found there. Before joining in, be sure to check our privacy statement.
Tables: Inside SQL Server 7.0
In this chapter, we'll look at some in-depth implementation examples. But let's start with a basic introduction to tables.
Optimizing Query
Guidelines for you to keep in mind, along with some pointers that refer back to helpful materials.
Get Ready for Windows 2000
Learn about the benefits Microsoft Windows 2000 Server can offer BackOffice Server 4.5 customers and find information on how to upgrade successfully.
TechNet Presents: BackOffice Server 4.5 Training and Deployment Tour
Through a series of live discussions, demos, and videos, Microsoft BackOffice Product Managers will give you step-by-step information on how to deploy Microsoft BackOffice Server 4.5, how to optimize it to meet your specific needs, and how to leverage it as a platform to build solutions enabling your organization to operate more effectively.
Administration Manual for Microsoft SQL Server 7
This chapter is an excerpt from a prototype SQL Server 7.0 Administration Manual for database Administrators. You can provide the author with feedback on this project.
SQL Server Clustering
This article from SQL Server Magazine describes installation, integration, and 13 clustering gotchas.
Leveraging the Microsoft Repository in Your Data Warehouse
This paper is based on a presentation given by Patrick Cross and Saeed Rahimi at the COMPASS '99 conference.
Creating Databases
Chapter 3 from Microsoft SQL Server 7.0 Database Implementation Training Kit covers database design, how SQL Server 7.0 stores data, and how to implement databases and manage database files, transaction log files, and filegroups.
Planning and Creating Indexes
This chapter describes how SQL Server 7.0 indexes work and how to create and use appropriate indexes on your tables.
Advanced Query Techniques
This chapter describes using subqueries, cursors, and modifying data.
Using Data Connections with SQL Server and Visual InterDev 6.0
This article focuses on how to use development tools with SQL Server to create Web applications.
Database Management Through Stored Procedures
There are many benefits to using the stored procedures included in SQL Server 7.0.
SQL Server User Group Conference, Sept 29 - October 2
COMPASS99 will have over 75 sessions dedicated solely to SQL Server. This conference is hosted by the newly formed Professional Association for SQL Server (PASS). $100 discount off Web registrations by August 31, 1999.
Flash DBMS Performance and SQL Server 7.0
Today, fast access to information no longer provides a competitive advantage: it is now a critical success factor.
Configuring Proxy Server for SQL Server 7.0 Replication over the Internet
By combining SQL Server with Microsoft Proxy Server, you can replicate data over the Internet without compromising the security of your database.
Distributed Queries for SQL Server 7.0: OLE DB Connectivity
How the Microsoft SQL Server version 7.0 query processor interacts with an OLE DB provider to enable distributed and heterogeneous queries.
Security in Microsoft SQL Server 7.0
Microsoft Windows NT security has been completely integrated into the core of SQL Server 7.0.
| |
Web Survey:
Tell us what you think of Windows 2000!
|
Features
Questions or Comments?