Vendors/3rd-party Products

Building reusable table build scripts using SQL Prompt

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

You need a fast, general-purpose way to save the results of a query or batch or procedure into any sort of worktable, such as a temporary table or a table variable or table valued parameter. A simple SELECT…INTO isn't versatile enough for these requirements, and the alternative ways to handcraft the list of columns are slow and error prone. Phil Factor shows how to create a 'table-build generator' that will do all this, and save you a lot of time, especially if you use a lot of working tables in your code.

2021-03-30

Customizations in SQL Prompt

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

In this brand new course on the Redgate University Grant Fritchey walks you through the many ways in which SQL Prompt can be customized to suit your specific needs.

2021-03-29

Why is my SQL Server Query Suddenly Slow?

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

A SQL Server query is suddenly running slowly, for no obvious reason. Grant Fritchey shares a 5-point plan to help you track down the cause and fix the problem.

2021-03-26

Checking for Missing Module References in a SQL Server Database Using Flyway

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

There are certain checks that need to be done after a database migration is complete. One good example of this is the check that a migration script, such as one that merges changes from a branch into main, doesn't cause 'invalid objects' (a.k.a. 'missing references') in your databases. I'll show you how to run this check, using sp_RefreshSQLModule, and incorporate it into a Flyway "after" migration script.

2021-03-25

Key findings from the 2021 State of Database DevOps report

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Redgate has just published the 5th annual State of Database DevOps report, In this blogpost, Andrea Giardina explores key insights across four trends: DevOps adoption, performance & DevOps, the rise of cloud & cross-database, and the impact of the pandemic.

2021-03-24

SQL Templates and Code Snippets in SSMS and SQL Prompt

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide.

2021-03-22

Documenting a SQL Server Data Catalog in HTML and Git Markdown

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Dave Poole explains the need for high quality database documentation and then demonstrates how to document the SQL Server database for a data catalog, in both HTML and Git Markdown, using SQL Doc, SQL Data Catalog, PowerShell, and a few helper scripts to ensure consistency and correctness.

2021-03-19

Reusing Query Results in SSMS

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Every time you need to reuse the query results from SSMS, for example to populate another table, or to search for matching rows in another table, it will inevitably mean a lot of manual tweaking to the get the results into the right format. Louis Davidson uncovers three SQL Prompt gems that can remove all this pain.

2021-03-16

Getting Data In and Out of SQL Server Flyway Builds

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

Phil Factor provides SQL routines to extract data from and load data into a SQL Server database, using BCP, and then a PowerShell automation script that uses Flyway to automatically build a database, from scratch and then fill it with data, ready for testing.

2021-03-10

What is the state of Database DevOps in 2021?

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

• Article

The latest State of Database DevOps report has been published and it’s packed with data from over 3000 IT professionals. You’ll learn about the latest DevOps trends, industry insights, and tips from contributors such as Pramod Sadalage and Kendra Little. Get your free copy.

2021-03-08