Grateful to have been a Microsoft MVP

A couple of weeks ago I received the disappointing but expected news that I wasn’t renewed as a Microsoft Data...

Make Your Application's Name Heard

Odds are, you’ve got more than one application or script accessing your database or SQL Server instance at any given time. You’re probably stacking them on a small number...

Identifying Blocking Chain in SQL Server

HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...

2016 – A Year to remember

2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid...

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...