Vendors/3rd-party Products

External Article

SQL Monitor v11.1 now supports Azure SQL Managed Instances

  • Article

Migration to the cloud and PaaS solutions has accelerated in the past years, and many organizations now manage hybrid estates. To reflect this, the latest release of SQL Monitor adds Azure SQL Managed Instances to its list of supported cloud platforms. This article explains how to monitor performance and activity for Azure SQL Managed Instances using SQL Monitor, with advice on monitoring hybrid estates and migrating from on-prem to Azure SQL Managed Instance.

2021-04-15

External Article

Have your say about PASS Summit 2021

  • Article

Redgate has committed to organizing a free virtual Summit for the PASS Community this fall. To help guide the format and provide you and the data platform community with the best virtual event experience possible, we'd appreciate your input. As a thank you for your feedback you could win a Peloton Bike or $3,000 (the equivalent in your local currency) to donate to your chosen charity.

2021-04-13

External Article

Building reusable table build scripts using SQL Prompt

  • 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

Blogs

My 2024 in Data: Music

By

This is my last week of the year working (I guess I come back...

A New Word: Suente

By

suente– n. the state of being so familiar with someone that you can be...

Side Projects

By

Anyone (everyone?) who has ever tried to learn a programming language knows that to...

Read the latest Blogs

Forums

Migrated to new server, 2019 enterprise, jobs taking 300% longer to run. Ideas?

By Mognar

Hi all, So here's the situation. We migrated to a new server as our...

2 identical tables reads on Table1 PK is 53394 reads on table2 PK 2246847

By joe.hellst

Tables have identical structure but different indexes (except) PK and different stats.    all...

Azure SSMS SQL Managed instance Windows Authentication

By Tomys

Hello, I am trying to connect to my SQL Managed Instance from my laptop...

Visit the forum

Question of the Day

DCL

We have DDL, DML, and DCL. What is DCL used for?

See possible answers