Sites Microsoft


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 …

Cumulative Update #21 for SQL Server 2017 RTM

Publié le 1 juillet 2020 sur MS Tech Community
 

The 21th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …

It just works – Backup compression on TDE databases

Publié le 1 juillet 2020 sur MS Tech Community
 

There’s not much logic to native database backups in SQL Server – read bits from the data file, write bits to the backup file – so the performance of a backup is essentially a factor of I/O speed.  Back in SQL Server 2008, backup …

Best Options for Database Migration into Azure

Publié le 30 juin 2020 sur Azure SQL Database Blog
 

We often hear that customers need help determining the best option when migrating their on-premises SQL Server to Azure. See the link below to the blog and video we developed to address that question. The video will help you begin your migration journe …


Pages :