Take Care

The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]

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.