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

Our Tech Ideas

Great minds discuss ideas!

  • Home
  • About Us
  • Privacy Policy

Year: 2019

2 min read 0
  • MSSQL

SQL Network Interfaces, error: 26

  • OTI
  • 17 November 2019
SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified…
2 min read 1
  • MSSQL

Find the SQL Server Cluster details

  • OTI
  • 8 November 2019
Scenario A cluster includes two or more physical servers, called nodes; identical…
2 min read 4
  • MSSQL

Create login by CMD in SQL Server

  • OTI
  • 7 November 2019
Scenario You have got the SQL database engine installed but…
4 min read 0
  • MSSQL

Best Practices for SQL Database setting

  • OTI
  • 6 November 2019
1. Database Owner: ‘sa’ As per my understanding, the Database…
Find all the users for a particular database
2 min read 0
  • MSSQL

Find all the users for a particular database

  • OTI
  • 6 November 2019
Introduction In SQL Server, managing user access and permissions is…
1 min read 0
  • MSSQL

How to run a SQL query using command prompt without SQL SSMS

  • OTI
  • 31 October 2019
Introduction How to run a SQL query using command prompt…
2 min read 2
  • MSSQL

Find IP and Port using SQL SSMS

  • OTI
  • 31 October 2019
Find IP and Port using SQL SSMS Find IP and…
2 min read 0
  • MSSQL

Find user activity without any Auditing

  • OTI
  • 28 October 2019
How to find out user activity on database without any…
4 min read 2
  • MSSQL

Latest service pack to SQL Server

  • OTI
  • 28 October 2019
Apply latest service pack to standalone SQL Server We have…
2 min read 0
  • MSSQL

Find SQL Server/Instance details using SQL query

  • OTI
  • 24 October 2019
Scenario Sometimes you need to gather the SQL instance details…

Posts pagination

Previous 1 2 3 … 6 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.