K. Fisher’s Homework – Create db

In December the topic of the month for #Tsql2sday was to talk about our learning goals for 2018. One of the goals I put forth was to get better at SQL development. As part of that goal, I also realized I have to get more familiar with Visual Studios. So to help with...

Source Control

I’ve been meaning to work on getting my mind wrapped around Source Control for a while now. I was all hyped about it after a recent SQL Saturday, then I wanted to make it a learning goal for the year. Looking back at those posts, I guess the goals was to do more...

Programming Journal

Some times I just want to kick myself. A very simple concept that I never thought about applying to work, I was bouncing around the internet trying to get a better understanding of how to use source control with my script library when I found a rabbit hole. The rabbit...

Getting whipped by GetDate()

I have recently been working on tuning a job that purges data out of various tables that are older than 13 months using getdate. Pretty straight forward right? Well originally the job consisted of 6 different statements like so: generic delete Transact-SQL delete from...

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close