Select Page

Microsoft Azure for the Gaming Industry

This blog post was co-authored by Patrick Mendenall, Principal Program Manager, Azure. We are excited to join the Game Developers Conference (GDC) this week to learn what’s new and share our work in Azure focused on enabling modern, global games ... continue reading
PowerShellExample

The PowerShell Extension is now in the Azure Data Studio Marketplace

We are excited to announce the PowerShell Extension is available in the Azure Data Studio (ADS) marketplace! Now you can write PowerShell scripts with the full benefits of PowerShell Editor Services using the excellent IDE-like interface that Azure Data Studio ... continue reading
Back up SQL Server in Azure VM using Azure Backup.

Enterprise-scale Backup for SQL Server Databases

More and more organizations are moving to the cloud to leverage the key benefits of agility and reduce overall cost. Its likely that at some point in time, your SQL Server will manifest as either of the three implementations in ... continue reading
Flowchart display of Spyglass Reference Architecture

Maximize existing vision systems in quality assurance with Cognitive AI

Quality assurance matters to manufacturers. The reputation and bottom line of a company can be adversely affected if defective products are released. If a defect is not detected, and the flawed product is not removed early in the production process, ... continue reading
Image result for SQL Server FCI with Availability Groups

Achieving SQL Server HA/DR with a mix of Always On Availability Groups and SANless SQL Server Failover Cluster Instances

Introduction The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented. However, most of the available documentation documents configurations that assume the SQL Server FCI portion of the solution utilizes ... continue reading
Alerting on Deadlocks with the SQL Server Management Pack

Alerting on Deadlocks with the SQL Server Management Pack

First published on TECHNET on Oct 28, 2014Today a customer asked me how to configure SCOM to generate Alerts for SQL Deadlocks. Looking in the SQL Server Management Pack, I found that we have event log Rules for deadlocks for ... continue reading
ACS “Event Count” reports

ACS “Event Count” reports

First published on TECHNET on Apr 18, 2013Here are a couple of ACS reports to show the event count by User, Forwarder, and Event ID. Just import the .rdl files into a folder in SQL Server Reporting Services.The first report ... continue reading
Creating a Group of Windows Computer and Health Service Watcher Objects

Creating a Group of Windows Computer and Health Service Watcher Objects

First published on TECHNET on Mar 20, 2012There are a lot of great blogs out there that discuss creating various types of groups ( Kevin Holman and Jonathan Almquist have a number of them), and the stuff that I do ... continue reading
Identify log write limits on Azure SQL Managed Instance using QPI library

Identify log write limits on Azure SQL Managed Instance using QPI library

Azure SQL Managed Instance is fully managed SQL Server instance hosted in Azure cloud. Managed Instance introduces some limits such as max log write throughput that can slow down your workload. In this post you will see how to identify ... continue reading
Running Azure CosmosDB queries from SQL Server using ODBC driver

Running Azure CosmosDB queries from SQL Server using ODBC driver

Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql. Why querying CosmosDB from SQL Server? Cosmos DB enables ... continue reading