HKN MZ – Medium

HKN MZ

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…

May 2

May 2

Sql Server Statistics

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

Apr 30

Sql Server Statistics

Apr 30

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…

Apr 30

Apr 30

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…

Apr 15

Sql Server Indexes All Notes

Apr 15

Published in
Python in Plain English

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…

Dec 28, 2023

SQL Server Blocking

Dec 28, 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…

Dec 27, 2023

Dec 27, 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…

Dec 26, 2023

Dec 26, 2023

Published in
Towards Dev

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…

Dec 25, 2023

Dec 25, 2023

Published in
Towards Dev

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…

Dec 24, 2023

Dec 24, 2023

Published in
Towards Dev

Sql Server Disk Control

This SQL query is designed to generate a report focused on the physical locations of files in a SQL Server database and the disk usage…

Dec 24, 2023

Dec 24, 2023

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
Privacy
Terms
Text to speech
Teams