Author: Vedran

sp_xdetails – procedure instead of SSMS Addin

While ago I wrote SSMS Addin called SQL XDetails. It was not updated long time because GUI integration with new SSMS versions were different every time and too much for my poor csharp knowledge. I am a DB guy after

Tagged with: , , , , ,

Speaking in Finland

In 2 days, 11th of May, I speak in Helsinki, Finland about SQL Server Magic. The country with the best education in the world, thinking out of the box, plus very nice nature and the best air quality. I am

Tagged with: , ,

Speaking in Sweden

In less than two weeks I will speak at SQL Saturday conference in Stockholm, Sweden. I am very excited to meet people there and see at least a glimpse of their culture and way of thinking.

Tagged with: , ,

Plan Cache Tsunami

Your SQL Server may be slow for a peculiar reason: a run-away query that pushes-out all other queries from the plan cache, like a huge wave. So called “tsunami query”. Tsunami query wipes other plans from the cache and makes your SQL running slow. Creating tsunami query is easy and usually not intentional: a developer concatenates values in SQL command string. As it “works on my machine”, it easily slips to production (nobody tests for this, right?), and the monster is loose!

Tagged with: , , ,

Databases on file share

Introduction You might have lot of virtual machines (VM) for Dev and Test environments. And a storage with huge amount of space to fit all databases. What are the options? Probably the best for performance would be to connect to

SQL Server 2017 and 2019 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

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