Developer’s Choice: Hinting Query Execution model

Over the years you have read a number of blogs advocating for or against trace flags that influence SQL Server’s query execution model. You can see a number of query execution related trace flags are documented at http://aka.ms/traceflags. However, trace flags are deemed a hacky way of influencing SQL Server’s behaviors – they’re named trace…

0

SQL Server on Linux: ADAuth issues 1: Issues with joining a VM to a domain

AD authentication is a popular mechanism for login and user authentication. It works very well in many scenarios, especially for enterprise applications. AD authentication is a supported scenario on SQL Server on Linux. Configuring the Linux VM to join with Active Directory (AD) can be a little tricky at sometimes though, especially in a complex…


Installing SQL Server 2017 for Linux on Ubuntu 18.04 LTS

Prior to SQL Server for Linux 2017 CU10 the package dependencies prevented install on Ubuntu 18.04 LTS. The SQL Server 2017 installation packages have updated use the libssl1.0.0 package, allowing installation to occur on Ubuntu 18.04 LTS installations. Ubuntu 18.04 LTS was updated and ships with version 1.1 of the openssl package. SQL Server 2017…


SQL Server Availability Groups – Enhanced Database Level Failover

Database level health detection failover (DB_Failover) option for Availability Groups was introduced in SQL Server 2016 with the objective to provide a mechanism for availability groups to failover, if one or more databases in the availability had any issues. This feature helps guarantee the high availability for your databases and is a recommended best practice…

0

Behavior Change for VSS Backups on VMs with Basic Availability Groups

This week we released SQL Server 2016 SP2 CU2 and SQL Server 2017 CU9. In this blog, I’d like to go into a little more detail on one of the fixes that is part of these CUs which involves the SQL Writer Service. If you are running SQL Server 2016 (or later) Standard Edition with…

0

Tiger Team at Data Platform Summit 2018

Tiger Team (@mssqltiger) represented by (Tejas Shah and Sourabh Agarwal) will be presenting about the recent investments in SQL Server at the Data Platform Summit (#DPS10), Asia’s Premier Data & Analytics Conference taking place on 9-11 August in Bangalore, India. Data Platform Summit 2018 is a full 3-day conference with more than 7 tracks, 50+…

0

Predicate Pushdown and why should I care?

If you follow this blog, you know that in the last couple years, we have been adding more information to showplan, to make it a one-stop-shop for all your query performance troubleshooting insights. You can see more about those showplan enhancements here. Hold on, there’s a reason I’m writing about showplan: in this scenario we…


TEMPDB – Files and Trace Flags and Updates, Oh My!

TL;DR – Update to the latest CU, create multiple tempdb files, if you’re on SQL 2014 or earlier enable TF 1117 and 1118, if you’re on SQL 2016 enable TF 3427. And now it’s time for everyone’s favorite SQL Server topic – tempdb! In this article, I’d like to cover some recent changes that you…

0