(Hannes du Preez) You can easily find tables referenced by foreign keys with a script similar to the following:

(Daniel) Azure provides native monitoring capabilities for an Azure Kubernetes Service cluster based on Azure Monitor, Azure Log Analytics and the Container Insights solution.

(Chris Webb) Recently I was working on an MDX calculation that calculated a value at a low granularity and aggregated the result – basically what I described in my blog post here.

(Kenneth Fisher) Anything that happens in a trigger happens within the same transaction of the command that called it.

(blobeater) The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when using Azure SQL Database?

(Pedro Lopes) Over the years you have read a number of blogs advocating for or against trace flags that influence SQL Server’s query execution model.

(Joe Gavin) We all have probably seen this. As a SQL Server DBA, you’re expected to support anything resembling a SQL Server in your environment regardless of who installed it, or whether you have or can get sysadmin access to it.

(Sifiso W. Ndlovu) As developers of business intelligence solutions, we tend to service different types of business users.

(Thomas LaRock) First, a quick definition and example for those that don’t know what deadlocks are inside of a database.

(Greg Larsen) If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably.