By Erin Joyce – Newly discovered vulnerabilities in the company’s EAI software could lead to attackers embedding malicious SQL statement into a query string or could even result in attackers executing code of their choice.

Rich Rollman of SQL Server Magazine answers a reader’s query about using XML Bulk Load to upload ADO-generated XML data that includes date fields, prescribing a mapping schema that translates ADO’s ISO8601 format for dates.

Do SQL Server 2000, 7.0, and 6.x manage char values differently? If so, can I compensate for this difference by using the appropriate database compatibility level?

From Sql Server Magazine – Readers ask why so many SQL Servers were connected to the Internet–where they were vulnerable to Slammer, whether linked servers work for Oracle running on Solaris, and comment on choosing a .NET language.

By Don MacVittie – You may not be losing much sleep over how your database affects your network, but here’s a wake-up call: Databases today are more likely than ever to cause network congestion.

by Bryan Syverson – Before you can effectively query date/time (or temporal) data, you have to know something about how date/time values are stored. SQL Server supports two date/time data types: datetime and smalldatetime. The difference between the two is the amount of storage used.

The following sample demonstrates how to run a SQL 2000 template file while specifying an XSL file to transform the XML data. More specifically, a query is issued against SQL Server 2000 by using the command stream of ADO 2.6: This query fetches the XML datastream.

by Randy Dyess – Learn how to optimize the use of your table’s indexes.

By Itzik Ben-Gan – A histogram is a simple means of gathering statistics for analysis. But what’s the best way of generating histograms?

Break through to higher levels of database scalability with SQL Server 2000 Enterprise Edition (64-bit), the enterprise-class database optimized to run on the new generation high-end servers using the Intel Itanium processor family. Analyze hundreds of gigabytes to terabytes of data and get faster r