Sites Microsoft


ODBC Driver 17.5 for SQL Server Released

Publié le 3 février 2020 sur MS Tech Community
 

Version 17.5 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.5.1 brings a few new features and a handful of fixes to the driver. FeaturesNew SQL_COPT_SS_SPID connection attribute provides SPID without a round-trip …

Microsoft Drivers 5.8.0 for PHP for SQL Server Released

Publié le 3 février 2020 sur MS Tech Community
 

We recently released Microsoft Drivers for PHP for SQL Server, version 5.8.0. This production release of the SQLSRV and PDO_SQLSRV drivers has been built with PHP 7.2, 7.3, and 7.4 and tested on all supported platforms. Notable items about this re …

JDBC Driver 8.2 for SQL Server Released

Publié le 3 février 2020 sur MS Tech Community
 

Version 8.2 of the Microsoft JDBC Driver for SQL Server has been released. Version 8.2.0 brings several added features, changes, and fixed issues over the previous production release. AddedSupport for Always Encrypted with secure enclaves #11 …

Compute-optimized Fsv2 hardware in Azure SQL Database

Publié le 3 février 2020 sur Azure SQL Database Blog
 

Executive summary For CPU-bound workloads, Fsv2 can improve query response time and workload throughput by 20-40%, compared to Gen5 hardware.   What is Fsv2-series hardware? At the Ignite conference in November 2019, we introduced the preview of t …

New Data Exposed episode: It’s just SQL: CLR in Azure SQL Database Managed Instance

Publié le 23 janvier 2020 sur Azure SQL Database Blog
 

With the Common Language Runtime (CLR) hosted in Microsoft SQL Server (called CLR integration), you can author stored procedures, triggers, user-defined functions, user-defined types, and user-defined aggregates in managed code. CLR is also availa …

Optimize TCO with new SQL Server Software Assurance Benefits for Disaster Recovery

Publié le 22 janvier 2020 sur MS Tech Community
 

Software Assurance (SA) Benefits for SQL Server are enhanced on November 1st, 2019 with new rights to build a holistic high availability (HA) and disaster recovery (DR) plan for SQL Server workloads. Enhanced SA rights for SQL Server enable significant …

Failed to restart Polybase Data Movement service after running sp_polybase_join_group

Publié le 22 janvier 2020 sur SQL Server Support Blog
 

If you have a SQL Server 2019 named instance with Polybase feature as Head node, you may fail to restart the PolyBase Data movement service in compute node,after running the sp_polybase_join_group. You follow the steps in https://docs.microsoft.com/en- …

Released: Microsoft.Data.SqlClient 2.0 Preview 1

Publié le 22 janvier 2020 sur MS Tech Community
 

The SqlClient team is moving forward with continuous updates and improvements to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two preview releases in between. This cadence should provid …

Released: update for Kerberos Configuration Manager for SQL Server

Publié le 17 janvier 2020 sur MS Tech Community
 

The Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server, SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS). It can perform the follo …

New Data Exposed episode: How to connect to Azure SQL Database from Azure Data Studio

Publié le 16 janvier 2020 sur Azure SQL Database Blog
 

Want to get started with Azure Data Studio but don’t know where to begin? In this video, Anna Hoffman shows you how to get connected to Azure SQL Database for the first time using Azure Data Studio.  

Azure SQL Database Edge – Public Preview

Publié le 14 janvier 2020 sur MS Tech Community
 

Azure SQL Database Edge is available in public preview. Azure SQL Database Edge runs on ARM and Intel architecture and brings the most secure Microsoft SQL engine to the edge. By running the same Microsoft SQL database engine both on-premises and in th …

Scaling up an IoT workload using an M-series Azure SQL database

Publié le 13 janvier 2020 sur Azure SQL Database Blog
 

Executive summary M-series provides close to 30 GB of memory per core and up to 128 cores, enabling significant scale-up capability in Azure SQL Database. For the same IoT workload, we achieved 3 times higher throughput on M-series compared to P15, at …

Creating a database in Azure Blob Storage from SQL Server running on Linux OS may fail with Msg 1802

Publié le 10 janvier 2020 sur SQL Server Support Blog
 

If you have SQL Server 2017 running on Linux operating system and you try to create a database pointing to Azure blob storage using following statement it may fail with Msg 1802 error   USE master CREATE CREDENTIAL [https://<mystorageaccountnam …

New Data Exposed episode: Deployment options for Azure SQL Database

Publié le 9 janvier 2020 sur Azure SQL Database Blog
 

Azure SQL Database provides a number of options to optimize your deployment to best fit your needs. In this video we explain the different options and their aspects. More information: https://docs.microsoft.com/en-us/azure/sql-database/sql-databas …

Availability Groups in Big Data Clusters. Two or more replicas in the same node?

Publié le 6 janvier 2020 sur SQL Server Support Blog
 

Availability Groups in Big Data Clusters. Two or more replicas in the same node?   Big Data clusters supports high availability for all its components; most notably for the SQL Server master it provides an Always On Availability Group out of the b …


Pages :