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
690 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,916 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,291 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,137 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
637 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,985 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,228 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
485 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
871 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
659 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers