Redgate Hub

All products

All topics

All databases

All levels

SQL Prompt logo

SQL Prompt Code Analysis: Avoid using the ISNUMERIC Function (E1029)

Avoid using the IsNumeric() function, because it can often lead to data type conversion errors, when importing data. On SQL Server 2012 or later, use the Try_Convert() or Try_Cast() function instead. On earlier SQL Server versions, the only way to avoid it is by using LIKE expressions. Read more

SQL Change Automation logo

Documenting your Database with SQL Change Automation

Phil Factor uses SQL Change Automation and PowerShell to verify that the source code for the current database version builds successfully and, if so, to generate web-based database documentation using SQL Doc. Read more

Data Masker logo

Spoofing Realistic Credit Card Data for your Test Systems using Data Masker

Grant Fritchey shows how to use Data Masker to create fake credit card data that not only looks like the real thing, but also has the right distribution, so will act like it too, when we query it. Read more

SQL Provision logo

Creating Multiple Masked Databases with SQL Provision

Chris Unwin explains how SQL Provision can create copies of multiple databases, each masked consistently, and deliver them as a group. This is useful when, for example, you are working with a Data Warehouse that contains several cross-database relationships. Read more

SQL Prompt logo

SQL Prompt Code Analysis: INSERT INTO a permanent table with ORDER BY (PE020)

Data in relational tables is never guaranteed to be returned in a particular order, so adding an ORDER BY to an INSERT INTO statement is meaningless and, pre-SQL Server 2012, could cause performance issues. If you really need to impose a particular order on rows in the table, use a… Read more

SQL Change Automation logo

Practical PowerShell Processes with SQL Change Automation

Starting from the object-level source code for a database, Phil Factor shows how SCA can create a NuGet build package, use it to migrate target database to the same version, and publish web-based database documentation, a report of what changed on the target and the results of a static code… Read more

Data Masker logo

Data Masker

The ‘Right to be Forgotten’ and Data Masker for SQL Server

SQL Prompt logo

SQL Prompt code analysis: avoid non-standard column aliases (ST002 and DEP021)

If you declare a column alias using equals SQL Prompt will raise a violation of a style rule (ST002). It's best to follow the ANSI-SQL92 standard of assigning aliases using the AS keyword. If the alias is not a standard identifier, delimit it with double quotes. using single quotes has… Read more

SQL Prompt logo

SQL Prompt code analysis: avoiding the old-style TOP clause (ST006)

If you want to use TOP with an expression or subquery, or in INSERT, UPDATE, MERGE, and DELETE statements, then use of brackets is required, so it's a good habit to adopt everywhere. Read more

Redgate Monitor logo

Scaling Redgate Monitor to Large SQL Server Estates

Tony Davis describes the features and capabilities of Redgate Monitor that allow it to scale smoothly to monitor a growing estate of servers and databases, while still providing a single, simple dashboard that gives the team all of the essential SQL Server metrics and alerts, establishes baselines, and detects trends… Read more

Previous Next

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Hub

SQL Prompt Code Analysis: Avoid using the ISNUMERIC Function (E1029)

Documenting your Database with SQL Change Automation

Spoofing Realistic Credit Card Data for your Test Systems using Data Masker

Creating Multiple Masked Databases with SQL Provision

SQL Prompt Code Analysis: INSERT INTO a permanent table with ORDER BY (PE020)

Practical PowerShell Processes with SQL Change Automation

The ‘Right to be Forgotten’ and Data Masker for SQL Server

SQL Prompt code analysis: avoid non-standard column aliases (ST002 and DEP021)

SQL Prompt code analysis: avoiding the old-style TOP clause (ST006)

Scaling Redgate Monitor to Large SQL Server Estates

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Cookies on red-gate.com