Version Control for Stored Procedures

• by Andy Warren

• SQLServerCentral.com

• Administration

Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.

Get Your Free DTS Poster

• by Additional Articles

• SQLServerCentral.com

• News
• Uncategorized

SQLServerCentral.com has crossed 40,000 users! Thanks for all of you telling your friends about our site and making us a strong SQL Server community. To thank you, you can request to receive a free DTS object model poster that we worked on in conjuction with Lumigent. To sign up to get your hard copy, go to http://www.lumigent.com/go/sqlcentral05

Instructions for Changing Your Oil

• by Steve Jones

• SQLServerCentral.com

• The Lighter Side

I saw this at a local Auto shop and thought you'd like it.

Multi-Server Administration

• by Robert Marda

• SQLServerCentral.com

• Administration

Multi server administration allows you to create jobs and maintenance plans once. You can then monitor and change them from one SQL Server. View job histories and statuses for 2, 4, 10, or more SQL Servers from one master SQL Server. See how you can simplify your administration duties with multi server administration.

RAC's Site has Moved

• by Additional Articles

• ASPToday

RAC's domain name has changed to rac4sql.net. Read their sad fight with their hosting provider here.

Review of SQL Server 2000 Performance Tuning

• by Andy Warren

• SQLServerCentral.com

• Performance Tuning

This book from Microsoft Press has a lot of good information that will help you do capacity planning and performance tuning. Is it worth buying though? Andy just finishing reading it and writing the review, see what he thinks!

A Viable IIS Alternative? Apache 2.0 on Windows 2000

• by Additional Articles

• Swynk

• System Development Life Cycle

Brief introduction to Apache v2.0 with links to performance/setup and installation and other information.

Making Dynamic Queries Static

• by Leon Platt

• SQLServerCentral.com

• Performance Tuning

Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!

Hotek, Tripp Launch PASS Regional Seminars

• by Additional Articles

• Other

• News
• Uncategorized

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!