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

minikibe on windows, getting stuck on networking issues like cant connect messages?

Reading Time 1 Minute I have been getting kubernetes setup on my laptop via minikube and I followed all the examples to the T, especially the part about creating a new external network and referencing that when you create the minikube (go search for a tutorial on setting up minikube…

Read more

0 comments, 156 reads

Posted in Ed Elliott's Sql Developer Blog on 9 October 2018

TDD for SQL Server using tSQLt course certificates now available

I have been asked a few times now for course completion certificates so I have decided to give out certificates to anyone who pays for a plan and sends me a screen shot of a unit test they have written and answer a question on unit testing. I will generate…

Read more

0 comments, 193 reads

Posted in Ed Elliott's Sql Developer Blog on 18 July 2018

mentor or mentee be, be both, be neither, be happy

TLDR: There is a new exciting community slack channel where you can find a mentor, a mentee or both if that floats your boat. The great Chrissy LeMaire (https://twitter.com/cl) from dba tools and sqlcommunity.slack.com fame and general Powershell and SQL legend has started a new mentor’s slack channel. Come and…

Read more

0 comments, 173 reads

Posted in Ed Elliott's Sql Developer Blog on 6 July 2018

Deploying to Azure Without Writing JSON Arm Templates

Reading Time: 6 minutes (not a minute longer) TLDR; ARM templates are a great way to deploy to Azure, setting up a template that can deploy an entire environment from databases to web servers and load balancers to firewalls (damn you azure, ok, I’ll call it an nsg) is satisfying…

Read more

0 comments, 250 reads

Posted in Ed Elliott's Sql Developer Blog on 19 June 2018

Deploying to Azure Without Writing JSON Arm Templates

Reading Time: 6 minutes (not a minute longer) TLDR; ARM templates are a great way to deploy to Azure, setting up a template that can deploy an entire environment from databases to web servers and load balancers to firewalls (damn you azure, ok, I’ll call it an nsg) is satisfying…

Read more

0 comments, 348 reads

Posted in Ed Elliott's Sql Developer Blog on 19 June 2018

Running MySQL on a VSTS build agent

I had a requirement to run MySQL on a VSTS hosted build agent and then to be able to run commands from outside of the container and this gave me the chance to have a play around with VSTS support for containers and builds as YAML (YAML builds / builds…

Read more

0 comments, 175 reads

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

Database testing and ETL processes

Unit testing using tSQLt is really great, you call FakeTable on any tables your code touches and then insert the columns and rows your test actually need, nothing more, nothing less but what happens when you have more complicated processes like an ETL process? TLDR: the same as unit testing,…

Read more

0 comments, 2,915 reads

Posted in Ed Elliott's Sql Developer Blog on 1 May 2018

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like:


{
"comments": "Managed Disk.",
"type": "Microsoft.Compute/disks",
"name": "[variables('diskName')]",
"apiVersion": "2016-04-30-preview",
"location": "[parameters('location')]",
"tags": {
"displayName": "Data Disk 1 - Presented as LUN 0"
},
"properties": {
"accountType": "Premium_LRS",
"creationData": {
"createOption":…

Read more

0 comments, 254 reads

Posted in Ed Elliott's Sql Developer Blog on 5 April 2018

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like: { "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location": "[parameters('location')]", "tags": { "displayName": "Data Disk 1 - Presented as LUN 0" }, "properties": { "accountType": "Premium_LRS", "creationData": { "createOption":…

Read more

0 comments, 146 reads

Posted in Ed Elliott's Sql Developer Blog on 5 April 2018

Interesting Azure ARM "Make it So" behaviour

I had a template that deployed a premium managed disk and a virtual machine. I defined the disk like: { "comments": "Managed Disk.", "type": "Microsoft.Compute/disks", "name": "[variables('diskName')]", "apiVersion": "2016-04-30-preview", "location": "[parameters('location')]", "tags": { "displayName": "Data Disk 1 - Presented as LUN 0" }, "properties": { "accountType": "Premium_LRS", "creationData": { "createOption":…

Read more

0 comments, 83 reads

Posted in Ed Elliott's Sql Developer Blog on 5 April 2018

Why didnt my Azure ARM deploy work?

I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn’t have any debugging information enabled and when you run this powershell: New-AzureRMResourceGroupDeployment If you don’t have debugging information enabled, the output of a failed deployment is…

Read more

0 comments, 88 reads

Posted in Ed Elliott's Sql Developer Blog on 4 April 2018

Why didnt my Azure ARM deploy work?

I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn’t have any debugging information enabled and when you run this powershell: New-AzureRMResourceGroupDeployment If you don’t have debugging information enabled, the output of a failed deployment is…

Read more

0 comments, 86 reads

Posted in Ed Elliott's Sql Developer Blog on 4 April 2018

Why didn't my Azure ARM deploy work?

I have been using Octopus to deploy ARM templates for a while now and the default task that comes with Octopus to deploy doesn't have any debugging information enabled and when you run this powershell:

New-AzureRMResourceGroupDeployment

If you don't have debugging information enabled, the output of a failed deployment is…

Read more

0 comments, 1,567 reads

Posted in Ed Elliott's Sql Developer Blog on 4 April 2018

VSTS extensions, mixing VSS.require and import ... require

I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing a few vsts extensions and using typescript to write vsts extensions seems to be working quite nicely. One of the best things, for me, about typescript is to use type…

Read more

0 comments, 246 reads

Posted in Ed Elliott's Sql Developer Blog on 5 March 2018

VSTS extensions, mixing VSS.require and import ... require

I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing a few vsts extensions and using typescript to write vsts extensions seems to be working quite nicely. One of the best things, for me, about typescript is to use type…

Read more

0 comments, 84 reads

Posted in Ed Elliott's Sql Developer Blog on 5 March 2018

VSTS extensions, mixing VSS.require and import ... require

I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing a few vsts extensions and using typescript to write vsts extensions seems to be working quite nicely. One of the best things, for me, about typescript is to use type…

Read more

0 comments, 94 reads

Posted in Ed Elliott's Sql Developer Blog on 5 March 2018

gdpr - panic part 4

In the first part of this series, we looked at where to find out more information about GDPR in the UK (hint: The ICO.gov website has everything you need). In the second part, we looked at some historical enforcement action by the ICO against companies who had made a mistake…

Read more

0 comments, 2,019 reads

Posted in Ed Elliott's Sql Developer Blog on 8 February 2018

gdpr - panic part 4

In the first part of this series, we looked at where to find out more information about GDPR in the UK (hint: The ICO.gov website has everything you need). In the second part, we looked at some historical enforcement action by the ICO against companies who had made a mistake…

Read more

0 comments, 86 reads

Posted in Ed Elliott's Sql Developer Blog on 8 February 2018

gdpr - panic part 4

In the first part of this series, we looked at where to find out more information about GDPR in the UK (hint: The ICO.gov website has everything you need). In the second part, we looked at some historical enforcement action by the ICO against companies who had made a mistake…

Read more

0 comments, 74 reads

Posted in Ed Elliott's Sql Developer Blog on 8 February 2018

tSQLt Course

In the last half of 2017, I decided to run a tSQLt course and went down the route of putting together a free 12-week email course. The intention was that every week students would get a bit of a description about how unit testing T-SQL using tSQLt works and a…

Read more

0 comments, 2,922 reads

Posted in Ed Elliott's Sql Developer Blog on 6 February 2018

Older posts