Skip to content

Microsoft SQL Server

SQL-Server: What are VLF’s and why should I care about them?

Introduction: What are VLF’s? In SQL-Server, the transaction log is divided into several logical units called virtual log files (VLF). The amount of virtual log files and their size are managed automatically by the database engine. The database engine adds more VLF’s to the transaction log file every time when the transaction log file grows. For this reason, admins can… 

What I really like about Percona PMM

Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we can do much more with it! I discovered this tool 2 years ago when I started a monitoring study for a customer, and… 

SQL Server – Granting SQL Server permission to service SID

Introduction We know that SQL Server itself is using it own SID NT SERVICEMSSQL$ and NT SERVICESQLAGENT$ to grant permission to the database engine and the SQL agent services. But the same method can be used for other application services to acces and use the SQL Server instances. The enables to allow the access to the SQL instance when the… 

How to run Avamar backup on SQL Agent Job with PowerShell

By one of our customer we use Avamar for the backup and restore solution. I was asked by this customer to find a solution to run Avamar backups for a group of databases on a specified instance. In fact, we currently try a database clone solution on some instances and clone’s databases must not be backed up, but the rest… 

SQL Pass Summit 2018: SQL Server 2019 features coming soon!

It’s the 20th anniversary of the event and the keynote today was amazing (see the blog from Christophe) for different reasons but the more important is that is every time better people. Not only DBA’s but also people using their application connected to the database. Today, one of my focus will be the next version of SQL Server 2019 with…