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 to meet. Lot of interesting lectures you can attend there (besides mine of course) – this is the full schedule.

If anyone is interested to meet me, talk about SQL Server, life, or any other topic, it will be an opportunity there in Reykjavik at the conference, or have a drink with me on Sunday after the conference (11th May 2018) – you are welcome to contact me.

Read more ›

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 is already in use by many productions with mission-critical workload.

Read more ›

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 suggest to minimize deadlocks. How is that possible to deadlock? There is a complexity in simplicity of this demo. In video it is explained why single-row deadlock occurs. If you understand single-row deadlock, you will be able to understand even most complex production deadlock situations. And understanding the cause is the first step to eliminate them.

Enjoy the video, and tell me your opinion. Thank you!

Read more ›

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.

They have a 1.5TB SQL Server Enterpise Edition database used by Microsoft Dynamics AX. Read more ›

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 and very interesting topics. Be there and improve your skills! https://lnkd.in/gDhZ7NX #kulendayz17 http://www.kulendayz.com

SQL Server 2017 announcement and quick hello from vacation

We are always thinking about you, sometimes even on vacation! Here is a quick hello video from the island of Brac:

Read more ›

PowerBI for SQL DBA – Investigating Perfmon Counters

Introduction

PowerBI Desktop is a free tool from Microsoft you can download here. Paid versions also exist for Cloud and on premise (your servers), to easily share reports and view them on any device, not just PC. It is used for graphical analysis of any data, by clicking at the beautiful graphs and digging useful information out of it. This demonstration is analyzing Perfmon Counters data needed for SQL Server or Windows performance investigation, but similar process can be used on any data. It is intended for learning and get feeling what PowerBI is and how useful can it be.

This video is intended for PowerBI beginners, Windows administrators, SQL Server DBAs, Techical managers, and anyone who wants to make informed decisions based on investigating data using PowerBI. Enjoy!

Read more ›

Tagged with: , , ,

Crypto-virus resistent backup

Introduction

Crypto-viruses encrypt your data. If it asks money (a ransom) to decrypt, we call them “ransomware”. They cannot encypt your SQL Server databases because sql data and log files are in use by sqlservr.exe process, but they can encrypt your DB backups and other files. You DO have a backup? Normal backup will NOT protect you from cryptovirus. Because we care for your data and security, we will show you how to protect yourself using free tools. It might take more then a few steps to configure, but it needs to be done only once and it pays off in every way. Read on.

Read more ›

Tagged with: , , , , ,

Query with optional filters (catch-all query)

Introduction

In almost every database we have a process that filters the same data with different filters. Typically, query is within a stored procedure that has many optional filtering parameters. That is, only filters that have a value should be applied, and the NULL filters should be ignored in the WHERE clause. The problem is – a query optimizer builds only ONE plan that will handle every filter combination you throw at it. For example, we have index on NAME and another index on ID column. If compiled plan goes by NAME it is not efficient plan to reuse when we execute the procedure with filter on ID in the next procedure call, isn’t it? We get the plan that is occasionally slow, and looks like a random performance problem, giving headache to DBAs. Or to be more precise, it depends on parameter values that proc was executed with while it was (re)compiled. And we do not want our systems to depend on luck or random stuff, like a russion rulet with query plans. We want the best possible performance and consistent response time, without random slowness that drains DBA’s time, company’s money and user’s nervs. Can we achieve that? Yes we can! Read on…

Read more ›

Tagged with: , , ,
Top
Visit Us On TwitterVisit Us On FacebookVisit Us On LinkedinVisit Us On YoutubeVisit Us On Google PlusCheck Our Feed