(Shlomi Noach) A simple question I’ve been asked: Is it possible to merge two UPDATE queries, each on different WHERE conditions, into a single query?
Other News
Managing pureQuery-enabled applications efficiently, Part 1: Set up an SQL management repository using an ANT script
(Patrick Titzler and Soid Quintero) IBM Optim Development Studio and the pureQuery Runtime include a command line utility called ManageRepository that can be used to create, modify, export, import, and delete pureQuery metadata that is stored in the SQL management repository.
Replication in Oracle: Streams vs. GoldenGate
(Steve Callan) Replication in any database system, not just Oracle, provides functionality that can fill many needs. One of the main benefits of replicating data in Oracle is reducing (and practically eliminating) the load on a production server.
WCF: Streaming Large Data Files
(Andrew Fenster) WCF can be used to transfer image files, .pdf files or other large documents. The most common way to do this is to use streaming.
How to Write a Schema for XML – XSD Validation Files for XML
(Darla Ferrara) Schema is a relevant skill to have when learning XML. Not because you will use them often. Most formatting for XML works best with one of the XSL languages.
Insiders, and Your Databases
New SelecTViews Show! Database applications and tablet devices, toasters (er, appliances), and the SQL Server Tip of the Day. Also, Wendy Pastrick, insider knowledge of your systems and other key things to consider. [Watch the Show] (it’s free!) More, smaller databases? Manage your checklists, our featured blog of the week for business intelligence…Also, the hotmail outage and SQL Server, 3rd […]
Insiders a Real Threat
Insiders a Real Threat Today on the show [Watch the Show] one of the things we look into is the fact that "insiders" are becoming the key issue with IT-based systems. Essentially, with all of the privileges associated with being in IT, you end up with people with ready access to things that can be abused. From data storage to […]
Database applications and tablet devices, toasters (er, appliances), and the SQL Server Tip of the Day.
Pro-Center Video Programming for IT Professionals
Remote DBA, Is it For You?
SSWUG Free Expo Event: Real-World SharePoint Administration Friday, February 11, 2011, 9 a.m. – 1 p.m. PST Build your skills for deploying and supporting SharePoint by attending this virtual expo. Experts will teach you techniques for managing access control, implementation strategies and tips you can use immediately. With registration you also receive a free complimentary membership to SSWUG for one […]
DB2 10 Scalar Function
(Troy Coleman) DB2 provides the facility to extend SQL functionality through user-defined functions that can then be evaluated in the SQL statement.