Select Page

Getting started with Azure SQL Managed Instance

Azure SQL Managed Instance is fully managed PaaS version of SQL Server hosted in Azure cloud and placed in you own VNet with private IP address. In this post, I will shortly explain how to configure and create Managed Instance ... continue reading
OpsMgr event ID 26319 and p_GetDatawarehouseVersion on SCOM 1801 – RESOLVED !!!

OpsMgr event ID 26319 and p_GetDatawarehouseVersion on SCOM 1801 – RESOLVED !!!

First published on TECHNET on Jun 25, 2018 Hi SCOM folk Today I am going to blog how to resolve event ID 26319 on System Center Operations Manager (SCOM) 1801 related to the p_GetDatawarehouseVersion stored procedure from getting generated. The ... continue reading
How to deal with Scheduled Maintenance Mode and SQL Always On

How to deal with Scheduled Maintenance Mode and SQL Always On

First published on TECHNET on Mar 08, 2018 UPDATE: November 2018 the 9 th – For SCOM 2016 only this issue has been fixed in UR6 Hi everyone, Bruno here. Today I will cover a topic that came to my ... continue reading
Confidential computing using Always Encrypted with secure enclaves in SQL Server 2019 preview

Confidential computing using Always Encrypted with secure enclaves in SQL Server 2019 preview

SQL Server 2019 preview brings encryption technology to a broader set of scenarios by enabling rich confidential computing capabilities with the enhanced Always Encrypted feature, Always Encrypted with secure enclaves. Always Encrypted with secure enclaves allows rich computations on encrypted ... continue reading

Automate Always On availability group deployments with SQL Virtual Machine resource provider

We are excited to share that a new, automated way to configure high availability solutions for SQL Server on Azure Virtual Machines (VMs) is now available using our SQL VM resource provider. To get started today, follow the instructions in ... continue reading
SSMS 17.9.1 is now generally available

SSMS 17.9.1 is now generally available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9.1. Download SSMS 17.9.1 today and for details please see the Release Notes. This is a minor update to 17.9 with the following important improvements: Occasionally, SSMS ... continue reading
SSMS 18.0 Public Preview 5 Released

SSMS 18.0 Public Preview 5 Released

We are very excited to announce the release of Public Preview 5 of SQL Server Management Studio (SSMS) 18.0. This release has a number of new features and capabilities and several bug fixes across SQL Server Management Objects (SMO), UI, ... continue reading
Azure Data Studio for SQL Server

Azure Data Studio for SQL Server

Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under the preview name SQL Operations Studio, Azure Data Studio offers a ... continue reading
The easiest way to create Azure VM that can access your Azure SQL Managed Instance

The easiest way to create Azure VM that can access your Azure SQL Managed Instance

Azure SQL Managed Instance is fully managed and secured SQL Server Database engine hosted in Azure cloud, placed in your private Azure VNet. In order to access your Managed Instance, you need to create VM in your VNet where you ... continue reading
SSMS 17.9 is now available

SSMS 17.9 is now available

We are excited to announce the release of SQL Server Management Studio (SSMS) 17.9! Download SSMS 17.9 and review the Release Notes to get started. SSMS 17.9 provides support for almost all feature areas on SQL Server 2008 through the ... continue reading