SQL Monitor v11.1 now supports Azure SQL Managed Instances

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.

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.

Blogs

Daily Coping 22 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Altering a Computed Column in a Temporal Table in Azure SQL

By

System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...

Basic OFFSET–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

SQL2016 to Access2016 Linked server issue

By richardmgreen1

Hi all   We've got an issue with a linked server to an Access...

Future of SQL Server

By sean redmond

I am becoming a little disconcerted by the lack of news about the next...

Changing Data Drive Allocation Unit Size on Existing Installation

By garyb1

I have an existing SQL Server 2019 Standard installation that includes SSRS. The setup...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers