-- Insert a new color 
INSERT INTO [Warehouse].[Colors]
SELECT 
     37 AS ColorID
    ,'Dark Yellow' AS ColorName
    ,1 AS LastEditedBy
    ,GETUTCDATE() AS ValidFrom
    ,'9999-12-31 23:59:59.9999999' As Validto
GO
-- Verify the insert
SELECT [ColorID]
      ,[ColorName]
      ,[LastEditedBy]
      ,[ValidFrom]
      ,[ValidTo]
  FROM [Warehouse].[Colors]
  WHERE ColorID=37

-- Verify the insert
SELECT [ColorID]
      ,[ColorName]
      ,[LastEditedBy]
      ,[ValidFrom]
      ,[ValidTo]
  FROM [Warehouse].[Colors]
  WHERE ColorID=37

param(
        [Parameter(Mandatory=$true)]
        [string]$sqlserver,
        [Parameter(Mandatory=$true)]
        [string]$database,
        [Parameter(Mandatory=$true)]
        [string]$sqluser,
        [Parameter(Mandatory=$true)]
        [string]$sqlpassword,
        [Parameter(Mandatory=$true)]
        [string]$resourcegroupname,
        [string]$newdatabasename    
)

#Login to Azure account
Login-AzureRmAccount

While (1)
        {
            #Retrieve the distinct restore points from which a SQL Database can be restored
            $restoredetails = Get-AzureRmSqlDatabaseRestorePoints -ServerName $sqlserver -DatabaseName $database -ResourceGroupName $resourcegroupname
            #get the earliest restore date
            $erd=$restoredetails.EarliestRestoreDate.ToString();
            #ask for the point in time the database is to be restored
            $restoretime = Read-Host "The earliest restore time is $erd.'n Enter a restore time between Earliest restore time and current time." 
            #convert the input to datatime data type
            $restoretime = $restoretime -as [DateTime]
            #if restore time isn't a valid data, prompt for a valid date
            if(!$restoretime)
            {
…           
                break;
            }
        }

#set the new database name
        if([string]::IsNullOrEmpty($newdatabasename))
        { 
            $newdatabasename = $database + (Get-Date).ToString("MMddyyyymm")
        }
…
 #restore the database to point in time
        $restore = Restore-AzureRmSqlDatabase -FromPointInTimeBackup -PointInTime $restoretime -ResourceId $db.ResourceId -ServerName $db.ServerName -TargetDatabaseName $newdatabasename -Edition $db.Edition -ServiceObjectiveName $db.CurrentServiceObjectiveName -ResourceGroupName $db.ResourceGroupName 
# restore deleted database
        if($rerror -ne $null)
        {
            Write-Host $rerror -ForegroundColor red;
        }
        if($restore -ne $null)
        {
            Write-Host "Database $newdatabasename restored Successfully";
        }

.PITRAzureSQLDB.ps1 -sqlserver toyfactory -database toystore -sqluser sqladmin -sqlpassword Packt@pub2 -resourcegroupname toystore -newdatabasename toystorepitr

.GeoRestoreAzureSQLDB.ps1 -sqlserver toyfactory -database toystore -sqluser sqladmin -sqlpassword Packt@pub2 -resourcegroupname toystore -newdatabasename toystorepitr