Data Channel - Interview 02 - Hamid Fard on SQL Server Memory Capacity Planning

Dear All,

Welcome to the second interview of Data Channel. Very happy and proud to have Mr Hamid Fard, MVP and...

Performance-Oriented SQL Server Development – The Scripts

Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.
It was a great experience,...

Finding Automatic Soft-NUMA

If you already know about Automatic Soft-NUMA in SQL Server 2016, then you probably already read the blog post SQL...

Query tuning 101: Non-trusted Foreign Keys

Foreign keys are an interesting feature of relational databases. They help enforce data integrity, sometimes help improve performance by eliminating...

Off topic: The two cycle engine and your career path

I’ve been in technology for twenty years now. I’ve seen hundreds of environments, nearly 300 while employed at Microsoft alone.
One...

Comparing plan consistency and query performance using the Query Store Replay script

The 1.2 version of the Query Store Replay script a number of new features are added that return information of...

Checking Permissions for Keys–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Power BI Custom Visuals Class (Module 31 – Horizontal Funnel)

In this module you will learn how to use the Horizontal Funnel Power BI Custom Visual.  The Horizontal Funnel functions...

Looking Back At 2016

When this blog started back in 2011 I had no idea that it would continue to grow to where it...

Power BI Custom Visuals Class (Module 32 – Percentile Chart)

In this module you will learn how to use the Percentile Chart Power BI Custom Visual.  The Percentile Chart is...