Mike Beaver's Tech Support Page 3

Interesting and Useful A - F F - K L - P P - Y Questions Articles and Find a Hypnotist SQL Access SQL
Dates and Times in Access Microsoft Access Misc. Tips DevGuru Jet SQL Quick Reference	Access query language elements Access date formats String Manipulation Functions in Access Access SQL
Books Online
SQL Server 2000 Books Online	Getting Started with SQL Server Books Online
Columns
Joe Celko's columns at DBMS magazine	about SQL John Paul Ashenfelter's columns
Data Modeling
The Importance of Data Modeling	Data Modeling
Data Warehousing
Data Warehousing (Microsoft defines 6 of its major components) Data Warehousing and Online Analytical Processing (OLAP and OLTP are defined) English Query Meta Data Services Fundamentals	Data Transformation Services (DTS) in Microsoft SQL Server 2000 The Data Warehousing Information Center has an introductory page Getting Started with Data Warehousing. Microsoft SQL Server 2000 Analysis Services Operations Guide
FAQs
SQL FAQ Oracle SQL FAQ Part of the large Oracle FAQ site ANSI SQL FAQ - Tek-Tips	MySQL FAQ SQL FAQ.doc
Forums & Discussions
The Case for the Surrogate Key Tek-Tips ANSI SQL forum	Top 3 records query for any database The Case for the Surrogate Key Discussion on the SQLTeam.com forum Immerse yourself in SQL Server - is a Q&A session between administrators and major experts.
IBM
SQL Reference	IBM Red Brick Warehouse 6.3
Magazines, Journals & Major Pages
SQL Server Performance SQL Server Professional SQL Server Magazine Database Journal SQL Server Central SQL Team has articles on Database Design.	Data Warehouse SQL Monster SQL Skills Windows IT Pro / SQLServer SQL Dev SQL Skills
Microsoft
SQL Server 2000 Resource Kit MS's Main SQL Server Page MS's Main MSDN SQL Server Page	MS's SQL Server Developer Center SQL Server 7.0 Resource Guide Microsoft SQL Server 2000
MySQL
MySQL - the latest information about MySQL is available on the web here PostgreSQL vs. MySQL dev.mysql.com	Reference Manual Error Codes & Handling
Oracle
Differences Between Oracle and MS SQL Server	Report Subtotals and Totals Using Select ROLLUP in Oracle Performing Top-N Queries in Oracle
Other Major References
SQL Server 2000 Survival Guide Transact-SQL Reference (Microsoft's MSDN Site) SQL Server 2000 Survival Guide.doc System Stored Procedures Fluffy Cat SQL Reference and Example Site	e SQL Language Reference discusses the SQL that can be passed to Access DevGuru Transact-SQL Syntax Charts Schema Mania / jkl / booksonline / SQLBOL70 is a huge reference to SQL 7. SQL Coding
Scripts SQL 7.0 Scripts Tip & Article Repositories
SQL Wiki MySQL Documentation Dot Net John / SqlServer	Sybase Transact-SQL User's Guide Rules to Better SQL Server Databases SQL Server Development Techniques and Scripts
Back to Mike Beaver's Hypnotherapy Home Page