Oracle Database 11g: Flashback Transaction Backout
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
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
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
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
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
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
Learn how to create right click (Short Cut) Menus in Microsoft Access 2007.
Get SSAS Database Properties with PowerShell and AMO
Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.
Proxy Accounts in SQL Server
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
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.