Search This Blog

Monday, December 30, 2019

Building Home Lab VPN

In this post, we are going to setup Home Lab VPN using VeeamPN. Once setup, you able to access your lab from outside.

Download from here. Current latest version is:- Version: 2.1.0.461
Export OVA to Vmware infrastructure

Default login:
username: root
password: VeeamPN



After login in, get the ip address using command "ifconfig"


Use browser to login to VeeamPN webpage for further configuration

https://veeampn ip address

Change your password when login 1st time/

Then walkthrough on initial configuration

  • installation type (Network hub, site gateway, restore config backup)
  • generate self signed certificate
  • specify VPN settings 
You may view further configuration from here

For macbook user, follow this site to learn how to connect.

Enjoy!






Friday, December 27, 2019

How to Backup Azure SQL Database to Local - Part 4

Continue from Part 3, we are going to explore on way to backup Azure SQL Database. In this post, we are putting backup data into Azure Blob Storage.

Natively Azure SQL Database allow to export database into Azure Blob Storage.

To do so, on database click Export


Provide

  • File name
  • Subscription Plan
  • Storage to store backup data
  • Database credential


It will take a while for the process to run. You can view status from Import/Export History.

 After backup completed, you can view the bacpac file in your Azure Blob Storage.

That's all for today.

To view previous part, please click below link:




Sunday, December 15, 2019

How to Backup Azure SQL Database to Local - Part 3

Continue from Part 2, we are going to explore next tool to backup Azure SQL Database to Local Computer.

Tool 3: SqlBackupAndFTP Tool

Able to download this tool from here. It is provided free to backup 2 database.

It support MS Sql, My SQL and PostgreSQL database. This tool allow you to backup SQL database to Bacpac file with scheduling for full, differential & transaction.



You can use wizard to configure the backup. Start by selecting type of database.


Next step, enter Azure SQL Server name & credential


Once connected, select database that you want to backup.


Then select your backup target location. For our scenario, we select "Local"


Specify the schedule that you want to backup. You can click on Settings to change the schedule to advance mode.


Finally to get the result, we can send notification via email.


[Result] 
Backup will run according to schedule. You can view the status from log.




That's all for today.

Click here for Part 4.

Wednesday, December 11, 2019

How to Backup Azure SQL Database to Local - Part 2

Continue from Part 1, we are going to explore next tool to backup Azure SQL Database to local.

Tool 2:- Use SQLPackage Utility. This tool will create BACPAC file from a command line. You can run unattended/automatically using batch file & scheduler.


[Pre-requisite]
Download SQLPackage from here
or 
Download Visual Studio Community. Install Data Storage & Processing
Install Analysis Services & Reporting Services, Integration Services component in Visual Studio Market Place. Click here

[Begin]

Query the location of SQLPackage by typing command "dir sqlpackage.exe /s /p"



[ Backup ]

Execute command 

Command:
sqlpackage.exe /Action:Export /ssn:tcp:<location> /sdn:<dbname> /su:<username> /tf:c:\backup\<dbname>.bacpac /sp:<password> /p:Storage=File


Example:
sqlpackage.exe /Action:Export /ssn:tcp:testdb1.database.windows.net /sdn:testdb1 /su:ericlaiys2019 /tf:c:\backup\testsqlpackage.bacpac /sp:1234567890@ms4u /p:Storage=File



Click here for Part 3.


Monday, December 9, 2019

How to Backup Azure SQL Database to Local - Part 1

In this post, we are looking into a way to backup Azure SQL Database which resides on PaaS to local or back to customer on-prem.

This is Part 1 of the tools.

[Pre-requisite preparation]


  • Create any Windows VM operating system. We used Win 10.
  • Install SQL Server Management Studio (SSMS). It require the latest DAC library installed.To download, click here
  • Add Service endpoint on virtual network. Go to Virtual Network > Add Service Endpoint > Microsoft.SQL

  • On SQL Database, open Azure SQL Database Firewall to allow access to the VM



Tool 1: Export a Data Tier Application Using SSMS


  • Open SSMS Tools and Connect to your Azure SQL Database
  • Right click select your database > Tasks > Export Data Tier Application


It will create BACPAC file which will create an exact copy of the database.

This process is manual procedure.

Review Part 2 here.

Thursday, November 21, 2019

ALTARO - Holiday Contest 2019 - Great Prizes to be Won



This Holiday Season, Altaro is helping you out with your Holiday Shopping: they’re giving you the chance to WIN fantastic gifts that you can give to your loved ones! 
It’s no secret that Holiday shopping can be stressful and very time-consuming. So this year, whether you need a present for your partner, your children, your parents and in-laws, or your friends… Altaro’s got your back. Enter and share it on socials for a chance to WIN one of the Grand Prizes: a Holy Stone GPS FPV RC Drone HS100, an All-Access MasterClass pass, 
Lomography Lomo’Instant San Sebastian, an Echo Plus (Smart Home Hub), a Wii Console & Mario Kart for Wii, 2x Netflix Gift Cards of $100 each, and a JBL Clip Portable Waterproof Speaker. 
And guess what? For any eligible subscription they give you a guaranteed Amazon voucher! 
So, if you are a Hyper-V or VMware user, download Altaro’s VM Backup and follow the instructions you will find over here to WIN these exciting prizes! 

Good luck & Happy Holidays! 

Friday, November 8, 2019

FREE Webinar - Fast Track your IT Career with VMware Certifications


Everyone who attends the webinar has a chance of winning a VMware VCP course (VMware Install, Config, Manage) worth $4.5k!




Climbing the career ladder in the IT industry is usually dependent on one crucial condition: having the right certifications. If you’re not certified to a specified level in a certain technology used by an employer, that’s usually a non-negotiable roadblock to getting a job or even further career progression within a company. Understanding the route you should take, and creating a short, medium, and long term plan for your certification goals is something everyone working in the IT industry must do. In order to do this properly you need the right information and luckily, an upcoming webinar from the guys at Altaro has you covered!

Fast Track your IT Career with VMware Certifications is a freewebinar presented by vExperts Andy Syrewicze and Luke Orellana on November 20th outlining everything you need know about the VMware certification world including costs, value, certification tracks, preparation, resources, and more.

In addition to the great content being discussed, everyone who attends the webinar has a chance of winning a VMware VCP course (VMware Install, Config, Manage) worth $4.5k! This incredible giveaway is open to anyone over the age of 18 and all you need to do to enter is register and attend the webinar on November 20th! The winner will be announced the day after the webinar via email to registrants.

VMware VCP Certification is one of the most widely recognized and valued certifications for technicians and system administrators today however the hefty price tag of $4.5k puts it out of reach of many. The chance to get this course for free does not come along every day and should definitely not be missed!