1/09
Recent installments of our series have discussed configuring Service Broker full dialog level security, which required a mechanism to facilitate the exchange of certificates between communication partners. In this article, we will present an alternative approach, which eliminates this requirement by relying on anonymous dialog security. 1/07
Learn how to create an Analysis Service Database using Windows
PowerShell and AMO.
1/05
Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.
12/31
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.
12/30
Join MSAS Architect Bill Pearson as
he leads the hands-on creation of a simple bar chart based upon an Analysis
Service data source.
12/26
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.
12/23
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.
12/22
An interview with Herain Oberoi, group project manager for the SQL Server Business Intelligence and Data Warehouse product.
12/17
Learn how to use Windows PowerShell and AMO to retrieve the database properties of SQL Server Analysis Service.
12/15
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them.
12/09
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.
12/08
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.
12/05
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.
12/03
Part 2 of this series illustrates how to use Windows PowerShell and AMO to get the various Server properties of SQL Server Analysis Service.
11/28
Join BI Architect Bill Pearson in concluding his extended examination of the MDX BottomCount() function. Discover, through a hands-on practice exercise, another business use for the MDX BottomCount() function, in combination with the MDX Descendants(),
.CurrentMember, .Item() and .Name functions.
