Best online courses on SALE – All Courses $9.99

  • January 12, 2018
  • 0 Comments

Bets online courses for only $9.99 Udemy.com, the biggest source for web-based learning, is offering courses for $9.99 each to kick off your learning in the new year. Udemy’s main goal to improve living style with a focus on self-improvement. Kick Start your learning on Udemy today! Courses are normally esteemed at $200 or more. […]

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

Introduction When tuning PostgreSQL databases, the hardest part isn’t writing the fix — it’s knowing what to fix. Without visibility into which queries consume the most resources, optimization becomes guesswork. That’s where pg_stat_statements comes in. It acts as PostgreSQL’s Query Store, recording detailed statistics about query executions. With it, DBAs and developers can measure performance, […]

Top PostgreSQL Monitoring Tools Every DBA Should Know

Top PostgreSQL Monitoring Tools Every DBA Should Know (pg_stat_statements, pgBadger, pgAdmin, Prometheus, Grafana) Introduction As databases grow in size and complexity, monitoring PostgreSQL is no longer optional — it’s essential. Without monitoring, DBAs are blind to slow queries, blocking locks, or system bottlenecks. Proper monitoring helps in troubleshooting performance issues, optimizing queries, and avoiding downtime. […]

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

Vacuum, Autovacuum, and Analyze — Everything a PostgreSQL DBA Must Know Introduction PostgreSQL uses MVCC (Multi-Version Concurrency Control) to handle concurrent transactions. When rows are updated or deleted, PostgreSQL doesn’t overwrite them. Instead, it marks the old versions as dead tuples and keeps new versions. Over time, dead tuples accumulate → bloat, wasted space, slower […]

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

SQL Server Extended Events (XE) is the modern replacement for SQL Trace and Profiler. It provides a lightweight, highly customizable way to capture diagnostic and performance data, making it one of the most powerful tools for DBAs to troubleshoot production issues efficiently. In this guide, we’ll cover: What Extended Events are How to create and […]

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 understand changes within your database environment, auditing is critical. This blog is dedicated to uncovering the intricacies of SQL Server Audit, a powerful feature that helps you monitor and record server activity to meet compliance […]

SQL Query to check port number of SQL Server

  • February 9, 2023
  • 0 Comments

We can use below query to check the port on which SQL Server is listening. DECLARE @InstanceName nvarchar(50) DECLARE @value VARCHAR(100) DECLARE @RegKey_InstanceName nvarchar(500) DECLARE @RegKey nvarchar(500) SET @InstanceName=CONVERT(nVARCHAR,isnull(SERVERPROPERTY(‘INSTANCENAME’),’MSSQLSERVER’)) –For SQL Server 2000 if(SELECT Convert(varchar(1),(SERVERPROPERTY(‘ProductVersion’))))=8 BEGIN if @InstanceName=’MSSQLSERVER’ Begin SET @RegKey=’SOFTWARE\Microsoft\’+@InstanceName+’\MSSQLServer\SuperSocketNetLib\TCP\’ END ELSE BEGIN SET @RegKey=’SOFTWARE\Microsoft\Microsoft SQL Server\’+@InstanceName+’\MSSQLServer\SuperSocketNetLib\TCP\’ END EXECUTE xp_regread @rootkey = ‘HKEY_LOCAL_MACHINE’, @key […]

All About Oracle Database Cloud Offerings and Features – 2023

  • January 15, 2023
  • 0 Comments

Oracle Database Cloud Offerings Oracle Database is a widely used relational database management system (RDBMS) that is available in various cloud-based offerings and on-premises versions. Oracle Cloud Infrastructure (OCI) provides several options for running Oracle Database in the cloud, including: Autonomous Database: A fully managed, self-driving database service that eliminates the need for manual administration […]

AWS RDS SQL Server Overview and Offering & FAQs

  • January 15, 2023
  • 0 Comments

Amazon RDS (Relational Database Service) for SQL Server is a fully managed service that makes it easy to set up, operate, and scale SQL Server databases in the cloud. It allows users to launch a fully managed SQL Server instance, with the ability to choose from several versions and editions, including Express, Web, Standard, and […]

SQL Server DBA Interview Questions Answers – Always On availability group

  • January 14, 2023
  • 0 Comments

Availability Groups is a feature in SQL Server that allows you to create a group of read-write and read-only replicas of a primary database to provide high availability and disaster recovery. The feature was first introduced in SQL Server 2012 and since then it has been improved and enhanced in later versions. Availability Groups allow […]