Exploring Azure SQL Managed Instance Management Pack
We released System Center Operations Manager Management Pack for Azure SQL Managed Instance recently. It provides comprehensive monitoring capabilities for SQL Managed Instance. If you have a hybrid data environment, you can use a single monitoring sol …
How to find SQL Server Replication related jobs and T-SQL statements
Verbose log is heavily used in replication troubleshooting. You need to find the right job to enable to verbose log. However, it’s not easy to find the jobs when you have hundreds replication jobs in one server. Here is how: 1 …
Azure SQL and IoT | Data Exposed
IoT is almost always associated with NoSQL database. This is quite understandable as its flexibility and specialization are great for ingesting IoT data. But what if that flexibility and performance are also available in Azure SQL? That would make Azur …
The July 2020 release of Azure Data Studio is now available
The July release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.Azure Data Stu …
The Benefits of Advanced Threat Detection in Azure SQL Database | Data Exposed: MVP Edition
One of the major benefits of Azure SQL Database is that the Azure platform provides additional protection for your database against SQL Injection attacks and Data Exfiltration, amongst other threats. In this episode, MVP Joseph D’Antoni teaches you …
How to configure windows authentication for Microsoft JDBC in Linux
How to configure windows authentication for Microsoft JDBC in Linux. (We use Squirrel to do this test) Install necessary packages sudo yum install realmd krb5-workstation sudo yum install sssd-tools sudo yum install samba-common-tools Edi …
Why Azure SQL is Best for Developers (Part 2) | Data Exposed
In the second part of this two-part series, Davide Mauri and Anna Hoffman further discuss why Azure SQL is the best database in the cloud for developers, dive deeper into architectures, and review customer case studies to truly understand how Azur …
Data Exposed + MVPs = Better together
Today, we have exciting news to share as part of the launch of joint efforts between multiple organizations in Microsoft and the MVP community. I thought it’d be interesting to take a look at how far we’ve come (and how much fun we’ve had). A li …
What is MaxDOP controlling?
The Max Degree of Parallelism, or MAXDOP, is one of the most known settings in the SQL Database Engine. There are guidelines of how to configure it that have intricate dependencies on the type of hardware resources you’re running on, and there ar …
[SQL Server on Azure VM] Automated Backups run daily when scheduled to run weekly
When we enable Automated Backup for SQL Server as documented in https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-backup and if we setup manual schedule with Weekly backup, we will continue to see the backup …
COVID-19 data analytics and reporting with Azure Databricks and Azure SQL
With the evolving need to keep up with growing data volumes, increased data dependency on the business decision making process and the evolution of data platforms with Cloud Computing, enterprises have widely adopted Unified Analytics systems, Data War …
Lift and Shift Always ON SQL Server Failover Cluster Instance (SQL FCI) to Azure VMs
Today, we are announcing two new features enabling lift and shift of Always ON SQL server Failover Cluster instances (SQL FCI) from on-premises to Azure Virtual Machines: Distributed Network Name (DNN) for SQL FCI and Azure Shared Disks for SQL …
Released: Azure SQL Managed Instance Management Pack (7.0.22.0)
System Center Operations Manager Management Pack for Azure SQL Managed Instance is now available. If you have a hybrid data environment and SCOM is your preferred monitoring solution, you can now use it to monitor your Azure SQL Managed Instances …
Why Azure SQL is Best for Developers (Part 1) | Data Exposed
Azure SQL has a lot of built-in features that make it the best database in the cloud for developers. In this first part of this two-part series, Davide Mauri discusses what those features are and which kinds of customers can benefit most from them. Wat …
Released: Preview of Azure Arc enabled SQL Server
We are making available the private preview of Azure Arc enabled SQL Server. The preview includes the following features: Use the Azure Portal to register and track the inventory of your SQL Server instances across on-premises, edge sites, and multi-cl …