Archive for 2019

Scenario You often get complained that user is not able to connect to SQL server or Application is not able to connect to SQL for some reason. There might be…

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 and asked to restore it on a pre-production SQL Server….

Introduction As per business requirements, a report needs to generate four times every month. The report will generated by a Stored Procedure. So the DBA’s task is to execute the…

Introduction Installing lower version SQL Server on a higher version of Windows Server may be problematic at times of installation. Recently we have faced such a scenario. We are sharing…

Problem When your application uses the distribution transaction then you may encounter below error. Error: The operation could not be performed because OLE DB provider “SQLNCLI11” for linked server “Linked_Server_Name”…

Introduction We can rename a user-defined database in SQL Server by using SQL Server Management Studio or Transact-SQL. System databases cannot be renamed. The database name cannot be changed while…

Scenario We recently came across a situation where one of the drives in the production server is almost full. There are two large databases and they were not backed up….

Introduction Find the database file growth for all the databases. It is not a good practice to keep your database file growth limited. In that case, you may get an…

Introduction There are two types of database-level roles: Fixed-database roles db_accessadmin Granted: ALTER ANY USER, CREATE SCHEMA,Granted with Grant option – Connect By SSMS By TSQL USE [Our_Tech_Ideas] — Database…

Introduction: Sometimes your query gives you very bad performance because of statistics as SQL database engine Query optimizer uses statistics to create query plans. Updated statistics will give you good…