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

Microsoft Dynamics 365 Storage Pitfalls – Here is the Cost Effective Solution

0
3
In Microsoft Dynamics 365, by default, database is optimized for database record storage and not for files or attachment storage. Hence, cost effective storage management of huge sized data files becomes one of the most critical aspects for the organizational users. This blog narrating the process of optimizing storage capabilities of Microsoft Dynamics 365 CRM … Read more

My First Experience Migrating a .NET App to Core

6
18
I recently migrated an old .NET Framework 4.5.2 app to .NET Core 2.0. This isn’t a guide to that process and certainly isn’t an exhaustive list of all the things that can go wrong, but rather provides an account of what worked for me, where the pitfalls were, and whether it was worth it. The … Read more

Music City Data – A Conference for Data Professionals

1
3
Update: the schedule is out there, and as we promised, the topics are diverse. http://www.musiccitycode.com/sessions/ The conference starts in just two weeks (Music City Data sessions are all on Saturday), so if you are a developer using data, agile, and really most any programming technologies, in driving distance to Nashville, you still have time to easily prod … Read more

What Counts for a DBA – Deadlines

0
0
Everyone needs deadlines. Even the beavers. They loaf around all summer, but when they are faced with the winter deadline, they work like fury. If we didn’t have deadlines, we’d stagnate. ― Walt Disney I hate deadlines. Really. I truly hate them. The problem is: they are usually unrealistic, often not much more than a wild … Read more