This step-by-step article describes how to implement bidirectional transactional replication. This article also discusses the issues that are involved in implementing bidirectional transactional replication.
Tag: sql server
SQL Server 2005 Part 3 – High Availability and Scalability Enhancements – Failover Clustering
(Marcin Policht) In the previous article of this series, we started reviewing high availability and scalability enhancements in SQL Server 2005 (based on its recent Beta 2 release) by discussing database mirroring. In this article, we will continue exploring the same area of functionality, shifting
Keeping QA Up To Date – Part 2
(Steve Jones) In the first article in this series I looked at the basic process for keeping your QA machine up to date. Here I’ll delve further into the first step in this process, getting the latest backup from your production machine. (R)
Using Performance Monitor To Identify SQL Server Hardware Bottlenecks
(Brad M. McGehee) The best place to start your SQL Server performance audit is to begin with the Performance Monitor (System Monitor). By monitoring a few key counters over a 24 hour period, you should get a pretty good feel for any major hardware bottlenecks your SQL Server is experiencing.
Secrets to Successful SQL Server Programming
(Buck Woody) In this article, I’ll cover what you need to learn to program using SQL Server. Some of the concepts I’ve mentioned before, but in this article I’ll bring them all together, along with the other processes and procedures that you’ll need to understand to create effective programs. You
Managed Stored Procedures and User Defined Functions – Part I
(Darshan Singh) By now you might have heard that SQL Server 2005 hosts the .NET 2.0 runtime. This enables writing stored procedures, functions and triggers using any of the managed languages, such as C# and VB .NET. This article is based on my first experience with SQLCLR integration, where I co
Moving Your Access 2002 Database to SQL Server 2000
(Adam Cogan) Use this features comparison in preparation for migrating your Access 2002 database back end to SQL Server 2000.
The Curse and Blessings of Dynamic SQL
(Erland Sommarskog) If you follow the various newsgroups on Microsoft SQL Server, you often see people asking why they can’t say: SELECT * FROM @tablename SELECT @colname FROM tbl SELECT * FROM tbl WHERE x IN (@list)
Exploring SQL Server 2000 Configuration Properties
(Dale Elizabeth Corey) Did you ever wonder what the heck all those property settings meant in SQL Server 2000’s client tool, Enterprise Manager, and whether or not you really needed to tweak them? What are the key points? It never hurts to review. (R)
How to implement a SQL Server 2000 Desktop Engine callback function and example
This article describes how to implement a callback function during the installation of the SQL Server 2000 Desktop Engine (MSDE 2000) and also discusses all the conditions that must be met to make sure the callback function runs properly.