One more reason to use foreign key constraints

Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]

Using Table Hints in a Query

Disaster Recovery and High Availability Solutions in SQL Server

Learn about disaster recovery and high availability options in SQL Server with details on the tradeoffs you make when choosing from Availability Groups, Log Shipping, Database Mirroring, and Replication.

Default Objects in Clones

Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts

Learn how it works and how to use the DENSE_RANK() function in your code.

Join Hint Limitations

To Each Their Own

I recently came back from a trip to Las Vegas. I was privileged to be able to take part in the very first Fabric Community Conference. It was a great event, well attended. BUT... It was in Las Vegas. I am not a fan. First of all, Vegas is just far too noisy for me. […]

SQL Server Patching Using PowerShell DSC

In this article, learn how to use the PowerShell DSC to patch your SQL Server instances.

How to Optimize Power BI Semantic Model Performance with Vertipaq Analyzer

Learn how to optimize the size of your Power BI semantic models with the free Vertipaq Analyzer tool. Extra tips & tricks included.

Correct SQL Server Transactional Replication Issues with T-SQL and SSMS

Learn how to address SQL Server transactional replication issues with these easy-to-follow steps using T-SQL and SSMS to troubleshoot and fix issues.