Annette Allen

Annette is a Microsoft SQL Server MVP, and has been a SQL Developer since 2000, starting work with a London City based Law firm before moving to Cornwall and working as a part Developer part Managerial role. She then worked as Developer for a health care company and in 2015 joined the University of Exeter where she was the SQL Server DBA. Now Annette is working as a remote DBA for WellData, a leading UK provider of database support.

Contact Annette:

Email: annetteallen69@gmail.com
Twitter: @Mrs_Fatherjack

Follow Annette Allen via
10 March 2019
10 March 2019

SQLBits and Data in Devon 2019

0
0
This is my first blog in a while and I’m sorry it’s not a technical one.  You may be aware but I’m one of the SQLBits organisers which means that for the last few months all my spare time has been devoted to SQLBits organisation. We were really pleased with how the event went and … Read more
0
0
12 July 2018
12 July 2018

I’m presenting this year

0
2
This year I decided that I wanted to give more back to the community in the way of sharing my (limited) knowledge.  The first thing I did was talk to the folks at Redgate and started blogging.  I haven’t presented a session for a while because I’m usually too busy organising events but I decided … Read more
0
2
10 June 2018
10 June 2018

Installing and setting up TeamCity

0
3
 I’ve just started a project where I’ve had to set up Team City from scratch.  Whilst I’ve used Team City extensively I’ve never had to start from the beginning, so I thought I’d document the steps I took. TeamCity is a Continuous Integration tool is free to use for small teams.   It connects to your … Read more
0
3
14 May 2018
14 May 2018

When is good enough, good enough?

0
0
Currently the project I’m working on is using Azure’s Infrastructure as a Service (IaaS) and we want to move to using Azure SQL Database on Platform as a Service (PaaS).  The one thing stopping us doing that was cross database scripting, known in Azure terms as an Elastic Query. Before we agreed the move to … Read more
0
0
11 May 2018
11 May 2018

GDPR – What do we need to know?

0
1
On 25th May GDPR comes into force.  I’ve been learning everything I can about GDPR to ensure my systems adhere to the regulations and will be attending Redgate’s SQL Privacy summit, details and registration here on Friday 18th May in London .  However I’ve been really shocked at the amount of developers I know who … Read more
0
1
07 May 2018
07 May 2018

I’m speaking at SQL GLA

0
0
I am one of the organisers of SQLBits and this year we decided to make some real effort with the Community Corner.  Craig Porteous (@CPorteous) happened to offer to help at a time when we were considering how to make that happen.  Craig runs Glasgow User Group and SQL GLA which ran for the first … Read more
0
0
05 May 2018
05 May 2018

Who comments code?

0
8
I am a firm advocate of commenting code, but you need to make sure that you are commenting the right thing.  I worked on a project last year and then the project was paused.  I’m now back on it full time, some 6 months later.  I wrote most of the database code and all calls … Read more
0
8
03 May 2018
03 May 2018

I’m finally blogging

0
3
I have finally decided to start blogging and Redgate have kindly given me a platform to do it. So, what am I going to blog about?  Well pretty much anything and everything that I come across that is vaguely SQL Server related.  Hopefully a lot of Azure content while I’m getting to grips with it.  … Read more
0
3
16 October 2013
16 October 2013

SSIS Basics: Using the Merge Join Transformation

0
202
SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This 'Merge Join' transformation works in a similar way to a SQL join by specifying a 'join key' relationship. This transformation can save a great deal of processing on the destination. Annette Allen, as usual, gives clear guidance on how to do it.… Read more
0
202