Sites Microsoft


Exploring Azure SQL Managed Instance Management Pack

Publié le 21 juillet 2020 sur MS Tech Community
 

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

Publié le 17 juillet 2020 sur SQL Server Support Blog
 

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

Publié le 16 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 15 juillet 2020 sur SQL Server Blog
 

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

Publié le 14 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 10 juillet 2020 sur SQL Server Support Blog
 

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

Publié le 9 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 7 juillet 2020 sur Azure SQL Database Blog
 

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?

Publié le 7 juillet 2020 sur MS Tech Community
 

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

Publié le 6 juillet 2020 sur SQL Server Support Blog
 

 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

Publié le 6 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 6 juillet 2020 sur MS Tech Community
 

  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)

Publié le 3 juillet 2020 sur MS Tech Community
 

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

Publié le 2 juillet 2020 sur Azure SQL Database Blog
 

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

Publié le 2 juillet 2020 sur MS Tech Community
 

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 …


Pages :