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 –
Author: SSWUG Research
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.
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.
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.
Can XML Web Services Offer a Standard Across Databases?
by Brian C. Reed – XML is often promoted as the standard format for exchanging data. But dig into how XML is actually being implemented by the database and tools vendors, and you will often find that XML is not necessarily being delivered in the interoperable way they might expect.
Plan to use XML namespaces, Part 1
By David Marston – This article introduces XML namespaces, explores their practical benefits, and shows you how they are used in the standard XML formats and tools defined by the W3C. Several W3C specifications are mentioned, notably XML Schema and XSLT, which offer useful ideas for using namespaces
XMLNotePad 1.0
Notepad for XML Files
Converting an eMbedded Visual Basic 3.0 Application from SQL Server CE 1.x to SQL Server CE 2.0
Learn How to Set Up Security and Encryption for Servers Accessed by SQL Server CE Clients
Running total in an SQL query
by James Crowley – There are no standard functions in either MySQL or MS SQL Server to return a running total for an SQL query. It is, however, relatively easy using the CROSS JOIN statement. In order to do this, use the following SQL: