Medium

HKN MZ

HKN MZ

·

Sep 27, 2025

Monitoring PostgreSQL with Zabbix Agent on RHEL 9

Monitoring your PostgreSQL databases efficiently is essential for ensuring performance and reliability. In this guide, I will show you how…

Monitoring PostgreSQL with Zabbix Agent on RHEL 9

HKN MZ

·

May 2, 2024

Sql Server : Connections / Sessions

In SQL Server, connections and sessions are fundamental concepts that play a crucial role in how clients interact with the database server…

HKN MZ

·

Apr 30, 2024

Sql Server Statistics

SQL Server statistics help the query optimizer generate efficient execution plans, improving query performance by making better decisions…

Sql Server Statistics

HKN MZ

·

Apr 30, 2024

How much is left until the Identity Column reaches its Max Value?

This code provides insight into the current values of identity columns in the database and calculates the percentage of their usage…

HKN MZ

·

Apr 15, 2024

Sql Server Indexes All Notes

Indexes in SQL Server are data structures that improve the speed of data retrieval operations on tables by providing quick access paths to…

Sql Server Indexes All Notes

In

Python in Plain English

by

HKN MZ

·

Dec 28, 2023

SQL Server Blocking

SQL Server blocking occurs when one transaction or process holds a lock on a resource (like a table or a row) and another transaction or…

SQL Server Blocking

HKN MZ

·

Dec 27, 2023

Sql Server CPU Control

This SQL query retrieves information about the top 10 currently executing sessions along with details about their associated queries. It…

HKN MZ

·

Dec 26, 2023

Sql Server : Memory

This SQL query retrieves information about the system memory on a SQL Server instance using the sys.dm_os_sys_memory dynamic management…

In

Towards Dev

by

HKN MZ

·

Dec 25, 2023

Sql Server Backup Control

This SQL query retrieves information about database backups from the msdb database, using a Common Table Expression (CTE) named CTE_Backup…

In

Towards Dev

by

HKN MZ

·

Dec 24, 2023

Sql Server Jobs Control

This SQL query retrieves information about SQL Server Agent jobs, including details about the job, its schedule, and the recent execution…

HKN MZ

HKN MZ

I am writing about Sql Server, Elasticsearch and Python. İ am an Database Administrator on SQL Server and Elasticsearch more than 5+ years.

Following

Help

Status

About

Careers

Press

Blog

Store

Privacy

Rules

Terms

Text to speech