Author: Alexander Chigrik

SQL Server

Tips for using ASP.NET with SQL Server 2016

Tips for using ASP.NET with SQL Server 2016 Set the TrustServerCertificate to False in the SQL Azure connection string. The TrustServerCertificate=False setting is recommended to help protect against man-in-the-middle attacks. Use the SQL Server .NET data provider to access SQL Server 2016 data using ADO.NET. Because using the SQL Server .NET data provider provides better performance in comparison with other […]

SQL Server

Some tips for using SQL Server 2016 distributed queries

Some tips for using SQL Server 2016 distributed queries Try to avoid using distribution queries or minimize it using. Because distribution transactions incur more overhead than general transactions, avoid using distribution queries, whenever possible. The first steps to optimize distributed queries against a SQL Server 2016 linked server is rewriting queries so, that the most work will be performed on […]