Select Page

Do you need more memory on Azure SQL Managed Instance?

Azure SQL Managed Instance is fully-managed SQL Server database engine where you can easily choose the size of the instance with the amount of resources you want to use. Sometime, it is hard to determine what instance size you need ... continue reading

Troubleshooting Database Mail issues in Azure SQL Managed Instance

Azure SQL Database - Managed Instance enables you to directly send the email messages to the external email servers. You can send email messages directly using sp_send_dbmail procedure or via SQL Agent Jobs as alerts. Learn more about Database Mail ... continue reading
Graph display of usage patterns for SQL Database serverless over a 24 hour period

Optimize price-performance with compute auto-scaling in Azure SQL Database serverless

Optimizing compute resource allocation to achieve performance goals while controlling costs can be a challenging balance to strike especially for database workloads with complex usage patterns. To help address these challenges, we are pleased to announce the preview of Azure ... continue reading

SQL Server 2017 achieves top TPC benchmarks for OLTP and DW on Linux and Windows

Once again, SQL Server 2017 has led the pack with three new TPC benchmarks published in April 2019, ranking SQL Server 2017 as the fastest database for online transaction processing (OLTP) and data warehouse (DW) workloads on Windows and Linux ... continue reading
Exam review: AZ-900 Microsoft Azure Fundamentals

Exam review: AZ-900 Microsoft Azure Fundamentals

When did you last sit an official industry exam? For me, it's been more years than I care to count! But recently, a group of staff at my local Microsoft office planned to sit the AZ-900 Microsoft Azure Fundamentals exam ... continue reading
The case of (Un)Explained :ConfigMgr SQL Always ON – Upgrade to 1902 with Certificate backup Error using Listener Name

The case of (Un)Explained :ConfigMgr SQL Always ON – Upgrade to 1902 with Certificate backup Error using Listener Name

Hi there! Here is an interesting one (in case you encounter one), Where the upgrade to 1902 for a SQL AO infra was failing with the below error - CONFIGURATION_MANAGER_UPDATE 28292 (0x6e84) Create_BackupSQLCert : SQL server failed to backup cert ... continue reading

Do you need to more memory on Azure SQL Managed Instance?

Azure SQL Managed Instance is fully-managed SQL Server database engine where you can easily choose the size of the instance with the amount of resources you want to use. Sometime it is hard to determine what instance size you need ... continue reading
Demystifying the Native SQL Replication co-existence issues with Resident ConfigMgr DRS

Demystifying the Native SQL Replication co-existence issues with Resident ConfigMgr DRS

I think it is very common resident knowledge with experts who work on the cases involving Native SQL replication with ConfigMgr DRS (Be it MP Replica DB, or just plain out of box SQL Replication usage in ConfigMgr infra) “The ... continue reading
The case of (un)explained – ConfigMgr Console Slowness After moving to SQL Always ON — Multi Subnet Configuration

The case of (un)explained – ConfigMgr Console Slowness After moving to SQL Always ON — Multi Subnet Configuration

Hi there! Back to you with another installment of the unexplained series. If you ever get into an issue where things got slow after moving to SQL Always ON like 1 minute delay etc. while doing basic things in console ... continue reading
Azure SQL Data Warehouse is a critical piece of the big data pipeline.

Azure SQL Data Warehouse releases new capabilities for performance and security

As the amount of data stored and queried continues to rise, it becomes increasingly important to have the most price-performant data warehouse. While we’re excited about being the industry leader in both of Gigaom’s TPC-H and TPC-DS benchmark reports, we ... continue reading