Links  

Home
What's New
DTS
SQL-DMO
SQL-NS
XP's
SQL Agent
Misc. Tools
Events
FAQ
Links
About...

 

Links to useful SQL Server related resources:

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;q151596

DevX
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


***

Questions or problems regarding this web site should be directed to webmaster@sqldev.net.
Copyright © 1991-2003 SQLDev.Net. All rights reserved.
Last modified: 07/06/03.