SQL Server CE: Multiple single-column statistics connected by OR
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
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
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
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)
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
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
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
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
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
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
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
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
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!
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.
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 …