Scheduling Backups with SQL Server Express

SQL Server 2012 Express is the free and lite version of the Microsoft database offering for small stuff.   Some of the opportunities SQL Server Express edition provides is extensive, for example, someone running a Microsoft Access database can take advantage of linked tables on SQL Server instead of storing the data inside Access.   This might be enough to […]

PowerPivot as a data source for Performance Point 2010

Here’s a quick run down of some considerations for using PowerPivot as a data source for Performance Point 2010. First, make sure your integrated Microsoft Business Intelligence SQL Server 2012 Sharepoint 2010 environment has Service Pack 1 applied http://www.microsoft.com/en-au/download/details.aspx?id=35575.  The assumption here is you already have SQL Server 2012 PowerPivot integrated with Sharepoint 2010.    Now, as […]

Excel 2013 – Data Explorer Add-in Updates

Data Explorer is a new preview add-in for Excel 2013 that allows advanced data manipulation techniques, previously only available in SQL Server products. The new release of the add-in includes a few new features, but more importantly bug fixes which might have frustrated you if you downloaded the release a short time ago.  Read about […]

Excel 2013 Geoflow – Where to Buy Cannabis in Chicago ?

Project codename “GeoFlow” Preview for Excel 2013 allows you render geographic data, analyse that data and create interactive tours for your end users – all in 3D.   Much more fun than looking at tabular data in a spreadsheet.  Now onto more important stuff, where to buy Cannabis in Chicago ? Download the Public Preview […]

Excel 2013 PowerPivot Charts : Format Data Labels as Percentage

You want to add Data Labels to your Excel 2013 PowerPivot chart and format as a Percentage. First right click on your chart bar or line, select “Add Data Labels”, then “Add Data Labels” again.   This will add a data label, but you now need to format it.  Right click the actual data label […]