Sites Microsoft


Configure multiple-subnet AlwaysOn Availability Groups by modifying CIB

Publié le 24 juillet 2020 sur SQL Server Support Blog
 

In the Windows world, a Windows Server Failover Cluster (WSFC) natively supports multiple subnets and handles multiple IP addresses via an OR dependency on the IP address. On Linux, there is no OR dependency, but there is a way to achieve a proper mult …

Configure multiple-subnet AlwaysOn Availability Group by modifying CIB

Publié le 24 juillet 2020 sur SQL Server Support Blog
 

In the Windows world, a Windows Server Failover Cluster (WSFC) natively supports multiple subnets and handles multiple IP addresses via an OR dependency on the IP address. On Linux, there is no OR dependency, but there is a way to achieve a proper mult …

Azure SQL – Automated Backups (Part 1) | Data Exposed

Publié le 23 juillet 2020 sur Azure SQL Database Blog
 

In part one of this two-part series, Shreya Verma discusses the different backups options (point-in-time restore, long-term retention) Azure SQL provides and how to effectively manage them.   Watch on Data Exposed   Additional Resources:Overv …

Changing default MAXDOP in Azure SQL Database

Publié le 23 juillet 2020 sur Azure SQL Database Blog
 

Executive Summary To improve customer workload performance and reduce unnecessary resource utilization, the default MAXDOP setting for new databases in Azure SQL Database is changing from the previous default of 0 (unlimited) to 8.   Why MAXDOP ma …

GA of new memory and compute optimized hardware options in Azure SQL Database

Publié le 23 juillet 2020 sur Azure SQL Database Blog
 

Now released for general availability (GA), M-series and Fsv2-series are new hardware generations in Azure SQL Database specialized for workloads requiring very high compute or memory scale or very …

SQL Server Management Studio 18.6 is now generally available 

Publié le 22 juillet 2020 sur SQL Server Blog
 

The release of SQL Server Management Studio (SSMS) 18.6 is now available for download. Today we’re sharing some of the updates from the release and the ongoing work in SQL Server Management Studio.Download SSMS 18.6 and read on for some highlights from …

Benchmarking SQL Server and Azure SQL with WorkloadTools | Data Exposed: MVP Edition

Publié le 21 juillet 2020 sur Azure SQL Database Blog
 

Lifting and shifting your application to the cloud is extremely easy, on paper. The hard truth is that the only way to know for sure how it is going to perform is to test it. Benchmarking on-premises is hard enough, but benchmarking in the cloud can ge …

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 …


Pages :