SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Ed Elliott's Sql Developer Blog

Ed is a Sql developer who has a mixed background in support, as a dba and as a developer working with a number of languages c, c#, vb, go, assembly with a variety of technologies and is currently trying to make the sql developer community a little bit more agile, one build step at a time!

Archives: November 2017

Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)

I was setting up an availability group listener recently and when I tried to connect to the listener I got an error message to say "The host cannot be found" after the usual 15 seconds connection delay.

I checked the usual thing like TCP was enabled on the replicas and…

Read more

0 comments, 147 reads

Posted in Ed Elliott's Sql Developer Blog on 30 November 2017

"the input device is not a TTY" error running docker on VSTS build agent

I have been playing around with including all my build dependencies in docker for windows lately and had a build that kept giving me this error in the build log:

"the input device is not a TTY. If you are using mintty, try prefixing the command with 'winpty'"

The command…

Read more

0 comments, 206 reads

Posted in Ed Elliott's Sql Developer Blog on 22 November 2017

How do I use VSTS variables in YAML CI Build definitions?

Hey, VSTS YAML builds are my new favorite thing, by like a million miles.

If you have a yaml build definition ( .vsts-ci.yml ) and you want to use one of the build variables then it isn't totally clear how to include them in a definition (it hasn't been out…

Read more

0 comments, 242 reads

Posted in Ed Elliott's Sql Developer Blog on 21 November 2017

You have your database in source control now what?

This post is for a specific type of person if you are:

  • New to source control
  • Are getting started on your path to the continuous delivery nirvana
  • Have been able to get your database into some sort of source control system
  • Have more than one person checking in code to…

Read more

0 comments, 163 reads

Posted in Ed Elliott's Sql Developer Blog on 16 November 2017

Running any AzureRM powershell command tells you to "Run Login-AzureRmAccount to login." even though you are logged in!

Every AzureRM command I was running I would get an error message telling me to login, I then did a login, checked that I had the right subscription and I was still getting the error message - after logging in 7 times I figured that maybe there was something else…

Read more

0 comments, 126 reads

Posted in Ed Elliott's Sql Developer Blog on 15 November 2017

Watching for powershell changes and running Invoke-Pester

It seems like more and more recently I have been writing powershell and typescript rather than c# and t-sql and there are quite a few things to like about the tools for both of these (typescript and powershell). One thing I really like with typescript and javascript in general is…

Read more

0 comments, 128 reads

Posted in Ed Elliott's Sql Developer Blog on 14 November 2017

SSDT How To Fix Error SQL17502


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 trying to use something in the "sys" schema or the "INFORMATION_SCHEMA" schema then you need to add a database…

Read more

0 comments, 205 reads

Posted in Ed Elliott's Sql Developer Blog on 6 November 2017