When moving to SQL Server 2012, ETL developers would need to rethink custom ETL frameworks. If you embrace the new project deployment model, SQL Server 2012 offers a lot of […]
Scenario: Processing a 100 GB SSAS 2012 cube on a dedicated DELL PowerEdge server (128 GB RAM with 32 logical cores) reveals that 50% of the time is spent on […]
I have a talk “The Personal-Team-Organizational BI Conundrum” at SQL Saturday on April 14th at 9 AM. Confused about the BI alphabetical soup? Not sure which one makes sense for […]
Issue: Previewing a Report Builder report connected to Analysis Services works in Report Designer but it fails in Report Builder 3.0 with the following error: An existing connection was forcibly […]
Question: How do I find the source column name in PowerPivot if I’ve renamed and moved columns around? Answer: Assuming that the table doesn’t use a custom query to import […]
Apparently, the name “VertiPaq” wasn’t catchy enough so Microsoft rebranded it as xVelocity (probably got tipped by Comcast). This is just a name change, no new features. Glossary xVelocity: The […]
Fellow MVPs have just released the latest public beta build of BIDS Helper, which should one of the first utilities you install after you install SQL Server on your machine. […]
To continue my Report Server Settings in SQL Server 2012 SharePoint Integration Mode blog, here is another example of how to use the new PowerShell-based configuration mechanism to hide a […]
I upgraded SQL Server 2012 from RC0 to RTM today on a SharePoint application server which was configured for Reporting Services integration. The upgrade went with no errors but I […]
I’ve been honored to be selected by Microsoft to present the Self-service BI using PowerPivot and Power View session for the SQL Server Special Ops Tour in Atlanta on Monday, […]
