Posts

How To Move or Migrate SQL Server Workload to Azure SQL Database

Image
Migrating SQL Server Database to Azure SQL (PaaS) In this article, we will highlight SQL Server Data migration to Azure SQL (PaaS). You can find different approaches for this migration process because SQL Server offers different types of tools and features for this migration. Some of these are:    Database Migration Assistant    SQL Server Management Studio Deployment Wizard    SQL Server to Azure SQL replication Data Migration Assistant DMA : The Data Migration Assistant (DMA) enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server and Azure SQL Database. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server. Features which are provided by Database Migration Assistant play a key role in the migration process. T
Post a Comment
Read more

How to create a Virtual Machine in Microsoft Azure - ARM

Image
How to create a Virtual Machine in Azure - ARM  Azure virtual machines can be created through the Azure portal. This method provides a browser-based user interface for creating and configuring virtual machines and all related resources.  Login to your Azure Portal: https://portal.azure.com/ If you don't have an account sign up here for  Free Let's Create a Virtual Machine: Click on Virtual machines from the Hub menu(left side on the portal). If you don't see this option please click on All Services and search Virtual machines. Click on Add option as shown below Select the OS flavor from the blade menu, in this case, we have selected Windows machine. Select the flavor/version of Windows machine. Here we have selected 2016 Datacenter. Then click on Create option. This will take you to the configuration of the machine window. Below is the Basic configuration required for setting up this virtual machine. Once done please click on OK
Post a Comment
Read more

iPhone/iPad Can’t Update to iOS 11? Here’s How to Fix

Image
iOS 11 is available for downloading at present. It is not surprising that various Apple users have been rushing to update and install the latest major upgrade. However, some iPhone 7 or iPhone 6s/6 users can’t find the update via Settings > General > Software Update. Some other users will get update failure or unable to install update error. Given this, we have gathered some of the cases and solutions about how to fix iPhone won’t update to iOS 11. Case 1. What Devices Can Update to iOS 11? "After the last night presentation I' d like to know if there will be compatibility of iOS 11 with iPhone 5c." How-To Fix : If your machine won’t update to iOS 11, confirm that whether it is compatible with iOS 11 at first. You need to recognize that not all iOS devices are able to update to iOS 11. Therefore, before complaining about failing to update iOS 11, check if your Apple device supports the update. Here is a full list of iOS 11 device compatibility.
Post a Comment
Read more

How to write a Formatted Email using Powershell / Automation

How to write a Formatted Email using Powershell / Automation #Author : Nishant Naidu #Technet - i-TechNinja Hey Bros, This script will help you to write a formatted email using Powershell :) With the help of this script, you can send mail with customize date. You can also have a formatted custom body, html, table, cells and all. You can automate or schedule this to run occasionally. When you are sending static mails every time across number of users, you can simply use this script to do your job. Let the script do its job and you sit back and relax :enjoy your day :) ThisScript : #  Hi, This script will help you to format mail # You can use this to automate/schedule mail # You can also convert this ps1 to exe and schedule it # I hope it helps :) #If you want to sent attachment in mail pls mention filename path below $dir = "c:\crazycerebro\yourfilename.here" #If you to add dynamic date so that whenever you schedule it should take that particular
Post a Comment
Read more

Check Uptime for Multiple Servers using Powershell - GUI based tool

Image
Check Uptime for Multiple Servers using Powershell - GUI based tool #Author : Nishant Naidu #Technet - i-TechNinja # https://social.technet.microsoft.com/profile/i-tech%20ninja/ #azurebros.blogspot.in This tool will help you to determine the uptime for the multiple servers. Script : Function Get-Uptime{ Param([string]$server) Begin { function PingServer { Param([string]$srv) $pingresult = Get-WmiObject win32_pingstatus -f "address=’$srv’" if($pingresult.statuscode -eq 0) {$true} else {$false} } function myUptime { param([string]$srv) $os = Get-WmiObject Win32_OperatingSystem -ComputerName $srv $uptime = $os.LastBootUpTime return $uptime } function ConvertDate { param([string]$date,[string]$srv) $year = $date.substring(0,4) $Month = $date.Substring(4,2) $day = $date.Substring(6,2) $hour = $date.Substring(8,2) $min = $date.Substring(10,2) $sec = $date.Substring(12,2) $RebootTime = new-Object System.DateTime($year,$month,$day,$hour,$min,$sec) $now = [System.D
Post a Comment
Read more

Robust Copy large files over the network - using ROBOCOPY

Robust Copy large files over the network - using ROBOCOPY Robust File and Folder Copy. By default Robocopy will only copy a file if the source and destination have different time stamps or different file sizes. Syntax  robocopy source destination [file [file]...] [options] file(s)_to_copy : A list of files or a wildcard . (defaults to copying *.*) Source Options: /S : Copy Subfolders. /E : Copy Subfolders, including Empty Subfolders. /COPY: copyflag [ s ] : What to COPY (default is /COPY:DAT) (copyflags : D =Data, A =Attributes, T =Timestamps S =Security=NTFS ACLs, O =Owner info, U =aUditing info). /SEC : Copy files with SECurity (equivalent to /COPY:DATS). /DCOPY:T : Copy Directory Timestamps. /COPYALL : Copy ALL file info (equivalent to /COPY:DATSOU). /NOCOPY : Copy NO file info (useful with /PURGE). /A : Copy only fil
Post a Comment
Read more

Get Account Expiry Date for the list of users - Powershell

Get Account Expiry Date for the list of users - Powershell  The standard approach lets you to get the account expiry details for the entire ADuser and its also time consuming. Since it has to return the all the users with their expiry details. Querying such a large database takes lot of time. Below script will allow you to narrow down your search query. Script: #import AD module Import-Module   ActiveDirectory ; #save the list of users in text file at any given location, mention that path below $userlist   =   Get-Content   "C:\folder\listofuser.txt" ; # $output variable will save the result in it $Output   =   foreach ( $user   in   $userlist ) { #Querying each user and returning their respective details by using Select Get-ADUser   -property   *   -ldapfilter   "(samaccountname= $user )" |   select   sAMAccountName ,   Displayname , accountExpirationDate ,   Enabled ,   Title    }; #Mention the filename and path
Post a Comment
Read more