Sites Microsoft


SQL Server CE: Multiple single-column statistics connected by OR

Publié le 7 septembre 2021 sur SQL Server Support Blog
 

In post SQL Server CE: Multiple single-column statistics, I discussed the selectivity when AND is used to join the columns in Where clause. Today, I’m going to talk about the OR operator   Let’s say we have four predicates connected by O …

SQL Server CE: Multiple single-column statistics

Publié le 7 septembre 2021 sur SQL Server Support Blog
 

The SQL Server Query Optimizer is a cost-based Query Optimizer. For one specific query and tables,  SQL Server creates the query plan based on the estimated rows. Hence, understanding how SQL Server calculate the estimated rows helps you troublesh …

SQLIOSim utility now available for Linux

Publié le 2 septembre 2021 sur MS Tech Community
 

We are excited to announce the availability of SQLIOSim utility for Linux ecosystem. SQLIOSim is used to perform stress tests on disk subsystems to simulate SQL Server activity. You can use this tool to perform reliability and integrity tests on d …

GMSA is used for SQL service and it fails to start

Publié le 31 août 2021 sur SQL Server Support Blog
 

    GMSA is used for SQL service and its failing to start with error “the request failed, or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details”.      I …

Custom visuals failing to load in Power BI desktop for RS (May 2021)

Publié le 31 août 2021 sur SQL Server Support Blog
 

This article discusses about the issue with custom visuals failing to load in Power BI desktop for RS and the solution to get the visuals to load.   About the issue: From Power BI desktop for RS, when adding a custom visual from local file, the vi …

Move SQL Server licenses without Software Assurance to Azure

Publié le 30 août 2021 sur SQL Server Blog
 

Migrating your on-premises infrastructure and architecture to the cloud may seem like a daunting task, especially if you don’t have Software Assurance for your on-premises licenses. While this may seem difficult and challenging, there is a pain-free wa …

Released: Microsoft.Data.SqlClient 4.0 Preview 1

Publié le 25 août 2021 sur MS Tech Community
 

Microsoft.Data.SqlClient 4.0 Preview 1 has been released. This release contains improvements and updates 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. …

Microsoft at Data Platform Virtual Summit 2021

Publié le 24 août 2021 sur SQL Server Blog
 

Data Platform Virtual Summit 2021 (DPS 2021) is just a few days away. A free, global learning event for the data professionals, DPS 2021 will feature over 150 breakout sessions and 15 training classes. This content will be delivered by Azure Data Engin …

SQL Server 3rd Party Backend for Django v1.0 Released

Publié le 17 août 2021 sur MS Tech Community
 

We’re officially announcing the release of mssql-django v1.0 as an open source project!   At Microsoft we’ve heard from the community loud and clear – SQL Server is the biggest enterprise backend not yet fully supported in Django.   That’s ab …

Near real-time monitoring of SQL Server Linux/containers using Telegraf-InfluxDB and Grafana

Publié le 6 août 2021 sur MS Tech Community
 

Introduction:  In this blog, we will look at how we configure near real-time monitoring of SQL Server on Linux and containers with the Telegraf-InfluxDB and Grafana stack. This is built on similar lines to Azure SQLDB and Managed In …

JDBC Driver 9.4 for SQL Server Released

Publié le 5 août 2021 sur MS Tech Community
 

Version 9.4 of the Microsoft JDBC Driver for SQL Server has been released. Version 9.4.0 brings several added features, changes, and fixed issues over the previous production release.   Added Added Java 16 support #1579 Added optional realm c …

Cumulative Update #12 for SQL Server 2019 RTM

Publié le 5 août 2021 sur MS Tech Community
 

The 12th cumulative update release for SQL Server 2019 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 …

ODBC Driver 17.8 for SQL Server Released

Publié le 30 juillet 2021 sur MS Tech Community
 

Version 17.8 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.8 brings several new features and fixes to the driver.   Features Ability to modify KeyStoreAuthentication and KeyStorePrincipalId settings via the DSN …

Deploy SQL Server – The Ansible way!

Publié le 28 juillet 2021 sur MS Tech Community
 

Today, we’ll look at how to automate SQL Server deployment and configuration on Linux. To automate our deployment, we will use the Ansible system role, which is available here.   Note: The Ansible system role that I use in this blog is a sample sy …

Azure Defender for SQL is now available on the SQL Virtual Machine blade.

Publié le 27 juillet 2021 sur MS Tech Community
 

Running SQL Server on Azure VM comes with many benefits such as  Lower the cost to run SQL Server on Azure with Azure-only pricing offers.  Easily bring your SQL Server to the cloud and enjoy versatile and powerful virtual …


Pages :