Lumigent Technologies, Inc. today introduced Entegra to help enterprises create audit records of data access to fulfill internal business practice requirements and insure regulatory compliance. Entegra is the only product to provide a complete audit trail of information on data access, including cha
Tag: sql server
Book Review: Writing Secure Code
By Vyas Kondreddi – The cover page of this book says, “Practical strategies and proven techniques for building secure applications in a networked world”. And that’s exactly what you’ll find inside this book. The authors are top security experts, from Windows XP team and Microsoft’s new trustworthy c
Database Battle Heats Up
By Lisa Vaas and John S. McCright – Oracle Corp. and Microsoft Corp. will ratchet up their ongoing database battle with each announcing new and upgraded features that hit at the other’s strengths.
HOW TO: Using DB-LIBRARY in a Threaded Application
This article provides tips for using DB-LIBRARY in a threaded application.
An Interview with the Authors of SQL Performance Tuning
by Brad M. McGehee – In this interview, the authors tell us a little about their book and offer some advice for DBAs and SQL developers.
True DBA Blooper #7: Tricks, slips and surprises
By Sara Cushman – Not all true DBA bloopers involve running errant code or deleting live production databases with a single keystroke. This collection shows that sometimes technical difficulties occur when communications go awry, practical jokes turn sour, or someone turns on the lights.
Can Holistic Security Plug Data Security Holes?
by Joseph McKendrick – A recent survey of database developers and managers from Evans Data also confirms that direct attacks against databases are on the rise. More than one out of five respondents, 20 percent, report a direct security breach against a database in their company over the past year –
Mathematical User-Defined Functions
Alexander Chigrik presents a few Math UDFs he has developed. These scalar User-Defined Functions perform a calculation, usually based on input values provided as arguments,and return a numeric value.
Microsoft SQL Server Webtasks privilege elevation
Using a number of flaws in the webtask functionality of Microsoft SQL Server an attacker may gain control of the database by elevating their privileges.
Retrieve XML Data with a Template File from a Visual Basic Client
This sample in this article demonstrates how to retrieve an XML document from SQL Server 2000 by using a template file that contains parameters. More specifically, a query is issued against SQL Server 2000 by using an ActiveX Data Objects (ADO) 2.6 command stream. This query fetches the XML DataStre
