Viewing 15 posts - 1 through 15 (of 116 total)
Sending our thoughts and prayers Ken.
July 8, 2020 at 12:44 am
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...
April 20, 2018 at 7:59 am
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...
February 3, 2017 at 8:31 am
t.franz (9/16/2016)I think the risk is reasonable, as long you are using an xp_cmdshell_proxy_account with minimal privileges.
I agree the risk can be mitigated.
September 16, 2016 at 10:41 am
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...
June 28, 2016 at 7:30 am
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...
June 24, 2016 at 8:20 am
I love helper routines like this... definitely going in my toolbox. 😎
April 18, 2016 at 2:04 pm
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...
March 1, 2016 at 7:56 am
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...
February 24, 2016 at 10:59 am
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...
February 16, 2016 at 1:58 pm
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...
February 16, 2016 at 10:35 am
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...
February 16, 2016 at 8:58 am
February 16, 2016 at 8:03 am
Chris Quinn-821458 (2/16/2016)
February 16, 2016 at 7:57 am
Intellisense is fine, but there is the tried and true ALT+F1. In SSMS simply select the object name in the query window and press ALT+F1 which executes the sp_help...
February 11, 2016 at 9:34 am