External Article

Testing a Flyway Database Migration

Often, we want to test the new version of a database, produced by a Flyway migration, before committing the new migration file, or to test the same migration run on a number of different databases. This article demonstrates how to do it, by generating and using JSON parameter files to run a series of Flyway actions on any number of databases, on any number of servers.

SQLServerCentral Editorial

Knowing When to Respond

I ran into this quote on the Microsoft Learn site, which I thought was a great way to think about how to administer a system: "Without a baseline, every issue encountered could be considered normal and therefore not require any additional intervention." When I've had users file tickets or complain about things not working well, […]

Blogs

Fixing a giant or running a SQL Server project deployment with Temporal tables

By

(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a...

Azure Cosmos DB introduction

By

Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...

Display dates between two input dates using SQL DATEDIFF function in SQL Server

By

SQL Server has a very useful function called DATEDIFF. This function is used to...

Read the latest Blogs

Forums

Create View in stored procedure

By newcomer

Hello, I'm new here and currently learn SQL Server. For my program I try...

Optimize Query

By ktflash

--####################################### --Given Rawdata --####################################### create table #Base (C1 char(1),C2 char(3)) insert into #Base values...

Static data masking is not showing in 18.0 above

By sqlfriend

I read this article trying to understand the feature of data masking in SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers