Monthly Archives: March 2018

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

Posted on March 30, 2018 by vivekjohari

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

Posted on March 30, 2018 by vivekjohari

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

Posted on March 29, 2018 by vivekjohari

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

Posted on March 18, 2018 by vivekjohari

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