Author: Vedran

SQL Server 2017 on Docker inside Synology DS918+

Introduction Docker is perfect for launching DEV and TEST SQL Server environments, when you need many independent SQL instances, or ability to run and stop instances in seconds, only when you need them. Launched from one common image (1GB in

Tagged with: , , ,

SQL Profiler for Developers and Testers

Introduction You developed a new TSQL code and want to check is there a slow SQL statement inside and which is it? Or you debug the code and want to know which statement throws error, maybe inside of a trigger

ROWVERSION/TIMESTAMP skipping rows problem

Do you use ROWVERSION/TIMESTAMP to pull changed data? If you do, you might experience a problem – not all changed rows are pulled, some are skipped. How can that be, if we pulled entire range of rowverion changes with no

Tagged with: , , , ,

Confusion between Login and User in SQL Server

There is often confusion between Login and User in SQL Server. What is the difference and what is the link? I hope to clear that out in this short video:

Speaking in Iceland

In a few days I am traveling to Iceland for the first time in life. A land of lava, ice caves and Aurora Borealis. There is a SQL Saturday conference organized by local SQL community that I am looking forward

Collect Performance Data

Introduction Server is sometimes slow and you want to know why? Here is a lightweight diagnostic SQL kit which will give you the answer. You need to put it on your server to start logging of performance info. This solution

Tagged with:

Single-Row Deadlock

Introduction Demonstration of the smallest possible deadlock: only one statement, one table, one row. Without transactions (no BEGIN TRANSACTION). Even RCSI (Read Committed Snapshot Isolation) is turned ON to eliminate shared locks. Everything is “by the book” as Books Online

Tagged with: ,

Speaking in Switzerland!

It is SQL Server user group in Basel, after spending short time in Zürich. I am very happy to meet people there. Presentation will be very useful and interesting, and you are more than welcome to register and get there!

How to save 250 000 EUR to your customer?

Recently, for the first time in my life I had a customer from India. A far away, beautiful country I had never opportunity to visit, with 1.3 billion of people. I thought it would be interesting experience, and it was indeed.

Speaking at Kulendayz 2017

I am honored to be selected to speak in not one but two sessions of SQL Server conference Kulendayz 2017. The topics are “Tuning optional filters” and “Mirror Killer in SQL 2016&2017 Standard Edition”. There are also other great speaks

Top
Visit Us On TwitterVisit Us On FacebookVisit Us On LinkedinVisit Us On YoutubeVisit Us On Google PlusCheck Our Feed