2 min read
1
Find the SQL Server Cluster details
Scenario A cluster includes two or more physical servers, called nodes; identical…
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.
2 min read
4
4 min read
0
Best Practices for SQL Database setting
1. Database Owner: ‘sa’ As per my understanding, the Database…
2 min read
0
Find all the users for a particular database
Introduction In SQL Server, managing user access and permissions is…
1 min read
0
How to run a SQL query using command prompt without SQL SSMS
Introduction How to run a SQL query using command prompt…
2 min read
2
2 min read
0
4 min read
2
2 min read
0
Find SQL Server/Instance details using SQL query
Scenario Sometimes you need to gather the SQL instance details…
2 min read
1
Login failed for user ‘XXXX’ (Microsoft SQL Server, Error: 18456)
Scenario You often get complained that user is not able…