External Article

Searching a Flyway Database

As a database gets larger, and development more complex, so it becomes increasingly necessary to be able to search for strings in the source files and the database itself. Maybe you need to find when a table first got created, when a foreign key was added, or to find out which tables lack documentation. I'll show you how to answer these sorts of questions by running simple 'wildcard' searches on your Flyway migration files, or source files, as well as more targeted searches on certain parts of your database model.

SQLServerCentral Editorial

Look Beyond What You See

One of the sales managers at Redgate Software posted an origin story about how he came to work at Redgate Software. It's an interesting story, and while I don't work in sales or have the same origin story, I don't know that I could have seen the place I'm in now early in my career. […]

External Article

Building a Database with Flyway

Flyway, especially Flyway Teams edition, can be used in several different ways to accommodate a database development that was originally based on builds rather than migrations. This article explores four different ways to use Flyway to build a particular version of a database, from the ground up, using a single migration script. It should help teams select the best way to incorporate Flyway into an existing database build system, during development, while benefitting from use of Flyway's versioned migration system for deployments and releases.

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

By

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

data compare between 2 tables with same structure for any changes after etl run

By syam.tunuguntla

i have huge table with lot of data and is also wide. i took...

Creating a JSON Document II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document II

Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Backing Up Azure Key Vault...

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table: 

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960
If I run this code, what document(s) is/are returned? 
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams;

See possible answers