SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to

SQL 2005 Web Synchronization for Merge Replication

by Additional Articles

SQLServerCentral

Replication

Web synchronization in SQL 2005 enables highly secure synchronization of your merge subscriptions. This feature has been in high demand for many years, and Microsoft has finally delivered. This feature is difficult to deploy, however, so Hilary Cotter provides a tutorial on how to set up this complex feature.

Moving Your Database to a New Server

by Paul Mu

SQLServerCentral.com

Administration

As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.

Compress Binary Messages Using SQL

by Additional Articles

SQLServerCentral

Advanced Querying

Data compression is a great method for maximizing data storage space and making data communication faster. However, compression and decompression of binary data sometimes can be quite tricky. Learn a few useful data-compression techniques.

Unit Testing With Visual Studio

by Grant Fritchey

SQLServerCentral.com

Miscellaneous

Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.

E-Mail Functionality in SQL Server 2005

by Additional Articles

SQLServerCentral

Administration

Sending an e-mail has become very important in any system for purposes such as sending notifications. SQL Server database has an integrated mailing system. With the arrival of SQL Server 2005, users now have the new functionality of Database Mail, which is different from SQL Server 2000 SQL Mail. The purpose of this article is to introduce Database Mail and highlight the advantages of using it over legacy SQL Mail.

A Special Announcement from Andy, Brian, and Steve

by Press Release

SQLServerCentral.com

SQL Server Central

It's been five and a half years since SQLServerCentral.com was founded by Andy, Brian, and Steve. We've greatly enjoyed the time and we're looking forward to many more, but a major announcement today changing the way we will operate in the future.

Making SA Work

by Vasant Raj

SQLServerCentral.com

Security

There are quite a few changes in SQL Server 2005 and many of those relate to security. Did you know the sa account can be disabled by default? Longtime author Raj Vasant brings a basic look at connecting and authenticating in SQL Server 2005.

The Test of Time

by Steve Jones

SQLServerCentral.com

Editorial

A change here at SQLServerCentral.com and Steve Jones gives some thoughts on the impact of this for the future.

Designing relational tables with subtypes

by Additional Articles

SQLServerCentral

Basics

Relational tables often describe more than one type of real world entity. In this tip, Bob Watkins covers some things to think about when designing such tables.

Access to SQL Server: Linking Tables

SQL 2005 Web Synchronization for Merge Replication

Moving Your Database to a New Server

Compress Binary Messages Using SQL

Unit Testing With Visual Studio

E-Mail Functionality in SQL Server 2005

A Special Announcement from Andy, Brian, and Steve

Making SA Work

The Test of Time

Designing relational tables with subtypes

Blogs

A New Word: Gnossienne

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

Learning Tool – Deepstash

Forums

When the Token Meter is Zero

Understanding Temp Tables and Table Variables in SQL Server

The Data API Builder MCP Server Tools

Question of the Day

The Data API Builder MCP Server Tools