(Pinal Dave) Do you still use SQL Server Management Studio or do you use Azure Data Studio? I was recently asked during my recent Comprehensive Database Performance Health Check, Well, the answer is I am still using SQL Server Management Studio (SSMS) as I find it very comfortable and it still has m

Tuning database performance is a complex process, but consultant Joey D’Antoni details a list of SQL Server performance tuning best practices that can make it easier.

(Kenneth Fisher) In my last post I discussed the fact that SQL Ids can, in fact, be useful on an instance that is set to Windows Authentication only. Today I’m going to use that same technique to give someone permission to run a SQL Server Agent job without granting them excessive permissions.

(John Grover) Three years ago, our organization made the decision to go “all-in” with Amazon Web Services. This was not purely a cost-saving effort, but one that also allowed for far greater flexibility with our IT infrastructure.

(Paul White) In SQL Server 2012, grouped (vector) aggregation was able to use parallel batch-mode execution, but only for the partial (per-thread) aggregate.

(Thomas LaRock) Last year I wrote a post comparing the data services offered by both AWS and Microsoft Azure. Well, there’s been some changes since, so it was time to provide an updated graphic and links.

(Pinal Dave) One of the most common connectivity errors which I have heard about it is “A network-related or instance-specific error occurred while establishing a connection to SQL Server.”

(Rick Dobson) In this tip we look at an overview of SQL Server xp_cmdshell to help a SQL Server professional to know when, why, and how to invoke the xp_cmdshell extended stored procedure in SQL Server solutions. We will also look at some errors related to using xp_cmdshell.

(Pinal Dave) I was working with one of my clients and they wanted to clean up old backup blobs from Azure. I have already blogged and shared my script. In this blog we would learn how to fix error: (403) Forbidden – This request is not authorized to perform this operation. SQL SERVER – PowerShell Sc

(Kenneth Fisher) tl;dr; Yes, but.