This article presents an approach to database development and deployment that combines the strengths of Entry Framework Code First for .NET-driven development with the control and database versioning provided by Flyway's SQL migrations. It allows every database change to be reviewed and tested for integrity, performance, and stability in the same way as any application change. It should make a Database CI process much easier to sustain.

Sharing the Code

by Steve Jones

SQLServerCentral

Steve notes that Microsoft has open sourced another piece of software.

The Survivors

by Steve Jones

SQLServerCentral

There have been a lot of layoffs in the last year. Steve has some empathy for both those let go and those that remain. He also reminds us to manage our own careers.

Using the New Open Source SQLCMD to Create Containers

by Steve Jones

SQLServerCentral

See how the new, open-source sqlcmd works with containers to kickstart the development experience.

How to Automate Cross-Platform Database Development

by Additional Articles

Redgate

Vendors/3rd-party Products

In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.

Mental Health and Wellness Day – 2023

by Additional Articles

SQLServerCentral

Uncategorized

We are proud and honored to announce DPWIT-Mental Health and Wellness Day, May 5th,2023,

Creating Documentation

by Steve Jones

SQLServerCentral

Who should create documentation for software? In many companies, it's the developers. In fact, in Redgate, often our developers are tasked with updating articles for products on our documentation site. We do have a streamlined process that has developers can submitting changes in some format (markdown? ) and an automation process that automatically updates the […]

Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica

by Kiran Peddireddy

SQLServerCentral

This article examines how one can structure a pipeline for processing real-time data using Kafka and Informatica.

Azure Machine Learning Introduction: Part 1 Overview and prep work

by Additional Articles

SimpleTalk

Azure

The five-part series is designed to jump-start any IT professional’s journey in the fascinating world of Data Science with Azure Machine Learning (Azure ML). Readers don’t need prior knowledge of Data Science, Machine Learning, Statistics, or Azure to begin this adventure.

PASS Data Community Summit registration is open!

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

In 2023, connect, share & learn with like-minded peers, speakers, and industry leaders during the full week of data celebrations. Summit happens in person, from November 14th to 17th in Seattle. Check out the blog post and learn more.

Working with Flyway And Entity Framework Code First: An Overview

Sharing the Code

The Survivors

Using the New Open Source SQLCMD to Create Containers

How to Automate Cross-Platform Database Development

Mental Health and Wellness Day – 2023

Creating Documentation

Revolutionizing Real-Time Data Management with SQL Server, Kafka, and Informatica

Azure Machine Learning Introduction: Part 1 Overview and prep work

PASS Data Community Summit registration is open!

Blogs

Changing the Cardinality of a FK in Redgate Data Modeler

Future-Proofing: How to Stay Ahead in FinOps

Introducing the SQL Server on Kubernetes Operator

Forums

Removing TDE

Poor Names

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Question of the Day

Removing TDE