 |
| |
|
|
|
 |
 |
People Online:
|
 |
Visitors:
28
|
 |
Members:
0
|
 |
Total:
28
|
 |
Online Now:
|
|
|
|
|
|
|
|
| |
|
|
| |
|
|
Latest Articles
|
|
| FLASH: SQL Server 2008 R2 Error: Could Not Find Database Engine Startup Handle by William Pearson | If you encounter the error “Could not find the Database Engine startup handle” when attempting to install SQL Server 2008 R2, the cause may not lie with SQL Server, but with WinZip. This document...
| | Optimizing Analysis Services Based Upon Usage by William Pearson | Join Business Intelligence Architect Bill Pearson as he leads practice in employing the Usage-Based Optimization Wizard to fine tune our aggregation design based upon cube usage statistics.
| | How to Filter Data at Client and Database in Report Builder(Model) by Wayne Snyder | Data can be filtered in the database query, or at the client, or both. When you write SQL or MDX, you know what is filtered in the database, because you directly control the query. When your report us...
| | Reporting Services Models are Broken (for me) by Wayne Snyder | Reporting Services Models garnered a lot of attention, and offer much promise, but the actual implementation falls short of being useful in many situations. The shortcomings I list below cause Reporti...
| | Implement Kimball Navigation Bridge Table by Wayne Snyder | Ralph Kimball proposed a navigation bridge table circa 1998 to assist in the tra veral of hierarchies. The intention is to make it easy to traverse hierarchies and do sums and grouping using eas...
| | Report Model Change which Break SSRS Reports by Wayne Snyder | Be very careful when deploying Reporting Services Report models. Do not deploy them and their associated reports until the model is stable. Otherwise when you change the report model, you may br...
| | ODS and Data Warehouse Best Practices by Wayne Snyder | The purpose of this document is to provide some “best practices” guidance for designers and architects ODSs and Data Warehouses . This document will grow over time as we add your ideas and comments. A...
| | Formatting Expressions in Reporting Services by Wayne Snyder | Setting the format of a text box can be very time consuming... Reporting Services does not have an easy place to go to look up all of the formatting expressions that can be used in the format property...
| | Best Practices for Reporting Services Data Sources by Wayne Snyder | You should make a plan around how you are going to organize Data Sources, and what connection types you recommend at the very beginning of your adoption of SSRS. Otherwise, you may find you'll ha...
| | Naming Standards by Wayne Snyder |
Many people get all tangled up in naming conventions. I have been tripped up by it also. But let me cut to the chase on naming. In the past many databases could only support object short objec...
|
|
|
|
|
|
|
| |
|
|
| |
|
|
Featured Contributors
|
|
Melissa Coates |  Melissa Coates has more than 10 years of experience as a hands-on developer with various reporting and analysis tools. As a Senior Consultant with Intellinet, she specializes in delivering business intelligence solutions using the Microsoft platform and has experience with SQL Server Reporting Services, Analysis Services, Integration Services, Master Data Services, as well as SharePoint BI. Formerly a CPA, Melissa brings a beneficial blend of technical, business, and training skills. She has a keen interest in visualization techniques and repeatable best practices. Melissa’s blog is at http://www.sqlchick.com. |
|
|
|
|
|
|
| |
|