Our Tech Ideas

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…

Introduction As per business requirements, a report needs to generate four times every month. The report will generated by a…

Introduction Installing lower version SQL Server on a higher version of Windows Server may be problematic at times of installation.…