Book by Denise Gosnell, Tony Bain, Jonathon Walsh – Many VB developers choose SQL Server 2000, a robust enterprise-level database system, to provide the data layer in their applications. The introduction of Microsoft’s .NET Framework brings us ADO.NET, the latest means of connecting to that data sou
Author: SSWUG Research
SQL Syntax Validator
By Santosh Rao – I had one of my requirements in my application to store some custom SQL Queries into our System. These SQL Queries would be provided by the end user who is kind of well versed at least with SQL. Our system later would execute these queries to perform various aspects of the system.
Interesting SQL-Based Web-Site Implementation
Several people have asked since SQL Server Live! Spring 2002 what the site was that was used in several of the demonstrations. The site is entirely SQL Server-driven, and the backend is millions of rows of data that is searched and used to find the issues about your car. It was challen
SVG Tips and Tricks: Adobe’s SVG Viewer
by Antoine Quint – Since Adobe’s SVG Viewer is the main SVG implementation, with 160 million deployed units and counting, I thought it would be a good idea to take a look at some special features that only the Adobe SVG Viewer offers to its users. Want to see what we can do with it? Grab a copy of v
Build Generic Page-Specific Help with XML in ASP
by Philip Dickerson – In this article, you’ll see several possible approaches for implementing context-specific Web help pages, as well as a discussion of the strengths and weaknesses of each approach.
Can EDI Survive XML Challenge?
By Dan Orzech – With support from high-tech’s heavy hitters, XML-based RosettaNet is becoming a popular way for companies to synch up their supply chains.
Oracle plans to make unstructured data searchable
by Eric Doyle – Businesses will be able to search unstructured data held in anything from e-mail to Powerpoint slides, if an Oracle project achieves its aim.
GenerateScript
Created by: Alexander Chigrik – This script will generate script for all tables and all dependent objects for the given database. You can pass the Server name, user name, user password, database name and file name into GenerateScript stored procedure
Moving SQL Server Databases to a New Location with Detach/Attach
This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database.
Edgar Online Pushes XBRL For Financial
By Eileen Colkin – Edgar Online Inc., the Internet-based company that provides electronic versions of Securities and Exchange Commission filings, is pushing hard for an XML-type standard for financial reporting. The eXtensible Business Reporting Language, XBRL, creates a standards-based method for c