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
893 reads
Data Adventures
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,612 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,213 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,447 reads
SSRS reports in SharePoint mode, Saga #2: PowerShell generates email subscriptions
Life is full of opportunities, it only takes to notice and use them. About 3 months ago I wrote a...
2014-07-07
2,775 reads
And I wonder, where that column is?
I wouldn't have decided to write this post if I didn't see my boss at one of my previous jobs...
2014-04-30
1,701 reads
PowerShell, help me to publish my SSRS reports to SharePoint!
Every time when I heard the word 'PowerShell' it was just like a call to Terra Incognito, you know nothing...
2014-03-18 (first published: 2014-03-09)
8,440 reads
SQL Server and MS Access 2013 are still friends in Azure!
With more and more features being added to the SQL Server I started thinking that its friendship with MS Access...
2014-02-13
2,171 reads
My Visual Studio crashed and I didn't know why!
Recently I had to develop a simple ETL task with the help of SSIS to transfer an Excel data file...
2014-01-31
1,298 reads
Blogs
The Data API Builder Start and Add Extensions in VS Code
By Steve Jones
One of the things that I like about the Data API Builder (DAB) is...
Using OneLake for Excel Files in Microsoft Fabric
By DataOnWheels
Hey data friends! This blog is to discuss an edge case I’ve run into...
Another AI Faux Pax
By Steve Jones
I was experimenting with a local model (article) and as a part of this,...
Forums
AD, powershell and ssis
Hi, i have a requirement that involves visiting multiple folders in AD for active,...
File date from Extended Event .xel files
I know this, but I do not remember it. I have scoured by saved...
SSMS gets very messy
At work we have quite a few databases that I'm frequently browsing. This is...
Question of the Day
Sparse Column Defaults
What are the restrictions for defaults on columns declared as sparse?
See possible answers