PASS Data Community Summit is just a few days away—don't miss your chance to join the world's largest gathering of data platform professionals. Featuring over 250 sessions and speakers, Learning Pathways, keynotes, and networking opportunities, this is your chance to level up your data career. Registration is free!
The post Don't miss out on 3 days of data platform training appeared first on SQLServerCentral.

In this article, we will explore the HTAP capabilities of Cosmos DB. The goal is to derive real-time insights from transactional changes made to Cosmos DB, in a cost-effective manner with minimal overhead. I want the solution to be scalable, reliable and overall simple to maintain.
The post Azure Cosmos DB – HTAP using Azure Synapse Link appeared first on SQLServerCentral.

It’s not difficult to set up an extended event session, but reviewing and saving the data can be complex. In this article, Edward Pollack demonstrates how to collect extended event data.
The post Automating Extended Events data collection appeared first on SQLServerCentral.

With Google Sheets you can create branded reports with data visualizations to share with your clients. Combined with CData Cloud, Google Sheets give you cloud-to-cloud access to data from the supported SaaS, Big Data and NoSQL sources for visualizations, dashboards, and more. In this article we explain how to use the CData Cloud Add-On to […]
The post Configure the CData Cloud Add-On for Google Sheets appeared first on SQLServerCentral.

Flyway Teams has an Undo facility that enables you to roll back one or more migrations. This article demonstrates how it works and explains how Undo migrations make testing migration scripts easier and branch-based development simpler.
The post Secrets of Flyway Teams Undo appeared first on SQLServerCentral.

In this article we cover which performance monitor counters to use to baseline and troubleshoot SQL Server network issues that may be causing performance issues.
The post SQL Server Network Related Performance Monitor Counters appeared first on SQLServerCentral.

Background The dbatools module is broadly used and is an ever-growing set of useful commands. While looking for some inspiration I checked the old issues logged on the GitHub repository. Finally, I found this one Remove-DbaDbMail Profile and Account · Issue #4990 · sqlcollaborative/dbatools (github.com). The issue was more than 2.5 years old (32 months). […]
The post dbatools - new functions for Database Mail appeared first on SQLServerCentral.

Intro In 2008 I wrote an article called “Scope: The drastic caveat with Logon Triggers.” Ever since, we have been using Event Notifications to capture logins for our SQL Server instances. Issues were only very rare, usually on servers that had an extreme load of many connections. In such a case, we stopped this continuous monitoring and […]
The post Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events appeared first on SQLServerCentral.