Additional Articles

Flyway Teams and the Problem of Database Variants

by Additional Articles

SQLServerCentral

Vendors/3rd-party Products

The 'ShouldExecute' script configuration option in Flyway Teams simplifies 'conditional execution' of SQL migration files. This makes it easier to support multiple application versions from the same Flyway project, to deal with different cultural or legislative requirements. It also helps developers handle environmental differences between development, test and staging, such as the need to support multiple versions or releases of the RDBMS.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2021-12-10

Introduction to DAX for paginated reports

by Additional Articles

SimpleTalk

SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.

2021-12-10

Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services

by Additional Articles

MSSQLTips.com

Big Data

In this article we look at how to create a scale-out SQL Server PolyBase solution on AWS

2021-12-08

How a monitoring tool benefits the entire organization

by Additional Articles

Redgate

Vendors/3rd-party Products

Redgate estimate that the savings realized with a monitoring tool could be well over $85,000 / year*. Does your organization understand how a monitoring tool can impact almost every department?

2021-12-08

Dry Runs for Database Migrations using Flyway Teams

by Additional Articles

Redgate

Vendors/3rd-party Products

How Dry Run scripts work, and how they can be used to deliver a single-script release artifact to Staging, verify placeholder substitutions in SQL migration scripts, and simply team code reviews.

2021-12-06

Using SQL Server sequence objects

by Additional Articles

SimpleTalk

Learn SQL

SQL Server sequence objects have several properties that control how they behave. Greg Larson explains the options of using SQL Server sequence objects.

2021-12-06

Top Query Search in SQL Monitor

by Additional Articles

Redgate

Vendors/3rd-party Products

SQL Monitor v12.0 has added a new Query Text Search feature to allow users to search the text of the most expensive queries that executed on a SQL Server instance over a period. Here's what it does, and how it works.

2021-12-03

Trusting STRING_SPLIT() order in Azure SQL Database

by Additional Articles

MSSQLTips.com

T-SQL

Learn about the changes to the STRING_SPLIT function in Azure SQL Database that allows you to specify ordinal position of the output.

2021-12-03

On-Demand: 2021 Accelerate State of DevOps webinar

by Additional Articles

Redgate

Vendors/3rd-party Products

Redgate is a proud sponsor of this year’s Accelerate State of DevOps Report, by the DevOps Research and Assessment (DORA) team at Google Cloud. Watch our lastest webinar to find out how the future of DevOps will effect you.

2021-12-01

SQL Server RETURN and OUTPUT Clause in Stored Procedures

by Additional Articles

MSSQLTips.com

Stored Procedures

In this article we look how to use RETURN and OUTPUT in a SQL Server stored procedure to get a return value after execution.

2021-12-01

All authors

Additional Articles

Flyway Teams and the Problem of Database Variants

Introduction to DAX for paginated reports

Create a SQL Server PolyBase Scale-out Group Using Amazon Web Services

How a monitoring tool benefits the entire organization

Dry Runs for Database Migrations using Flyway Teams

Using SQL Server sequence objects

Top Query Search in SQL Monitor

Trusting STRING_SPLIT() order in Azure SQL Database

On-Demand: 2021 Accelerate State of DevOps webinar

SQL Server RETURN and OUTPUT Clause in Stored Procedures

Blogs

AI: Blog a Day – Day 7: Vector and Vector Databases

AI: Blog a Day – Day 6: Embeddings – How AI Understands

The Book of Redgate: Mistakes

Forums

Why End-User Testing Is Even More Important with AI

Dynamic Unpivot

Writing as an Art and a Job

Question of the Day

String Similarity II