My DTS Package won’t load with the error “here were errors loading package”
You are trying to open a DTS package (yes some people still use DTS packages) and receive the following error:
Error...
2014-11-03
785 reads
Blog Posts
PASS Summit 2014 Diary – Day 1
Today is the first day of official activities for the week. The PASS Summit hasn’t yet started, but I’ll be...
2014-11-03
769 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,474 reads
Setting Expectations–T-SQL Testing
I don’t know who started this pattern, as I’ve seen it in a few places. It could have been Sebastian...
2014-11-03
882 reads
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of Database Mirroring to ensure that everything is working...
2014-11-03
16 reads
SQL Server Database Mirroring Monitoring
SQL Server Database Mirroring keeps running all time to sync data between Principle & Mirror database. We need regular monitoring of...
2014-11-03
6,424 reads
SQL Server Table Partition Example
Why Use a SQL Server Table Partition
Data warehouses and data repositories often have tables that store millions of records and...
2014-11-03
5,178 reads
SQLPASS Summit 2014 is here, The largest SQLServer Conference !
November is not the right time to visit Seattle (Blame the rain!), but I kinda like November because that’s when...
2014-11-03
541 reads
What is a data warehouse and why do I need one?
While the data warehouse isn’t a new concept, many are left wondering – what is a data warehouse? And why do I need one? I’m sad to tell you...
2014-11-03
13 reads
Bon Voyage fellow PASS Summit 2014 Attendees!
For the first time ever, I will be a PASS Summit Attendee! I’m very excited about going and I’ll be...
2014-11-02
473 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Learn From History
Comments posted to this topic are about the item Learn From History
The SQL Server MCP Server
Comments posted to this topic are about the item The SQL Server MCP Server
The Hidden Danger of Wildcard Operators In Join Operations
Comments posted to this topic are about the item The Hidden Danger of Wildcard...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers