(Pinal Dave) Followup question to previous blog posts is always fun and interesting. Earlier on this blog, I had written about SQL SERVER – Dynamic SQL and Global Temporary Tables, I received following follow up question about Dynamic SQL and Temporary Tables.

(Dinesh Asanka) SQL Server is usually accessed by numerous users and applications. When all applications are in use, overall performance can impact higher priority tasks. There can be cases where some of the applications are business critical therefore, they should not be disturbed by other applicat

(blobeater) There is a lightweight and quick way to start querying your database in Azure which doesn’t involve SQL Operations Studio or Management Studio.

(Grant Fritchey) I’ve said it before and I will repeat myself on this because it’s an important concept:

(Pinal Dave) Recently I had a very interesting situation at my client where I had to visit in person for Comprehensive Database Performance Health Check. Most of my performance tuning engagements are online but there are clients who can’t share their application screen online and I have to visit in

(Chris Webb) There are a lot of great community-developed tools out there for Analysis Services developers to use (BI Developer Extensions, DAX Studio, Tabular Editor, Analysis Services Query Analyzer to name a few) and they have saved me vast amounts of time and effort over the years.

(Marcin Policht) In the article Introduction to Running SQL Server 2019 on Kubernetes recently published on this forum, the core concepts and basic architecture of implementation of SQL Server 2019 Always On Availability Groups on a Kubernetes cluster are described.

(Eduardo Pivaral) In a previous tip we looked at some tips to help improve T-SQL performance and in this tip we continue with some additional tips.

(Jason Brimhall) With SQL Server 2008 and 2008R2 limping along and becoming terminally ill (End of Life Support was July 9, 2019), it should come as no surprise that it is recommended to migrate/upgrade affected databases/servers to newer technology.

(Itzik Ben-Gan) This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices.