aisto.com aisto.com

Three Steps To Get Started With Database DevOps

Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve already done the hard part, making the decision to shift the culture. Now, what’s involved is just lots of labor. There are three things you can do to begin your Database DevOps journey: Get your database into source control Start using a tool to build databases from source control Automate those builds through a...

aisto.com aisto.com

Challenges to Database DevOps: Dealing With Drift

Sometimes, people start their DevOps journey by getting their database into source control, but then, they don’t deploy from source control. Instead, they continue their manual deployments to production. Quickly they find that the database code in their production instances and the database code in their source control system don’t match. Alternatively, you may have a full-blown, full-automated deployment process from source...

aisto.com aisto.com

Challenges to Implementing Database DevOps: Where To Start With a Separate Team?

There were so many questions asked at a recent presentation that I just didn’t have time to answer them all. However, many of them were really interesting, so I promised to address them over time as blog posts. The next question is: I manage an ETL team that supports highly customized code for all our processes. What is the best approach for implementing a DevOps process for a team that is separate from applications but still has a...

aisto.com aisto.com

Challenges to Implementing Database DevOps: What If I Get It Wrong?

I recently took part in a panel discussion at the PASS Virtual Summit 2020 entitled: Challenges to Implementing Database DevOps. The interaction with the attendees was stupendous. We received all sorts of questions. Most of them were answered during the event, but a few were not. I’m going to create a series of blog posts answering the questions we couldn’t get to, and probably a few of the ones we did. The next question I want to...

aisto.com aisto.com

Challenges to Implementing Database DevOps: Dealing With Hotfixes

I recently took part in a panel discussion at the PASS Virtual Summit 2020 entitled: Challenges to Implementing Database DevOps. The interaction with the attendees was stupendous. We received all sorts of questions. Most of them were answered during the event, but a few were not. I’m going to create a series of blog posts answering the questions we couldn’t get to, and probably a few of the ones we did. The first question I’m...

aisto.com aisto.com

Let’s Talk About Build vs. Buy

I have written a nearly 1,000 page book on SQL Server performance tuning. In several chapters through the book, I outline all the necessary metrics you need to monitor your systems. I also show exactly how to put together those metrics in a variety of tools built into your OS and SQL Server itself. I’ve also posted over 1,000 blog posts at my personal blog. Loads of them are how to use various built-in tools to enhance your...

aisto.com aisto.com

The OWASP Top 10 Security Risks and Redgate Tools

The Open Web Application Security Project (OWASP) is a nonprofit foundation focused on improving the security of software. They have all sorts of projects, presentations, and educational content, but one of the things they are most known for is the OWASP Top Ten. This is an annual report on the top ten most critical security risks, specifically for web apps. The current top 10 list is as follows: Injection Broken...

aisto.com aisto.com

Starting to Use Git Hooks With a Team

Git Hooks are scripts that can be run in response to certain actions. Git Hooks are defined for each repository within your system. By design, the Hooks are not transmitted between repositories. The idea behind the design is that an evil actor can’t introduce automated code to anyone’s machine. I’m all in favor of this. However, as you start to work with Git Hooks, you’ll quickly recognize that this is something you’ll need...