The 10 Benefits of Monitoring for Leaders

A third-party database monitoring tool is an investment that drives enormous value for the bottom line of a business in ten key ways, from simplifying cloud migration to retaining talent. Here's how.
The post The 10 Benefits of Monitoring for Leaders appeared first on SQLServerCentral.

Getting an Overview of Changes to a PostgreSQL Database using Flyway

How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts.
The post Getting an Overview of Changes to a PostgreSQL Database using Flyway appeared first on SQLServerCentral.

How to get length of Text, NText and Image columns in SQL Server

There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?
The post How to get length of Text, NText and Image columns in SQL Server appeared first on SQLServerCentral.