MSSQL Archives

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…

3 min read 0

Finding Active Sessions in SQL Server

OTI
30 July 2023

Active Sessions in SQL Server

3 min read 0

MSSQL

Analyzing Statistics in SQL Server

OTI
19 July 2023

Introduction In the world of database management, understanding the statistics of your SQL Server database is crucial for optimizing query…

2 min read 0

MSSQL

Find Object-Level Permissions in SQL Server with T-SQL

OTI
14 July 2023

Introduction Managing permissions is a critical aspect of database security. As a database administrator or developer, it’s important to have…

2 min read 0

MSSQL

Which login has write access on database

OTI
6 July 2023

Introduction In this blog post, we will explore how to use T-SQL (Transact-SQL) to identify which logins have write access…

3 min read 0

MSSQL

Configuring Email Notifications for Backup Jobs in SQL Server

OTI
3 July 2023

Setting up email notifications for your SQL database backup jobs can be a useful way to stay informed about important…

8 min read 0

MSSQL

Essential Scripts related to SQL Server Users and Logins

OTI
28 June 2023

Introduction In this blog post, we will explore six (6) essential scripts that will revolutionize your SQL Server management, ranging…

6 min read 0

MSSQL

Essential Scripts related to SQL Server Database Backups

OTI
27 June 2023

Introduction Database backups are crucial for ensuring data integrity and disaster recovery. As a database administrator or developer, having reliable…

4 min read 0

MSSQL

T-SQL to backup all user SQL Server databases at a time

OTI
27 June 2023

Introduction In today’s world, data is very important. We need to make sure that our data is safe and secure.…

8 min read 1

MSSQL

SQL Server Installation Best Practices

OTI
27 June 2023

Introduction SQL Server is a powerful database management system that is used by businesses of all sizes. However, if SQL…

Category: MSSQL

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

Finding Active Sessions in SQL Server

Analyzing Statistics in SQL Server

Find Object-Level Permissions in SQL Server with T-SQL

Which login has write access on database

Configuring Email Notifications for Backup Jobs in SQL Server

Essential Scripts related to SQL Server Users and Logins

Essential Scripts related to SQL Server Database Backups

T-SQL to backup all user SQL Server databases at a time

SQL Server Installation Best Practices

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