Grant Fritchey, Author at Redgate

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.

Building dbRosetta Using AI: Part 3, Creating a Database

The AI said I had to do a database first, not code. Who am I to argue? So, with all the prompts outlining the goals of the project, I’ve gone forward with the project, and step one is creating a PostgreSQL database on Azure. This is part three of a multi-part set of articles.... Read more

Building dbRosetta Using AI: Part 2, Defining the Project & Prompt Templates

This is the next installment of the series on building a database and an application called dbRosetta using AI/LLM. Part 1 introduces the concept. THE AI PICKED DATABASE FIRST! Look, I talk databases at this thing a lot, so it probably knows my own preference, but when I asked it, it chose to build... Read more

Building dbRosetta Using AI: Part 1 of Many

Like many of you, over the last couple of years, I’ve been using AI, or, well, let’s just name it appropriately, Large Language Models (LLM), as a part of my job. I’ve also used it in my hobby. With it, I’ve generated snippets of code, tested data conversions, even built a small database for... Read more

Does Moving Faster with Cloud and Analytics Make Systems Stronger, or Just More Fragile?

I’ve been part of projects where speed was the main goal: get into the cloud, adopt analytics, deliver results fast. And I’ve seen both sides of the outcome. Experienced architects usually know where cracks will appear. They design guardrails: cost controls, security measures, fallback plans. The systems may move fast, but they don’t break... Read more

Introducing PostgreSQL Static Data in Flyway

One kind of data in most relational databases is what we call static data. This is also referred to as lookup data, code data, domain data or even list data. Whatever you like to call it, it’s usually smaller data sets consisting of data that never changes, or changes very slowly. One example might... Read more

Deploying PostgreSQL DB Changes Through AWS Developer Tools Using Flyway

The fundamentals of deploying database changes through Flyway are pretty simple. At the root of it all, there are two words you need to know: This of course comes with a whole set of assumptions. You’ve set up your configuration to connect to the correct database being just one of them. And that’s talking... Read more

The Benefits and Challenges of Managing Hybrid Estates

Updated September, 2023 – More and more organizations are migrating their data to the cloud but the majority are likely to end up managing hybrid estates, with some data managed through a cloud provider and some managed locally. This leads to some unique issues, especially around monitoring and services. If the objective of migrating... Read more

Redgate and the Cloud: How we can help you

*Updated for 2023* For many of us, our cloud undertakings are growing and growing, and it can be dauting to embark on a cloud migration initiative of any scale. The good news is, Redgate is right there with you. Many of our tools already work with the cloud. Also, we work with the cloud.... Read more

What are the biggest challenges organizations face in their digital transformation efforts?

As part of a recent Redgate Summit which focused on digital transformation and data modernization, I was fortunate enough to be able to interview Pramod Sadalage, a Director at Thoughtworks. There, and I’m quoting here, he enjoys the rare role of bridging the divide between database professionals and application developers. He’s usually sent in... Read more

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Blog

Posts by

Grant Fritchey