Trending :
  • Why normally full recovery model is used in production server?
  • Explain different types of backups?
  • When we will go for bulk-logged recovery model.
  • How many types of recovery models are in SQL server ? Explain them.
  • Why normally full recovery model is used in production server?
  • facebook
  • twitter
  • linkedin

SQL Database

Wanna be a Database Administrator ? Follow Us , Support Us , Stay with Us Because "We are DBA".

  • Home
  • Microsoft SQL Server
  • Microsoft Azure
  • Windows PowerShell
  • About Us and Privacy Policy
Search for:
  • Home
  • 2018
  • January

Automated Back Up and Restore of SQL Database in Different Server using Windows PowerShell.

January 28, 2018January 12, 2021Windows PowerShell

# Declear all variable. $BackUpServerName=”ServerName From Where Take The Backup” $DatabaseName=”DatabaseName” $BackUpLoactionWithFileName=”C:\BackUpLocation\FileName.bak” $RestoreServerName=”ServerName Where You Wants to Restore Your Backup”…

Read More

SQL Function to Convert Unix (Linux) Date Format to SQL Timestamp

January 21, 2018January 7, 2021Microsoft SQL Server

How to create the Function ? CREATE FUNCTION SchemaName.FunctionName(@String VARCHAR(40)= null) RETURNS DATETIME WITH RETURNS NULL on NULL input AS…

Read More

How to create SQL Database as Software as a service(SAAS) in Azure Portal?

January 14, 2018January 5, 2021Microsoft Azure

In left panel menu bar click on ‘SQL Database’ Then click on ‘Add’ button. Then type ‘Database Name’. Choose your…

Read More

How to create Virtual Machine as Infrastructure as a service(IAAS) in Azure Portal?

January 7, 2018January 4, 2021Microsoft Azure

First select ‘Virtual Machines’ from left side menu. Then click on Add. Then select your preferred operation system or application.…

Read More

How to create Resource Group in Azure Portal?

January 1, 2018January 2, 2021Microsoft Azure

Before create a Resource Group first we have to know what resource group is. Resource group is nothing but a…

Read More

Recent Posts

  • Why normally full recovery model is used in production server?
  • Explain different types of backups?
  • When we will go for bulk-logged recovery model.
  • How many types of recovery models are in SQL server ? Explain them.
  • Why normally full recovery model is used in production server?

Archives

  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018

Categories

  • Microsoft Azure
  • Microsoft SQL Server
  • Windows PowerShell
Copyright © PABTechnology
PT Magazine by ProDesigns