By need

By role

Edward Elliott

Edward Elliott

Ed is London, UK based Sql Server and .Net developer who has a worked for almost 15 years in a mixture of support, development and database administration. Ed is passionate about Sql Server development and loves using tools such as tSQLt, Sql Server Data Tools, DacFx Api and ScriptDom to deliver automated and testable solutions. Follow Ed through his blog at http://sqlserverfunctions.wordpress.com/ or ed.elliott@outlook.com

Edward Elliott
18 August 2017
Edward Elliott
18 August 2017

Azure Resource Manager (ARM) Templates

2
19
If you need a way of deploying infrastructure-as-code to Azure, then Azure Resource Manager (ARM) Templates are the obvious way of doing it simply and repeatedly. They define the objects you want, their types, names and properties in a JSON file which can be understood by the ARM API. Ed Elliott takes the mystery out of a simple means of specifying your Azure environment, whether it is a VM with blockchain software, SQL Server or a Web App on Linux with PostgreSQL … Read more
2
19
Edward Elliott
19 May 2017
Edward Elliott
19 May 2017

Continuous Database Deployment with Confidence

1
3
To achieve gains from Database Lifecycle Management in general, and in Continuous Deployment in particular, it pays to aim for lightweight but consistent techniques and processes, refining them iteratively in the light of experience. Edward Elliott describes a Test-driven development process for developing SQL Server databases that worked for CD, based on a series of steps. Though the tools for CD may be necessary, they are not sufficient, without an effective structured process.… Read more
1
3
Edward Elliott
13 April 2017
Edward Elliott
13 April 2017

A DLM Approach to Database Testing

0
12
Database Lifecycle Management aims to make the development and modification of databases more predictable. Bugs are the source of more unpredictability than anything else, purely because it is so difficult to guess how long it will take to fix them. Good testing at all stages may take some time and effort, but it greatly reduces likelihood of the wildcard factor of the bug that is first detected during the deployment process; or worse, that gets into the production release.… Read more
0
12
Edward Elliott
24 February 2017
Edward Elliott
24 February 2017

What is the Go Language, and Why is it Useful?

2
5
When Google announced the 'Go' language in 2009 we were all underexcited. After all, a compiled, statically typed language in the tradition of Algol and C isn't that radical, especially one that eschewed generic programming, implicit type conversions, assertions, inheritance and pointer arithmetic. However, it has proved to be robust, highly-portable, simple to use, and productive to work with. Ed Elliott reckons that it is definitely worth checking it out. … Read more
2
5
Edward Elliott
04 October 2016
Edward Elliott
04 October 2016

Which Edition of SQL Server is Best for Development Work?

7
23
You might think, as a developer, that nothing but the best is good enough as a development database. You might be mistaken. There is a lot to be said for LocalDB, but Ed Elliott argues that every edition has its pros and cons, and you need to consider Cloud-based resources, VMs and Containerised databases too. There is a whole range of alternatives and how you choose depends on the type of database you are developing, but for Ed, LocalDB gets the five-star accolad… Read more
7
23
Edward Elliott
16 November 2015
Edward Elliott
16 November 2015

SQL Server Data Tools (SSDT) and Database References

1
21
SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other databases even if they are on other servers. Although it is adds an extra level of complexity to deployments, it can increase the probability that deployments will succeed without errors due to broken references or binding errors.… Read more
1
21
Edward Elliott
21 July 2015
Edward Elliott
21 July 2015

Non-Breaking Online Database Deployments

1
13
For an experienced database developer, the idea of doing non-breaking database deployments while the database is still online holds respect but only a little fear. If your test procedures are good, you attend to the detail, and the application interfaces are properly managed, it can be achieved. Ed Elliott explains some of the issues to tackle.… Read more
1
13
Edward Elliott
22 September 2014
Edward Elliott
22 September 2014

Improving the Quality of SQL Server Database Connections in the Cloud

4
47
To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile, TDS is still used to connect to databases in the cloud, but you need to use a combination of the new features such as connection pools and idle connection resiliency to make applications faster and more reliable. … Read more
4
47
Edward Elliott
03 December 2009
Edward Elliott
03 December 2009

A Look at Exceptions in .NET Applications

1
25
Memory dumps are a wonderful way of finding out what caused an exception in a managed .NET application, particularly if it is happening in a production application. It is when tracking exceptions in applications where you can't use Visual Studio that the techniques of using cdb and sos.dll come into their own. They may nor be skills that you need to use regularly, but at some point, they will be invaluable. Edward supplies sample memory dumps and gives you a simple introduction.… Read more
1
25
Edward Elliott
14 October 2009
Edward Elliott
14 October 2009

.Net Debugging? Don’t give me none of your VS

10
26
Visual Studio is fine for most debugging purposes. Just occasionally, it isn't practicable, or there are other quicker ways of doing it with a user-mode debugger. Edward argues that debugging in MSIL or assembly language is a strangely liberating experience and can be a lightweight route to discovering the cause of elusive bugs. He starts off with a simple introduction to SOS debugging.… Read more
10
26