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.

Bug Management

by Steve Jones

SQLServerCentral

software development

Google is sponsoring open source projects with development resources.

Using Data Science And Machine Learning In Identifying Fraudulent Activities

by siddharthray123

SQLServerCentral

A look at one way to detect fraud using R and a machine learning model.

Digital Event: Innovate Today with Azure SQL

by Additional Articles

Redgate

Conferences, Classes, Events, and Webinars

Join Microsoft's Rohan Kumar, and a full team of Azure SQL experts, for Innovate Today with Azure SQL. This free digital event from Microsoft lets you choose the sessions and technical demos that are most interesting to you and focus on the capabilities and possibilities that you want to learn more about.

Oracle sequences: The basics

by Additional Articles

SimpleTalk

Oracle

Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they work under-the-hood.

DevOps in Space

by Steve Jones

SQLServerCentral

DevOps and Continuous Delivery (CI/CD)

Steve draws some DevOps parallels with how SpaceX is developing rockets.

Understanding the Internals of a Data Page

by Mohsin Khan

SQLServerCentral

SQL Server internal storage

In Part 1 of this series, we examine the structure of data pages and how your tables are stored on these pages.

Export SQL Server Data to Excel and Add New Columns with C#

by Additional Articles

MSSQLTips.com

Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.

Have your say about PASS Summit 2021

by Additional Articles

Redgate

Vendors/3rd-party Products

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.

Easing Back to the Office

by Steve Jones

SQLServerCentral

Work environment

Companies are starting to bring people back to the office. Microsoft has announced their policy, and Steve wonders if more will follow.

SQL Monitor v11.1 now supports Azure SQL Managed Instances

Bug Management

Using Data Science And Machine Learning In Identifying Fraudulent Activities

Digital Event: Innovate Today with Azure SQL

Oracle sequences: The basics

DevOps in Space

Understanding the Internals of a Data Page

Export SQL Server Data to Excel and Add New Columns with C#

Have your say about PASS Summit 2021

Easing Back to the Office

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

Get a Range of Sequence Values: #SQLNewBlogger

The Agent Era: When “How do I…?” Replaces “Where do I click?”

Forums

that one limitation in replication

Local Agents

Detecting Deadlocks

Question of the Day

Detecting Deadlocks