SQL Server Archives - DBA Mantra

Vacuum, Autovacuum, and Analyze — Everything a PostgreSQL DBA Must...

Vacuum, Autovacuum, and Analyze — Everything a PostgreSQL DBA Must Know Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) to handle...

BY Technical Editor
August 22, 2025
0 Comment

DBA Stuff Performance Tuning SQL Server

Using Extended Events for SQL Server Performance Troubleshooting (with Real-Time...

SQL Server Extended Events (XE) is the modern replacement for SQL Trace and Profiler. It provides a lightweight, highly customizable...

BY Technical Editor
August 20, 2025
0 Comment

DBA Stuff Performance Tuning Scripts SQL Server

SQL Server Query Store: A Complete Guide for DBAs

Enabling and Using Query Store in SQL Server As a SQL Server DBA, the Query Store is one of the...

BY Technical Editor
August 20, 2025
0 Comment

Permission & Security Scripts SQL Server

How to Setup SQL Server Audit using SQL scripts

Navigating the complexities of SQL Server auditing can be daunting. Whether you’re ensuring compliance, securing data, or simply looking to...

BY Technical Editor
April 13, 2024
0 Comment

Scripts SQL Server

SQL Query to check port number of SQL Server

We can use below query to check the port on which SQL Server is listening. DECLARE @InstanceName nvarchar(50) DECLARE @value...

BY Editor
February 9, 2023
0 Comment

AWS Cloud Computing SQL Server

AWS RDS SQL Server Overview and Offering & FAQs

Amazon RDS (Relational Database Service) for SQL Server is a fully managed service that makes it easy to set up,...

BY Editor
January 15, 2023
0 Comment

Interview Question SQL Server

SQL Server DBA Interview Questions Answers – Always On availability...

Availability Groups is a feature in SQL Server that allows you to create a group of read-write and read-only replicas...

BY Editor
January 14, 2023
0 Comment

SQL Server

SQL Server Feature – In Memory OLTP (Online Transaction Processing)

In Memory OLTP (Online Transaction Processing) is a feature in SQL Server that allows you to improve the performance of...

BY Editor
January 14, 2023
0 Comment

SQL Server Performance Tuning

SQL Server Performance Counter Data collection using TypePerf utility

https://dbamantra.com/wp-content/uploads/2018/02/TypePerf-1.jpgSQL Server performance tuning and Optimizing SQL Server is part of the day to day job of a Database administrator....

BY Editor
February 7, 2018
0 Comment

SQL Server

How to Perform database restore with Database Encryption

Database encryption is the process of changing the information inside database into some ciphertext using encryption keys and appropriate algorithm....

BY Harsh Diwan
February 3, 2018
0 Comment

Archives

Categories

Meta

PostgreSQL Query Store with pg_stat_statements: A

Top PostgreSQL Monitoring Tools Every DBA

Vacuum, Autovacuum, and Analyze — Everything

Using Extended Events for SQL Server

Vacuum, Autovacuum, and Analyze — Everything a PostgreSQL DBA Must...

Using Extended Events for SQL Server Performance Troubleshooting (with Real-Time...

SQL Server Query Store: A Complete Guide for DBAs

How to Setup SQL Server Audit using SQL scripts

SQL Query to check port number of SQL Server

AWS RDS SQL Server Overview and Offering & FAQs

SQL Server DBA Interview Questions Answers – Always On availability...

SQL Server Feature – In Memory OLTP (Online Transaction Processing)

SQL Server Performance Counter Data collection using TypePerf utility

How to Perform database restore with Database Encryption

Best online courses on SALE – All Courses $9.99

PostgreSQL Query Store with pg_stat_statements: A DBA’s Guide to Performance Tracking

Top PostgreSQL Monitoring Tools Every DBA Should Know

Vacuum, Autovacuum, and Analyze — Everything a PostgreSQL DBA Must Know

PostgreSQL Query Store with pg_stat_statements: A DBA’s Guide to Performance

Top PostgreSQL Monitoring Tools Every DBA Should Know

Vacuum, Autovacuum, and Analyze — Everything a PostgreSQL DBA Must

Using Extended Events for SQL Server Performance Troubleshooting (with Real-Time

PostgreSQL Query Store with pg_stat_statements: A DBA’s Guide

Top PostgreSQL Monitoring Tools Every DBA Should Know

Vacuum, Autovacuum, and Analyze — Everything a PostgreSQL