OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Annette Allen

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
Annette Allen
10 March 2019
Annette Allen
10 March 2019

SQLBits and Data in Devon 2019

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
Annette Allen
12 July 2018
Annette Allen
12 July 2018

I’m presenting this year

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
2
Annette Allen
10 June 2018
Annette Allen
10 June 2018

Installing and setting up TeamCity

1
 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
1
Annette Allen
14 May 2018
Annette Allen
14 May 2018

When is good enough, good enough?

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
Annette Allen
11 May 2018
Annette Allen
11 May 2018

GDPR – What do we need to know?

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
0
Annette Allen
07 May 2018
Annette Allen
07 May 2018

I’m speaking at SQL GLA

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
Annette Allen
05 May 2018
Annette Allen
05 May 2018

Who comments code?

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
8
Annette Allen
03 May 2018
Annette Allen
03 May 2018

I’m finally blogging

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
3
Annette Allen
16 October 2013
Annette Allen
16 October 2013

SSIS Basics: Using the Merge Join Transformation

185
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
185
Annette Allen
21 May 2012
Annette Allen
21 May 2012

SSIS Basics: Setting Up Your Initial Package

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