12 July 2018
12 July 2018

I’m presenting this year

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
09 July 2018
09 July 2018

T-SQL Tuesday #104: Code You Would Hate To Live Without (Relative Positioning in Date Table)

Today’s blog post is in response to Bert Wagner’s invitation here: https://bertwagner.com/2018/07/03/code-youd-hate-to-live-without-t-sql-tuesday-104-invitation/. For me, the answer was pretty simple. There is one piece of code that I have written that I find very useful, and even more… it was my (as far as I know, my own idea!)  In my life, I have obviously learned a … Read more
29 June 2018
29 June 2018

Is this a ‘new dawn’ for the data catalog?

0
4
How should you store the information you need to understand the information in your relational databases? Or rather, how should you store the information your new developers need, that your compliance team requires, that your business wants? With extended properties, Microsoft gave us a mechanism in SQL Server to add metadata to database objects. Extended … Read more
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
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