OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Louis Davidson

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
Louis Davidson
26 October 2020
Louis Davidson
26 October 2020

Ignore the technology for a moment, let’s talk about the problem

3
Twelve and a half years ago I wrote my largest hit count article of my writing career Ten Common Database Design Mistakes. It currently shows as having over 1.2 million hits, despite having a misspelling in the first paragraph. After this length of time, you would think that things would have changed and we would … Read more
3
Louis Davidson
02 September 2020
Louis Davidson
02 September 2020

Weighted Randomization In T-SQL

0
When I am not working on or writing about SQL, I am posting theme park pictures on Twitter of DisneyWorld (@DisneyPicADay) and Dollywood (@DollywoodP). The fun part of it is taking the pictures. The HARD part is deciding what to post every day. So instead of picking things from my head, I decided to harness … Read more
0
Louis Davidson
17 April 2020
Louis Davidson
17 April 2020

SQL Agent Job Generator: Scheduling A Job

1
In this last entry in the initial series of posts on building a SQL Agent Job Generator, I am going to add the ability to schedule the jobs that we generated in the previous post. The code that is available here in github: https://github.com/drsqlgithub/SSISDeployTool/tree/e8c44505bba6b3c764531c8b489101b39b5c27a7, is likely sufficient for some smaller organization’s needs with jobs. (Future … Read more
1
Louis Davidson
31 March 2020
Louis Davidson
31 March 2020

Using PowerShell to Control Visio

2
Note: Please be kind on my PowerShell programming techniques. If I am doing something really horrible, let me know. I will change my code. As our team struggles to get to a place where we can do continuous integration, some of the biggest issues we have needed to work on is figuring out how to … Read more
2
Louis Davidson
30 September 2019
Louis Davidson
30 September 2019

The Case of the Vanishing Index Compression

0
Recently, we started adding compression to some of our larger tables in our data warehouse where columnstore indexes didn’t make sense. (For example, some very large dimension tables, and a few facts where they are not used for large aggregates in the common manner). The changes were checked into source control, we monitored performance, all … Read more
0
Louis Davidson
16 June 2019
Louis Davidson
16 June 2019

A Father’s Influence

0
My dad and I had a very interesting and complex relationship. Some of this was due to his complex upbringing. His father was an alcoholic who died fairly early in his life, and his mom, well, his mom liked me a lot, but she was a messed up woman in many ways. After his father … Read more
0
Louis Davidson
12 June 2019
Louis Davidson
12 June 2019

Building a Great Technical Team

3
The process of putting together a team of technical people once was largely centered around getting a group of similarly minded people. How people worked was valued more than how well they could accomplish their job. Finding people who could work together smoothly was a big focus when picking new team members, and was a … Read more
3