Skip to content
13, Apr 2026
  • facebook
  • instagram
  • twitter
  • youtube

Our Tech Ideas

Great minds discuss ideas!

  • Home
  • About Us
  • Privacy Policy

Category: MSSQL

Unable to open the “Properties” window for databases on the Managed Instance
2 min read 0
  • MSSQL
  • Troubleshooting and Issue Resolution

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…
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…

Posts pagination

Previous 1 … 6 7 8 … 21 Next

Recent Posts

  • SQL Server Database Stuck in Recovery Pending After VM Reboot – A Real-World Root Cause and Fix 10 April 2026
  • SQL Server Out of Memory (OOM) Error: Causes, Fixes 8 April 2026
  • Future-Proof Your SQL Server DBA Career in 2026 8 April 2026
  • Automating SQL Server Index Maintenance Using Dynamic T‑SQL 24 March 2026
  • How to Find Private Database Mail Profiles Associated with Logins in SQL Server 4 March 2026

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

In-Place Upgradation vs Side-by-Side Migration in SQL Server

In-Place Upgradation vs Side-by-Side Migration in SQL Server

  • Sanjay
  • 9 October 2025
Microsoft Entra ID Authentication in SQL Server

Microsoft Entra ID Authentication in SQL Server

  • Sanjay
  • 8 October 2025

Everything was fine yesterday—now it’s super slow!

  • Sanjay
  • 28 July 2025
Detect and Fix Orphaned Users in SQL Server – The Complete Guide

Detect and Fix Orphaned Users in SQL Server – The Complete Guide (All Possible Methods)

  • Sanjay
  • 3 July 2025

Blog Posts

Detect and Fix Orphaned Users in SQL Server – The Complete Guide

Detect and Fix Orphaned Users in SQL Server – The Complete Guide (All Possible Methods)

  • Sanjay
  • 3 July 2025

Exploring SQL Server Agent Jobs

  • Sanjay
  • 28 May 2025
Monitoring SQL Server Agent Jobs

Monitoring SQL Server Agent Jobs

  • Sanjay
  • 13 May 2025

Upgrading Windows Server Failover Cluster Functional Level

  • Sanjay
  • 15 April 2025

Footer Posts

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
SQL Server Database Auditing: Daily, Weekly, and Monthly Best Practices

Database Auditing Best Practices: SQL Server Scripts for Security & Compliance

  • Sanjay
  • 27 March 2025
SQL Server Post-Installation Checklist

SQL Server Post-Installation Checklist

  • Sanjay
  • 27 March 2025
Copyright © 2026 [Our Tech Ideas] Theme: Legacy Blog By Adore Themes.