Month: October 2019

Introduction How to run a SQL query using command prompt without SQL…

Find IP and Port using SQL SSMS Find IP and Port of…

How to find out user activity on database without any particular Auditing…

Apply latest service pack to standalone SQL Server We have given a…

Scenario Sometimes you need to gather the SQL instance details in a…

Scenario You often get complained that user is not able to connect…

Introduction Error – System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A database backup…

Introduction As per business requirements, a report needs to generate four times…

Introduction Installing lower version SQL Server on a higher version of Windows…

Problem When your application uses the distribution transaction then you may encounter…

Introduction We can rename a user-defined database in SQL Server by using…

Scenario We recently came across a situation where one of the drives…

Introduction Find the database file growth for all the databases. It is…

Introduction There are two types of database-level roles: fixed-database roles that are predefined…

Introduction: Sometimes your query gives you very bad performance because of statistics…

Introduction Here we will discuss different backup strategies and methodologies used to…

Introduction In this post, we will try to show step by step…

Introduction Backing up a database is one of the most important things…