Skip to content
28, Oct 2025
  • facebook
  • instagram
  • twitter
  • youtube

Our Tech Ideas

Great minds discuss ideas!

Header Advertisement Image
  • Home
  • About Us
  • Privacy Policy

Year: 2023

  • Home
  • 2023
  • Page 2
Finding Active Sessions in SQL Server
3 min read 0
  • Monitoring and Alerting
  • MSSQL

Finding Active Sessions in SQL Server

  • OTI
  • 30 July 2023
Active Sessions in SQL Server
Analyzing Statistics 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…
Find Object-Level Permissions in SQL Server with T-SQL
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.…
Which login has write access on database
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…
Configuring Email Notifications for Backup Jobs in SQL Server
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…
Essential Scripts related to SQL Server Users and Logins
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 related to SQL Server Database Backups
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…
T-SQL to backup all user SQL Server databases at a time
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…
SQL Server Installation Best Practices
8 min read 1
  • MSSQL

SQL Server Installation Best Practices

  • OTI
  • 27 June 2023
Introduction SQL Server is a powerful database management system that…
Adding a TDE-Enabled Database to an Always On Availability Group
9 min read 0
  • MSSQL

Adding a TDE-Enabled Database to an Always On Availability Group

  • OTI
  • 26 June 2023
Introduction Ensuring the security of your database is crucial, especially…

Posts pagination

Previous 1 2 3 … 6 Next

Follow Us On:

Facebook Linkedin Instagram Twitter

Author Info

Sanjay Humania

Sanjay Humania

DBA

Welcome to OurTechIdeas.com, your go-to destination for insightful and practical SQL Server DBA-related technology content. Based in the vibrant city of Bangalore, India, we are a team of passionate learners dedicated to sharing our knowledge and experiences with the tech community.

Featured Posts

Impact of Upgrading Secondary Node to Windows Server 2022 in SQL Server 2016 AG

Impact of Upgrading Secondary Node to Windows Server 2022 in SQL Server 2016 AG

  • Sanjay
  • 7 April 2025
Ultimate Guide to SQL Server Performance Tuning and Monitoring

Ultimate Guide to SQL Server Performance Tuning and Monitoring

  • Sanjay
  • 3 April 2025
Ultimate Guide to SQL Performance Tuning Interview Questions

Ultimate Guide to SQL Performance Tuning Interview Questions

  • Sanjay
  • 28 March 2025
SSMS 21 Solves Major Blocking Issues

SSMS 21 Solves Major Blocking Issues

  • Sanjay
  • 27 March 2025

Recent Posts

  • Exploring SQL Server Database User Information with a T-SQL Query 28 October 2025
  • In-Place Upgradation vs Side-by-Side Migration in SQL Server 9 October 2025
  • Microsoft Entra ID Authentication in SQL Server 8 October 2025
  • Everything was fine yesterday—now it’s super slow! 28 July 2025
  • Detect and Fix Orphaned Users in SQL Server – The Complete Guide (All Possible Methods) 3 July 2025

Categories

Archives

Our Tech Ideas

Welcome to OurTechIdeas.com, your go-to destination for insightful and practical SQL Server DBA-related technology content. Based in the vibrant city of Bangalore, India, we are a team of passionate learners dedicated to sharing our knowledge and experiences with the tech community.

Featured Posts

Upgrading Windows Server Failover Cluster Functional Level

  • Sanjay
  • 15 April 2025
Database Recovery Analysis: Dealing with a Missing Full Backup

Database Recovery Analysis: Dealing with a Missing Full Backup

  • Sanjay
  • 8 April 2025

Boost Your SQL Server Performance: Key Optimization Strategies

  • Sanjay
  • 7 April 2025
Impact of Upgrading Secondary Node to Windows Server 2022 in SQL Server 2016 AG

Impact of Upgrading Secondary Node to Windows Server 2022 in SQL Server 2016 AG

  • Sanjay
  • 7 April 2025

Blog Posts

Impact of Upgrading Secondary Node to Windows Server 2022 in SQL Server 2016 AG

Impact of Upgrading Secondary Node to Windows Server 2022 in SQL Server 2016 AG

  • Sanjay
  • 7 April 2025
Ultimate Guide to SQL Server Performance Tuning and Monitoring

Ultimate Guide to SQL Server Performance Tuning and Monitoring

  • Sanjay
  • 3 April 2025
Ultimate Guide to SQL Performance Tuning Interview Questions

Ultimate Guide to SQL Performance Tuning Interview Questions

  • Sanjay
  • 28 March 2025
SSMS 21 Solves Major Blocking Issues

SSMS 21 Solves Major Blocking Issues

  • Sanjay
  • 27 March 2025

Footer Posts

Detecting and Resolving Deadlocks in SQL Server 2019

Detecting and Resolving Deadlocks in SQL Server 2019

  • OTI
  • 1 March 2025
SQL Server Interview Questions and Answers 2025

SQL Server Interview Questions and Answers 2025

  • OTI
  • 1 March 2025
GCP SQL Database Backup and Restore with Backup and DR Service

GCP SQL Database Backup and Restore with Backup and DR Service

  • Soyeluddin Biswas
  • 30 January 2025
Granting UPDATE Permissions on Specific Tables and Columns in SQL Server

Granting UPDATE Permissions on Specific Tables and Columns in SQL Server

  • OTI
  • 3 January 2025
Copyright © 2025 [Our Tech Ideas] Theme: Legacy Blog By Adore Themes.