Simon Worth’s SQL Server Weblog

SQL Server and its many complexities

Tableau 6.0 What If Modeling

with 2 comments

Tableau 6 has introduced what if modeling using parameters.  Click the link here to see a short 5 minute demo of the product in action.  It’s these little enhancements to the product that set Tableau ahead of the pack when it comes to data visualization and analysis. 

Written by Simon Worth

January 5, 2011 at 8:21 am

Posted in Analytics

Tableau 6.0 What If Modeling

with one comment

Tableau 6 has introduced what if modeling using parameters.  Click the link here to see a short 5 minute demo of the product in action.  It’s these little enhancements to the product that set Tableau ahead of the pack when it comes to data visualization and analysis. 

Written by Simon Worth

October 15, 2010 at 8:31 am

ProClarity Analytics Server Hotfix Available

leave a comment »

A new hotfix rollup package is available to fix a few issues with PAS 6.3.  Here is the link to the downloads page (by request for download).

From the website

Issues that this hotfix rollup package fixes

This hotfix rollup package fixes the following issue:
After you install ProClarity Analytics Server 6.3 Service Pack 3, you may experience one or more of the following symptoms:

  • Internet Explorer stops responding when you try to access the home page of ProClarity Analytics Server.
  • You receive a "Catastrophic failure" error message when you click the My Views menu in ProClarity Web Professional.
  • You cannot start ProClarity Web Professional. Specifically, ProClarity Web Professional stops responding during the starting process.

Written by Simon Worth

October 15, 2010 at 8:02 am

Calgary SharePoint User Group – Meeting October 21st

leave a comment »

The speaker this month will be Todd Bleeker (Microsoft SharePoint MVP) with Mindsharp.  Todd will be presenting “An Introduction to SharePoint Workflow”.

Overview:

SharePoint 2010 still makes an excellent Workflow host. This session will walkthrough creating a Visual Studio Workflow introducing concepts like: handling faults, correlation tokens, static properties, imperative properties, property binding, property bags, and workflow state in general. Some common tasks like creating a SharePoint task and sending an email will be shown along with some common gotchas that plague first timers.

 

Hope to see you there.

Simon

Written by Simon Worth

October 14, 2010 at 7:58 am

Posted in SharePoint

SQL Server 2008 Service Pack 2

leave a comment »

The team at Microsoft have released Service Pack 2 for SQL Server 2008.  The big enhancement from this SP for me is Reporting Services integration with SharePoint 2010. 

The link to the Service pack is here.  As always, test any new service packs before promoting to a production environment – and have fun.

The list of new features are as follows (directly from the Service Pack page)

  • 15K partitioning Improvement. Introduced support for a maximum of 15,000 partitions in tables and indexes in Microsoft SQL Server 2008 Service Pack 2 in the Enterprise, Developer and Evaluation Editions. For details on how this support can be enabled and disabled, along with recommended operation paramaters, see the white paper Support for 15000 Partitions.
  • Reporting Services in SharePoint Integrated Mode. SQL Server 2008 SP2 provides updates for Reporting Services integration with SharePoint products. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in to support the integration of SQL Server 2008 R2 report servers with SharePoint 2007 products. For more information see the “What’s New in SharePoint Integration and SQL Server 2008 Service Pack 2 (SP2)” section in What’s New (Reporting Services).
  • SQL Server 2008 R2 Application and Multi-Server Management Compatibility with SQL Server 2008.
  • SQL Server 2008 Instance Management.With SP2 applied, an instance of the SQL Server 2008 Database Engine can be enrolled with a SQL Server 2008 R2 Utility Control Point as a managed instance of SQL Server. For more information, seeOverview of SQL Server Utility in SQL Server 2008 R2 Books Online.
  • Data-tier Application (DAC) Support.Instances of the SQL Server 2008 Database Engine support all DAC operations delivered in SQL Server 2008 R2 after SP2 has been applied. You can deploy, upgrade, register, extract, and delete DACs. SP2 does not upgrade the SQL Server 2008 client tools to support DACs. You must use the SQL Server 2008 R2 client tools, such as SQL Server Management Studio, to perform DAC operations. A data-tier application is an entity that contains all of the database objects and instance objects used by an application. A DAC provides a single unit for authoring, deploying, and managing the data-tier objects. For more information, see Designing and Implementing Data-tier Applications.

Written by Simon Worth

September 29, 2010 at 12:59 pm

SQL Server 2008 SP1 Cumulative Update 9 Now Available

leave a comment »

Microsoft has released cumulative update 9 for SQL Server 2008 SP1.  The link to the details page can be found here.  As with most cumulative updates, Microsoft does warn against installing these packages unless you are experiencing specific issues that are addressed in the update.  SP2 will contain all cumulative updates after SP1 – so if you don’t need any of the specific fixes then it is probably best to wait for the next service pack to be released.

A few of the fixes include

  • Error message when you run a SQL Server 2005 or SQL Server 2008 Integration Services package (SSIS) after you install the .NET Framework 2.0 SP2 or the .NET Framework 3.5 SP1: "ADO NET Source [1424]"
  • Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer
  • A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008
  • A SSRS 2008 report shows duplicate first row for each group of a subreport when you export the report to CSV format
  • Blank spaces between some items are generated incorrectly in a SQL Server 2008 report
  • "Internal error: An unexpected exception occurred" error message when you run a Multidimensional Expressions (MDX) query by using time intelligence in Microsoft SQL Server Analysis Services 2008
  • A query returns inconsistent results before the data cache is warmed up in SSAS 2008

These are just a few of the fixes, visit the website for more information on all issues resolved and to get further details on how to download the updates if required.

Written by Simon Worth

July 22, 2010 at 8:28 am

Microsoft SQL Server 2008 SP2 CTP Available

leave a comment »

Microsoft has released the Community Technology Preview for SQL Server 2008 Service Pack 2.  The CTP can be downloaded from this link.  This is CTP only and should not be deployed to a production environment.  Service Pack 2 contains all the cumulative updates released after SQL Server 2008 SP1.

Service pack 2 includes

  • Compatibility for the SQL Server 2008 R2 Server Utility.  2008 SP2 servers are supported by the utility and contain the same functionality as R2 servers.
  • SQL Server 2008 R2 Supports DAC operations for SQL Server 2008 SP2
  • Reporting Services Add-in for SharePoint 2007

Written by Simon Worth

July 9, 2010 at 10:09 am