(Pinal Dave) I love working with my clients and solving their SQL Server Performance Tuning challenges which are difficult to solve. I have been working for over 10 years performing Comprehensive Database Performance Health Check at many different clients and my clients can vouch that I have seen pr

(Ranga Babu) In this article, we will review SQL Server MERGE statement, alternatives to MERGE statement, different clauses and examples of MERGE statement in SQL Server.

(Kenneth Fisher) In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting question came up.

(John Miner) Microsoft has provided customers with boiler plate architectural diagrams for common business problems. The solution diagrams website is a great place to start as a reference point when creating a new custom solution.

(Chris Webb) While writing my Microsoft Business Applications Summit session on Power Query-related reasons for Power BI dataset refresh failures (which you can watch online here for free, along with all the other sessions), I remembered something important that I have been meaning to blog about for

(Paul White) The ANY aggregate is not something we can write directly in Transact SQL. It is an internal only feature used by the query optimizer and execution engine.

(Pinal Dave) While I work with my customers on SQL Server Performance Tuning Practical Workshop, I always try to categorize them into one of the following three issues 1) CPU, 2) Memory or 3) IO. Recently, while working with the customer who had a Memory issue, we ended up talking about Clean Pages

(Eduardo Pivaral) Azure Data Studio’s (ADS) popularity has been growing, this is because it is a cross-platform tool focused on working with data related tools (not just SQL Server, as support for other databases is being added).

(Pinal Dave) Database Diagram was one of the most popular features of SQL Server Management Studio (SSMS). This feature was available in SSMS till version 17.9. However, the same was removed by Microsoft in version 18.0.

(Jason Brimhall) Permissions in the database environment is such an important task. Setting permissions correctly is paramount to a successful audit and one of your best defenses against improper/unwanted access.