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

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, 93 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,736 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, 167 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, 77 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, 25 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, 29 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, 35 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,459 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, 161 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, 22 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, 26 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, 1,898 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, 23 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, 26 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,723 reads

Posted in Ed Elliott's Sql Developer Blog on 6 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, 39 reads

Posted in Ed Elliott's Sql Developer Blog on 6 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, 35 reads

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

Re-Imagining an SSIS IDE

Re-Imagining the SSIS development environment.

oooh:

ahhh:


SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out of SQL Server. The development environment, BIDS and now SSDT allow developers to create, edit and debug SSIS package. I struggle with the actual IDE. The thing…

Read more

0 comments, 319 reads

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

Re-Imagining an SSIS IDE

Re-Imagining the SSIS development environment. oooh: ahhh: SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out of SQL Server. The development environment, BIDS and now SSDT allow developers to create, edit and debug SSIS package. I struggle with the actual IDE. The thing…

Read more

0 comments, 24 reads

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

Re-Imagining an SSIS IDE

Re-Imagining the SSIS development environment. oooh: ahhh: SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out of SQL Server. The development environment, BIDS and now SSDT allow developers to create, edit and debug SSIS package. I struggle with the actual IDE. The thing…

Read more

0 comments, 21 reads

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

Older posts