 |
| |
|
|
|
 |
|
|
SQL Server 2008
John L. Hall posted on March 09, 2011 15:05
How to determine the room you have left in a record to store more column data.
[Read the rest of this article...]
William E. Pearson III posted on November 11, 2010 07:27
BI Architect Bill Pearson continues an extended examination of parameterization within Analysis Services reports. In this, Part 3 of the article, we continue to get hands-on practice creating a parameter within the graphical user interface, and then examine the construction that Reporting Services 2005/ 2008 / 2008 R2 performs behind the scenes.
[Read the rest of this article...]
MelissaCoates posted on October 27, 2010 19:22
Effective data presentation techniques help users interpret information quickly and reliably. Layout, formatting, sizing, labeling, and other report elements may all be used to facilitate analysis and decision-making. This article will focus on one aspect of formatting: color. More than just an aesthetic concern, color serves a valuable purpose to enhance perception and understanding of data.
[Read the rest of this article...]
John L. Hall posted on September 17, 2010 16:13
If you ever see the warning message “This field is missing from the returned result set form the data source” and get unexplained #Errors in columns on your report it may be from SSAS not returning a column is the column is null for all the rows. You can use the IsMissing method of the field object and a vb function in your report to work around this problem.
[Read the rest of this article...]
Javier Guillen posted on September 07, 2010 14:50
PowerPivot and DAX are a powerful technologies, but there is still a good amount of work that can be done with traditional cube functions. In its current version, PowerPivot lacks the concept of dimension hierarchies; however very customized Excel reports that leverage cube hierarchies can still be built using MDX enabled cube functions. This approach goes beyond the limiting nature of traditional pivot tables by enabling power users to transverse dimensions using custom formulas that are a mix of MDX with traditional Excel functionality.
[Read the rest of this article...]
William E. Pearson III posted on July 05, 2010 20:10
Join BI Architect Bill Pearson as he introduces Attribute Discretization into his extended examination of the dimensional model within the integrated Microsoft Business Intelligence solution.
[Read the rest of this article...]
William E. Pearson III posted on May 12, 2010 10:58
Business Intelligence Architect Bill Pearson launches a new subseries surrounding components of the SQL Server Analysis Services 2008 / 2008 R2 dimensional model. In this two-part article, we introduce dimensions, and then focus upon property settings for Database Dimensions.
[Read the rest of this article...]
William E. Pearson III posted on April 30, 2010 07:09
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 describes issues I encountered in attempts to install SQL Server 2008 R2 on a Windows 7 machine, and my conclusion that the issue lay with flawed setup files, as extracted from the downloaded SQL Server 2008 R2 Developer .iso file by the WinZip extraction utility.
[Read the rest of this article...]
Wayne Snyder posted on April 15, 2009 06:48
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 easy SQL. This article contains a small script which allows you to easily implement and test such a bridge table.
Updated to fix a bug in original version
[Read the rest of this article...]
Wayne Snyder posted on March 11, 2008 03:30
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 basic requirement for this ODS/Data Warehouse is that we expect to include data from other sources/applications and companies. We do not know currently who they are or what their requirements will be. We do know that their data types may not match our source systems, and that we should be able to tag each row with the source system which contributed the data.
[Read the rest of this article...]
Wayne Snyder posted on July 01, 2008 05:08
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 object names. In SQL Server the length was 16 characters. IT came up with many rules, codes and abbreviations to keep the name short. This often led to cryptic names that made no sense to business. Prefixes, suffixes, class words – all part of this new language to allow short names. This is no longer required, since SQL Server allows 128 character names. The purpose of this standard is to eliminate the cryptic names. We are not encouraging the use of short or long names – the requirement is that business names be used.
[Read the rest of this article...]
Wayne Snyder posted on January 25, 2008 13:32
Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to manufacturing (RTM) of SQL Server 2008 expected in Q3.
[Read the rest of this article...]
Wayne Snyder posted on June 07, 2007 05:03
Announced on Monday, June 4, 2007, SQL Server 2008 CTP is now available. We list some of the new features, and links where you can get more information.
[Read the rest of this article...]
|
|
|
|
|
|
| |
|
|