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
28 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
237 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
475 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,064 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,102 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
618 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,234 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
36 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
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Breaking SQL Server for disaster recovery practice
Hey all. I understand if this gets taken down due to the subject matter...
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers