RawXml for /SQL.xf

This website produced with XsltFilter. The Page.Response buffer output is shown below.

Return to normal view of page  

<? xml-stylesheet type="text/xsl" href="woric.xsl" ?>
<DisplayPage >
<title > SQL </title>
<Content  Heading="SQL" ID="software" CreatedTmSt="19-Sep-2001 23:35:14"> Don't know how many links I can put here - but lets see. Since I'm doing Oracle coding today, I'll start with that and then add more as they come along. Next will probably come Interbase (aka Firebird) and then SQL Server.<br/>
Also - here are some really useful <a href="SQLServer_Scripts.xf"/>SQL Server scripts/</a> I've collected. </Content>
<SiteList  ID="software_sites" title="SQL Server" CreatedTmSt="21-Sep-2001 20:13:46">
<SITE href="http://www.aspfaq.com/show.asp?id=2534" title="Removing DT_xxx stored procedures from Sql Server databases">Excellent article which explain why the annoying dt_xxx procedures are created, and how to remove them.</SITE>
<SITE href="http://www.sql-server-performance.com/optimizing_indexes.asp" title="Tips on Optimizing SQL Server Indexes">Some excellent tips about how to get the best performance from Sql Server Indexes. Essential reading for all developers/DBAs using Sql Server. </SITE>
<SITE href="http://www.joesack.com/index.htm" title="Joseph Sack's SQL Server Publication Site">One guy's personal collection of info about Sql Server. Quite useful.</SITE>
<SITE href="http://www.sql-server-performance.com/optimizing_indexes.asp" title="Tips on Optimizing SQL Server Indexes">Some excellent tips about how to get the best performance from Sql Server Indexes. Essential reading for all developers/DBAs using Sql Server. </SITE>
<SITE href="http://www.sqldts.com" title="SQL Server DTS site">Excellent site with lots of good stuff about DTS packages. Specialised and very helpful if thats what you ned info on.</SITE>
<SITE href="http://www.sqlmonster.com/" title="Sql Monster">Great community site full of Sql tips, tricks and problem solving.</SITE>
<SITE href="http://www.databasejournal.com/features/mssql/article.php/1460131" title="Getting A List of Tables From SQL Server ">It is often helpful to be able to query SQL Server to find out the schema for a certain database, including tables, information about columns in a particular table, the text of a stored procedure and so forth. </SITE>
<SITE href="http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B252987" title="Execute a SQL Server DTS Package from Active Server Pages">Explains how to execute DTS packages from ASP pages</SITE>
<SITE href="http://www.databasejournal.com/scripts/article.php/3376261" title="get Row Count">This script returns the number of rows in each table for a database.</SITE>
<SITE href="http://vyaskn.tripod.com/sql_server_dts_best_practices.htm" title="DTS Best practices">This article list the authors DTS "best practices" list, along with some tips and tricks. </SITE>
<SITE href="http://msdn.microsoft.com/vstudio/downloads/addins/msde/default.asp" title="MSDE (Microsoft Data Engine) for Visual Studio 6.0">According to Microsoft, this is a SQL Server 7.0 compatible data engine for building mobile and shared solutions that easily migrate to SQL Server 7.0. According to everyone else it is SQL Server 7.0, but with a 5 simultaneous connection limit and a licensing agreement that says you can give it away with apps built using Visual Studio.</SITE>
<SITE href="http://www.sqldev.net/" title="SQL Server Developers Network">SQLDev.Net is an initiative of a former member of the Microsoft SQL Server development team - the site has information and coding examples on a varierty of tools/utilities that make life with SQL Server easier.</SITE>
<SiteList  ID="software_sites" title="PostgreSQL" CreatedTmSt="21-Sep-2001 20:13:46">
<SITE href="http://www.ca.postgresql.org/index.html" title="PostgresQL">PostgreSQL is a sophisticated Object-Relational DBMS, supporting almost all SQL constructs, including subselects, transactions, and user-defined types and functions. It is the most advanced open-source database available anywhere.</SITE>
<SITE href="https://github.com/npgsql/npgsql" title="Npgsql">Npgsql is a .Net Data Provider for PostgreSQL - I think that one line says everything you need to know.</SITE>
<SiteList  ID="software_sites" title="Oracle" CreatedTmSt="21-Sep-2001 20:13:46">
<SITE href="http://www.timonions.com/index.html" title="Oracle Scripts">Tim Onions really good list of useful Oracle scripts, including a whole seciton for Reverse Engineering Oracle schemas.</SITE>
<SITE href="http://www.orafaq.com/faqsql.htm" title="Oracle SQL FAQ">A whole page on Oracle SQL and how to use it. Not terribly in depth, but has some very useful bits of code.</SITE>
<SITE href="http://www.uwp.edu/academic/mis/baldwin/oraddl.htm" title="Oracle Data Definition">Just the Oracle Data Definition syntax with a few examples.</SITE>
<SITE href="http://otn.oracle.com/collaboration/content.html" title="Oracle Technology Network">Lots of Oracle stuff (uh, duh)</SITE>
<SITE href="http://www-rohan.sdsu.edu/doc/oracle/server803/A54647_01/ch2.htm#3381" title="Elements of Oracle8 SQL">Contains reference information on the basic elements of Oracle SQL. Heavy going.</SITE>
<SiteList  ID="software_sites" title="Interbase / Firebird" CreatedTmSt="21-Sep-2001 20:13:46">
<SITE href="http://www.mitec.d2.cz/" title="MiTec">Fantastic collection of apps which inlcudes 2 very good Interbase tools. Highly recommended.</SITE>
<SITE href="http://www.ibobjects.com/ibowhatis.html" title="IB Objects">Excellent "trustware" components for Interbase/Firebird with native connectivity. This is probably the best IBX alternative for those without Profesional and Enterprise versions of Delphi.</SITE>
<SITE href="http://firebird.sourceforge.net/" title="Firebird home page">Firebird is a relational database offering many ANSI SQL-92 features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names since 1981</SITE>
<SITE href="http://www.ibphoenix.com/" title="InterBase Phoenix">IBPhoenix is a web site and an organization that provides information and services to InterBase and Firebird developers and users. They have an unparalleled depth and breadth of experience with InterBase and Firebird and provide useful answers to questions about either product.</SITE>
<SITE href="http://www.ibphoenix.com/ibp_blobs.html" title="Interbase Blobs">InterBase and Blobs - A Technical Overview By Paul Beach</SITE>
<SITE href="http://www.ibcollection.com/TOC.html" title="The InterBase Collection">This collection focuses on InterBase 6.0 and above and related software. It is the best list of resources for Interbase/Firebird I've found outside of the IB Pheonix site. Highly recommended.</SITE>
<SITE href="http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm" title="Comparison between BLOB, CHAR and VARCHAR features and performance.">Very in depth and reasonably unbiased comparison between BLOBs and VarChars on IB/Firebird. Recommended reading for anyone doing large database application with IB/Firebird and considering storing large amounts of data in any column.</SITE>
<SITE href="http://www.mers.com/IBSTATS.HTML" title="The Interpretation of InterBase Database Statistics">The interpretation of GSTAT statistics is somewhat of a mystery, however, on the Interbase List Server there was a excellent piece written by Ann Harrison of Harbor Software (One of the original authors of Interbase) on the subject. This version of the article is hosted by Mer Systems.</SITE>
<SITE href="http://bdn.borland.com/all/0,1435,n%7C10050%7C10%7C41,00.html" title="Borlands Interbase knowledgebase ">I dont know if this is officially a knowledge base, but it sure looks one to me. Lots of in-depth technical articles about Interbase.</SITE>
<SITE href="http://delphi.weblogs.com/" title="Delphi / InterBase WebLog">News of interest to Delphi and InterBase developers, and the home of the excellent InterBase PLANalyzer. Essential site for all Interbase users. (and it has some good Delphi stuff as well)</SITE>
<SITE href="http://www.fingerbird.de/main.htm" title="FingerBird">The firebird developers site - I am confused.</SITE>
<SITE href="http://www.ibprovider.com/eng/index.html" title="IBProvider">Commercial OleDB drivers for Firebird/Interbase.</SITE>
<SiteList  ID="software_sites" title="Others" CreatedTmSt="21-Sep-2001 20:13:46">
<SITE href="http://www.databasejournal.com/" title="Database Journal">A site for database professionals with very good articles on the major database,</SITE>