Author: OTi

Meet OTi, the brains behind the popular tech blog "OurTechIdeas.com." OTi is an accomplished author, tech enthusiast, and an expert in SQL Server. With over a decade of experience in the tech industry, he has become a trusted voice in the world of database management. OTi's passion for technology began at a young age, and he has been tinkering with computers ever since. He graduated with a degree in Computer Science and has since worked for some of the biggest tech companies in the world. His experience has given him a deep understanding of how technology works and how it can be used to improve our lives.
Posted in MS SQL

Check SQL Server license in SQL Server

As a SQL Server DBA, I would rephrase the statement as follows:…

OTi 12/03/2023
Long Running Queries in SQL Server
Posted in MS SQL

How to Identify and Store Long Running Queries in a Table

Scenario How to Identify and Store Currently Long Running Queries in a…

OTi 10/02/2023
How to backup a TDE protected database on Azure SQL Managed Instance
Posted in MS SQL

How to backup a TDE protected database on Azure SQL Managed Instance

We can take a COPY_ONLY backup of a TDE-protected (encryption enabled) database…

OTi 09/02/2023
How many TempDB files are recommended for SQL Server
Posted in MS SQL

TempDB files recommendation in SQL Server

The number of tempdb data files in an SQL Server depends on…

OTi 08/02/2023
Finding All Access and Permissions for All Users in SQL server
Posted in MS SQL

Find All Permissions for All Users in SQL

We recently encountered an issue with one of our users being denied…

OTi 12/01/2023
Posted in MS SQL

How to change SQL Server instance name

Scenario Troubleshooting host name changes. When the machine name is changed where…

OTi 03/01/2023
SQL server database in SUSPECT MODE
Posted in MS SQL

SQL server database in SUSPECT MODE

Scenario A database in SUSPECT mode is one that is not fully…

OTi 02/01/2023
Posted in MS SQL

Checking the Free Space in Data and Log Files in a Database in SQL Server

In a database, data and log files are used to store the…

OTi 31/12/2022
Posted in MS SQL

Checking the Backup Path of a Database in SQL Server

Backing up a database is an important part of any database administrator’s…

OTi 31/12/2022
Posted in MS SQL

How to check the attachment size limit in SQL Database Mail

Overview of Database Mail Are you looking for the quickest and most…

OTi 19/12/2022
Finding All Access and Permissions for All Users in SQL server
Posted in MS SQL

Check permissions given to a database role

As a Database Administrator, you may need to identify the permissions that…

OTi 08/12/2022
Posted in MS SQL

Operating system error 50 in Azure SQL Managed Instance

We encountered an error while taking a backup of a database from…

OTi 08/12/2022
Posted in MS SQL

Password reset of SQL service account

Impact of resetting password for SQL Server service account Resetting the password…

OTi 30/11/2022
How and Why to become a SQL Server DBA?
Posted in MS SQL

How and Why to become a SQL Server DBA?

How and Why to become a SQL server dba? What is a…

OTi 21/11/2022
Find IP and Port using SQL SSMS
Posted in MS SQL

How to find SQL Server running TCP IP port

Finding the SQL Server Port Number Recently we have installed a second…

OTi 21/11/2022
Posted in MS SQL

Get CPU Utilization Data from SQL Server

Get CPU Utilization Data from SQL Server SQL Server is built on…

OTi 19/11/2022
Posted in MS SQL

Driver could not establish a secure connection to SQL Server

Driver could not establish a secure connection to SQL Server Recently windows…

OTi 17/11/2022
Posted in MS SQL

Migrating SQL Server Database Mail Settings

Migrating SQL Server Database Mail Settings Migrating SQL Server Database Mail profiles,…

OTi 16/11/2022
Posted in MS SQL

Checking SQL Server Job History by Script

Checking SQL Server Job History by Script Mainly msdb.dbo.sysjobs and msdb.dbo.sysjobhistory contains…

OTi 07/11/2022
Posted in MS SQL

Checking Compatibility Level Of All Databases In SQL Server

Checking Compatibility Level Of All Databases In SQL Server SQL Server is…

OTi 28/10/2022
Posted in Oracle

Oracle DBA Interview Questions

Oracle DBA Interview Questions A. COMPANY- Oracle (OFSS), Location -Bangalore 1. Describe…

OTi 16/07/2022
Posted in MS SQL

Find active transactions by duration

Find active transactions by duration Recently frequently we faced blocking issues on…

OTi 15/07/2022
Posted in MS SQL

Certificate chain issued by authority that is not trusted

Certificate chain issued by authority that is not trusted Recently we moved…

OTi 21/06/2022
Check the Status of E-Mail Messages Sent With Database Mail
Posted in MS SQL

Check the Status of E-Mail Messages Sent With Database Mail

Check the Status of E-Mail Messages Sent With Database Mail In SQL…

OTi 13/06/2022