SQL Server

Exploring Project Mercury: An Experience with Agent Creation and Cross-Platform Capabilities

First of all, i would like to thank Geoffroy Dubreuil and Gael Colas for this amazing event and all the work the did for this to be possible I also want to thank dbi Services for their(…)

Keep an eye on your SQL Agent jobs using T-SQL!

Introduction: A couple of weeks ago I had a customer who was interested in monitoring the duration of some of his SQL-Agent jobs. The jobs were running in a data warehouse environment and were executing some ETL processes for loading(…)

PosgreSQL + SQL Server = WiltonDB – Part 2 – Database Management

Few months ago I write about WiltonDB and how to install it. Now, I move one step forward with the Database Management. How to create a Database ? I test first with the T-SQL Command CREATE DATABASE script: I(…)

Plotting SQL Server Performance counters with Python

As a consultant, I often use Performance Monitor (Perfmon) to collect performance metrics for SQL Server. After running Perfmon for, say, a week to capture a baseline of server activity, you can end up with a(…)

Make SQL Server services more secure with Managed Service Accounts

In the past years, I actively have been involved in securing MSSQL Instances (and other services).This lead me to use the Managed Service Accounts (MSA) and the grouped Managed Service Accounts (gMSA)The MSA have been introduced in Windows Server 2008(…)

Cześć polska! SQLDay2024 in Wrocław

Welcome to the SQLDay!! With these words, the start of the event was announced punctually at 10 am. Now the question, what can we expect? A total of 59 speakers in 49 sessions will share their experiences and skills(…)

Build SQL Server audit reports with Powershell

Introduction When you are tasked with conducting an audit at a client’s site or on the environment you manage, you might find it necessary to automate the audit process in order to save time. However, it can be challenging to(…)

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(…)

SQL Server Security: Ensure that SQL Server service accounts are not a member of the Windows local Administrator group

These last few weeks, I work on a project to check the compliance of an instance with the Center for Internet Security (CIS) document. The Benchmark documentation provides prescriptive guidance to secure SQL Server and I develop a tool(…)

SQL Server: Manage large data ranges using partitioning

Introduction:  When it comes to moving ranges of data with many rows across different tables in SQL-Server, the partitioning functionality of SQL-Server can provide a good solution for manageability and performance optimizing. In this blog we will look at the(…)