Tips and Tricks for SQL Server tuning

SMT 00.5.32 Released!

by Michal Tinthofer on 31/08/2017

After some time, we have finally released big set of changes and fixes for currently known issues. Most visible is new Waiting Task report for operational analysis, added timeline button for Index Usage & recommendation, new functionality to search for an

SMT Read more

Usefull SQL Tools

by Michal Tinthofer on 24/07/2013

A few weeks ago a had task to create procedure for testing workload from production server on test environment.Itsurely wasn't a big deal, but I need to learnmanycustomer employees to repeat this task on regular base. I started to look if somehow I could

SQL Server 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

Issues with cluster installation

by Michal Tinthofer on 15/06/2012

Recently i have observed some problems with cluster installation in one of my clients. In server logs were those messages:

Instalation Cluster Read more