Dataprix

In the previous installment of our series covering the most relevant features of SQL Server 2005 Express Edition, we started an overview of Service Broker full dialog-level security. In this article, we will conclude this subject by describing the remaining prerequisites and a method to invoke a secure dialog.

Join MSAS Architect Bill Pearson as he leads the hands-on creation of a simple bar chart based upon an Analysis Service data source.

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.

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.

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.

Paul Zikopoulos introduces you to the Data Web Services Test Client that's available in IBM Data Studio Version 1.2 or later

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.

An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.

Learn how to create right click (Short Cut) Menus in Microsoft Access 2007.

Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.

Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them.

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.

ASE 15's new optimizer produces significant performance improvements if it receives the most accurate information about your data. The statistics contain the information the optimizer needs to do its job quickly and efficiently. This article discusses how to create and maintain accurate statistics to reach the highest level of performance for ASE 15.

Learn what Oracle has to offer with respect to searching and sorting, and especially so when it comes to linguistic sorting. You may not know this, but you do have some control over how sorts are performed within your database's character set and you can compare Apples to apples, as it turns out.

This article focuses upon Column charts, and extends the examination of Reporting Services charts for Analysis Services data sources that we began in Introducing Reporting Services Charts for Analysis Services.

Part 36 of this series, turns our attention to dialog level security, which provides considerably more flexibility in regard to authorization and encryption than its transport-level counterpart does.

Don Schlichting compares and contrasts the various SQL Server 2008 Data Types. In addition, he explores which Data Types are the best solutions for specific situations.

James Koopmann takes some of the confusion out of Oracle nested tables with this step by step approach to create a table with a nested table.

Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.

Continuing last months article on "MySQL Replication Pitfalls," Sean Hull discusses what to do to make your replication setup more resilient.