SQL Server MVP Mike Hotek and industry expert Kimberly Tripp launch the latest SQL Server educational offering from PASS - one day seminars beginning this June in Chicago and August in Las Vegas. Join Mike and Kim as they demonstrate their expertise on SQL Server replication and tuning high performance SQL Server 2000 databases. Space is limited. Seminar details and convenient, secure online registration is available at http://www.sqlpass.org/events/seminars.

Press Release - RedGate Announces SQL Server Compare

by Additional Articles

SQLServerCentral.com

Product and Book Reviews

RedGate software has announced their newest product, SQL Server Compare, a new tool for comparing and synchronizing SQL Servers. Read the press release!

Supplement to 'Converting Shaped Recordsets into XML'

by Jon Winer

SQLServerCentral.com

Jon Winer further discusses some comparisons using ADO versus the XML DOM to parse shaped recordsets. This article is a supplement to his previous article titled: Converting Shaped Recordsets into XML.

SQL Server DMO Resources

by Steve Jones

SQLServerCentral.com

SQL-DMO

As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.

Multiple Monitors

by Steve Jones

SQLServerCentral.com

The Lighter Side

Want to get more productive? Fit more work into normal working hours? Steve Jones found a relatively inexpensive hardware upgrade to help you.

Choosing an Edition of SQL Server 2000

by Additional Articles

Microsoft SQL Home

Installation

Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization. This paper will inform you about the differences among the various editions of SQL Server 2000, and how you can save time and money by choosing the right one for the job.

SQL Server DTS Resources

by Steve Jones

SQLServerCentral.com

A list of DTS resources, including bugs, issues, books, and some good programming resources.

Tips for Performance Tuning SQL Server Transactional Replication

by Additional Articles

SQL Server Performance

Replication

From this real-world case study, learn how you can boost SQL Server performance and scalability by off-loading reporting from your production SQL Server to a reporting server, using transactional replication.

Alice in Unix Land

by Steve Jones

SQLServerCentral.com

The Lighter Side

A high-tech version of the classic children's tale.

Review of SQLZip

by Andy Warren

SQLServerCentral.com

Product and Book Reviews

Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider!

Hotek, Tripp Launch PASS Regional Seminars

Press Release - RedGate Announces SQL Server Compare

Supplement to 'Converting Shaped Recordsets into XML'

SQL Server DMO Resources

Multiple Monitors

Choosing an Edition of SQL Server 2000

SQL Server DTS Resources

Tips for Performance Tuning SQL Server Transactional Replication

Alice in Unix Land

Review of SQLZip

Blogs

Upgrading SQL Server Containers on the Laptop

How to Find Expensive Queries in Amazon Redshift

The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech

Forums

SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade

How Long is a Long I/O?

T-SQL Trigonometric Functions in SQL Server

Question of the Day

How Long is a Long I/O?