Louis Davidson 10 October 2019

Programmer Gear: Thin Apple Watch Band

0

Blogs

This blog is different than my normal T-SQL blogs I almost always do. But I know that I cannot be the only computer programmer who wants to wear a smart watch when working to get some of the health and alert benefits that they can provide. The band though, has always been a blocker to … Read more

0

Blogs

Louis Davidson 30 September 2019

The Case of the Vanishing Index Compression

0

Blogs

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

Blogs

Louis Davidson 25 September 2019

Getting back to normal after a long summer

0

Blogs

It has been a fun summer, sort of. 13 weeks ago, I had my left knee replaced to balance out my other two hip replacements on my right side. This is hopefully the last time that Dr Morrison of Southern Joint Replacement Institute ever has to cut into parts of my body with power tools. … Read more

0

Blogs

Louis Davidson 16 June 2019

A Father’s Influence

0

Blogs

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

Blogs

Louis Davidson 12 June 2019

Building a Great Technical Team

3

Editorials

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

Editorials

Louis Davidson 05 June 2019

SQL Saturday Virginia Beach this weekend!

0

Blogs

Coming up this weekend, I will be in Virginia Beach, VA for their first ever SQL Saturday event. I have strong ties to the area, as the company I work for is located there, and they are helping me out to be able to come in for the event at a more reasonable pace than … Read more

0

Blogs

Louis Davidson 01 June 2019

NOT NULL Persisted Computed Columns (And What They Allow)

4

Blogs

Ok, so I have been, and will mostly stay, in a bit of blog hibernation. I am super busy trying to finish up a rather large number of tasks (a few chapters in a book, 2 more SQL Saturdays, and as much theme park time as I can get in before the end of June, … Read more

4

Blogs

Louis Davidson 30 April 2019

Speaking at SQL Saturday Jacksonville on May the Fourth

0

Blogs

SQL Saturday Jacksonville this weekend! Coming up this weekend, on the least holiest, but still very awesome holiday (May the Fourth), I will be in Jacksonville, Florida delivering a couple of sessions. Now, you might say: “Louis, why would you be travelling on May 4?” Check out the logo for Jacksonville’s event: That’s right, since … Read more

0

Blogs

Louis Davidson 05 April 2019

Finding a character in every character string by elimination

2

Blogs

A few weeks ago, a coworker had a scenario where he was trying to import a large amount of data into some format (I think it was JSON, but I think it was a special limitation… that isn’t really important to the solution), and it didn’t allow certain characters. Narrowing down what the bad character … Read more

2

Blogs

Louis Davidson 08 March 2019

Discovering Three or Four Part Names in SQL Server Database Code

1

Blogs

I am in the middle of a project to enable our corporate databases to work with continuous integration using RedGate SQL Automation (and hopefully get a few blogs/articles out of it too.) One of the things that the tool does is create your database in multiple ways, with multiple names, in order to compare to … Read more

1

Blogs

Louis Davidson 27 February 2019

Running a .PS1 or .CMD file from Visual Studio Project Explorer

1

Blogs

Today’s blog is one of those topics that I just needed to get written down somewhere, and I expect that a few readers may find this interesting and want to do the same thing. In many of the Visual Studio projects we have where I work, there are Powershell and/or batch CMD files that we … Read more

1

Blogs

Louis Davidson 17 February 2019

How To, and Not To, Escape a String In TSQL

7

Blogs

You are never too old to learn an important lesson. Like most programmers, I read programming language documentation for one of two reasons. 1. You have just found out about something new 2. You find out that you were wrong about something you thought you had read the first time, probably 10 years ago. Today’s … Read more

7

Blogs

Louis Davidson 14 February 2019

We’re Putting the SQL Band Back Together In Chattanooga

0

Blogs

Wow, it has been a while since I last posted, with the holidays, and way too many other projects that I haven’t blogged about just yet because I haven’t found the time. Last June, the SQL Saturday in Chattanooga and SQL Server User Group lost their venue, as well as the leader of the group. … Read more

0

Blogs

Louis Davidson 03 January 2019

The New Year Has Started, So It Must Be SQL Saturday Nashville Time!

0

Blogs

Happy New Year everyone! Hope the holiday season’s passing finds you well rested, well fed, and ready to hit the ground running. As year’s go, it was a relatively great year last year… as far as the SQL community goes in any case. But now that 2019 has started, it is time to get back … Read more

0

Blogs

Louis Davidson 11 December 2018

Technique and Simple Utility to Determine the Datatype of a Scalar T-SQL Expression

2

Blogs

Note: post revised to take into consideration tips from comments The other day, I was working with a query where someone had put together an expression that had something along the lines of: And I thought to myself… “Self, what will the datatype of this be? Will it fit what the programmer wanted it to … Read more

2

Blogs

Louis Davidson 06 December 2018

I Have an Exclusive Lock, My Row Is Safe, Right?

1

Blogs

Note: This is an update of a blog I posted in 2006 with a lot of additional information (I was less wordy in my 30s apparently). It is just as relevant today. I have a presentation I do occasionally on concurrency entitled “Let Me Finish” that covers many of the different types of concurrency behaviors … Read more

1

Blogs

Louis Davidson 26 November 2018

PASS Summit Wrap-up and 2019 PASS Resolutions

1

Blogs

Most years, by the time the PASS Summit has finished, I have at least written the basics of my wrap-up blog to the conference, usually when I am sitting at SEATAC eating my breakfast pizza from the little Italian restaurant. It may take me a few days or a week to post it, but that … Read more

1

Blogs

Louis Davidson 03 November 2018

PASS Summit Resolutions 2017 Followup

0

Blogs

The summit is my favorite time of year, but this is literally my least favorite post of every year (and yes, I do consider NOT posting it every year, this year more than most!) It is that time when I take my previous year’s resolutions (centered squarely on the most important 12-ish month period, from … Read more

0

Blogs

Louis Davidson 09 October 2018

Calculating a Security Principal’s Complete Effective Rights

1

Blogs

In my blog Calculating a Security Principal’s Effective Rights. I built a view, named Utilty.EffectiveSecurity that you could query to fetch a security principal’s rights to objects in a database. In that blog I tested the code and showed how it works. Now I have taken this to the extreme and expanded the view to … Read more

1

Blogs

Louis Davidson 01 October 2018

Speaking at SQL Saturday Memphis on October 6

0

Blogs

There are several SQL Saturday events I have attended every event that has existed. Louisville, Nashville, Chattanooga (didn’t speak one of the years), and (I am pretty sure) Birmingham. On October 6, I will add one more to this list. The inaugural SQL Saturday Memphis! Having lived in Nashville for 20 or so years before … Read more

0

Blogs

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Louis Davidson