Louis Davidson

Louis has been in the IT industry for over 20 years as a corporate database developer and data architect. Currently he is the Data Architect for CBN in Virginia Beach. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the PASS locally and globally. He is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.

Follow Louis on

09 July 2018
09 July 2018

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

2
3
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
2
3
30 April 2018
30 April 2018

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
0
2
18 April 2018
18 April 2018

Finding overlapping ranges of data

3
8
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
3
8
14 February 2018
14 February 2018

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
1
3
13 February 2018
13 February 2018

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