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.

Power BI Auto Detect Relationship Failure

Power BI doesn't always detect relationships, and this article explains a bit about the problem.

Evolving Role of Data Professionals in Artificial Intelligence Era

Generative Al tools like Gemini and GPT promise to automate and augment knowledge-based work. Data professionals must adapt to this transformation by acquiring new skills and playing a central role in their organization's AI-driven future. Data preparation, curation, ethical sourcing and labeling, and collecting user feedback become crucial as high-quality data is essential for effective LLM based application.

What Every DBA Should Know about Always On Readable Secondaries

Learn a bit about the impact of readable secondaries, which you might not expect.