Learn database in a simple and easy way.
Migrating SQL Database to Azure SQL Database using SSMS Deploy In the previous articles, we had introduction about the Azure SQL Database, Azure Service Tiers and pricing models, Creation of Azure SQL Database & How to connect with the Azure SQL Databases. Now, in next step, we will discuss about the SQL database […]
Continue Reading
This article gives the Step by Step process of how to connect with Azure SQL Server. Images has been added at every step to make understanding of the concept easy and in a better way.
Continue Reading
Azure Service Tiers Contents Introduction DTU Based Pricing model What is DTU? Example Different Service Tiers in DTUs base pricing model Standard Service Tier Levels Premium Service Tier Levels DTU Calculator How DTU Calculator work Conclusion Introduction When we start migrating our database from SQL Server to Azure Database, we want to know what are […]
Continue ReadingSQL 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 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 ReadingSQL 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 ReadingAzure 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
Problem Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a lot of issues. To maintain the workflow they need to recover deleted records from SQL Server 2014. This could be possible only with successful SQL […]
Continue ReadingWays to Restore Database from MDF File Introduction In todays decade Relational database Management system became the necessity of the organizations whether they are small level or large level. In such context SQL Server is the best and successful RDBMS which provides highly integrated services to manipulate the SQL database over the Server. As we […]
Continue ReadingResuming Suspended Database Mirroring in SQL Overview Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and minimizes the loss of the data. Redundancy ensures that there is always a one backup copy of the database […]
Continue Reading