ZD Net (Free subscription) | yesterday
I've been carting around my latest sheaf of press releases about the green-ness of electronic document technology for weeks now. Yes, as I've blogged before, I am still one of those people who can't help printing out certain emails in order to act on them. Yes, it's bad, I know....
Database Journal (Free subscription) | yesterday
SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.
Database Journal (Free subscription) | 07/24/2008
With a single MERGE statement, you can easily implement insert, update, and delete logic to handle criteria for maintaining a table. Read on to learn how to use the MERGE statement.
ZD Net (Free subscription) | 07/23/2008
Today, MindTouch Deki releases Kilen Woodds, its latest and biggest release. In conversation with co-founder Aaron Fulkerson I learned that Deki is rapidly transforming itself from being a smart wiki into what Fulkerson calls the 'connecting tissue' between applications. Others might call it mashup environment, still others a means of...
Database Journal (Free subscription) | 07/23/2008
As an Oracle DBA you might think that Oracle Reports have nothing to do with you, and you might be missing out on a simple means of generating reports to identify a source file, create an external table, write an SQL script and more.
Database Journal (Free subscription) | 07/21/2008
MSAS Architect Bill Pearson introduces the intrinsic MEMBER_NAME property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
Database Journal (Free subscription) | 07/18/2008
Garry Robinson outlines how usage data can make the quest to speed up an Access database more focused. The article also delves into an Access 2007 ACCDB only feature called TempVars.
Database Journal (Free subscription) | 07/16/2008
ANTs software inc. introduces the Sybase-to-Oracle Accelerator Program, a new promotional offering that complements Oracle's current Sybase Safe Switch Program...
Database Journal (Free subscription) | 07/16/2008
Part 3 of this series illustrates how to acquire operating system and hardware related information from a host machine.
Database Journal (Free subscription) | 07/15/2008
This article discusses re-organizing a table using the move and shrink commands, then compares how the rows are compacted within Oracle blocks and how row chaining is resolved.
Database Journal (Free subscription) | 07/14/2008
Learn how to monitor database-level actions and write audit results to files.
Database Journal (Free subscription) | 07/11/2008
This article is a brief overview of Service Broker's core features, which are available (in a somewhat limited capacity) in SQL Server 2005 Express Edition. The next installment will describe a sample application illustrating its operations and discuss its management, security, and routing characteristics.
Database Journal (Free subscription) | 07/10/2008
Oracle supplies quite a large complement of pl/sql stored procedures, packages, and functions, which can help with some of a DBA's day-to-day needs. This article looks at some of the useful ones that we can add to our DBA or Developer toolbox.
Database Journal (Free subscription) | 07/09/2008
Learn how to recover from the loss of a datafile, when you don't have a backup of that file.
ZD Net (Free subscription) | 07/08/2008
Linkedin's web infrastructure seems to offer a model for mid range sites: it's fast, it's clean - and development seems to have been based on combining the best of open source products with minimal customization. by Paul Murphy
