-->
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!

ARMED - Where is the source?

ARMED, where is the source?

For quite a few years I’ve been putting everything I wrote on github and made most of it open source with a permissive license like MIT or Apache2. If anyone asked then I would be happy to change any licenses, whatever they wanted but with…

Read more

0 comments, 82 reads

Posted in Ed Elliott's Sql Developer Blog on 9 December 2017

ARMED - ARM resource dependency graph inside VSCode

I think the title sums it up, I have published a new version of ARMED the arm helper extension for VSCode.

This version includes the ability to see a graph of the resources and how they relate to each other:

There are a couple of limitations at the moment this…

Read more

0 comments, 133 reads

Posted in Ed Elliott's Sql Developer Blog on 8 December 2017

ARMED - Azure ARM VS Code extension

I have been working with ARM templates for a little while and have found it really annoying to test functions inside the templates, you see if you have an ARM template it is a JSON document made up of lots of key/values like:

{"name": "a_name"}

but it is slightly more…

Read more

0 comments, 168 reads

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

Azure Virtual Machine + Premium Disk Throughput Calculator

I keep having to refer to the virtual machine size page and the disks pricing page to work out how best to stripe disks for whichever type of virtual maching in Azure to work out what sort of throughput we can get so I thought I would save myself some…

Read more

0 comments, 100 reads

Posted in Ed Elliott's Sql Developer Blog on 2 December 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, 97 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, 164 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, 196 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, 143 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, 101 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, 106 reads

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

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

Read more

0 comments, 168 reads

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

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 all virtualisations fault!

To set the scene it was a company who wasn't really used to having developers, they had a load of SQL analysts and some mainframe developers but…

Read more

0 comments, 3,076 reads

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

Where do you install tSQLt?

The question of where to install tSQLt is probably the most common question I get when I talk about unit testing T-SQL, so much so that I thought that it would be a good topic for a blog. I mention tSQLt in the title, but this covers all unit test…

Read more

0 comments, 509 reads

Posted in Ed Elliott's Sql Developer Blog on 19 October 2017

tSQLt Test Adapter for Visual Studio 2017

So Visual Studio 2017 has been released a while and I had created a version of the test adapter (which lets you run tSQLt tests from within Visual Studio with SSDT, ReadyRoll or just plan sql scripts using the test window but I held off on pushing it to the…

Read more

0 comments, 157 reads

Posted in Ed Elliott's Sql Developer Blog on 3 October 2017

Learn how to unit test SQL Server T-SQL code

A free email course on how to use tSQLt including the technical aspects of writing unit tests AND the art of writing repeatable, useful unit tests for even the most complicated T-SQL code

UPDATE: I thought that if I got a certain number by October 1st I would run the…

Read more

0 comments, 229 reads

Posted in Ed Elliott's Sql Developer Blog on 5 September 2017

SSIS ForEach Enumerator File Order

I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically doesn't order) files. I have been thinking about ssis quite a lot lately and whil I am in no hurry to start using it day to day it is quite an interesting tool.

Read more

0 comments, 138 reads

Posted in Ed Elliott's Sql Developer Blog on 1 September 2017

TSQL Tuesday - Databases and DevOps

DevOps isn't running SQL Server in a container and pushing code to it from Jenkins

When we talk about DevOps we envision that we have the ability to check-in code, spin up a new environment, deploy, test and push that code to production and be in the pub at 4.…

Read more

0 comments, 207 reads

Posted in Ed Elliott's Sql Developer Blog on 13 June 2017

SSDT: Unable to connect to master or target server.

Every now and then I come across this error in SSDT, normally when trying to publish and the odd thing is that the description never matches the actual cause (if you desperate for the cause it is because you can't connect). The thing I like about the description is the…

Read more

0 comments, 224 reads

Posted in Ed Elliott's Sql Developer Blog on 12 June 2017

SSDT DevPack + Visual Studio 2017

I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and have started to think about how to improve it going forward.

The first feature of sorts is the ability to clear the connection used by the quick deployer without having…

Read more

0 comments, 708 reads

Posted in Ed Elliott's Sql Developer Blog on 8 May 2017

SSDT Dev in Visual Studio Code

I have been quite interested by vs code and have been using it more and more recently. I use it for all my GO (#golang FTW) work and also powershell and I have been toying with the sql tools team's sql extension which is great. For a long time I…

Read more

0 comments, 1,671 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2017

Older posts