Additional Articles

New Product - Equivalent Script

At Last! No need to convert SQL Scripts from one dialect to another. Although SQL is a simple language, it can be tedious, inaccurate and frustrating when developing equivalent SQL scripts for multiple database servers. This product handles the conversion for you. (Not Reviewed)

2003-07-15

804 reads

SQL Bible

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. (Not Reviewed)

2003-07-11

947 reads

Microsoft SQL Server 2000 Weekend Crash Course

The big day is Monday. The day you get to show off what you know about SQL Server 2000. The problem is, you're not really up to speed. Maybe it's been a while since you worked with SQL Server. Or maybe you just like a challenge. Open the book Friday evening and by Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to get right to work on a SQL Server 2000 databases.(Not Reviewed)

2003-07-04

793 reads

SQL Server DTS Best Practices

This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.

2003-06-24

4,068 reads

Free BCP GUI

Pedro Estrada has published a free tool that according to his site "This is a complete application to have an easier interface to work with BCP against MSSQL servers. Just specify a server, database, table user name and password to BCP out or IN." Worth a try, and he has some other free utilities (some SQL, some not) on the site.

2003-06-19

1,922 reads

Blogs

Creating a SQL Clone Agent and a First Image

By

In a previous post, I set up the SQL Clone server. This is really...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Availability Group issues fixed with Alerts

By

Learn how to use the SQL Server Agent Alerting system to capture Availability Group...

Read the latest Blogs

Forums

Why aren't the backups working?

By Rod at work

You've heard of "the accidental DBA", right? Well, I'm the accidental TFS admin. I...

Cannot insert duplicate key in object

By adonetok

In table tUSERI primary key was added in the column [Email]. I deleted a...

Random excessive CPU consumption

By DataGuy

Hi all. I'm in a bit of a quandary with one of our Analysis...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers