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

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

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

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

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

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

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

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

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

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