Monthly Archives: January 2019

Starting a Proof of Concept with SQL Change Automation

Posted on January 22, 2019 by way0utwest

One of the ways that you can more easily perform database development tasks is with SQL Change Automation (SCA). This is a plug-in from Redgate that works with Visual Studio, and while there are tutorials on Setting up SCA and … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Starting a Proof of Concept with SQL Change Automation

The Justification Database

Posted on January 18, 2019 by way0utwest

I saw an article on the security at various Department of Defense facilities that control the ballistic missile systems in the US. It’s interesting reading, especially if you want to shake your head at bad practices. I think this article summarizes just … Continue reading →

Posted in Editorial | Tagged | Comments Off on The Justification Database

Ensuring Designs have Flexibility

Posted on January 17, 2019 by way0utwest

One of the biggest complaints from developers about RDBMSs is that they are inflexible and hard to change. This has led to many developers in the past using existing fields for a variety of purposes, sometimes putting data from multiple … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Ensuring Designs have Flexibility

Getting Parameters Out From a Stored Procedure–#SQLNewBlogger

Posted on January 16, 2019 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the lesser used and known features of T-SQL are the output parameters from a stored procedure. I … Continue reading →

Posted in Blog | Tagged , , | 5 Comments