By Lisa Vaas – Microsoft Corp. has consolidated the database security tools that shield SQL Server 2000 and MSDE 2000 installations from the Slammer worm. SQL Server 2000 SQL Scan, SQL Check and SQL Critical Update are now available in a single download, the SQL Critical Update Kit, which can be dow
Author: SSWUG Research
Coding Defensively
By Michael Otey – One of the most dangerous system attacks–SQL Injection–is code-based, and defending against it falls squarely on the application developer’s shoulders.
Move tables between tablespaces
By Sergey Solodilov – This script generates a script that moves tables from one tablespace to another. Also, it rebuildes indexes of these tables and doesn an analysis. The script can be fixed for a range of sizes for tables and size extents for new tables. It is based on an article by Brian Peaslan
Web services in serious jeopardy
By David Berlind – When people ask me to define Web services, I tell them that it’s primarily an idea hatched by IBM and Microsoft to steal customers from each other.
Peek Into the Future of XSLT 2.0
XSLT 2.0 provides powerful new features that XSLT 1.0 was missing. Although XSLT 2.0 is still under development, Mike Kay’s Saxon 7 implementation lets you experiment with the new capabilities now.
HOW TO: Import XML into SQL Server with the XML Bulk Load Component
Data that is expressed in XML can be loaded into a SQL Server 2000 database by using the XML Bulk Load component. This article outlines the steps that you need to follow to load XML data into a table that already exists in the database.
Export TABLE Records into Flat File with INSERTs
by Dave Nikhil – This procedure writes an ASCII file to specified folder. UTL_FILE_DIR parameter must be set in the init.ora file prior to installing and running the procedure. This package looks for TABLE COLUMNS in USER_TAB_COLUMNS data dictionary. So user will be able to fetch the data onl
Displaying Dependencies
I get different results when I use the sp_depends system stored procedure to display my database object dependencies instead of using the Display Dependencies window in SQL Server Enterprise Manager. Why?
Oracle lends support to UnitedLinux
By Michael S. Mimoso – Oracle Corp. has entered into an agreement to provide level 1, 2 and 3 technical support for enterprise customers using UnitedLinux’s distribution of Linux. In addition to supporting its own products on the UnitedLinux distribution, it will also support the operating system.
How I used SQL Server CE in my eVB application
In this article, Steven Heyvaert shares some of the SQL Server CE knowledge he has gained implementing SQL Server CE into his eVB application. In addition to the code snippets covering a variety of routine CE database access scenarios, there is also code to fill a grid with a CE recordset.