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 to object [XXX].[XXX].”
If the code that is failing is...
2017-11-06
35 reads
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
118 reads
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
43 reads
SSISDB for SQL Server Integration Services
Microsoft introduced some major changes in SQL Server Integration Services with SQL Server 2012.
Brand new “SSISDB” database launched as SSIS...
2017-11-16 (first published: 2017-11-06)
24,121 reads
dbatools at PASS Summit 2017
I registered for Summit about a month before getting actively involved in the dbatools project, so when I saw the team was running a pre-con and I was going...
2017-11-06
14 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
712 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
483 reads
A View On Views
In my experience, there are few database objects more poorly understood, misunderstood, misused, and outright abused, than the humble view....
2017-11-16 (first published: 2017-11-05)
1,997 reads
Over-Indexing can hurt your SQL Server performance
Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...
2017-11-15 (first published: 2017-11-05)
5,241 reads
PASS Summit 2017 Day 2
It’s day 2 of the PASS Summit. Yesterday was a whirlwind of a day, after my early-morning post-Halloween trip to...
2017-11-02
643 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers