SSDT How To Fix Error SQL17502
TLDR: If you build an SSDT project you can get an error which says:
“SQL71502: Function: [XXX].[XXX] has an unresolved reference...
2017-11-06
113 reads
Blog Posts
SSIS Basics: Integration Services Catalogs
In the new Project deployment model for SQL Server Integration Services, a new SQL Server database is used to provide...
2017-11-06
235 reads
An attempt at creating a "universal", set-oriented, near-real-time ODS ETL interface
Defining the Problem
Imagine I have two different systems - say, a CRM and an ERP - on different SQL Servers. Both systems...
2017-11-05
473 reads
PASS Summit 2017 – the best ever
I have been a PASS summit attendee for 14 years now. This year is my 15th. Every year is different...
2017-11-05
708 reads
A virtualized CPU forced me to eat my lunch early, every day, for weeks
I worked one particular contract where I was forced to take my lunch at 11:35 every day, and it was...
2017-11-03 (first published: 2017-10-21)
4,062 reads
SQL Clone Server Service Permissions
SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series...
2017-11-03 (first published: 2017-10-23)
1,101 reads
An overview of Python vs PowerShell for SQL Server Database Administration
Today, Microsoft claims that Linux runs like a First-Class citizen on Azure, .NET Core has been open-sourced, and has been...
2017-11-02
616 reads
But I Don't *Want* To "Restore from a backup of the database or repair the database!"
Do you like Log Shipping?
Before my time at Ntirety I had done quite a bit of work with failover clustering...
2017-11-02 (first published: 2017-10-23)
3,231 reads
Contained Databases
Today's post is in regards a feature that was released with SQL Server 2012, it hasn't gotten the attention or used that it deserves even when it helps solving...
2017-11-02
34 reads
Microsoft MVP!?
What? Is probably the most common reply out there and if it is then that is how I felt when...
2017-11-02
406 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers