SharePoint Reports and Scorecards on Apple Devices
While some people may consider this topic off limits the fact remains that more and more companies are adopting Apple...
2011-12-19
697 reads
Bradley Schacht
The ‘Microsoft.Ace.OLEDB.12.0' Provider Is Not Registered on the Local Machine
If you have used SSIS to move data from something like Access or more commonly Excel, it is a good...
2011-12-16
36,922 reads
PowerPivot Data Connection Error
PowerPivot report returns the following error from Excel Services:
The data connection uses Windows Authentication and user credentials could not be...
2011-12-15
1,304 reads
Installing SharePoint 2010 and SQL Server 2012 RC0
With SQL Server 2012 right around the corner and Release Candidate 0 already out there I’m sure you will all...
2011-12-14
5,185 reads
Content Shift, Still SQL, Just More SharePoint
Many of you may have notice that I have been a little inconsistent with my posts lately. It’s been a...
2011-11-20
642 reads
Find Recently Run Queries
If you have ever closed a query window by accident only to wish you could get back your work an...
2011-11-03
3,993 reads
SSIS Variable and Expressions Followup
Over the last week I have done several sessions either for the Pragmatic Works Free Training online or at SQL...
2011-09-30
4,249 reads
Posting This Week
I just wanted to do a quick post to let everyone know that I am in fact going to be...
2011-09-28
490 reads
SSIS Variables and Expressions Webinar Recording
Thank you to everyone who attended my free webinar hosted by Pragmatic Works yesterday (September 20, 2011) on SSIS Variables...
2011-09-21
877 reads
SSIS Variables and Expressions Webinar
Looks like it is that time again… for me to present a FREE webinar for good ol’ Pragmatic Works today...
2011-09-20
669 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers