(Pinal Dave) Today, I have received a very interesting question from my client with whom I have worked in the past on Comprehensive Database Performance Health Check. The question was really not related to SQL Server Performance Tuning but DBA wanted to know if they can use any custom Quote Characte

(Jignesh Raiyani) SQL Server Merge Replication configuration supports Identity Range options using either “Automatic” or “Manual” to manage Auto Incremented values for a column of a table.

(Pinal Dave) Let us discuss a very interesting question recently I received during the 1 FREE consulting hour for SQL Server Performance Tuning Practical Workshop – Recorded Classes. The question was about is there any way to know how many rows each thread execute in parallel operations.

(blobeater) I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only.

(Michael Otey) SQL Server databases can be moved to the Azure cloud in several different ways. Here’s what you’ll get from each of the options for migrating SQL Server to Azure.

(Siddharth Mehta) Amazon Web Services (AWS) is one of the leading cloud providers in the industry, along with other cloud providers like Microsoft Azure and Google Cloud Platform.

(Allan Hirt) It’s been a crazy summer so far. I haven’t had much time to blog but an interesting scenario came up recently that I wanted to share with everyone.

(Jack Vamvas) Question: I’m getting this Execution timeout error when executing a Powershell script using the $sql.ExecuteReader() method. How can I fix this issue?

(Rajendra Gupta) In the SQL world, it is an important activity to perform SQL Server installation for a database administrator. Have you ever noticed ‘SQL Server Startup Parameters’ for the SQL Service? You might not have noticed them, but these parameters are beneficial for DBAs.

(Pinal Dave) SQL Server Performance Tuning is what I do for leaving and every single day, I get different problems to solve. Just another day I was hired for just 1 hour to solve one specific problem of my client with whom I had worked on Comprehensive Database Performance Health Check.