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,804 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,842 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,638 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,163 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,957 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,473 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,165 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,942 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
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Why SQL Server Database Attach fails and how to repair it
Comments posted to this topic are about the item Why SQL Server Database Attach...
Fixing P1 Queries
Comments posted to this topic are about the item Fixing P1 Queries
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers