SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Archives: August 2012

SQL Server 2012 and SharePoint 2013: Installing on a Virtual Machine

With the preview of SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to use SharePoint 2013 instead of SharePoint 2010.  If you would like to get a head start on learning what is new with SharePoint 2013 and Excel 2013, follow… Read more

11 comments, 15,407 reads

Posted in James Serra's Blog on 27 August 2012

Excel 2013 and BI

On July 16, 2012, Office 2013 Preview was released to the public (download).  Excel 2013 now includes a lot of the SQL Server BI components directly in the initial install, as well as enhancements made to the business intelligence (BI) capabilities in Excel.  Here are the details:

  • Much…

Read more

0 comments, 1,835 reads

Posted in James Serra's Blog on 15 August 2012

PerformancePoint 2013 and SharePoint 2013

PerformancePoint is an important BI Tool in the Microsoft world and it will continue to be Microsoft’s solution for creating interactive, context-driven dashboards with balanced scorecards, key performance indicators, analytic reports, and filters.  There is no doubt it is an integral part of Microsoft’s Business Intelligence offering,

Fortunately there are… Read more

0 comments, 2,885 reads

Posted in James Serra's Blog on 13 August 2012

Prevent wiping out of SSAS partitions

There have been a few times when I have created SSAS partitions outside of BIDS using script code in an SSiS package, then later made a change in BIDS and deployed the cube, wiping out those partitions (since they did not exist in the BIDS project).

To prevent partitions getting… Read more

1 comments, 1,003 reads

Posted in James Serra's Blog on 1 August 2012