I’ve worked in IT for 30 years, a large part of which has involved managing data and databases. I’m now a SQL Server Enterprise Architect and I manage the direction and operation of a Microsoft Platform Team, as well as the design, build and implementation of a global SQL Server estate. I recently took... Read more
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.... Read more
In this 20 minute video, we share an easy way to automate "rebaselining" in a database DevOps CI/CD workflow. Follow the video or simply check out the scripts. Read more
You don’t even have to leave your house this year to access all the great content PASS Virtual Summit 2020 has to offer, so pull up a chair, slip into your best video conference PJs, and join Redgate for what promises to be three days you won’t want to miss. Join us at the... Read more
We had a recent forum question about Azure DevOps Release Pipelines that prompted me to look a bit into how schedules work in “classic” release pipelines. While Microsoft has documentation on scheduling options, I found that there are multiple places where one can set a schedule. It wasn’t completely clear to me how these... Read more
"Rollbacks" are easily the most controversial topic in database DevOps. In this post, I share why there's no simple solution to the problem of rollbacks -- but how you can still get started with database DevOps and continuously improve over time. Read more
I attend a fair amount of tech conferences, and there's often something missing: talks from managers and leadership in tech. In this post I explain how public speaking benefits tech leaders and why this is an important need for IT and software communities. Read more
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... Read more
If you work in the insurance industry, you need to know about the NAIC Insurance Data Security Model Law. In this post we give you an overview of the security model, a list of adopting states (so far), and links to learn more. Read more
As organizations realize the advantages they can gain by integrating database development into their DevOps pipelines, the conversation about database DevOps has moved from ‘why’ to ‘how’. This has been helped along the way by the growing availability of third-party tools and solutions which plug into and align with application development processes and workflows... Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
