2 min read
0
SQL Network Interfaces, error: 26
SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified Users often see “SQL Network Interfaces, error: 26 – Error Locating…
Year: 2019
2 min read
1
Find the SQL Server Cluster details
Scenario A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node,…
2 min read
4
Create login by CMD in SQL Server
Scenario You have got the SQL database engine installed but no SSMS installed on it. In this scenario how you…
4 min read
0
Best Practices for SQL Database setting
1. Database Owner: ‘sa’ As per my understanding, the Database Owner always should be ‘sa’. We can change ‘sa’ login…
2 min read
0
Find all the users for a particular database
Introduction In SQL Server, managing user access and permissions is crucial for maintaining the security and integrity of a database.…
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 without SQL SSMS Open CMD from Run and run the…
2 min read
2
Find IP and Port using SQL SSMS
Find IP and Port using SQL SSMS Find IP and Port of a SQL Server from a client machine. The…
2 min read
0
Find user activity without any Auditing
How to find out user activity on database without any particular Auditing Sometime you may need to find out who…
4 min read
2
Latest service pack to SQL Server
Apply latest service pack to standalone SQL Server We have given a Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)…
2 min read
0
Find SQL Server/Instance details using SQL query
Scenario Sometimes you need to gather the SQL instance details in a proper format such as Server Name, Instance, Service…