-
CTP3 Build of SQL Server 2005 Service Pack 2 Released
December 20, 2006 / No Comments »
In the spirit of the season, the SQL Server team give us the third (and probably last before the final release) CTP3 build (version 9.00.3033.0000) for the forthcoming SQL Server 2005 Service Pack 2.
-
SQL Server 2005 Samples and Sample Databases (December 2006)
December 9, 2006 / No Comments »
The December 2006 edition of the SQL Server 2005 Samples and Database is available for download.
-
Losing Identity
December 1, 2006 / 1 Comment »
After installing CTP2 of SQL Server 2005 SP2, I started getting a rather annoying exception when attempting to launch the Report Builder. An application for this deployment is already installed with a different application identity. I've noticed that this happens when I run the Report Builder form a server that has CTP2 installed and then I run it from my local machine that doesn't have CTP2 installed. While I wasn't able to find what's causing ClickOnce to lose identity, the workaround I found was to nuke the Report Builder download folders as follows: Open Windows Explorer and navigate to C:\Documents and Settings\<your user name>\Local Settings\Apps\2.0 Delete all folders below the folder except the Data folder.
-
SSRS-SharePoint Integration in SP2 (the Good, the Bad, and the Ugly)
November 26, 2006 / 4 Comments »
As noted before, a major SSRS enhancement in the SQL Server 2005 Service Pack 2 is integration with SharePoint v3.0 and Microsoft Office SharePoint Server. After the RTM release of SQL Server 2005, the SSRS team has been hard at work to implement this feature. Starting with the newly released CTP2 build of SQL Server 2005 Service Pack 2, the SharePoint integration mode is available for public review and testing. Here are my initial high-level observations after testing the SSRS SharePoint integration in CTP2. The Good Integrating reports in dashboards and portals is an increasingly popular requirement. It is obvious that the major design goal that the RS team has set up from the get-go was a seamless integration between SSRS and SharePoint. Many changes were made to the SSRS architectural stack to materialize this goal. The final result speaks for itself (see attached screenshot ). Once the Report Server...
-
SharePoint Services 3.0 Released
November 22, 2006 / No Comments »
Download location: http://www.microsoft.com/technet/windowsserver/sharepoint/download.mspx Demo: http://office.microsoft.com/en-us/sharepointtechnology/HA102055631033.aspx
-
Report Snapshots and rsReportNotReady
November 13, 2006 / No Comments »
Two very useful features of Reporting Services (version 2000 and above) are snapshot execution and report history. Snapshot execution allows you to cache the report execution. Optionally, you can keep the cached reports in history, e.g. if the user wants to keep a copy of the report for historical analysis. Once a report is enabled for snapshot execution, you can generate the history snapshot by invoking the CreateReportHistorySnapshot API assuming you need to do so programmatically, e.g.: historyID = managementProxy.CreateReportHistorySnapshot(reportPath, out warnings); However, if your code just calls CreateReportHistorySnapshot and the end user requests the report by clicking on the report link in the Report Manager or SharePoint (if the server is configured for SPS integration with SQL Server 2005 SP2), the user will get: The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady) This error is...
-
Visual Studio 2005 Team Edition for Database Professionals
November 11, 2006 / No Comments »
The newly released CTP7 of Visual Studio 2005 Team Edition for Database Professionals (aka DataDude) now supports bi-directional schema updates. Once you generate the scripts from your database schema, you can choose either the database or the scripts as a source of changes and commit the changes to the target. Visual Studio 2005 Team Edition for Database Professionals requires Visual Studio 2005 Team Edition.
-
SQL Server 2005 SP2 CTP 2 Build Released Today
November 8, 2006 / No Comments »
The second CTP (Community Technology Preview) build of the forthcoming SQL Server 2005 Service Pack 2 was released today. Besides bug fixes, SP2 includes major BI features and enhancements including: Reporting Services SharePoint 2007 integration – this one is a true enzilla (enhancement Godzilla) and deserves a separate post. Suffice to say that unlike the previous Explorer and Viewer webparts, SP2 will allow you to move the report catalog to SharePoint to enable publishing, viewing, and managing SSRS 2005 reports within SharePoint 2007. Report Builder support for Oracle 9.2.0.3 or above (previously only SQL Server and Analysis Services 2005 were supported for Report Builder models) New .NET Data Provider for Hyperion 9.3 BI+ Essbase Enterprise Analytics Select All option has been restored with multi-valued parameters (it was disabled in SP1 for performance reasons). Analysis Services Better Excel 2007 integration – advanced filtering, cube formulas, offline cubes. Data mining add-ins for...
-
Office 2007 RTM’ed
November 6, 2006 / No Comments »
Microsoft Corp. today announced the completion of the 2007 Microsoft® Office system code and confirmed its release to manufacturing (RTM).
-
Linked Attribute Hierarchies
October 21, 2006 / No Comments »
In UDM, the cube space is defined by attribute hierarchies. Dimensions are just logical containers of attribute hierarchies. It will be great if the next release of SQL Server (Katmai) could expand further on the attribute nature of UDM and solve some nagging issues that modelers currently face. Let's consider an example. Say, you have Geography and Customer dimension tables (see the AdventureWorksDW database). It is logical to expect that end users may be willing to browse data by the Geography-Customer hierarchy. As common this requirement is, modelers today need to make some tradeoffs to meet this requirement. To start with, you could embrace the star schema and build two UDM dimensions (Geography and Customer) on top of the corresponding dimension tables. Then, the end users can drop these two dimensions side-by-side in their favorite OLAP browser to slice the data by Geography and Customer. Behind the scenes, the server...
Training
We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.For more information or to register click here!
Books
Learn Power BI at your own pace with our latest book Applied Microsoft Power BI. Targeting information workers, data analysts, pros, and developers, It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.
