microsoft.public.sqlserver.server newsgroup
SQL Server 2000 Operations Guide
Learn SQL Tutorial SQL tutorial featuring comprehensive guide to SQL language concepts and SQL commands
Using sets in SQL Server
Microsoft SQL Server 2000 Resource Kit (With CD-ROM), at Amazon UK for £41.56 or Amazon USA for $55.99
Programming SQL Server 2000 with XML, at Amazon UK
developer.com
Experts Exchange
Experts Exchange
SQL Server 2000 Useful undocumented stored procedures
Download SQL Server 2000 Service Pack 1
Data Mining in SQL Server 2000
What's New in T-SQL
A Survey of Microsoft SQL Server 2000 XML Features
Download SQL Server 2000 Service Pack 1
SQL Server 2000 Operations Guide
Exposing SQL Server Data to the Web with XML
DevArticles
Today Skills
HelpToFind
All About Passwords
Linking SQL Server to Heterogeneous Systems e.g. share data with Oracle
Make ADO Work Faster Using Output Parameters in Your Stored Procedures
SQL Server Home Page
SQL Server Books
Java2s
SQL Server Documentation
Querying SQL Server System Catalogs
SQL Server Service Pack 2
SQL Server info on MSDN
ODBC and SQL Server
Choosing from 7 different editions of SQL Server 2000 (.zip file)
SQL Server 2000 Product Guide (.zip file)
How to connect to SQL Server from Enterprise Manager (at home or in the lab)
How to connect to SQL Server from a Java application (at home or in the lab) (.zip file)
SQL Server Transact-SQL syntax (SQL Syntax for SQL Server 2000)
SQL Server syntax for CREATE PROCEDURE and CREATE TRIGGER (.zip file)
SQL Server syntax for DEFAULTS, CONSTRAINTS, and RULES (.zip file)
Dezign database development tool from DataNamic
Manifold Database Commander
Introduction to Transact SQL User-Defined Functions
Retrieving Dynamic XML from SQL Server 7.0 and 2000
AddCriteria Simplifies SQL Queries where optional criteria are posted by the user
The Truth About VarChar
SQL Server administration best practices
SQL Server Resources
Accessing SQL Server from C#
Overview of SQL Server security model and security best practices
Overview of the SQL Server Security Model and Security Best Practices
SQL Server Performance
Use the Correct ASP (ADO) Syntax to Enable Connection Pooling for Best SQL Server Performance
Eliminate the Use of Temporary Tables For HUGE Performance Gains
Using XML To Supercharge SQL-Based Website Performance
Paging certain # of records using Stored Procedure, Command Object and MS-SQL Server
SQL Server 2000 Undocumented Stored Procedures
The Self-Taught DBA
Use OPENXML to Minimize SQL Server Database Calls and boost ASP performance
Performance Tuning ASP Pages Using SQL Server
Transact-SQL SQL Server Performance Tuning Tips
Tips for Performance Tuning SQL Server Replication
Microsoft adds Java support to SQL Server - 25/09/01 rebranding Merant's Java Database Connectivity (JDBC) driver as their own
How SQL Compare Makes You a More Productive DBA
NULL is NULL
Top ADO Tips
Top SQL/XML Integration Features
SQL Server 2000 Datatypes
RDBMS Performance Tuning Guide for Data Warehousing
SQL Server 2000 operations guide
Moving SQL Server Databases to a New Location
SQLXML 2.0 (XML for SQL Server 2000)
Download SQL Server SP2
List of Bugs Fixed by SQL Server 2000 Service Packs (Q306908)
How to Obtain the Latest SQL Server 2000 Service Pack (Q290211)
Readme.txt Files for SQL Server 2000 Service Packs (Q300516)
Swynk
Database Creation Basics
Download the SQL Server Web Services Toolkit from Microsoft
Download the Updated SQL Server 2000 Books Online from Microsoft
CuteSQL a very useful tool for all who work with more than one database system. Allows you to execute SQL commands and queries against any database
DTS Programming Techniques Used in Microsoft SQL Server Accelerator for Business Intelligence
EXEC sp_configure 'cursor threshold', 0
Microsoft SQL Server 2000 offers a performance optimization of populating large keyset-driven or static cursors asynchronously by setting the cursor threshold to 0. This allows rows to be returned while the cursor continues to retrieve data.
Articles by Marcin Policht
MDX at First Glance: Introduction to SQL Server MDX Essentials - 06/11/02
Automating SQL Server Management with WMI (Part 1) - 19/11/02 Windows Management Instrumentation is becoming one of the prevalent management technologies in Windows environments
Automating SQL Server Management with WMI (Part 2) - 26/11/02 methods dealing mostly with SQL Server and database maintenance
Automating SQL Server Management with WMI (Part 3) - 19/12/02 sample code for performing SQL database backup and restore
Automating SQL Server Management with WMI (part 4) - 14/01/03 truncating the database transaction logs, updating statistics, rebuilding indexes on database tables
Automating SQL Server Management with WMI (part 5) - 31/01/03 rebuilding indexes and updating statistics on the table level
Scalability and high availability of Microsoft SQL Server 2000 (Part 1) - 13/02/03 clustering
Scalability and High Availability of Microsoft SQL Server 2000 (Part 2) - 27/02/03 installing clustered SQL Server 2000
Scalability and High Availability of Microsoft SQL Server 2000 (Part 3) - 11/03/03 Distributed Partitioned Views are based on horizontal partitioning of the data
Scalability and High Availability of Microsoft SQL Server 2000 (Part 4) - 27/03/03 As far as high availabilty is concerned, log shipping is inferior to clustering, but it can run on dissimilar hardware and be located in separate geographical locations
SQL Server 2000 Active Directory Integration - 08/04/03
XML and SQL 2000 (Part 1) - 25/04/03 Retrieving data as XML document using FOR XML clause of the SELECT statement
XML and SQL 2000 (Part 2) - 13/05/03 Inserting XML formatted data into SQL databases using the OpenXML function
XML and SQL 2000 (Part 3) - 23/05/03 Executing T-SQL statements against SQL Server 2000 via HTTP by using the SQLXML component SQLISAPI.DLL
XML and SQL 2000 (Part 4) - 10/06/03 Configuration options available when using IIS Virtual Directory Management for SQL Server
XML and SQL 2000 (Part 5) - 27/06/03 Accessing SQL Server data in the XML format via HTTP
XML and SQL 2000 (Part 6) - 07/07/03 Allow XPath
XML and SQL 2000 (Part 7) - 25/07/03 Allow POST
XML and SQL 2000 (Part 8) - 12/08/03 XML-based bulk loading
XML and SQL 2000 (Part 9) - 22/08/03 Using DiffGrams for XML data modifications
XML and SQL 2000 (Part 10) - 09/09/03 SQLISAPI and XML Client-Side Processing
XML and SQL 2000 (Part 11) - 26/09/03 SQL 2000 and Web Services
SQL Server 2000 DTS Part 1 - 14/10/03
SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards - 24/10/03
SQL Server 2000 DTS Part 3 - DTS Designer Connections - 11/11/03
SQL Server 2000 DTS Part 4 - DTS Designer Tasks - 26/11/03
SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables - 09/12/03
SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow - 29/12/03
SQL Server 2000 DTS Part 7 - DTS Designer Tasks: the ActiveX Script task - 13/01/04
SQL Server 2000 DTS Part 8 - DTS Designer Tasks - Transform Data Task - 23/01/04
SQL Server 2000 DTS Part 9 - DTS Designer Tasks - 10/02/04
SQL Server 2000 DTS Part 10 - DTS Designer Tasks - The Data Driven Query Task - 27/02/04
SQL Server 2000 DTS Part 11 - DTS Designer Tasks - the Message Queue task - 09/03/04
SQL Server 2000 DTS Part 12 - Transactional Support - 26/03/04
SQL Server 2000 Security - Part 1 (Net Libraries) - 13/04/04
SQL Server 2000 Security - Part 2 (Authentication) - 23/04/04
SQL Server 2000 Security - Part 3 (Service Accounts) - 11/05/04
SQL Server 2000 Security - Part 4 (Authorization) - 28/05/04
SQL Server 2000 Security - Part 5 (Application roles) - 08/06/04
SQL Server 2000 Security - Part 6 - Ownership and Object Permissions - 25/06/04
SQL Server 2000 Security - Part 7 - Statement and Object Permissions - 13/07/04
SQL Server 2000 Security - Part 8 - Introduction to Replication Security - 23/07/04
SQL Server 2000 Security - Part 9 - Replication Security - 10/08/04
SQL Server 2000 Security - Part 10 - Auditing - 27/08/04
SQL Server 2000 Security - Part 11 - DTS Security - 14/09/04
SQL Server 2000 Security - Part 12 - Auditing with Meta Data Services - 24/09/04
SQL Server 2000 Security - Part 13 - SQL Injection attack - 08/10/04
SQL Server 2000 Security - Part 14 - Conclusion - Pre- and Post- Installation Recommendations - 25/10/04
Index Tuning Wizard - 29/07/05
How to Consolidate Physical Files and Rename the Logical File Name of a Database in SQL Server 2000
Error Message "HTTP Error 404 - File or directory not found" Occurs When You Access SQL Server 2000 with HTTP
SQL Server Does Not Start and an Access Violation Occurs After You Install SQL Server 2000 Service Pack 3
Installation of a Named Instance of SQL Server 2000 Virtual Server on a Windows 2003-Based Cluster Fails
SQL Server 2000 Tips and Tricks Center
HOW TO: Configure Memory for More Than 2 GB in SQL Server
UK SQL Server User Group SSUG
Professional Association for SQL Server PASS
SQLDTS.com Data Transformation Services on the web
Microsoft SQL Server 2000 SP3 Security Features and Best Practices
SQL Server 2000 Service Pack 3a Readme.htm Additions
How to Pass a List/Array to a Stored Procedure in SQL Server no arrays in SQL Server!!!
Migrating from Oracle to SQL Server
HOW TO: Dynamically Number Rows in a Select Statement
BUG: WMI MSSQL_Table.ExportData Always Uses Standard Security
Windows Server 2003 Support for SQL Server 2000
Frequently Asked Questions - SQL Server 2000 - Setup
Finding All Columns
SQL USA
PSS Service Center Labs - 2004 these free labs can be used for self-paced troubleshooting training on SQL Server 2000
dbazine.com">dbazine.com
Professional Association for SQL Server Membership costs $150
SQL Standards
SQL Server Magazine
What's New in Yukon T-SQL
Introducing Microsoft Visual Studio Tools for the Microsoft Office System Includes SQL Server 2000 Developer Edition
Coordinate Your DTS Tasks, Part I: "After the Fact" Data Updates
Oracle Has SQL Server Beat in Stored Procedure Programming
Migrating from SQL Server to Oracle
SQL Server 2000 for Experienced DBAs, at Amazon USA
Virtual DBA Remote monitoring, admin & support. Tailor service to budget and need
buyerzone.com Find Database Experts. Free quotes on design and dev. Save when you compare experts
sswug.org SQL Server Worldwide User Group - Free Help: How-to's, news, tips, reviews, scripts, newsletter, discussions
Start to Finish Guide to SQL Server Performance Monitoring, at Amazon USA PDF Download
The SQL 2000 Book, at Amazon UK
SQL-Server-Performace.com
ASP / SQL
SQL Compare Compare and Synchronize SQL Database Structures - Version 3 released October 15th 2003
SQLServerFAQ home of the UK SQL Server User Community
Quest Surf the Pipelines
SQL Server Web Data Administrator Microsoft download
Red Gate comparison utilities
WebSQL from SQL Care Manage Your SQL Server Remotely via the Web with WebSQL
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) the free, redistributable version of SQL Server
Writing Secure Transact-SQL
SQL Server Developer Center
Introduction to SQL Profiler
Understanding and Troubleshooting the Copy Database Wizard in SQL Server 2000
Arrays and Lists in SQL Server
Full Text Search on SQL 2000 Part 3
Sandline Learning Affordable Online Computer Courses
Date Parameters in SQL Server - 06/06/05
FREETEXT Searches with SQL Server and ADO.NET
Understanding How the Transact-SQL KILL Command Works
Everything you wanted to know about Stored Procedures
ADO Connection Strings
SQL Server articles
SQL Tuning Tutorial - Understanding a Database Execution Plan (1)
Beginners guide to accessing SQL Server through C#
Professional Association for SQL Server
The Power of SQL CASE Statements
How to search all columns of all tables in a database for a keyword
How to search and replace SQL Server data in all columns of all tables, in a given database
Handling Errors in Stored Procedures
How NOT to trap errors in a stored procedure
Handling Custom Errors in a Client Application
Working with SQL Server Date/Time Variables - 16/04/03
Working with SQL Server Date/Time Variables: Part Two - Displaying Dates and Times in Different Formats - 07/05/03
Working with SQL Server Date/Time Variables: Part Three - Searching for Particular Date Values and Ranges - 21/05/03
How to get a list of SQL Server tables and their row counts
Enumerate all the indexes in a SQL Server database - 12/05/05
The ARRAY In SQL Server 2000 - 16/05/05
SQL Server DO's and DON'Ts
Table Variables In T-SQL - 20/03/05
SQL Server interview questions
CAST and CONVERT (T-SQL)
decimal and numeric (T-SQL)
Dynamic XQuery Expressions
Data Type Performance Tuning Tips for Microsoft SQL Server
Using ADO.NET with SQL Server
Choosing SQL Server 2000 Data Types SQL Server 2000 ships with 27 built-in (system) data types
Understanding Identity Columns smallint goes up to 32,767
Hide System Tables and Objects in MS SQL Enterprise Manager
Identity and Primary Keys "there are some very good reasons NOT to use an Identity column for the primary key on your tables" - all the comments that followed shot this fellow down in flames, so don't bother avoiding identities
Creating an Identity Column
Date and Time
Indentation Tool
Getting Creative with EXEC and EXEC()
Use the quoted identifier setting with single and double quotes
ALTER TABLE how to ADD a column to an existing table
Finding the biggest tables in a database BigTable.sql
Cursors with SQL 2000 Part 1
T-SQL: Cursor Example
DATEDIFF
SQL Quiz Test and improve your SQL and database knowledge for free
How to Find a SQL Server Database Object
How stored procedures work inc searching for source code
Use Sysobjects in SQL Server to Find Useful Database Information
Determining SQL 2005 System Object Types
REPLACE() is the SQL equivalent of StrTran()
Overview of the SQL Server Security Model and Security Best Practices
Using BLOBs text, ntext, image
Choosing SQL Server 2000 Data Types
Returning the Length of an Text or nText Field use Datalength() for Text and Datalength()/2 for nText
SQL Team
Cursors: An Overview
Full Text Search on SQL 2000 Part 1
Full Text Search on SQL 2000 Part 2
Understanding SQL Server Full-Text Indexing
SQL Server Full Text Search Optimization
SQL Server 2000 Full-Text Search Deployment white paper
Search and Replace in a TEXT column
search the code of stored procedures, triggers or user defined functions
PRB: A Full-Text Search Query on TEXT or NTEXT Column Does Not Return Valid Results
Articles at aspfaq.com
