March 2018 - Technology with Vivek Johari

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

March 30, 2018April 16, 2018 vivekjohari31 Comments

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) […]

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

March 30, 2018April 27, 2018 vivekjohari28 Comments

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? […]

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

March 29, 2018December 24, 2018 vivekjohari55 Comments

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 […]

Understanding Azure SQL Database – Introduction

March 18, 2018January 27, 2019 vivekjohari32 Comments

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 […]