Skip to content
Performance Tuning And Infra Automation

I love performance tuning and building automation

  • Home
  • About Me
  • SQL Resources
  • Privacy Policy
  • Contact Me
  • Home
  • About Me
  • SQL Resources
  • Privacy Policy
  • Contact Me
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe
  • Home
  • Database Administration
StackOverflow2013 database on PostgreSQL
Posted inDatabase Administration PostgreSQL

Get StackOverflow2013 Database for PostgreSQL & SQLServer

Posted by By Ajay Dwivedi June 30, 2025
Download StackOverflow2013 database for PostgreSQL & SQLServer to compare performance. We can figure out which if faster between PostgreSQL & SQLServer.
Read More
SQL Server Lab Setup
Posted inDatabase Administration

SQL Server Lab 01 – MultiSubnet Availability Group with FCI

Posted by By Ajay Dwivedi July 4, 2021
As a SQL Server DBA, it is very important to learn concepts by doing or…
Read More
Indexing Maintenance Solution for Replication
Posted inDatabase Administration

Indexing Maintenance Solution for Replication

Posted by By Ajay Dwivedi July 10, 2018
Like any other DBA, I fell into the trap of using straight maintenance solution using…
Read More
OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names
Posted inDatabase Administration

OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names

Posted by By Ajay Dwivedi April 24, 2018
If you are a DBA then you understand the importance of having robust Database Maintenance…
Read More
Setup Custom Log Shipping in SQL Server
Posted inDatabase Administration

Setup Custom Log Shipping in SQL Server

Posted by By Ajay Dwivedi April 7, 2018
When it comes to Disaster Recovery Setup, every DBA has its own preference. I personally…
Read More
How to Verify Given Access/Permissions to User/Login
Posted inDatabase Administration

How to Verify Given Access/Permissions to User/Login

Posted by By Ajay Dwivedi November 8, 2017
Hi Friends, I have seen DBAs to wait for user's confirmation for long after providing…
Read More
SQL Server Database Administration (DBA) Classes in Noida
Posted inDatabase Administration

New SQL DBA Coaching Batch Starting from Nov 2017

Posted by By Ajay Dwivedi September 12, 2017
Hi Friends, I am starting new batch for SQL Server DBA Classroom training from first…
Read More
Setup fresh/Scriptout Existing Mirroring on SQL Server
Posted inDatabase Administration

Setup fresh/Scriptout Existing Mirroring on SQL Server

Posted by By Ajay Dwivedi January 25, 2017
In my current organization, we have lot of servers where database mirroring is used as…
Read More
A Curious Case of Orphan User
Posted inDatabase Administration

A Curious Case of Orphan User

Posted by By Ajay Dwivedi November 30, 2016
Hi Friends, Today at work I received an access request to provide multiple database permissions…
Read More
Error/Fix: The Extended Events session named “blocked_process” could not be found.
Posted inDatabase Administration Errors

Error/Fix: The Extended Events session named “blocked_process” could not be found.

Posted by By Ajay Dwivedi November 24, 2016
Two days back while I am presenting in a KT session within team on how…
Read More

Posts pagination

1 2 Next page
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 99 other subscribers
See what other community members think about SQLMonitor.
Recent Posts
  • Get StackOverflow2013 Database for PostgreSQL & SQLServer
  • Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
  • LogRotate Policy For PostgreSQL
  • Run Ansible Playbooks with Github Action
  • SQLServer Gradually Becomes Slow Until Reboot
Facebook With Ajay Dwivedi
Facebook With Ajay Dwivedi

CATEGORIES

  • Ansible 1
  • Baseline-SQL-Server 22
  • Database Administration 11
  • DevOps 1
  • Errors 15
  • Execution Plan 8
  • Growth & Development 2
  • Health Check 8
  • Internals 3
  • Linux 4
  • Performance Tuning 35
  • PostgreSQL 3
  • Powershell 8
  • SQL Alerts 5
  • SQLMonitor 17
  • TSQL 41
Copyright 2025 — Performance Tuning And Infra Automation. All rights reserved. Bloglo WordPress Theme
Scroll to Top