hi Copy How to migrate SQL Database to Azure SQL Database using SSMS deploy Azure

How to migrate SQL Database to Azure SQL Database using SSMS deploy

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
title Azure Pricing Models and Service Tiers Azure

Azure Pricing Models and Service Tiers

  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 Reading

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
DB recovery 1 SQL Script: - How to find the database restoring history of SQL Server databases DBA Scripts

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

SQL Script to find all the triggers defined on a database or on a single table

SQL Script to find triggers in SQL Database Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] , trig.name as [Trigger Name] , trig.is_disabled FROM [sys].[triggers] as trig INNER JOIN sys.tables as tbl ON trig.parent_id = tbl.object_idIn […]

Continue Reading
table detailed 1 Interview question - Is Clustered index on column with duplicate values possible? CodeProject

Interview question – Is Clustered index on column with duplicate values possible?

Through this article, we are going to discuss three important interview questions of SQL which are given below:-  1) Can we create clustered index on a column containing duplicate values?  2) Can we create a Primary Key on a table on which a clustered index is already defined? 3) If a clustered index is already defined on a […]

Continue Reading
emp plandata Question of the Month (July) Question of the Month

Question of the Month (July)

Question of the Month Suppose we have a table emp_plan  which contains 4 columns “Empid” (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate). Its structure is given below:-4  Create table emp_plan (empid nvarchar(200),planid nvarchar(20),startdate datetime, enddate datetime) Also below is the script to enter sample data into the table:- insert into emp_plan(empid,planid,startdate,enddate) select ‘001’,’planA’,’2015-05-15′,’2015-05-30′ […]

Continue Reading