(Pinal Dave) This is one of the common causes in Always On for which my clients contact me – “Unable to create listener”. In this blog we would learn about how to fix event Id 1212 – Attempt to locate a writeable domain controller.

(Prashanth Jayaram) In this article, we’ll walk-through the SQL update statement to modify one or more existing rows in the table.

(Nisarg Upadhyay) How can I email SQL Server database corruption errors when generated by SQL Server DBCC executions?

(Pinal Dave) One of my earlier clients to whom I helped in configuration Always On Availability Group came back to me with strange behavior.

(Chris Webb) It is very difficult for an organisation to decide whether to buy Power BI Premium or to stick with Power BI Pro. Power BI Premium represents a big financial commitment, but how do you know whether the benefits will be worth the costs involved?

(Grant Fritchey) The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but first, let’s explore the idea behind joins.

(benjamin perkins) As if writing some code wasn’t complicated enough, now you need to write it using patterns designed to run on the cloud platform and pick the most effective service or services to run it on.

(Brien Posey) SQL Server 2019 includes welcome new features, particularly updates to its indexing and high availability capabilities and added SQL Server on Linux functionality.

(Glenn Berry) As any veteran production DBA knows, you are often under significant pressure to diagnose and alleviate database performance issues as quickly as possible.

(Pinal Dave) As a part of my consulting, I see many clients who use SSIS. In this blog we would learn how to fix error “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”.