Tuesday, October 06, 2015

Secure sensitive data with SQL Server on Azure

Hi All,

SQL Server 2016 has released a new feature that is called "Dynamic Data Masking" which allows to mask sensitive information to be masked on the fly without a change to a line of code in your application. The video covers the DDM technology, the need for it and how to implement it on SQL DB in Azure. This feature can be implemented either using SQL PaaS (Azure SQL DBs) or IaaS (SQL Server VMs) on Azure.

If you have for example Personal Identification Information (PII), Credit Card Numbers, or Social Security Numbers that you would like to secure from non-authorized view from viewing restricted information to comply with your security policies. DDM is the right feature for you with zero change line of code.

SQL Database Dynamic Data Masking (DDM) limits sensitive data exposure by masking it to non-privileged users. Dynamic data masking is in preview for Basic, Standard, and Premium service tiers in the V12 version of Azure SQL Database.
Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. It's a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database is not changed.

In this video, I cover how to configure DDM feature in SQL Database on Azure using the new Azure portal. How to manage existing masks and how to test out this feature using SQL Server Management Studio (SSMS).

The video covers how to manage multiple users scenario to allow either masked or unmasked data on a SQL database in Azure.

Enjoy the video below.

Channel 9 video link


Monday, October 05, 2015

Identity and Office 365 presentation on DC Cloud Tour Event

Hi All,

I presented a presentation on Cloud Tour event at Microsoft Chevy Chase office in DC metro area. The presentation covered Identity and Azure Active Directory (AAD). I covered how Office 365 uses AAD under the hood to authenticate users and how AAD uses standard protocols such as: OAuth 2.0 to authentication and generate user claims to other applications. The presentation covers how to register apps as a multi-tenant apps and how to set permissions for registered apps.

The presentation covered the following topics:
1) Azure Active Directory (AAD).
2) Office 365 Services.
3) AD Graph API.
4) Registering apps to AAD & Office 365.
5) Build Connected apps using VS 2015 with O365.

Hope this helps.

Azure Data Platform presentation on DC Cloud Tour event

Hi All,

During Azure Cloud Tour in DC, I presented a session about Azure data platform services which includes wide range of services for developers, and architects.

When you build a cloud based solution, you need to have an understanding of the available options to store and secure your data. This presentation covers the following topics:

1) SQL Server Database on Azure as PaaS.
2) SQL Server Database security features such as: Row Level Security, Dynamic Data Masking and Transparent Data Encryption (TDE).
3) SQL Server VMs as IaaS vs PaaS offering.
4) DocumentDB as NoSql option on Azure.
5) Elastic Database Pool for SQL Servers on Azure.
6) Azure Search as enterprise scalable solution.
7) HDInsight Microsoft Hadoop cluster implementation available on Windows and Linux.
8) Data Warehousing as a service on Azure.
9) Data Lake: enterprise wide repository of your data in its original format.

Hope this helps.

Wednesday, September 23, 2015

How to download Azure Publish Settings file

Hi All,

If you are trying to download Azure Publish Settings file and you are not having any luck by using PowerShell command: Get-AzurePublishSettingsFile or the url provided at MSDN article:


Here is the fix:

1) Login with your credentials to Azure portal.
2) Open a new tab in the same browser and paste below url:


Then, you will see the file has started to download, Enjoy!

Tuesday, September 22, 2015

Let's Dev This Tour - DC Oct 1st - Cloud Tour

Build a powerful, enterprise-grade cloud platform using the NEW features of Visual Studio 2015 & Microsoft Azure

Date: Oct 01, 2015 8:30 AM - 5:00 PM
Microsoft Office - Washington, D.C.
5404 Wisconsin Ave Suite 700
Chevy Chase , Maryland 20815
See map and/or driving directions
Please join us for this interactive, full-day training session led by Microsoft experts, created specifically for developers like you.

What am I going to learn?
At this event, you will learn about the latest release of Visual Studio 2015 and Microsoft Azure’s features and services – including Microsoft Azure Virtual Machines, Websites, and Visual Studio’s IntelliTest – that can help you build and move a variety of apps to the cloud. You’ll see how to build websites, mobile applications, and enterprise-class applications.

We’ll give you a free Microsoft Azure pass since you’ll spend most of the day in a hands-on lab environment.

See you all there! bring you computer and let's build software in the cloud!

Sign up now:

Saturday, September 19, 2015

Get started with Windows 10 IoT Core and Azure IoT Services


I had a great opportunity to present a workshop at hardware hacking event through #HardwareWeekend Hackster.io in DC.

The hardware hackathon was the first time for me to join the maker community and present the powerful features of Windows 10 IoT Core and Azure IoT sevices.

An amazing number of submitted projects so far and looking forward to seeing the demos tomorrow.

The submitted projects in DC Hackster event can be found here: hackster.io/dc

Below is my presentation for reference.

Building IoT solutions using Windows 10 IoT Core & Azure from Mostafa Elzoghbi

Social Engagement:

The MS winner team: BPM Biker

Saturday, September 12, 2015

How to get started with IoT devices running windows 10 IoT Core


Microsoft published a development center for developers to start developing IoT solutions for available IoT hardware devices in the market.

If you want to get started developing IoT solutions, You can use your existing development skill set in windows to develop solutions since there are good number of IoT devices that support running windows 10 IoT core such as:

1) Raspberry Pi 2.
2) MinnowBoard Max.
3) Galileo
4) Windows Remote Arduino
5) Windows Virtual Shields for Arduino

These IoT devices are not expensive, Once you get one of these devices, you can start running Windows 10 IoT core and start developing solutions using Visual Studio 2015.

Below is some useful links to get started:

Windows Dev Center - IoT:

Select your IoT Device:

Once you get Visual Studio 2015 Community edition for free, you need to get Windows 10 IoT core project templates:

Have fun!

Wednesday, August 19, 2015

Work with MySQL database on Azure


I have published two videos on channel 9 about Microsoft Azure capabilities on mySQL databases.
You can create MySQL databases for free on Azure, start your proof of concept and any development project by having MySQL instance that can scale based on the power of cloud computing.

I covered how to provision, create, manage MySQL databases on Azure and how to connect to these instances from MySQL workbench.

In the first video, Get Started with MySQL on Azure i covered how to provision, create and manage mySQL instance on Azure.

Video Url: https://channel9.msdn.com/Blogs/MostafaElzoghbi/Get-Started-with-MySql-on-Azure

In the second video, Get Started with MySQL workbench for MySQL databases on Azure i covered how to connect and manage MySQL azure instances from your favorite MySQL management studio "MySQL workbench".

Video Url: https://channel9.msdn.com/Blogs/MostafaElzoghbi/Get-Started-with-MySQL-Workbench-for-MySQL-databases-on-Azure

Hope you enjoy both of these videos.

If you need any in deep learning materials to be posted on ch9, please drop me a message.