↓ Skip to Main Content
Vedran Kesegic Blog

Vedran Kesegic Blog

Main Navigation

  • Home
  • sp_xdetails
  • Performance Logging
Vedran Kesegic Blog

Vedran Kesegic Blog

Off Canvas Menu

  • Home
  • sp_xdetails
  • Performance Logging
How to save 250 000 EUR to your customer?
Performance

How to save 250 000 EUR to your customer?

Vedran Sep 24, 2017

Recently, for the first time in my life I had a customer from India. A far …

How to save 250 000 EUR to your customer? Read more →

Conferences

Speaking at Kulendayz 2017

Vedran Sep 10, 2017

I am honored to be selected to speak in not one but two sessions of SQL …

Speaking at Kulendayz 2017 Read more →

SQL Server 2017 announcement and quick hello from vacation
Data Engine

SQL Server 2017 announcement and quick hello from vacation

Vedran Aug 19, 2017

We are always thinking about you, sometimes even on vacation! Here is a quick hello video …

SQL Server 2017 announcement and quick hello from vacation Read more →

PowerBI for SQL DBA – Investigating Perfmon Counters
BI

PowerBI for SQL DBA – Investigating Perfmon Counters

Vedran Jul 6, 2017 Tagged with Counters, Perfmon, Performance Analysis, PowerBI

Introduction PowerBI Desktop is a free tool from Microsoft you can download here. Paid versions also …

PowerBI for SQL DBA – Investigating Perfmon Counters Read more →

Crypto-virus resistent backup
Funny hacker in action on his keyboard
Backup and Recovery

Crypto-virus resistent backup

Vedran Jun 24, 2017 Tagged with Backup, Cryptovirus, FreeFileSync, Ransomware, Security, Veeam Endpoint Backup

Introduction Crypto-viruses encrypt your data. If it asks money (a ransom) to decrypt, we call them …

Crypto-virus resistent backup Read more →

Query with optional filters (catch-all query)
Performance, TSQL and SQL Client Code

Query with optional filters (catch-all query)

Vedran May 30, 2017 Tagged with Catch all query, Optimize, Performance, SQL Server, TSQL

In almost every database we have a process that filters the same data with different filters.…

Read more →

Max Memory in SQL Server 2016 Standard Edition
Data Engine

Max Memory in SQL Server 2016 Standard Edition

Vedran May 7, 2017

What is the memory limit for Standard edition of SQL 2016? The answer you will most …

Max Memory in SQL Server 2016 Standard Edition Read more →

Table and Index Compression
Data Engine

Table and Index Compression

Vedran Jan 1, 2017

Compression feature was reserved for Enterprise Edition of SQL Server. With SQL 2016 SP1 we get …

Table and Index Compression Read more →

Conferences

Speaking at SQL Saturday Ljubljana

Vedran Nov 9, 2016

I am honored to be selected to enjoy SQL Saturday in Ljubljana, Slovenia, as a speaker. …

Speaking at SQL Saturday Ljubljana Read more →

Conferences

Speaking at Advanced Technology Days 2016

Vedran Nov 9, 2016

Congratulations! Your session Show me the cache! has been accepted for Advanced Technology Days 12! http://atd.mscommunity.hr/predavanja/#session_61 …

Speaking at Advanced Technology Days 2016 Read more →

Posts pagination

Previous 1 2 3 4 5 6 Next

Our Mission

Our Mission

Databases should be fast and simple to use. We make them so. Do not let your customers wait for a slow database response - hire a top professional! We are passionate about creating highly-tuned SQL Server systems. Do you want yours to become one? Simply call us or send email, and we will take care of the rest.

Vedran Kesegić, M.Sc.
SQL Server Database Consultant
Email: [email protected]

A Random Thought

Keep your transaction log backups at least to second full backup. Even if the latest full backup is corrupt, you can recover without any data loss. E.g. if you take full backup weekly, diff backup daily, and transaction log backup hourly, keep your transaction log backup at least for 2 weeks, so it reaches the second full backup.

Categories

  • Backup and Recovery
    • Transaction Log
  • BI
  • Conferences
  • Data Engine
  • Performance
  • Security and encryption
  • Storage
  • TSQL and SQL Client Code
  • Uncategorized

Recent posts

  • Instant SQL Masterpieces
  • Immutable backup against crypto attacks
  • Database recovery IMPORTANT rule
  • SUSPECT database
  • How to partition a really big table?
Copyright © 2026 Vedran Kesegic Blog | Powered by Responsive Theme
Copyright © 2026 Vedran Kesegic Blog | Powered by Responsive Theme
Visit Us On TwitterVisit Us On FacebookCheck Our FeedVisit Us On LinkedinVisit Us On Youtube