Annette Allen

Annette 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 until April 2018. Now Annette is working on a project and does both SQL Database code and DBA work on an Azure environment. When not working with SQL, she assist her husband, Jonathan, with the running of SQLSouthWest, the Cornwall/Devon/Somerset SQL User Group based in Exeter. She also rides, breeds and trains horses and is a British Showjumping qualified Course Builder.

Contact Annette:

Email: annetteallen69@gmail.com
Twitter: @Mrs_Fatherjack

14 May 2018
14 May 2018

When is good enough, good enough?

1
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
1
0
11 May 2018
11 May 2018

GDPR – What do we need to know?

1
0
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
1
0
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?

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

16
179
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
16
179
21 May 2012
21 May 2012

SSIS Basics: Setting Up Your Initial Package

21
320
When working with databases, the use of SQL Server Integration Services (SSIS) is a skill that often needs to be acquired quickly, from scratch. Up until now, it has been a curiously frustrating search to find out the basics, fast, in order to get up and running quickly. No longer, as Annette comes up with a simple introduction for the rest of us.… Read more
21
320