Updating PowerPivot model and PowerView report with PowerShell
Before I start describing a problem that my PowerShell script helps to resolve, these are a few blog posts of...
2015-06-18
4,801 reads
Data Adventures
Powershell for SSRS in SharePoint: Multiple data sources and shared datasets
I thought that I would leave any further attempts to improve my Powershell script that was used to deploy SSRS...
2015-05-14
3,839 reads
Big Data Hackathon in Microsoft Canada: Power Map will find your way!
Big Data, what a term! Some people instantly think of a huge sometimes cumbersome volume of information, others define it...
2015-04-10
1,637 reads
SSRS report footer is NOT lost in Excel
With all the recent changes and updates within the Microsoft PowerBI universe, SSRS core technology gets less and less attention....
2015-04-07 (first published: 2015-03-31)
14,154 reads
PowerPivot Saga 2: DAX OR function (OR there is something better)
I didn't realize that the DAX OR function only accepts 2 arguments compared with the similar function in Excel where a limit of...
2014-12-24
12,954 reads
PowerPivot Saga: Scheduled Refresh more than once a day
PowerPivot data models in Excel is a great way to quickly pull data from various sources, build relationship between different...
2014-11-03
2,472 reads
SSRS report rendered in EXCELOPENXML then something went missing
Recently I had been requested by a client to look into one of their SSRS reports issues. They had one...
2014-10-16
3,161 reads
SSIS Pivot makes you stronger
At the recent Toronto SQL Server User group meeting Michal J Swart (@MJSwart) gave a good presentation based on 10...
2014-10-15
901 reads
SSRS report: Multi-value parameter going after Data-driven subscription
It is always good to enrich SSRS reports with multi-value parameters; users have more flexibility to combine different reporting scenario...
2014-09-03 (first published: 2014-08-27)
27,932 reads
Power View report migration from SharePoint 2010 to 2013
With the latest changes to the Microsoft Power BI and ability to create Power View reports within an Excel file...
2014-07-31 (first published: 2014-07-24)
8,224 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers