Links to useful SQL Server related resources: Partner sites: SQL Skills SQL Immersion Events
XPSMTP extensions Db Maint SMTP Alerter SQL Server Agent can be configured to notify an operator when certain error messages has been written to the eventlog by SQL Server. Unfortunately, this is based on MAPI, and installing and getting MAPI to functioning properly for SQL Server and SQL Server Agent can be a mess. We already have a substitute for the MAPI based xp_sendmail: xp_smtp_sendmail from SQLDev.Net. The Db Maint SMTP alerter allow you to be notified using SMTP (using xp_smtp_sendmail) instead of MAPI. This mean that you do not have to install Outlook and configure MAPI on your SQL Server. http://www.dbmaint.com/SmtpAlerter.asp
DTS (Data Transformation Services) SQLDTS.com:
The Data Transformation Services resource on the web. This site is aimed at all DTS users regardless of experience. Hopefully there is something here for everyone.
http://sqldts.com SWYNK: Darren Green
The original DTS resource on the web
http://www.swynk.com/friends/green/ Mosaic Interactive Technologies:
Extending the Microsoft Data Warehousing Framework through meta data conversion tools and DTS Custom Tasks
http://www.mosaicinteractive.com SQLMag.com DTS Topics
SQL Server Magazine, Topic Index for DTS
http://www.sqlmag.com/Articles/Index.cfm?TopicID=783
SQL-DMO MSDN Magazine:
"SQL Server and DMO: Distributed Management Objects Enable Easy Task Automation" by Francesco Balena
http://msdn.microsoft.com/msdnmag/issues/01/05/sqldmo/sqldmo.asp Microsoft Knowledge Base:
SQL-DMO List Available Servers example in VB and VC
http://support.microsoft.com/support/kb/articles/Q287/7/37.ASP Microsoft Knowledge Base:
Q248241 - INF: Enabling SQL DMO Clients Without Installing the Client Side Utilities
http://support.microsoft.com/support/kb/articles/Q248/2/41.ASP DbaMgr: Andrea Montanari
An alternative Administrative Console for Microsoft MSDE 1.0 and MSDE 2000 written in Microsoft Visual Basic 6.0 using SQL-DMO
http://www.asql.biz/DbaMgr.shtm Exploiting MS SQL Server 7 DMO - part 1 + 2
Using SQL-DMO from Delphi
http://www.delphi32.co.yu/preuzeti_tekstovi/exploiting_sql_server_1.htm
http://www.delphi32.co.yu/preuzeti_tekstovi/exploiting_sql_server_2.htm
XP's (Extended Stored Procedures) Microsoft Knowledge Base:
INF: Extended Stored Procedures: What Everyone Should Know (Q190987)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q190987 Microsoft Knowledge Base:
INF: Use of Thread Local Storage in an Ext. Stored Procedure (Q163449)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q163449 Microsoft Knowledge Base:
INF: Moving Extended Stored Procedures Out Of Process (Q243428)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q243428 Microsoft Knowledge Base:
INF: Extended Procedure Error: "Cannot find the DLL 'xxx.dll'" (Q151596)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q151596DevX
Enhance SQL Server with your own Extended Stored Procedures by Igor Livitz
http://www.devx.com/free/mgznarch/vcdj/1998/mar98/sql1.asp Berend de Boer NederWare (Inprise DevCon ‘99)
Download article "Writing MS SQL Server Extended Stored Procedures with Delphi"
Download source "Writing MS SQL Server Extended Stored Procedures with Delphi" MC Programming Libraries (Leonid 'MC' Belousov)
Extended Stored Procedure component for Delphi 5 and 6
Extended Stored Procedure class for Visual C++ 6
SQL Server (general) Professional Association for SQL Server (PASS)
"PASS is the definitive, global community for SQL Server professionals. It is the first independent, user-run, not-for-profit association committed to providing SQL Server professionals around the world with the resources and knowledge necessary to achieve unparalleled business results."
http://www.sqlpass.org/ mssqlserver.com
A large selection of original articles covering topics including high availablity and replication, product reviews, scripts and an excellent tutorial on T-SQL. This site also hosts a copy of Neil Pike's SQL Server FAQ.
http://www.mssqlserver.com/ SQLSecurity.com
A site dedicated to helping you ensure your SQL Server's are secure.
http://www.sqlsecurity.com/ SQLServerCentral.com
Regular columnists with articles covering a wide range of subjects.
http://www.sqlservercentral.com/ SQL-Server-Performance.com
"Your Source for SQL Server Performance Tuning and Optimization Tips"
http://www.sql-server-performance.com SQLTeam.com
An active site with plenty of articles, and the ability to Ask SQL Team your questions.
http://www.sqlteam.com UK Independent SQL Server User Group
Includes fully searchable version of Neil Pike's SQL Server FAQ, original KBase articles and Forums.
http://www.sqlserverfaq.com Umachandar's Technical Resources
An exceptional range of high quality scripts covering all aspects of SQL Server, as well as a selection of other useful resources as well.
http://www.umachandar.com/resources.htm Vyas's SQL Server Home
A selection of articles and code library covering topics as diverse as replication, interview questions, programming guidelines, and federated database servers on SQL Server 2000.
http://vyaskn.tripod.com Microsoft MSDN:
International Features in Microsoft SQL Server 2000
http://msdn.microsoft.com/library/techart/intlfeaturesinsqlserver2000.htm Microsoft Knowledge Base:
Q232580 - INF: Storing UTF-8 Data in SQL Server
http://support.microsoft.com/support/kb/articles/q232/5/80.asp
Data Access (ODBC, OLE-DB, ADO, etc) Microsoft MSDN:
Pooling in the Microsoft Data Access Components
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/pooling2.asp
Misc. Tools Sysinternals
The ultimate source for Windows internals and tools. The Sysinternals web site provides you with advanced utilities, technical information, and source code related to Windows 9x, Windows Me, and Windows NT/2000 internals that you won't find anywhere else.
http://www.sysinternals.com
*** | 
