Author Archives: Deepak

About Deepak

I am a Sr. Consultant at Saskatoon/Canada and MVP (C# Corner). I am a passionate Microsoft Certified Professional Developer (MCPD) /Technology strategist, Technical author & Software Architect (TOGAF 9.1 Certified) with hands on experience in Software design & development, Agile practices and Continuous Delivery. Since 2008, I am exchanging knowledge with the technical fraternity via different online forums and personal blogs. I LOVE to share my knowledge with community.

Presented on ‘MS Azure at 360*’at Microsoft Canada

Thank you all for joining my sessions ‘MS Azure at 360*’ on Jan 9th at Microsoft Canada 222 Bay St. Suite 1201 · Toronto, ON

I had a great time presenting at full room capacity on #Azure at # Microsoft Toronto… I really enjoyed!

I’m super happy that everyone enjoyed and learned from my session:

This moment captures the journey from Microsoft Toronto

Here is the ‘Toronto user Group’ Meetup URL:

MS Azure at 360*, Data Ingestion with Azure Data Platform, and MS Graph SDK

Wednesday, Jan 9, 2019, 6:00 PM

Microsoft Canada
222 Bay St. Suite 1201 Toronto, ON

26 Members Went

Join us for the first C# Corner meetup of 2019!!! On 9 Jan meetup, we will have 3 speakers. Agenda: • Introduction to C# Corner & it’s Toronto chapter • Let’s explore Microsoft Azure at 360* by Deepak Kaushik • Modern Data Platform Part 1: Data Ingestion by Heather Grandy • Programming with Microsoft Graph SDK by Nilesh Shah Session details: • Let’…

Check out this Meetup →

Please have slides of session “Let’s explore Microsoft Azure at 360*” are here – https://www.slideshare.net/DeepakKaushik007/microsoft-azure-at-360-128194942

Advertisements

Microsoft Ignite | The Tour -Toronto (January 10-11, 2019)

This year I’ll travel the world to deliver presentations focused on building cloud-based apps and adopting/ migration to Azure SQL Data Warehouse for the enterprise.

In addendum, I would love to share the success story of my client, after successfully migration to Azure.

I attended Microsoft Ignite | The Tour -Toronto (January 10-11, 2019) and I would like to thank to everyone for catching me at ‘Meet The Experts’ booth for #azure at #Toronto #MSIgniteTheTour !!

I must say awesome venue, great Q&A, astonishing audience at #MSIgniteTheTour . I hope everyone enjoyed discussion and #Azure #SQL Datawarehouse and #Azure Storage demo.

Indeed this #MSIgniteTheTour was incredible!!

I met so many phenomenal people, friends, MVP’s, Microsoft team! I can’t believe how lucky I am 😊😊!

See you soon at next event. This moment captures the journey from Toronto

#Toronto #msignitethetour #Azure #Microsoft #technology #microsoft #presenter

Azure Subject Matter Expert at Microsoft Redmond

Last week of November 2018, I’m honored to got an opportunity to contribute as an Azure Subject matter expert and attended highly packed meetings on Microsoft Redmond Office.

All Azure geeks and the Microsoft employees were brainstorming on the Azure Learning Path. Focus/ objective was how to improve the Azure learning experience, empowering everyone by Az-certifications, focusing on the current/ future technology challenges, innovative solutions for customers and many more…

Super happy to be part of such a incredible ecosystem, and could say that very exciting things happening in the Azure world, Priceless!!

Thanks Microsoft for giving me this wonderful opportunity, I love my Job and Azure!!

#technology #microsoft #azure #microsoftlife #subjectmatterexperts #mvpbuzz #cdnmvp

You could also find this article at LinkedIn

Pics : Microsoft Redmond/ Washington


Let’s save cost of *Azure Data Warehouse* by AUTO PAUSING

PowerShell Script For Data Warehouse

Introduction

If you want to use Azure Data Warehouse for a couple of hours/days and want to save cost, you can certainly do that by *AUTOMATICALLY PAUSING* your Data warehouse. This will minimize the Azure Cost to a great extent.

In this article, I will explain the nitty gritty of the process step by step. You just need to replicate the steps at your Azure Environment.

Schedule Pause - Resume for your Azure Data Warehouse
Schedule Pause & Resume

Prerequisites

  • Azure Subscription.
  • Azure SQL Server and Azure Data Warehouse Database

Let’s start!

I am going to use *Azure RunBook* and *Scheduler*, so everything will be under the Azure environment. Let’s start now.

Create Automation Account

We need to create an Azure Automation account for RunBook; you could use your existing automation account as well. Please give a suitable name, choose a subscription, Resource Group, and a location. Please choose the location as per your geography. As I’m from Canada, I choose Central Canada and hit Create, as shown below.

Schedule Pause - Resume for your Azure Data Warehouse
Automation Account

You will see a screen like below.

Schedule Pause - Resume for your Azure Data Warehouse

Create Credentials

Now, it’s time to create the credentials of the Automation Account. You will find it under ‘Shared Resources’ as shown below.

Schedule Pause - Resume for your Azure Data Warehouse

Click on Credentials >> ‘Add New Credentials’. I prefer to use a service account with a non-expiring password. Otherwise, you need to change the password frequently.

Schedule Pause - Resume for your Azure Data Warehouse
Schedule Pause - Resume for your Azure Data Warehouse

Connections

Under Connection, you will find ‘AzureRunASconnection’ and information about the Azure environment like ApplicationID, TenantId, SubscriptionID etc.

Schedule Pause - Resume for your Azure Data Warehouse

Variables

I will use the below variables to prevent Hardcoded values:

  • ResourceGroupName
  • ServerName
  • DatabaseName

Please note that we have to use the EXACT name in the POWERSHELL, so please add a new variable for ResourceGroupName and add the name of the Resource Group that is used by your Azure Database.

Now, add Servername (name without .database.windows.net)

And finally, the DatabaseName (the name of your Azure DWH database).

Schedule Pause - Resume for your Azure Data Warehouse

Usually, here we make mistakes with the name. Please be extra aware of that so as to save your debugging time.

Create Runbooks

Now, go to runbook and click on ‘Create a new runbook’. Give your Runbook a suitable name and Runbook type as ‘PowerShell’.

Schedule Pause - Resume for your Azure Data Warehouse

And it will open the following window.

Schedule Pause - Resume for your Azure Data Warehouse

Paste the attached script and click the Test Pane.

Schedule Pause - Resume for your Azure Data Warehouse

The Test Pane will open like below.

Schedule Pause - Resume for your Azure Data Warehouse

Hit the Start button.

Schedule Pause - Resume for your Azure Data Warehouse

The PowerShell script is as per my need and I put in my comments to make it easily understandable. However, you could modify it as per your business need.

Thanks for your time, I hope it will be helpful for you guys!

Keep Learning!

My Journey as C# Corner MVP (Renewed July 2018 – Jun 2019)

July 1st is Canada Day and I’ve been fortunate to get the official notification earlier today that I’ve been re-awarded for the next year.

Woohoo! It’s a great way to start Canada Day!

2018 First Half of the Year MVPs Announced

C# Corner MVP Renewed

 

C# Corner MVP 2018

What it means to be a C# Corner MVP?

It is a recognition for contributors on the C# Corner platform – website, forums, chapter events and webinars. It is an appreciation of hard work and contributions by members who make C# Corner a successful community.

Why is it important to me?

C# Corner MVP was the first recognition/award I received since I started contributing to the technical community. This is my second time C# Corner MVP award. It gives a sense of fulfilment that your efforts/contributions are recognized and those don’t go unnoticed. Getting C# Corner MVP award mentally prepared me to take up the challenge to become Microsoft MVP.

Why I got C# Corner MVP award?

C# Corner MVP award is not limited to any technology or a specific domain. It is given to individuals for their contributions on C# Corner platform as well as to those who help spread the awareness about C# Corner by hosting public events either online or in-person.

What’s next?

This award is a boost for me. I will continue to contribute to the C# Corner by articles, videos and forums section with many more C# Corner chapter events and webinars.

 

Thanks..

Webinar : Learn Advanced Techniques with Azure Web App Service

Please join a new webinar on ‘Advanced Techniques with Azure Web App Service’ by

Roy Kim

On Sat, Jun 16, 2018 10:00 AM – 11:00 AM CDT

Please join my meeting from your computer, tablet or smartphone.
https://global.gotomeeting.com/join/729543085

“We will take a look at advanced techniques that can be applied to an Azure Web App to support various scenarios and requirements.

1.Application Gateway with Web Application Firewall

2.Azure SQL VNet Integration with (ASE v2)

3.Azure CDN

4.Auto Scale & Visual Studio Load Testing

We will go through demos and and key configuration in the Azure Portal.

BIO:Roy Kim

Roy Kim is a Microsoft MVP and who has been delivering enterprise solutions to many large organizations in a consulting role since 2003. Such as ASP .NET, SPA, SharePoint, SharePoint Online, Power BI and Office 365. He is an independent consultant and holds a BS in computer science from the University of Toronto. He is very open and passionate about discussing how technology can help organizations. You can check out his blog    https://roykim.ca/

 

Details:- 

Sat, Jun 16, 2018 10:00 AM – 11:00 AM CDT

Please join my meeting from your computer, tablet or smartphone.
https://global.gotomeeting.com/join/729543085

You can also dial in using your phone.
Canada: +1 (647) 497-9373

Access Code: 729-543-085

First GoToMeeting? Let’s do a quick system check: https://link.gotomeeting.com/system-check

Rocks ‘Saskatchewan IT Summit 2018’

SKITSUmiit

For the first time, I spoke at the Saskatchewan IT Summit 2018  in Saskatoon on May 1st. I’m very excited about bringing my World Farewell Tour to this Conference and rock the geeks.

I would like to ‘THANK YOU EVERYONE’ and I hope that you found the Conference as well my session ‘Using @MSPowerBI and @Azure DWH in K-12′ informative and worthwhile.

Sharing some of Pictures of the my talk/ Conference:

With Thanks, See you soon in next Conference..

 

-Deepak

Saskatchewan IT Summit 2018

SKITSUmiit

Excited and Happy to share that  I’m speaking at ‘Saskatchewan IT Summit 2018’  Conference on APRIL 30 – MAY 1 at Radisson Hotel Saskatoon -Canada.

I’m speaking on ‘Using PowerBI and Azure Data Warehouse in K-12’

Looking forward to hooked up with great speakers and talk about technologies.

My talk will be at Naples (TECH Stream) on Tuesday, May 1 at 1:15 – 2:15 P.M. 

Saskatchewan IT Summit 2018

Tech Talk Details

Register here

Here is abstract and Room Details :-

Session Abstract

Session Room Details

 

See You there…

Import your ‘On-Prem’ Data to Azure SQL Data Warehouse by SSIS

Introduction

We have already discussed many ways to import data in Azure DWH. Today I will discuss OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the most promising way to import data from different data sets/ types like SQL Server, Oracle, MySQL, Flat File, CSV, DB2 etc…

Prerequisite

  • Azure Subscription.
  • Azure SQL Server and an Azure Data Warehouse Database
  • SQL Server Data Tools with SSIS installed
  • Visual Studio 2015 – Visual Studio 2013

Let’s Start,

FYI~,  I’m using  VS 2015

Azure

Go to File>New project and select Integration Services Project,

Azure

Add ‘Data Flow Task’ as shown below,

Azure

Double click in Data Flow Task, it will open Data Flow pane

Azure

Attendance Code Source is Data Flow Components

Azure

Give details of your Server and Table after Double Clicking Attendance Code Source,

Azure

 

Azure

You could click on the table to Preview Data,

Azure

Here I’m only inserting the New Rows at Lookup Editor,

Azure

At Destination Editor, You need to give Azure Data Warehouse Name at connection manager, You could find it after Login at your Azure Portal and Clicking at Azure Data Warehouse as highlighted below,

Azure
Azure

 

Azure

After this, click F5 or Run and Your SSIS package will execute.

Please note GREEN Color reflect successful run.

Azure

Hope this will be helpful, until next time happy coding!!

Learn Chat bot application using Microsoft Bot Framework and Secure Cloud Azure Storage 

Learn Chat bot application using Microsoft Bot Framework and Secure Cloud Azure Storage“.

Sat, Mar 24, 2018 10:00 AM – 12:00 PM CDT  / 9 AM Saskatchewan Time. 

Where: Online

Price: Free of cost

Event URL: https://global.gotomeeting.com/join/776269525

Note: There are 100 seats only. First come first serve.

Details of Event

Learn Chat bot application using Microsoft Bot Framework – Rahat Yasir

• Why Chat Bot

• How to Develop

• Accelerated development

• Q&A

Unboxing Secure Cloud Azure Storage – Deepak Kaushik

• Brief Introduction to Azure Storage

• Scenarios / Working with Blob Storage

• Key Concepts / Architecture

• Q&A
Please join my meeting from your computer, tablet or smartphone. 
https://global.gotomeeting.com/join/776269525 

You can also dial in using your phone. 
Canada: +1 (647) 497-9373 

Access Code: 776-269-525