Skip to content

Our Tech Ideas

Great minds discuss ideas!

Month: November 2019

Best Practices for SQL Database setting

6 November 2019 By OTI Leave a comment

1. Database Owner: ‘sa’ As per my understanding, the Database Owner always should be ‘sa’. We can change ‘sa’ login name as per our organization standard login available in SQL security. While creating a database ‘sa’ should be assigned as…

Read More →

Find all the users for a particular database

6 November 2019 By OTI Leave a comment

Introduction In SQL Server, managing user access and permissions is crucial for maintaining the security and integrity of a database. Often, there is a need to retrieve a list of user names while excluding certain system roles. In this blog…

Read More →

Posts pagination

← Previous 1 2

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.

© 2026 Our Tech Ideas. All rights reserved.