Our Tech Ideas

Scenario You have got the SQL database engine installed but no SSMS installed on it. In this scenario how you…

1. Database Owner: ‘sa’ As per my understanding, the Database Owner always should be ‘sa’. We can change ‘sa’ login…

Introduction How to run a SQL query using command prompt without SQL SSMS Open CMD from Run and run the…

Scenario Sometimes you need to gather the SQL instance details in a proper format such as Server Name, Instance, Service…

Scenario You often get complained that user is not able to connect to SQL server or Application is not able…

Introduction Error – System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A database backup from a test server provided to DBA team…