Posts by
Grant Fritchey

Grant Fritchey works for Redgate Software as a Devops Advocate. Grant has worked for more than thirty years in IT as a developer and a DBA. He has built systems from the major enterprise to distributed systems to small boutique companies. Grant writes articles on various data related topics for SQL Server Central and SimpleTalk. He is the author of multiple books including, SQL Server Execution Plans and SQL Server Query Performance Tuning. Grant currently serves on the Board of Directors of the PASS organization, a non-profit professional organization for data professionals. He develops and presents complete structured learning plans to teach Azure, AWS, and other data related topics to developers and other IS personnel. Grant is a Microsoft Data Platform MVP and an AWS Community Builder.

Grant Fritchey

16 March 2021

Grant Fritchey

16 March 2021

Code Review and DevOps

Almost every time I teach a class on DevOps, one of the questions that comes up is: How do we do code reviews in this automated process? There are actually a number of answers to this question. Let’s walk through a few. Source Control If you’re automating your deployments, I don’t think I’m going... Read more

Grant Fritchey

15 March 2021

Grant Fritchey

15 March 2021

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... Read more

Grant Fritchey

22 February 2021

Grant Fritchey

22 February 2021

Database DevOps at Ignite

We’re only a week away from the Microsoft Ignite virtual conference. Ignite runs between March 2nd and March 4th. Follow the link to see the stellar individuals who will be presenting great content. There are a lot of opportunities to learn all you can about Microsoft technologies. I’ve got additional good news. Redgate is... Read more

Grant Fritchey

29 December 2020

Grant Fritchey

29 December 2020

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... Read more

Grant Fritchey

10 December 2020

Grant Fritchey

10 December 2020

Challenges to Database DevOps: Which Do you Deploy First, the Database or the Application?

Challenges to Implementing Database DevOps: Should You Deploy Database Changes Before or After Application Changes? Another great question came out during the Challenges to Implementing Database Devops that I’d like to try to address here. This question is pretty simple, although the answer might be a little complicated: Should you deploy databases changes before... Read more

Grant Fritchey

7 December 2020

Grant Fritchey

7 December 2020

Tackling the Challenges of Hybrid, Cloud, and On-Premises SQL Server Estates

More and more organizations are managing some part of their data in the cloud. Gartner and similar organizations are showing massive growth in cloud adoption in 2020. Redgate’s own State of Database Monitoring survey shows cloud adoption rising rapidly. Everyone, it seems, is moving to the cloud. Yet, there is data out there that’s... Read more

Grant Fritchey

23 November 2020

Grant Fritchey

23 November 2020

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... Read more