2023 | Our Tech Ideas

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

Understanding SQL Server Roles: Server Admin vs. Sysadmin

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…

2 min read 0

Unable to open the “Properties” window for databases on the Managed Instance

OTI
7 August 2023

Issue Definition Unable to open the “Properties” window for databases on the Managed Instance using SSMS. Getting error message. Error…

Year: 2023

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

Understanding SQL Server Roles: Server Admin vs. Sysadmin

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

Unable to open the “Properties” window for databases on the Managed Instance

Understanding Transparent Data Encryption (TDE) in SQL Server

Resolving SQL Server Error 9002: Log File Full

SQL Server Database Administrator with 6 years of experience, interview questions

Building SQL Server Database Inventory

Building SQL Server Database Inventory

SQL Server DBA Scenarios: A Comprehensive Guide

How to Relocate tempdb Files

Simplify SQL Server Login Transfers with sp_help_revlogin

Retrieving SQL Server Restore History Using T-SQL Queries

Discovering SQL Server TCP Port Configurations

Scripting Out Existing Database Mail Profile’s Settings in SQL Server

Troubleshooting SMTP Connections: Using Traceroute with SendGrid