By John McCormick – Database administrators using Microsoft’s SQL Server software need to know that their installation is vulnerable to an attack based on an unchecked buffer in the ad hoc query feature. This issue is covered in Microsoft Security Bulletin MS02-007.

By Dennis Fisher – Microsoft Corp. has issued a patch for a buffer overrun vulnerability in some versions of its SQL Server database software that could enable an attacker to execute code on a vulnerable machine.

From SQLTeam – We’ve got a quite a few articles on randomly selecting and ordering rows. I’m still amazed how popular that topic is. I recently stumbled across a post in the forums that led me to a better way to accomplish this. This has actually been posted a few times before. I’m just finally catc

by James Crowley – Visual Basic gives you several ways to provide pattern-matches in a search string. Typically, you use pattern-matching characters for two purposes: to search for strings in a VB application’s GUI or variable, or to look for items within a database, such as Access or SQL. When you

(Andy Clark) Much of the data you work with is probably hierarchical, and hierarchical cursors are a convenient tool you can use to work with data organization. In this column, I’ll show you how to use hierarchical cursors to develop programs quickly that access data the way your users think about i

In this tutorial you are going to learn everything in detail step by step you’ll ever want to know about inserting binary data ( images, zip files etc ) into database. This is actually first of the three articles I am going to write on manipulating binary data in the database. After this article you

By Brian Moran – You can’t judge a book by its cover, and you can’t judge a benchmark by its raw score. On behalf of PC Magazine and eWeek, eTesting Labs recently conducted database- and application-server benchmark tests.

SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly, MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access or anything else, at some stage you will need to know SQL. SQL, or Structured Query Language gives you complete control over databases, creat

By Tim DiChiara – A few weeks ago, I called upon you loyal SearchDatabase readers to submit your toughest questions to stump our site experts. We received over a hundred questions — I knew the modern DBMS was complex, but wow! The experts’ responses ranged from a confident “None of them really pose

By Peter Galli and Matt Hicks – Microsoft Corp. is bringing its next SQL Server release, code-named Yukon, in line with its .Net and Web services vision, with new data unification and integration technology. Microsoft plans to embed .Net CLR (Common Language Runtime) in the SQL engine, as wel