(Andrejs anant) Nobody likes to wait. SQL database is multithreaded system that can handle thousands of queries executed simultaneously.

(Thomas LaRock) At some point in your career as a data professional you will need to change the default database file locations in SQL Server 2016.

(Rajendra Gupta) Microsoft released SQL Server to run on Linux servers. To secure the database environment, DBA’s often change the SQL Server port from its default port 1433 to another available port number. In this tip we will see how we can make this change for SQL Server on Linux.

(Pinal Dave) Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.

(Kenneth Fisher) If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run the DMA (Database Migration Assistant).

(Pinal Dave) So far, I have written many blogs and I still feel that there are many errors and scenarios which are still uncovered. Whenever I see a new error and find a new solution, I always share it via this blog. Let us see how we can fix errors related to sp_xp_cmdshell_proxy_account.

(Marcin Policht) In a recent article published on this forum, we described main characteristics of Azure SQL Data Sync. This service, which has been lingering in the Preview mode since its introduction seven years ago, had been until recently one of few offerings that still required the use of the A

(Steven.Schneider) SQLCAT often works with early adopter customers, bring them into our lab, and run their workloads. With SQL Server now available on Linux, we needed a way to visualize performance and PerfMon, being a Windows only tool, was no longer an option.

(Manoj Pandey) Yesterday while opening SSMS I got an error message popup which mentions:

(Michael J Swart) We recently were surprised by a number of exceptions our application threw. Our application was failing when trying to Open a SqlConnection. The exceptions looked like this: