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.

Redgate Summit: The Database Landscape

A series of Redgate events across the globe for data professionals who want to improve their skills and knowledge about Database DevOps, learn about moving to the Cloud, AI, and working across multiple databases. Redgate Summit aims to bring together database professionals who want to level-up their skills to navigate the increasingly complex database landscape. Learn more about emergent technologies, and reliably solve the complex challenges of database management across the entire DevOps lifecycle. Each event will all feature three separate tracks covering New and Future Technologies, Deep Dive Solutions, and Leadership, all promising to equip senior database professionals with the tools and insights needed to navigate the intricate landscape of 2024.