Syndicate content
Daily Database News and Information for the Database Professional
Updated: 1 year 35 weeks ago

Oracle Database 11g: Flashback Transaction Backout

Mon, 12/29/2008 - 09:00
Oracle Database 10g offered two new Flashback features that allowed an authorized user to see all versions of any changes made to one or more rows in a table. Database 11gR1 provides the ability to back out one or more independent or dependent transactions with Flashback Transaction Backout.

Performance Testing – SQL Server 2008 versus SQL Server 2005

Fri, 12/26/2008 - 09:00
Comparing the performance of SQL Server 2005 to SQL Server 2000 demonstrated an improvement of 18.5% in the time to process a workload. Now that SQL Server 2008 has shipped, it's time to compare the performance of SQL Server 2005 to SQL Server 2008.

Multilingual linguistic searching and sorting in Oracle

Wed, 12/24/2008 - 09:00
How well do you know the sorting rules of your own language? Chances are, Oracle knows them much better than you, in addition to knowing all the rules for all of the languages Oracle supports. Take a tour through Oracle's multilingual linguistic searching and sorting features.

Testing your Web services using the Data Web Services Test Client

Tue, 12/23/2008 - 09:00
Paul Zikopoulos introduces you to the Data Web Services Test Client that's available in IBM Data Studio Version 1.2 or later

Introduction to Attribute Relationships in MSSQL Server Analysis Services

Tue, 12/23/2008 - 09:00
Join BI Architect Bill Pearson as he introduces Attribute Relationships into his extended examination of the dimensional model within the integrated Microsoft Business Intelligence solution.

Kilimanjaro, Gemini and Madison - Get the lowdown

Mon, 12/22/2008 - 09:00
An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.

Setting Up Right Click Menus for Access 2007

Fri, 12/19/2008 - 09:00
Learn how to create right click (Short Cut) Menus in Microsoft Access 2007.

Get SSAS Database Properties with PowerShell and AMO

Wed, 12/17/2008 - 09:00
Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.

Proxy Accounts in SQL Server

Mon, 12/15/2008 - 09:00
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them.

Testing your Web Service using the Web Services Explorer

Fri, 12/12/2008 - 09:00
In part 12 of this series, Paul Zikopoulos delves into the Web Services Explorer, one of the testing facilities for your Web services that is included in IBM Data Studio Version 1.1 and Version 1.2.