Our Tech Ideas

Latest Posts

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…

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…

Our Tech Ideas

Banner Posts

Exploring SQL Server Agent Jobs

Monitoring SQL Server Agent Jobs: A Deep Dive into Job Steps with T-SQL

Upgrading Windows Server Failover Cluster Functional Level

Latest Posts

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

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

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