Recommended books

"SQL Puzzles and Answers" (Second Edition) written by Joe Celko is an important resource for advanced techique of SQL programming. The book is published by Morgan Kaufmann in it's "Series in Data Management Systems". The book contains 75 puzzles and includes discussion about choosing the most efficient way for solving particular problem. SQL code used in examples fits SQL-92 standard and some solutions uses SQL-99 OLAP features. see Joe Celko articles on dbazine.com "Database Tuning: Principles, Experiments, and Troubleshooting Techniques" written by Dennis Shasha and Philippe Bonnet. The book shows how specific DBMS physical archetecture can influence decisions about writing SQL code. It also feature stories about implementation of various Data-Mining and OLTP solutions in financial and retail industries. "VBA Developer's Handbook" written by Ken Getz and Mike Gilbert came with a huge library of usefull VBA functions for string manipulation, math and dates calculations. It can take years of programming to write things like that. To mention few examples, I like their dhTranslate() from the strings chapter. SELECT FirstName, dhTranslate (FirstName,"abcdefgh","-@_123*=.56") AS Trans_Name FROM Employees WHERE EmpNo < 3 The result will be like this: FirstName FirstName john jo=n gret *r2t As well as function that calculates number of work days between two dates dhCountWorkdays() from the times chapter. "Beginning Spatial with SQL Server 2008" is a pioneer book about Spatial functions on SQL Server 2008. It covers various aspects of Spatial data creation, processing, testing relations, geocoding and advances uses like a linkage to Virtual Earth environment. Additiotional articles and code examples are availiable on web site: Beginning Spatial with SQL Server 2008   WEB links   theme link description SQL Standards Is SQL a Real Standard Anymore? Article by Michael M. Gorman SQL Online Tutorial for SQL Language SQL SQL Programming Directory @ eIT.in Web Resources for SQL Programming Language SQL SQLzoo.net Interactive SQL tutorial SQL DBMS Online comunity for Database issues and solutions: articles, blogs, podcasts and rss feeds. SQL-Server Journey to SQL Authority Pinal Dave. Notes of a SQL Server MVP and Database Administrator SQL-Server Craig Freedman's SQL Server Blog A discussion of query processing, query execution, and query plans in SQL Server SQL-Server Spatial Isaac @ MSDN Blog of Isaac Kunen - program manager for the MS SQL Server engine   Downloads   .mdb file with tables and SQL queries examples used in this site colombo.zip - 75 kb Simple utility for translating tables of variety of formats to XML file: Open data file -> Select table -> Click "Convert To XML" button -> Save AS XML MyXml.zip - 551 kb Sample points of interest in Milan city center: Name, type, latitude, longitude in Tab Delimeted text file. milan_pnt_src.txt - 3 kb URL Submit If you add reference to my site on any web page devoted to SQL or software programming, please send relevant url to e-mail amper102[at]hotmail.com and i'd be glad to place link to your site here.

sqlexamples.info