This white paper outlines the following:
-The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition.
-The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition.
-A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.
A new T-SQL Bible that is a must have for SQL Server DBAs. Read a review of this book.
At this session, a Microsoft Visual Studio.NET product manager will provide a technical overview of the forthcoming innovations of Visual Studio .NET. January 24, 2002 - 8:00 A.M. to 9:30 A.M. Pacific /11:00 A.M. Eastern
RedGate Software and SQLServerCentral.com will be at the PASS in January giving away an IPAQ. Be the biggest geek in your office! If you can't make it to PASS to see us, enter electronically here.
This sample is provided in conjunction with the MSDN Magazine article, "SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web." This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.
If you are like most DBAs, you have probably implemented some type of hash function for some of your tables at one time or another. This article takes a look behind the scenes as to how the Identity property works.
This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.
The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access.
This white paper is a joint effort by Microsoft and Dell to demonstrate the scalability of SQL Server 2000 and Dell hardware.
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
I spend my days working on and managing SQL Server instances—working days at least,...
Want to learn SQL and get some real practice this December? Check out the...
Hi I am working on a rolling average calculation that is not working quite...
Comments posted to this topic are about the item Subscribing to a Great New...
Hi, is there a way when using excel as a flat file source in...
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers