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

02 September 2020
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
17 April 2020
17 April 2020

SQL Agent Job Generator: Scheduling A Job

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
31 March 2020
31 March 2020

Using PowerShell to Control Visio

1
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
1
30 September 2019
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
16 June 2019
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
12 June 2019
12 June 2019

Building a Great Technical Team

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