By David Stodder and Justin Kestelyn – Strategic business applications count on the database to be rock solid, always available — and yet highly flexible in the face of new demands. A discussion with four industry veterans reveals some key directions.
Author: SSWUG Research
Interview with Thearon Willis
by James Crowley – An Interview with Thearon Willis, author of Beginning SQL Server 2000 for VB Developers book.
Effective Installation
By Itzik Ben-Gan – Installing SQL Server 2000 is deceptively simple–choosing the wrong options can lead to big headaches later. These detailed instructions will help you make the right decisions.
Make SQL Prompt Show Database Name and User
by Ahbaid Gaffoor – Description: This script (fnwhoami.sql) creates a public function (whoami) that allows a user to see the database and user he/she is connected to.
xmlto: XSLT processor front-end
Tim Waugh has released xmlto, a utility designed to act as a single XSL tool-chain "front end" for converting XML source documents into HTML, PDF, and other formats.
POSTing Form Data to a Web Page
By Bruce Johnson – Being able to post data to a web page from within a Visual Basic application can be quite handy. Even better when you can 'see' the response and process it automatically. Fortunately, there are at least two different techniques to achieve this goal. The best one depends on
Web Services at Work: Google Web APIs
A lot of hype is buzzing around Web Services these days. New acronyms are appearing every day and protocols and tools are implemented at break-neck speed; but not many real applications are publicly available up to now.Search engine Google makes the leap now and offers the Google Web APIs in
Big databases catch on to XML
By Eric Knorr – For conclusive evidence, look no further than the staid, slow-moving world of relational database management, which is embracing XML as its own.
More Trees & Hierarchies in SQL
Hierarchies are sometimes difficult to store in SQL tables…things like trees, threaded forums, org charts and the like…and it’s usually even harder to retrieve the hierarchy once you do store it. Here’s a method that’s easy to understand and maintain, and gives you the full hierarchy (or any pie
“Little” Design Mistakes
By Michael Otey – One of the most common mistakes in database and software design is thinking and testing too small. So think big to avoid unpleasant and unnecessary application rollout problems.