5/06
This installment of "Windows PowerShell and AMO" covers how to script a cube from a SQL Server Analysis Service instance to XMLA format file. 5/01
The benefits of using SQL Server VIEWs include the ability to restrict a user's access to underlying data, as well as hiding complex statements so simple result sets can be worked with. This article examines the syntax and options used in creating SQL Server VIEWs.
4/30
Display data as a set of points
connected by a line - typically to compare values over time. BI Architect
Bill Pearson leads the hands-on creation of a Line chart based upon an Analysis
Service data source.
4/27
Having completed our coverage of the Service Broker characteristics specific to SQL Server 2005 Express Edition, we now turn our attention to Reporting Services. In this article, we will present the initial setup process, leaving discussion of configuration, management, security, and usability for future installments.
4/24
Greg Larsen examines 10 new features that were introduced with SQL Server
2008.
4/20
The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?
4/17
Join BI Architect Bill Pearson as he continues his overview of Attribute
Discretization, within his extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution. In this article, we begin a hands-on overview of the use of the Automatic discretization method.
4/16
The first installment of this series describes the steps to configure a two-node Peer-to-Peer replication topology.
4/15
Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis
Service database to XMLA format file.
4/10
BI Architect Bill Pearson introduces the LEVEL_NUMBER intrinsic member property, supported by SQL Server 2005 Analysis Services, and leads a hands-on exercise providing sample uses.
4/09
Today's technical book market is flooded with misleading labels featuring tantalizing phrases promising easy access to insider information on even the most complex topics. In such an environment, it is refreshing to find a book whose rather terse title contrasts with the breadth and exceptional quality of its content.
4/03
Don Schlichting explores the various methods of using an INSERT statement with SQL Server 2008.
4/01
This installment of our series on " Microsoft Windows PowerShell and SQL Server 2008 AMO" examines the various types of Analysis service database detach and attach methods.
3/30
A number of different processes that can be used to make sure your data validates against your business rules. This article discusses how you can use database "check constraints" to validate your data within the SQL Server database engine.
3/27
One of the most interesting features in SQL Server 2008 is filtered indexes. This article starts with a quick explanation and then digs into the details and results.