(James Crowley) 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
Other News
Microsoft switches on to LAMP
(Gavin Clarke) Microsoft is positioning planned “express” editions of its next developer tools suite and database as “lightweight” alternatives to the open source LAMP stack.
Encrypting Sensitive Data in a Database
(Scott Mitchell) Every couple of weeks or so tech news sites like News.com or ZDNet tell an increasingly common tale – some big name company’s databases have been hacked, resulting in the hackers discovering oodles of personal information about the company’s customers. If you build public-facing
DB2 performance results for Linux on pSeries
(Chris Eaton) Before diving into the database configuration parameters I wanted to take a look at a recent benchmark result that I think is something significant that folks may want to take a look at. On August 8, IBM delivered a new TPC-C result on a platform that hasn’t yet appeared in TPC-C. pSer
Make the XMLHttpRequest Object Work Cross-Browser
(Nigel McFarlane) The World Wide Web has traditionally used a book or slideshow metaphor as the basis for navigation between hyperlinks. Clicking on a link is like flicking from one page to another in a book or magazine, or like operating a slideshow projector—click a button or link, and a new page
FIX: The UPDATE query blocks the SELECT query when you run an UPDATE query and a SELECT query at the same time in SQL Server 2000
In Microsoft SQL Server 2000, when you run an UPDATE query and a SELECT query at the same time, the UPDATE query blocks the SELECT query. You experience this problem when you run a SELECT statement that uses the TOP clause and the READPAST locking hint.
XMLFileWatcher Windows Service
(Venkata Kancharla) When I was reading the MSDN.Net, I found an interesting topic on Windows services and FileSystemWatcher. So, I tried to write a Windows service that monitors the directory changes, writes an entry in the event log about the change, notifies the changes to the users by sending mai
The Underground Guide to Oracle OpenWorld 2005
Oracle OpenWorld, PeopleSoft Connect, and Retek World conferences have merged into a single event—the biggest OpenWorld ever! Use this “underground” guide designed for developers and DBAs to navigate the show.
The Power of Insight
(Janet Perna and Andrew Warzecha) Businesses are facing a formidable challenge: the pressure to grow revenue, contain costs, respond more quickly to changes, and increase efficiency. These big goals demand that people and processes have access to the right information at the right time to take t
Learn about SQL*Plus 10g’s new features
(Scott Stephens) The Oracle SQL*Plus product has introduced some new features that have long been missing from this utility program, and some to support the new features. Here’s a rundown of the new features in Oracle SQL*Plus.