By Ellen O’Brien – Data mining is headed for the masses.Yes, the struggle continues to move data from the back end, where the hardcore techies figure algorithms, to the front end, where most math skills are limited to factoring sales commissions. Some major vendors are responding, though, wi

This patch eliminates a newly discovered security issue in SQLXML. Download and install this patch today if you have enabled SQLXML and HTTP queries.

By Margie Semilof – Stan Sorensen, director of SQL Server at Microsoft, said in the mid-1990s, his company faced a tough decision. At issue — whether Microsoft should enter the database business or whether it should let others cash in on that market. Naturally, Microsoft jumped in with gusto, recru

(Don Hite, Updated) By default you cannot edit or view most of the SQL server objects within the SQL server Enterprise Manager (SEM) or the SQL Query Analyzer (ISQLW). Using this tool you can perform these operations quite easily. <br><Br> This Visual basic generated application uses SQLDMO (SQL

By Mike Fratto – SQL Snake has been successful for two reasons, both related to implementation: The SQL servers were publicly available on the Internet, and no passwords were assigned to them.

By Ellen O’Brien – Here Barry Grushkin provides insight into the burgeoning data mining market and its revolutionary technology.

By Ken Pfeil – Matt Moore has discovered two vulnerabilities in XML for SQL Server 2000 (SQLXML). The first problem is a buffer overrun that lets an attacker execute arbitrary code on the affected system, and the second problem is in a function specifying an XML tag that lets an attacker run scripts

In this review, Vyas takes a closer look at this recently released T-SQL programming book.

By Matt Hicks – IBM and Microsoft Corp. are upgrading their respective database systems to perform real-time analysis of incoming data, giving users the ability to react more quickly to changes in customers’ habits and market conditions. Microsoft plans to add to its next release of SQL Serv

When you upgrade from SQL Server 7.0 to SQL Server 2000, you keep your existing sort order and code page by default. However, when you perform a clean installation of SQL Server 2000, you get the new sort order and code page. If you attach a database to a SQL Server 2000 instance, SQL Server keeps w