by Rahul Guha – Achieve flexibility and efficiency by separating data representation from data-handling presentation code to create data islands that process only code that has changed.
Author: SSWUG Research
TechNet Webcast: Protecting sensitive data in SQL Server 2000 presented by Protegrity, Inc.
We will begin this session by reviewing some of the legislation factors that are driving corporate initiatives for securing data. We will also outline security threats that are specific to databases, identify solutions for role based security and securing specific data such as salary information. We
Using Extended Properties to Create a Data Dictionary
I’m looking for shareware or an inexpensive tool that will let me maintain a SQL Server data dictionary. I’ve used sophisticated data-modeling tools that provide this functionality. However, I’m now in an organization that has many SQL Server databases but no data dictionary and no budget to buy exp
Setting Priorities for SQL Server 2000
Discover how to handle different users with different priorities when using Microsoft SQL Server 2000.
Oracle touts J2EE frameworks
By Paul Krill – Oracle will stress frameworks and the need to make Java programming accessible to more developers in a release of its JDeveloper developer environment that the company will focus on in June.
INF: Troubleshooting Performance of Ad-Hoc Queries
This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server — slow performance of a large number of concurrent ad hoc queries.
ZIP files with a stored procedure
By Matt Harper – Here is a simple SQL Server stored procedure that zips files from a source and destination directory that you pass when calling the procedure. It uses the DOS-based wzzip.exe to zip files specified into a zip file named the current date and time, e.g., 200303030809.zip.
High Performance Backup of Very Large Microsoft SQL Server 7.0 Databases White Paper
Mission-critical backup and data protection can cause interruptions in business operations, but Microsoft suggests adding functionality to SQL Server with HP OpenView OmniBack II, the market leader in enterprise storage management solutions. This white paper explains why Microsoft is working with Co
Three ways to speed up SQL execution in Oracle
Oracle provides several methods for reducing the time spent parsing Oracle SQL statements, which can cause a drag on performance when executing complex queries with a large number of possible execution plans.
InfoPath Shows XML’s Promise
By Jason Brooks – “Better working through XML” is the prevailing theme for Microsoft Corp.’s forthcoming Office 2003 productivity suite, and none of its components carries this banner more prominently than InfoPath, a new application for designing and filling out XML-based forms.