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 with their physical location 4) Database Creation Time 5) Users access type for Database 6) […]

Continue Reading

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 is restored recently? 2) Which backup file (with location information) is used for database restoration? […]

Continue Reading

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, we need to find out when a database is last accessed in order to find […]

Continue Reading

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 of the following Azure SQL concepts What is Azure and Azure SQL Database Pricing Model […]

Continue Reading