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

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, 98 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, 406 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, 53 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, 46 reads

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

gdpr - panic part 3

In part three of this short series

Part one is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-1
Part two is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2
This is part three: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/gdpr-panic-part-3

In part two I started looking at previous enforcement action taken by the ICO, Talk Talk (3!!! times) and the historical society:

https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2

In this part, we will start by…

Read more

0 comments, 241 reads

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

gdpr - panic part 3

In part three of this short series Part one is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-1 Part two is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2 This is part three: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/gdpr-panic-part-3 In part two I started looking at previous enforcement action taken by the ICO, Talk Talk (3!!! times) and the historical society: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2 In this part, we will start by…

Read more

0 comments, 31 reads

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

gdpr - panic part 3

In part three of this short series Part one is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-1 Part two is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2 This is part three: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/gdpr-panic-part-3 In part two I started looking at previous enforcement action taken by the ICO, Talk Talk (3!!! times) and the historical society: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2 In this part, we will start by…

Read more

0 comments, 19 reads

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

gdpr - panic part 2

Welcome GDPR friends :)

Part one is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-1
This is part two: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2
Part three is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/gdpr-panic-part-3

In this part, I am going to have a look at previous action the ICO has taken to give some context to the scary sounding 4% turnover or millions of pounds you will…

Read more

0 comments, 235 reads

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

gdpr - panic part 2

Welcome GDPR friends :) Part one is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-1 This is part two: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2 Part three is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/gdpr-panic-part-3 In this part, I am going to have a look at previous action the ICO has taken to give some context to the scary sounding 4% turnover or millions of pounds you will…

Read more

0 comments, 17 reads

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

gdpr - panic part 2

Welcome GDPR friends :) Part one is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-1 This is part two: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/GDPR-Panic-Part-2 Part three is: https://the.agilesql.club/blogs/Ed-Elliott/2018-02-01/gdpr-panic-part-3 In this part, I am going to have a look at previous action the ICO has taken to give some context to the scary sounding 4% turnover or millions of pounds you will…

Read more

0 comments, 21 reads

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

gdpr - panic part 1

GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you need to know and where do you start?

This post is based on how gdpr will apply to the UK. I have nothing against the EU, but in the UK…

Read more

0 comments, 261 reads

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

gdpr - panic part 1

GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you need to know and where do you start? This post is based on how gdpr will apply to the UK. I have nothing against the EU, but in the UK…

Read more

0 comments, 47 reads

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

gdpr - panic part 1

GDPR is coming (or if you are reading this in a few weeks then gdpr is here, what do you need to know and where do you start? This post is based on how gdpr will apply to the UK. I have nothing against the EU, but in the UK…

Read more

0 comments, 34 reads

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

Azure ARM template function internals

I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite a pain to work with, visualizing what it is that the functions will resolve to is often hard.

If you haven't used an ARM template, ARM templates are JSON documents…

Read more

0 comments, 380 reads

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

Azure ARM template function internals

I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite a pain to work with, visualizing what it is that the functions will resolve to is often hard. If you haven’t used an ARM template, ARM templates are JSON documents…

Read more

0 comments, 17 reads

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

Azure ARM template function internals

I have been working with azure arm functions for quite a while and they are exceptionally useful but also quite a pain to work with, visualizing what it is that the functions will resolve to is often hard. If you haven’t used an ARM template, ARM templates are JSON documents…

Read more

0 comments, 17 reads

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

xSQLServer is dead long live SqlServerDsc

I have had a problem with DSC in Azure Automation for a few months now, there was a change made to the xSqlServer DSC resource which meant that the paths internally were too long to be compiled on Azure Automation, I don't even really want to think why because the…

Read more

0 comments, 284 reads

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

xSQLServer is dead long live SqlServerDsc

I have had a problem with DSC in Azure Automation for a few months now, there was a change made to the xSqlServer DSC resource which meant that the paths internally were too long to be compiled on Azure Automation, I don’t even really want to think why because the…

Read more

0 comments, 26 reads

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

xSQLServer is dead long live SqlServerDsc

I have had a problem with DSC in Azure Automation for a few months now, there was a change made to the xSqlServer DSC resource which meant that the paths internally were too long to be compiled on Azure Automation, I don’t even really want to think why because the…

Read more

0 comments, 17 reads

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

What The Tool? Multiple choice quiz to help you choose a tool for SQL Server

There are a few different choices for tools to use when it comes to SQL Server, while the "experienced" amongst us have used query analyzer, enterprise manager and probably ssms it isn't always clear what tool you should use. If you consider sql operations studio and vscode it is a…

Read more

0 comments, 297 reads

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

Newer posts

Older posts