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

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

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

Who comments code?

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

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

Operator Precedence versus the Confusing Constraint Translation

0
2
The other day, a person I work with was creating some fairly complex CHECK constraints to protect data in a new table that was being created (a practice I am 100% for: https://www.red-gate.com/simple-talk/blogs/eliminating-annoying-space-characters-via-check-constraints/. The multiple constraints were combined into just one, with several conditions condensed into a single Boolean expression, using several ANDs, ORs, and … Read more

Finding overlapping ranges of data

0
2
This week, I had a problem where I needed to find and eliminate from the results of my query, data with overlapping ranges. I have written about this topic before, in my database design book book, in regards to building a trigger to avoid overlapping ranges. But even though I have written on the topic … Read more