Louis Davidson 05 April 2019

Finding a character in every character string by elimination

0

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

0

2

Blogs

Louis Davidson 08 March 2019

Discovering Three or Four Part Names in SQL Server Database Code

0

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

0

1

Blogs

Louis Davidson 27 February 2019

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

2

1

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

2

1

Louis Davidson 17 February 2019

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

1

3

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

1

3

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?

0

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

0

1

Blogs

Louis Davidson 26 November 2018

PASS Summit Wrap-up and 2019 PASS Resolutions

2

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

2

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

0

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

0

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

Louis Davidson 26 September 2018

Calculating a Security Principal’s Effective Rights

0

6

Blogs

Security. Oh that most painful of topics. I discussed it a few months earlier when I discussed the need to give rights only through roles to users, so everything is the same in dev and prod except the users who are placed in each role (SQL Server Database Security And Source Control). As I was … Read more

0

6

Blogs

Louis Davidson 05 September 2018

Using WITH in an IF Condition

0

11

Blogs

I am in the middle of working on my DB Design conference that occurs in a bit over a week from now. But I had this come up in some work I was doing and wanted to put it down in a blog. One of the most exciting features of SQL Server 2005 was the … Read more

0

11

Blogs

Louis Davidson 15 August 2018

Teaching a Database Design and Implementation Class in Orlando 9-13

1

0

Blogs

Thanks to Andy Warren (@sqlandy), on Thursday, September 13, I will be in Orlando, FL teaching an all-day seminar on the process of designing and implementing a relational database, entitled “Constructing a SQL Server Database.” Throughout the following 7 modules, we will make some requirements, model the database, create tables, with foreign keys, check constraints, … Read more

1

0

Blogs

Louis Davidson 08 August 2018

Finding duplicated data in a case insensitive column

1

2

Blogs

The other day, I had a problem with some data that I never dreamed I would ever see. In a case insensitive database, in a table’s column that was case insensitive, the customer was using the data as case sensitive. Firstly, let’s just go ahead and say it. “This was a sucky implementation.” But as … Read more

1

2

Blogs

Louis Davidson 07 August 2018

Speaking on Database Design at SQL Saturday Indianapolis on 8/11

0

Blogs

This weekend, I will be taking the short 7.5 hour drive up to Indianapolis, IN for my second SQL Saturday in Indianapolis. I will be speaking on my favorite topic, Database Design, hoping to give at least a few people the secrets of how to design their database if so if I ever have to … Read more

0

Blogs

Louis Davidson 27 July 2018

A performance issue with self-referencing tables

2

3

I have a great interest in hierarchy solutions, as I plan to write a book on implementing hierarchies in SQL Server in the next year or so (after I see what happens in SQL Server vNext after 2017). Something I didn’t include in my design testing when I built my presentation on hierarchies (available from … Read more

2

3

Louis Davidson 16 July 2018

Speaking on Row Level Security at SQL Saturday Louisville 7/21

1

0

Blogs

Coming up this weekend, I will be at my 10th SQL Saturday 729 in Louisville, KY. My topic will be row level security and dynamic data masking. Implementing Row Level Security in SQL Server Since the early days of SQL Server, it has been possible to use basic security measures to allow (and disallow) user … Read more

1

0

Blogs

Louis Davidson 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

Compliant Database DevOps

By need

By role

Louis Davidson