SQL Server 2000 Undocumented System Tables
Alexander Chigriks decodes some SQL Server 2000 Undocumented System Tables.
Where should I save my DTS packages?
One of the common questions you see in the newsgroups is where should you save your DTS packages. This article covers the most optimal way to save your packages as well as version controlling DTS.
SQL Server 2000 Replication Chat Hosted by PASS Today
SQL Server 2000 has better replication capabilities than ever before! Do you have questions about using Replication on SQL Server? Whether it be transactional or merge replication, you can not find a better group of guys to answer your questions. Right from the development team, Matt Hollingsworth and Dean Kalanquin, replication program manager and test lead respectively are setting aside this time to take on your most challenging replication questions!
ASP - Reaping the benefits of SQL 2000's FOR XML clause.
In the several years that I have been programming ASP pages, I have seen countless methods of dynamically filling HTML drop down list boxes. Well, here's another method. This one uses sql 2000's new FOR XML EXPLICIT clause, and I really like the results.
Point-Counterpoint - Why you Should be Certified.
In this view, Steve thinks that certifications are invaluable (especially in this economy).
Point-Counterpoint - Why You Should NOT Certity.
Andy Warren thinks certifications are worthless. That's opinion came after he obtained his MCDBA and MCSE certification. Find out why he thinks you should not be certified in this debate with Steve Jones.
Point-Counterpoint - Certification Debate
A new series on SQL Server Central - Two of our regular columnists take opposing looks at certification. In our first of the series, Steve Jones takes on Andy Warren in a certification debate.
THE PROGRAMMER'S QUICK GUIDE TO THE LANGUAGES
A brief description of some well known, and not so well known programming languages. Have you worked with any of these?
Blogs
A New Word: Lilo
By Steve Jones
lilo– n. a friendship that can lie dormant for years only to pick right...
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Forums
dont want pkg to abort if someone is in excel source document
Hi, is there a way when using excel as a flat file source in...
Database Archive missing FK
Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger...
SQL Server 2005 service fails to start
Hello, I’ve been trying to install Ms SQL Server 2005 for over two weeks...
Question of the Day
The Funny Dynamic SQL
What happens when I run this code:
EXEC sp_executesql N'PRINT 1; GO';See possible answers