Monthly Archives: March 2018

SQL Script to find the database & their files details on a SQL Server

SQL Script to find database details Sometimes we need a SQL Script which can give the below information about the databases created on a SQL Server for house keeping purpose: -1) Database Name 2) Database ID 3) Database Files name … Continue reading

Posted in DBA | Tagged , | 31 Comments

SQL Script: – How to find the database restoring history of SQL Server databases

SQL Script to findĀ database restoring history Sometime we need to find out the history of database restoration to get the answers of following questions: -1) Do we need to restore the database again as there is a possibility that it … Continue reading

Posted in DBA, SQL Database Restoration | Tagged , | 28 Comments

SQL Script: – How to find the last access date of a database

SQL Script to find database last access date Sometime we create databases on Test/ Development database servers for temporary uses for short duration andĀ  forgot to delete them after the work got completed. As a part of house keeping activity, … Continue reading

Posted in DBA | Tagged , | 35 Comments

Understanding Azure SQL Database – Introduction

Azure SQL Database – Introduction In this first article Azure SQL Database – Introduction of the series Understanding Azure SQL Database I am going to publish the Azure SQL Database concepts. After this series, you will have the good understanding … Continue reading

Posted in Azure | Tagged , | 32 Comments