With Flyway, you can adopt a test-driven development strategy that will allow you to test and evaluate databases, and database objects, at every phase of the database development lifecycle. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix. This approach will allow you to catch many of them before the database change even gets committed to version control, making a continuous delivery process much easier to adopt and sustain.

The Birth of Computing Was the Birth of Testing

by Grant Fritchey

SQLServerCentral

Uncategorized

Last year I had the most wonderful opportunity. I took part in Data Relay, an event in the UK which tours several cities. Wonderful time, but not the focus here. The very first one was held at the National Museum of Computing at Bletchley Park. Without a doubt, you've heard of Alan Turing, Enigma, and […]

Do You Have a Jeff?

by Steve Jones

SQLServerCentral

Career Growth

Today Steve wonders if you have a go-to person at work or maybe if you are that person. Or if that is even a good thing in a company. It might be better if there were more tools available to help others.

Leveraging AI Tools for SQL Queries

by mamta_d

SQLServerCentral

Artificial Intelligence (AI)

This article covers the basics of how different AI tools can be used to write SQL.

Use a Table Variable for Logging Entries that Need to Survive Rollbacks.

by lbravo

SQLServerCentral

T-SQL

This article shows how a table variable can be used to capture error information and log it when your code doesn't work as expected.

Fun with Powershell

by Additional Articles

SimpleTalk

PowerShell

Have you ever been in a situation that you want to call a cmdlet or a function with a parameter that depends on a conditional criteria that is available as a list? In this article I will show a technique where you can use PowerShell Dynamic Parameters to assist the user with parameter values.

LangChain Prompt Templates with OpenAI LLMs

by Additional Articles

MSSQLTips.com

Learn how to get started with a few sample prompt templates by using the gpt-4 LLM within OpenAI and LangChain in a Databricks notebook.

Dimensional Modeling Case Study Part 2 - Days Dimension

by Hang Liu

SQLServerCentral

Learn how you can model days in a dimension that might need to be aggregated in different ways for your data warehouse operations.

Ransomware vs. AI

by Steve Jones

SQLServerCentral

Microsoft is using AI to try and protect against ransomware, which is probably a good use of the technology.

Query Exercise: Find the Best Time for Maintenance

by Additional Articles

Brent Ozar Blog

If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it?

Planning a Database Testing Strategy for Flyway

The Birth of Computing Was the Birth of Testing

Do You Have a Jeff?

Leveraging AI Tools for SQL Queries

Use a Table Variable for Logging Entries that Need to Survive Rollbacks.

Fun with Powershell

LangChain Prompt Templates with OpenAI LLMs

Dimensional Modeling Case Study Part 2 - Days Dimension

Ransomware vs. AI

Query Exercise: Find the Best Time for Maintenance

Blogs

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

Forums

Creating a JSON Document I

Who is Irresponsible?

Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments

Question of the Day

Creating a JSON Document I