Skip to content
19, Jan 2026
  • facebook
  • instagram
  • twitter
  • youtube

Our Tech Ideas

Great minds discuss ideas!

Header Advertisement Image
  • 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.
  • Home
  • OTI
  • Page 15
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…
2 min read 1
  • MSSQL

Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)

  • OTI
  • 23 October 2019
Scenario You often get complained that user is not able…
3 min read 0
  • MSSQL

Error : FILESTREAM feature is disable

  • OTI
  • 17 October 2019
Introduction Error – System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A…
5 min read 0
  • MSSQL

Run a Job on few specific dates of every month in SQL Server

  • OTI
  • 16 October 2019
Introduction As per business requirements, a report needs to generate…
4 min read 0
  • MSSQL

Install SQL Server 2008R2 on Windows 2012R2

  • OTI
  • 15 October 2019
Introduction Installing lower version SQL Server on a higher version…
2 min read 0
  • MSSQL

Unable to begin a Distributed Transaction

  • OTI
  • 14 October 2019
Problem When your application uses the distribution transaction then you…
1 min read 0
  • MSSQL

Rename a Database in SQL Server

  • OTI
  • 11 October 2019
Introduction We can rename a user-defined database in SQL Server…

Posts pagination

Previous 1 … 14 15 16 … 20 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 © 2026 [Our Tech Ideas] Theme: Legacy Blog By Adore Themes.