Operations | Monitoring | ITSM | DevOps | Cloud

February 2021

SQL Server deployments: Which Redgate tools should you use?

Since 1999, we’ve been developing tools at Redgate to support database deployments for SQL Server. In the past couple of years, we’ve increased our effort in this space by further developing our proprietary technologies based on SQL Compare, and acquiring others like Flyway, the most popular database migration engine. As a result, we now offer tools which provide more options for SQL Server and also support deployments for 20 different database systems.

Architecting Database Dev and Test Environments: Best Practices and Anti-Patterns for SQL Server

Many organizations use out-of-date architecture patterns for developing relational databases which are a pain to manage, slow developers down, and limit testing and innovation. It’s time to modernize these environments and improve standards for database development. In the years I worked as a consultant specializing in SQL Server administration and tuning, I frequently fielded questions from customers about how to best manage databases in development and test environments.

A quick guide to reputational risk

When it comes to reputational risk, a reactive approach is generally taken by organizations, with efforts focused on handling threats to their business they are already aware of. As much as this enables short term damage limitation, it may not be enough to manage and protect your risk in the long term. Instead, a more proactive approach is key to success.

Using the SQL Change Automation PowerShell cmdlets with Jenkins

In this video you’ll get an overview of how Redgate’s SQL Change Automation PowerShell module can plug into Jenkins using pipeline-as-code to build and deploy your SQL Server Databases. For more information, feel free to email in, leave a comment below or visit the Redgate website!

Securing SQL Server with DoD STIGs

Making sure your SQL Servers are secured against malicious users is difficult. How can you know that you’ve done enough? How do you know you’re protected from the things that actually worry you? The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD).

Redgate commits to the future of PASS

When PASS announced in December last year that it was ceasing all operations from January 16, 2021, it came as a surprise to many people. For 21 years, it’s represented a global community of over 300,000 data professionals who use the Microsoft data platform. From the PASS Summit to online learning, SQLSaturdays to opportunities to network, its’s been a permanent fixture throughout the year.