Author: Vedran

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

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:

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

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

Tagged with: , , , , ,

Query with optional filters (catch-all query)

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 filtering parameters that are optional. The problem is – a query optimized builds only ONE plan that will handle every filter combination you throw at it.

Tagged with: , , ,

Max Memory in SQL Server 2016 Standard Edition

What is the memory limit for Standard edition of SQL 2016? The answer you will most often get is 128 GB. But that answer is not correct, or very partially correct at best case. When you plan a new SQL

Table and Index Compression

Compression feature was reserved for Enterprise Edition of SQL Server. With SQL 2016 SP1 we get it in all editions, e.g. Standard Edition. But, it is not always easy to say will we benefit from compressing certain table/index/partition or not.

Speaking at SQL Saturday Ljubljana

I am honored to be selected to enjoy SQL Saturday in Ljubljana, Slovenia, as a speaker. http://www.sqlsaturday.com/567/Sessions/Details.aspx?sid=54373 It is a free event, so if you want to mingle and learn about SQL, this is the great place! Registration is mandatory,

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