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,799 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,636 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,137 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,953 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,924 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
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Fuzzy String Matching in SQL Server 2025
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Representing Money
Comments posted to this topic are about the item Representing Money
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers