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

Our Tech Ideas

Great minds discuss ideas!

  • Home
  • About Us
  • Privacy Policy

Author: OTI

Welcome to OurTechIdeas.com, your go-to destination for SQL Server DBA-related tech insights. We are a dedicated team of experts passionate about sharing our knowledge and expertise with the community. Join us as we explore the world of SQL Server, offering valuable tips, tutorials, and innovative solutions.
15 min read 0
  • MSSQL

Things You Must Do After Installing SQL Server

  • OTI
  • 13 July 2021
Things You Must Do After Installing SQL Server Rolling out…
Find database size when it is offline
2 min read 2
  • MSSQL

Find database size when it is offline

  • OTI
  • 1 July 2021
Hi, Tech Giants! What new to me today? Yeah, We…
2 min read 0
  • MSSQL

Auto-open new query window in SSMS

  • OTI
  • 30 June 2021
How to Change Product Key for SQL Server The Microsoft…
2 min read 0
  • MSSQL

Make Named instance look like a Default instance

  • OTI
  • 29 June 2021
Convert or make SQL Server Named instance look like a…
Find database growth  size in SQL Server
3 min read 2
  • MSSQL

Find database growth size in SQL Server

  • OTI
  • 28 June 2021
All of a sudden I received an email from the…
How to Configure MSSQL Backup Compression as the Default Option
3 min read 0
  • MSSQL

How to Configure MSSQL Backup Compression as the Default Option

  • OTI
  • 28 February 2021
Introduction In Microsoft SQL Server, backup compression is a powerful…
Find blocking by T-SQL Queries
3 min read 2
  • MSSQL

Find blocking by T-SQL Queries

  • OTI
  • 27 August 2020
Blocking is an unavoidable and by-design characteristic of any relational…
2 min read 2
  • MSSQL

Find who dropped Database at what time

  • OTI
  • 12 January 2020
Find who dropped Database at what time As a DBA…
1 min read 2
  • MSSQL

Provide a SQL Login ALTER TRACE permission

  • OTI
  • 5 January 2020
Provide a SQL Login ALTER TRACE permission One SQL login…
4 min read 1
  • MSSQL

Extended Security Updates for SQL 2008

  • OTI
  • 22 December 2019
How to get SQL Extended Security Updates for SQL 2008/2008…

Posts pagination

Previous 1 … 12 13 14 … 20 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.