By Margie Semilof – Microsoft customers and analysts alike are expecting the vendor to shed some light on its little-discussed and fragmented management product line later this month at the Microsoft Management Summit.At the summit, analysts said Microsoft will likely explain how its three m
By Sam Costello – MICROSOFT released a patch for a security hole in its SQL Server 7.0 and 2000 databases that could allow an attacker to execute code of their choice on an affected system by exploiting a buffer overflow vulnerability.
By Ganesh Variar – Business-Savvy SQL Develop and execute complex business-intelligence queries quickly and efficiently in SQL, using Oracle9i’s analytic SQL features.
By Ed Parry – Do one of the 20 things seasoned DBA and Oracle expert Rachel Carmichael of Dragonfly Consulting LLC listed in her presentation at the Oracle user event International Oracle Users Group (IOUG) Live!, and you could find yourself holding a pink slip faster than you can say “Victoria’s Se
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
In this tip, author and developer Nicholas Chase shows you how to use the Java API for XML Messaging (JAXM) to simplify the process of creating and sending SOAP messages.
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