MSSQL Archives

2 min read 0

MSSQL

How to list the names, schema, and definition of all stored procedures in the specified database

OTI
20 March 2024

In the world of database management, SQL Server is a popular choice for organizing and retrieving data. One useful feature…

2 min read 0

MSSQL

Exploring Automatic Seeding in SQL Server Always On Availability Groups

OTI
17 November 2023

Introduction In the dynamic landscape of database management, SQL Server Always On Availability Groups (AG) play a pivotal role in…

2 min read 1

MSSQL

Find Encrypted Stored Procedures in SQL Server

OTI
19 October 2023

In SQL Server, stored procedures are often used to store and execute sets of SQL statements. Sometimes, for security reasons,…

4 min read 0

MSSQL

Missing MSI and MSP files error while patching SQL SERVER

OTI
10 October 2023

Hello everyone, I came across the following article in a WhatsApp group. I used to encounter similar issues while patching…

2 min read 0

MSSQL

How to Find Your In-Hand Salary Based on Your CTC

OTI
10 October 2023

Understanding job offers can be tricky, especially when the big number they throw at you (CTC) feels like a puzzle.…

4 min read 1

MSSQL

Daily Commands for Database Administrators

OTI
30 September 2023

As a database administrator (DBA), navigating the vast landscape of database management can be challenging and rewarding. It’s important to…

3 min read 0

SQL Server sysadmin vs serveradmin

OTI
31 August 2023

Introduction Managing a SQL Server environment involves various roles and responsibilities. Two key roles in this context are the “serveradmin”…

3 min read 0

How to set Maximum Memory for SQL Server

OTI
31 August 2023

One crucial aspect is setting the maximum memory for SQL Server. Recently one of my friend was asked this question…

3 min read 0

MSSQL

Understanding SQL Server Permissions: GRANT vs. WITH GRANT

OTI
31 August 2023

Introduction We’ve ever worked with SQL Server, we’ve probably encountered the need to manage permissions. Permissions control who can access…

8 min read 0

MSSQL

Renaming a SQL Server Database in an Always On Availability Group

OTI
11 August 2023

Introduction Renaming a database in SQL Server that is part of an Always On Availability Group requires careful planning and…

Category: MSSQL

How to list the names, schema, and definition of all stored procedures in the specified database

Exploring Automatic Seeding in SQL Server Always On Availability Groups

Find Encrypted Stored Procedures in SQL Server

Missing MSI and MSP files error while patching SQL SERVER

How to Find Your In-Hand Salary Based on Your CTC

Daily Commands for Database Administrators

SQL Server sysadmin vs serveradmin

How to set Maximum Memory for SQL Server

Understanding SQL Server Permissions: GRANT vs. WITH GRANT

Renaming a SQL Server Database in an Always On Availability Group

Ultimate Guide to SQL Performance Tuning Interview Questions

SSMS 21 Solves Major Blocking Issues

Database Auditing Best Practices: SQL Server Scripts for Security & Compliance

SQL Server Post-Installation Checklist

SQL Server Post-Installation Checklist

Securing Your SQL Database

SQL Server Backup and Restore: A Complete Guide

Detecting and Resolving Deadlocks in SQL Server 2019

How to Send Emails Using PowerShell with SMTP Authentication

Understanding Transparent Data Encryption (TDE) in SQL Server

Resolving SQL Server Error 9002: Log File Full

SQL Server Database Administrator interview questions