Uncovering Linked Servers
A little known feature that SQL Server offers is linked servers. Linked servers give the developer the option to use distributed queries and are a vital part of SQL Server's scalability.
2001-05-06
21,326 reads
A little known feature that SQL Server offers is linked servers. Linked servers give the developer the option to use distributed queries and are a vital part of SQL Server's scalability.
2001-05-06
21,326 reads
This article will show you some of the common problems fixed in service pack 3 for SQL Server 7.0 and how to rollback.
2001-05-04
6,100 reads
Need to make changes to table that is an article in a publication? Read this article to get step by step instructions on how to do it without doing a new snapshot!
2001-05-02
8,175 reads
Confused about the difference between using a DSN or DSN-less connection? This article by Andy warren explains the differences and offers some insight into when each is appropriate.
2001-05-02
5,668 reads
In this product review by Brad McGehee, he shows you how Coefficient helps you performance tune your database.
2001-05-02
1,543 reads
2001-05-01
3,265 reads
Did you know that the mean salary of a MCSE certified professional is $65,100, well above the industry standard (source MCP Magazine)? That's not including the long term benefits such as bonuses and promotions. No salary surveys have been conducted by Microsoft as of today for MCDBA certification. With the limited amount of MCDBA certified DBAs though, the demand far by out weighs the suply.
2001-05-01
5,047 reads
This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables.
2001-05-01
2,075 reads
This article shows you the basics of connecting to SQL Server in Active Server Pages.
2001-04-30
8,637 reads
How can you maintain a stable environment? Keeping track of all changes is the time-tested and proven technique. Read about it here.
2001-04-30
5,403 reads
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Dears, I was told that I cannot access delta files in SQL Server Managed...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers