(Pinal Dave) Today we will discuss a question which I was recently asked by my client during the Comprehensive Database Performance Health Check. The question was do heaps are very bad and always force a table scan?

(Nisarg Upadhyay) In my previous article, I have explained the step-by-step process of installing SQL Server Failover Clustered Instance. In this article, I will explain how to add a secondary node to the existing failover clustered instance.

(Emil Drkusic) One of the most important things in databases is to understand the types of relations in the databases. That stands for both – a process of designing a database model as well as when you’re analyzing your data.

(Jeremy Kadlec) I need to monitor the SQL Server instances in my environment and our IT team has a need to monitor the health and availability of our overall environment. We need to understand the issues in the environment at a high level, prioritize our findings then drill into issues in order to c

(Jack Vamvas) Question: I had a question from a developer who was troubleshooting an application to SQL Server connection via a DSN using ODBC.

(Pinal Dave) Every new consulting engagement teaches me new learnings. In the recent SQL Server Comprehensive Database Performance Health Check engagement, I had faced a very interesting issue, which I had not faced so far ever in my career before.

(Tibor Karaszi) Duh, it’s on the web, you say. Yes, of course it is, but sometimes you prefer to have a local copy of the documentation. For instance:

(Marcin Policht) Azure SQL Database offers a number of resiliency features that deliver a mix of high availability and disaster recovery capabilities.

(Fikrat Azizov) Azure Data Factory (ADF), is a great tool to schedule and orchestrate cloud activities. Although ADF has many features to cover various data integration needs, it is not as flexible as its on-premises predecessor, SQL Server Integration Services (SSIS).