Speaking at PASS Virtual Summit 2020

I am delighted to have been selected to speak at the world largest Microsoft Data Platform conference - PASS Virtual Summit 2020. I'll be speaking about the Query Store plan forcing. The session will … [Read More...]

Query Store Configuration Mysteries: QUERY_CAPTURE_MODE

In this article, I am gonna discuss one of the Query Store’s most important parameters – QUERY_CAPTURE_MODE. The QUERY_CAPTURE_MODE parameter defines which queries will be captured and later … [Read More...]

Query Store Configuration Mysteries: QUERY_CAPTURE_MODE

In this article, I am gonna discuss one of the Query Store’s most important parameters – QUERY_CAPTURE_MODE. The QUERY_CAPTURE_MODE parameter defines which queries will be captured and later … [Read More...]

Speaking at PASS Virtual Summit 2020

I am delighted to have been selected to speak at the world largest Microsoft Data Platform conference - PASS Virtual Summit 2020. I'll be speaking about the Query Store plan forcing. The session will … [Read More...]

Quo vadis iliti j*** te fičer koji sve radi umesto mene a ja moram ništa

Ovaj post ima previše psovki da bi bio napisan na engleskom jeziku, al računam da nije malo i to što će dopreti do onih koji se služe srpskohrvatskim jezikom. Postalo je gotovo nesnosno kako … [Read More...]

Last Post

Query Store Configuration Mysteries: QUERY_CAPTURE_MODE

In this article, I am gonna discuss one of the Query Store’s most important parameters – QUERY_CAPTURE_MODE. The QUERY_CAPTURE_MODE parameter defines which queries will be captured and later stored by Query Store. In SQL Server 2016 and 2017, you can choose from three options: ALL, AUTO i NONE. In SQL Server 2019, Microsoft added a […]

RECENT ARTICLES

Query Store Configuration Mysteries: QUERY_CAPTURE_MODE

In this article, I am gonna discuss one of the Query Store’s most important parameters – QUERY_CAPTURE_MODE. The QUERY_CAPTURE_MODE parameter defines which queries will be captured and later stored by … [Read More...]

Two videos from my recent online meetings

In these lockdown weeks caused by covid19, I participated in several online events. For two of them, sessions are recorded. However, since the events were organized by ex-Yu IT communities, both presentations … [Read More...]

Interleaved Execution in SQL Server

I wanted to write an article about the interleaved execution, but what you'll see here is a good illustration of the improvements in SQL Server database engine since the version SQL Server 2012. As you might … [Read More...]

When QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140 does not follow CL 140 rules

In this short post, I will demonstrate (for me) an unexpected behavior of one query hint. In August 2018, Microsoft introduced a new query hint QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_n to let you force another … [Read More...]

Speaking at IT-Tage 2019 Conference in Frankfurt

I am honored to have been selected to speak at one of the largest database conferences in the German-speaking area "IT-Tage 2019" in Frankfurt. The 3-day conference will be held from 10th to 12th December 2019, … [Read More...]

Slovak SQL Server & BI Meeting on 19th November

Next week I'll be back in Bratislava. I have the honor to present at the Slovak SQL Server & BI User Group's meeting. This time, I am gonna talk about developer's features in SQL Server 2019. We'll go … [Read More...]