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,828 reads
Data Adventures
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,631 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,099 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,941 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,467 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,155 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
897 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,793 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,220 reads
SSRS report subscription: Fire Event from SSIS package
My previous two posts about SSRS reports being deployed to a SharePoint site along with their subscription didn't stop me...
2014-07-29 (first published: 2014-07-22)
14,488 reads
Blogs
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated Database Recovery for tempdb in SQL Server 2025
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Deleting data in large table
I have a large table with 17M+ rows for our package record audits. I've...