Louis Davidson 05 September 2018

Using WITH in an IF Condition

0

10

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

10

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

Uncategorized

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

Uncategorized

Louis Davidson 09 July 2018

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

2

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

Louis Davidson 01 July 2018

Honored and Humbled to get my 14th Microsoft MVP Award

1

0

I don’t know if I can put into words how much I appreciate this award, so I won’t try too hard. I will say that feels really weird to be happening in July. For the first 13 years I had the award, the announcement was my kind of unofficial launch of the holidays in early … Read more

1

0

Louis Davidson 20 June 2018

Row-wise system function calls, always the same?

0

1

Assumptions are generally terrible things for programmers (and likely my next “What Counts” blog goes there), because what looks to be true when trying things out on your machine, may not be so at a larger scale. There are lots of examples out there, sorting when there’s a clustered index, not checking errors because you … Read more

0

1

Louis Davidson 31 May 2018

Why Design and Test Your Utility Code for Publishing?

0

Blogs

As the saying goes: do to others as you would have them do to you. When writing code, I would suggest a complimentary saying of “do to yourself as you would to do others”. Write your software as if it will be used by a very wide audience, even if you aren’t planning on being the … Read more

0

Blogs

Louis Davidson 17 May 2018

SQL Server Database Security and Source Control

0

Blogs

Maintaining database security can be a complex task. In this post, Louis Davidson describes a method that can be used to maintain separate security for multiple environments (e.g., production and development) without changes to the database itself. … Read more

0

Blogs

Louis Davidson 11 May 2018

SQL Saturday Atlanta is next weekend – Speaking on Hierarchies

0

1

Blogs

On May 19, a very busy day for SQL Saturday events (Atlanta, Dallas, and New York in the US, and Kyiv, Catania and Belo Horizonte elsewhere), I will be speaking in Atlanta on a subject that I am becoming more and more interested in: Hierarchies. This is the abstract: How to Implement a Hierarchy in … Read more

0

1

Blogs

Louis Davidson 30 April 2018

Operator Precedence versus the Confusing Constraint Translation

0

2

Blogs

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

Blogs

Louis Davidson 26 April 2018

SQL Saturday Jacksonville – I’m Speaking!

0

Blogs

Every so often, I want to try a new location to go to, and possibly speak at, a SQL Saturday event. This year, my new experience will be to go to Jacksonville, FL for their event. It will only be the second time I have been in the city, the first time being on my … Read more

0

Blogs

Louis Davidson 18 April 2018

Finding overlapping ranges of data

0

3

Blogs

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

0

3

Blogs

Louis Davidson 09 April 2018

Using SQLCMD, End Execution of SQL Commands in a File

3

2

Blogs

This week’s blog is a just about a few simple SQLCMD mode tricks for SSMS, but these tricks have saved me a lot of heartache over the years. If you have not used SQLCMD mode, you probably should be. I don’t intend to introduce SQLCMD too deeply, because there are tons of articles out there … Read more

3

2

Blogs

Louis Davidson 02 April 2018

Just What Exactly Will Cast to a Bit Value?

0

Blogs

I am working through my OneNote folder of blog ideas, and this one, while being one of the least consequential of them, was the most interesting tonight (and just may help you one day when converting data some day when you are wondering what the heck just happened in a query). You probably know that … Read more

0

Blogs

Louis Davidson 26 March 2018

Eliminating Annoying Space Characters Via Check Constraints

0

1

Blogs

Along with designing databases, I do a lot of ETL from, well, let’s call them “third party systems that I did not design or implement.” That may seem arrogant, but hey, I write books about database design so I should at least seem like I am able to do things right. In either case, when … Read more

0

1

Blogs

Louis Davidson 19 March 2018

Securing access to data for admin and dbo

0

3

Blogs

In this blog, I want to explore what you can do to block the owner of a database from doing stuff in the database they “own”. Own is a strange term, because really there is just one user that is listed as owner, but there are there are three users who essentially are owner level, … Read more

0

3

Blogs

Louis Davidson 14 February 2018

Music City Data – A Conference for Data Professionals

1

3

Blogs

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

Blogs

Compliant Database DevOps

By need

By role

Louis Davidson