Tips and Tricks for SQL Server tuning

Live Query Tuning

by Michal Kovaľ on 05/09/2024

During last SQL Server Bootcamp 2024 in Brno - our colleague Jan Repka presented a live query tuning session.

Tuning Index Read more

FIX: Msg 15170, Level 16, This login is the Owner of 2 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped

by Michal Tinthofer on 26/01/2018

Recently I had an issue with this error during upgrade of SSISDB AlwaysOn Support using wizard.

SSISDB AG Jobs Read more

Spectre and Meltdown vulnerability

by Michal Tinthofer on 19/01/2018

We would like to inform you in this form of an important event (about which you may already know yourself). It also applies to the security of your SQL Servers. We think we should have this initiative from our side.

Issues Spectre Meltdown Important Read more

Availability Groups (AG) on named nistances? (Part 1/2)

by Michal Tinthofer on 23/07/2013

SQL Server 2012 introduced AlwaysOn Availability Groups, a feature intended to replace clustering, database mirroring, log shipping, replication, and other technologies by giving us one easy-to-manage feature for high availability, disaster recovery, and

Availability Groups AlwaysOn Read more

SQL 2012 allow only 20 cores

by Michal Tinthofer on 01/10/2012

Anyway this post should focus on some different distressing news about SQL 2012.  If you have current software assurance (SA) for SQL Server 2008 R2, this allows you to slide into SQL Server 2012 while maintaining CAL licensing (by the way this is not pos

SQL Cores Read more

How to check multiple backups stored in one file

by Michal Tinthofer on 26/06/2012

Backup device is a standard backup file. But this file is registered in management studio and often used to store more than one backups from database. There are also some pros and cons in usage compared to standard backups stored in folders and made by ma

Backup Device Read more