OTI

Scenario We recently came across a situation where one of the drives in the production server is almost full. There are two large databases and they were not backed up….

Introduction There are two types of database-level roles: Fixed-database roles db_accessadmin Granted: ALTER ANY USER, CREATE SCHEMA,Granted with Grant option – Connect By SSMS By TSQL USE [Our_Tech_Ideas] — Database…

Introduction Here we will discuss different backup strategies and methodologies used to take the table backup in SQL Server with real-life examples. There are different methods of taking backup in…

Introduction In this post, we will try to show step by step Microsoft SQL Server 2016 installation on Windows Server 2012R2. Microsoft SQL Server 2017 is the latest stable version…

Introduction Backing up a database is one of the most important things you need to do when having a database depended application. It’s only all of your data in there,…

Introduction As a Database Administrator (DBA), my recent task involved listing all the jobs running in a production SQL Server environment, along with their respective databases. With over 200+ jobs…

Introduction In this article, we will try to pull all sizes from SQL server. How to find Database Size in SQL Server? How to Get size of all tables in…

Scenario How to provide ‘db_dataread’ database role to a SQL login when the database is in AlwaysOn & secondary node DB is in readonly mode? Introduction To provide ‘db_dataread’ database…

Introduction In the world of database management, having a clear understanding of the file information is crucial for optimizing performance and storage. In this technical blog post, we will dive…

Introduction Managing database sizes is a crucial task for database administrators. Monitoring database growth and tracking size changes over time are essential for capacity planning and performance optimization. In this…