We're not dinosaurs!  I saw a Star Trek movie (from the 23rd century mind you) where Spock said that a SQL injection attack was used to do nefarious stuff.  Hollywood...

Sending our thoughts and prayers Ken.

@SqlNightOwl

Thank you for the post.  I always like to see what others are doing to create repeatable DDL/DML scripts.

There are a few built in function you may want...

We use merge extensively as part of our delivery process.  We need to have re-runnable scripts that affect "process" related data (reference type data).  If the value isn't there then...

I agree the risk can be mitigated.

t.franz (9/16/2016)

---

On the other side it would nice,...

While a synonym will allow you to create a better name, it does nothing to handle the mix of order types. You may want to explore views that use...

I use synonyms for testing. I have a testing DB that has business object mock ups, staged data and testing inputs. I then create/sync the synonyms to the...

I love helper routines like this... definitely going in my toolbox. 😎

This wasn't a post advocating that you change your business process. If you're lucky enough to have a data steward then this post is irrelevant. If you have...

We need a thumbs up/down button and a count for each on posts. Sometimes all I want to do is know if a majority of readers agree or disagree...

Not all companies have the benefit of having a Data Steward. I've done this for a number of years for both large and small companies. My experience is...

g.britton (2/16/2016)

---

There's an easier way:

1. Set up a date table (aka DimDate) (examples abound: google is your friend)

2. Have a yearly process to update the table with new info...

I see, in that case feel free to change the behavior of how the function works for your environment. My focus was based on how federal holidays are observed...

michael.sasso (2/16/2016)

---

One little quirk is the US Federal Reserve System. If a holiday falls on a Sunday then Federal Reserve banks and branches are closed the following Monday. However, if...

Chris Quinn-821458 (2/16/2016)

---

In the UK if a holiday such as Christmas Day, Boxing Day or New Year's day falls at the weekend, the public (bank) holiday always moves to the...