SQL Server 2012 RC0 Released

Hello all, Just to share with you a summary with the news, publicly available, about SQL Server 2012 RC:   Technorati Tags: SQL Server 2012 RC0,What’s new   Official Release Information               SQL Server 2012 Release Candidate is now Available! http://blogs.technet.com/b/dataplatforminsider/archive/2011/11/17/sql-server-2012-release-candidate-is-now-available.aspx       Requirements & Specifications     Hardware and Software Requirements for…


Can PerformancePoint have interactive features?

Hi again, Do you know you can add interactive features to your dashboard in PerformancePoint with SSAS actions? It’s really easy, fast and it can give your business analysis the 5 stars user experience.   PerformancePoint can use Bing. Add a new SSAS URL action to your cube and allow users to get more information…


How to configure cascading filters in Dashboard Designer (SharePoint 2010 SP1)

Hello, In the past I posted the new SharePoint SP1 features for PerformancePoint Services which included the new cascading filters option. In this post, I’m going to show you the basic steps to achieve this goal with Dashboard Designer in SharePoint 2010 SP1. Goal: Create a set of two or more filters where the output…


SQL Server 2008 SP3 RTM

  Hi, Last week, it was released the SP3 of SQL Server 2008: SQL Server 2008 Service Pack 3 Microsoft SQL Server 2008 SP3 Express Edition Microsoft SQL Server 2008 Service Pack 3 Feature Pack Release Notes Readme The following article includes the list of issues that are fixed by the SP3: List of issues…


Auto Update Statistics Asynch – Are you really, really using it?

Hello all, It’s been awhile since I’ve updated the blog from my part. It’s been a rough month, and I’ve been on vacation prior to that, but I’m back. What I want to get your attention in this post is to the “Auto Update Statistics Asynchronously” database option. Not to discuss in which scenarios to…

0

What’s new in Performance Point Services (SharePoint 2010 SP1)

Hi, In the continuation of our Business Intelligence series in our Ezequiel Blog, I’m making this post to announce the release of SharePoint 2010 SP1 and the new features that have been included. From a BI perspective there are several functionalities and features that have been fixed or added to the product. You can go the…


SQL Swiss Army Knife #10 – VLFs again. What’s your current status?

EDIT (11-01-2011): A parenthesis was missing making the log_size_MB value skewed. Thanks Luis! EDIT (26-03-2012): Updated script for SQL 2012 support. EDIT (19-11-2012): Added information from Fixing VLFs post, namely potential log size after fix, actual number of VLFs, amount of used VLFs, potential number of VLFs after fix, how many growth iterations to achieve…


Notes about SQL Server 2008 R2 SP1

  Hi, The purpose of this post is to share some notes (links) about the recent release of SQL Server 2008 R2 SP1: SQL Server 2008 R2 SP1     Technorati Tags: SQL Server 2008 R2 SP1,Service Pack       Download     http://www.microsoft.com/download/en/details.aspx?id=26727           List of bugs that are…


MOSS, BizTalk, SCOM and SQL Server Collations

Hello all, The topic today is database and server collations. As part of pre-installation tasks for SQL Server, we should always take into account what is the collation required by the user databases. Why is that? Collation is a subject many times overlooked when installing SQL Server, and many just use the default when installing…