Articles

Database object documentation is essential for explaining to busy developers, and the wider business, the purpose of each object and how to use it. The solution presented in this article consists of a SQL script to allow developers to add comments to MySQL database objects, without affecting the database version, and a simple way to generate a documentation report, in JSON. The SQL script will execute automatically as a callback, during any Flyway Teams migration run, and the report will allow the team to spot any gaps quickly.

2022-07-18

T-SQL Comment Best Practices for SQL Server

by Additional Articles

MSSQLTips.com

T-SQL

Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.

2022-07-18

Linked Servers: a Peek Behind the Curtain

by maxtardiveau

SQLServerCentral

Administration

Learn how a linked server caused an issue with Gallium Data.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2022-07-15

5,205 reads

Discuss

[From the archives] Your guide to choosing the right monitoring tool [Video]

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Join Grant Fritchey in this 35 minute video to learn his top tips for evaluating monitoring tools and vendors, the common pitfalls when implementing a new solution, and how you can demonstrate Return on Investment (ROI) to the business post-purchase.

2022-07-15

SQL Server 2022: Backup Database Options to AWS S3 Bucket - Part 2

by Additional Articles

MSSQLTips.com

SQL Server

In this article we look at how to backup a SQL Server 2022 database using AWS S3 storage along with all the supported backup options.

2022-07-15

How to Find the Start and End Dates for the Current Week (and more)

by Jeff Moden

SQLServerCentral

Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

You rated this post out of 5. Change rating

2022-07-13

34,670 reads

Discuss

Cross-RDBMS Version Checks in Flyway

by Additional Articles

Redgate

Vendors/3rd-party Products

How does one check that a database is definitively at the version that Flyway says it is? Or that a test teardown procedure leaves no trace in the database? Or verify that an undo script returns a database's metadata to that state it should be in for the version to which you're rolling back? This article shows how to do high-level version checks, by comparing JSON models.

2022-07-13