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,305 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,187 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
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers