Blogs Annette Allen in Blogs Building a SQL Azure Database from TeamCity I’m in the process of setting up a new environment using Azure SQL Databases, previously in Azure we’ve just used... 20 June 2018 7 min read
Blogs Louis Davidson in Blogs Row-wise system function calls, always the same? Assumptions are generally terrible things for programmers (and likely my next “What Counts” blog goes there), because what looks to... 20 June 2018 6 min read
Blogs Annette Allen in Blogs Installing and setting up TeamCity I’ve just started a project where I’ve had to set up Team City from scratch. Whilst I’ve used Team City... 10 June 2018 4 min read
Blogs Kathi Kellenberger in Blogs SQL in the City Streamed: The June 2018 Edition I often joke that I wish cloning was perfected so that I could be two places at once. Sometimes, it... 05 June 2018 3 min read
Blogs Louis Davidson in Blogs Why Design and Test Your Utility Code for Publishing? As the saying goes: do to others as you would have them do to you. When writing code, I would... 31 May 2018 6 min read
Blogs Annette Allen in Blogs My thoughts from Redgate’s SQL Privacy Summit Last Friday (18th May 18) I attended Redgate’s SQL Privacy Summit in London. Before I go any further, for those... 20 May 2018 4 min read
Blogs Louis Davidson in Blogs SQL Server Database Security and Source Control Maintaining database security can be a complex task. In this post, Louis Davidson describes a method that can be used... 17 May 2018 7 min read
Blogs Annette Allen in Blogs When is good enough, good enough? Currently the project I’m working on is using Azure’s Infrastructure as a Service (IaaS) and we want to move to... 14 May 2018 3 min read
Blogs Annette Allen in Blogs GDPR – What do we need to know? On 25th May GDPR comes into force. I’ve been learning everything I can about GDPR to ensure my systems adhere... 11 May 2018 1 min read
Blogs Louis Davidson in Blogs SQL Saturday Atlanta is next weekend – Speaking on Hierarchies On May 19, a very busy day for SQL Saturday events (Atlanta, Dallas, and New York in the US, and... 11 May 2018 2 min read
Blogs Annette Allen in Blogs I’m speaking at SQL GLA I am one of the organisers of SQLBits and this year we decided to make some real effort with the... 07 May 2018 2 min read
Blogs Annette Allen in Blogs Who comments code? I am a firm advocate of commenting code, but you need to make sure that you are commenting the right... 05 May 2018 1 min read
Blogs Annette Allen in Blogs I’m finally blogging I have finally decided to start blogging and Redgate have kindly given me a platform to do it. So, what... 03 May 2018 2 min read
Blogs Louis Davidson in Blogs Operator Precedence versus the Confusing Constraint Translation The other day, a person I work with was creating some fairly complex CHECK constraints to protect data in a... 30 April 2018 6 min read
Blogs Louis Davidson in Blogs SQL Saturday Jacksonville – I’m Speaking! Every so often, I want to try a new location to go to, and possibly speak at, a SQL Saturday... 26 April 2018 3 min read
Blogs Louis Davidson in Blogs Finding overlapping ranges of data This week, I had a problem where I needed to find and eliminate from the results of my query, data... 18 April 2018 15 min read
Blogs Louis Davidson in Blogs Using SQLCMD, End Execution of SQL Commands in a File This week’s blog is a just about a few simple SQLCMD mode tricks for SSMS, but these tricks have saved... 09 April 2018 6 min read
Blogs Louis Davidson in Blogs Just What Exactly Will Cast to a Bit Value? I am working through my OneNote folder of blog ideas, and this one, while being one of the least consequential... 02 April 2018 4 min read
Louis Davidson Eliminating Annoying Space Characters Via Check Constraints Along with designing databases, I do a lot of ETL from, well, let’s call them “third party systems that I... 26 March 2018 9 min read
Blogs Louis Davidson in Blogs Securing access to data for admin and dbo In this blog, I want to explore what you can do to block the owner of a database from doing... 19 March 2018 11 min read
