Microsoft Azure Learning

Azure Data engineer

This is a very cool ,level 100 course to understand the different tools and technologies in Azure data platform. recommend to all data lover to follow and star exploring.

Their role can add tremendous value to both business intelligence and data science projects. It is widely regarded that data wrangling can consume a substantial amount of time on such projects. Having the Data Engineer perform these tasks can accelerate the development of these projects and enable Data Scientists to focus on other areas of their work.

Both Database Administrators and Business Intelligence professionals can easily transition to a data engineer role by learning the new tools and technology used to process these large amounts of data effectively

https://docs.microsoft.com/en-us/learn/paths/azure-for-the-data-engineer/

Azure Data Bricks Deep dive

 

Azure Data Bricks – the fast, easy and collaborative Apache Spark-based analytics platform , do you need to learn ?? please register

 

Language Date Registration link
English November 28, 2018 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks
English November 29, 2018 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks
English December 13, 2018 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks
English February 14, 2019 Technical Deep Dive on Cloud Scale Analytics: Azure Data Bricks

 

 

AI Capabilities for Power BI

There is a reason why in just few years Power BI has managed to become a market leader in Business Analytics and Business Intelligence.
The platform carries with itself the classic Microsoft attribute “Made for the User” from design to the actual platform itself.

happy to announces that new AI capabilities integrated with PowerBI , please refer the below and sign up for the preview early

https://powerbi.microsoft.com/en-us/blog/power-bi-announces-new-ai-capabilities/

Sign up for the preview here.

Power BI & Azure ML Better Together

also this a nice article on how to use AML with Power BI to deliver advance analytics to end users

https://powerbi.microsoft.com/en-us/blog/power-bi-azure-ml/

SQLSaturday 2018

It was a great opportunity to deliver session at SQLSaturday 2018 in Sri Lanka to many talented people. Also saw the momentum of developers trying to learn new things specially on Azure SQL, DevOps and AI area and truly appreciate it.

Hope they gained a good knowledge with all experts presented

.

Would like to specially thanks to organizer of SQLSaturday 2018 in Sri Lanka to share the knowledge with developers.

My presentation can download here

http://www.sqlsaturday.com/SessionDownload.aspx?suid=21379

Azure Hybrid Benefit for Azure SQL

Maximize your current Software Assurance investment by using your existing SQL Server licenses to save up to 55 percent on vCore-based SQL Database options, SQL Server in Azure Virtual Machines and SQL Server Integration Services.

The calculator will give the option to select Azure SQL instance type ( Mi,Elastic pool or single database)  with vCore based model. see how significant saving you would get with this offer.

https://azure.microsoft.com/en-us/pricing/hybrid-benefit/

Note: same offer is given for Windows servers also.

Azure SQL Managed Instance

Azure SQL Managed Instance is the best suited for your on-prem ,complex SQL deployment move to Azure. Which has  many features and will be GA very soon.

Quick start guides allow you to provision Azure SQL Instances ( MI,Single or Elastic pool)  with many options like Azure Portal,PowereShell or CLI, below URL give the starting guide

https://docs.microsoft.com/en-us/azure/sql-database/#5-minute-quickstarts

 Azure SQL MI starting guide

Creating managed instances on Azure docs: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-get-started.

In this approach you can:

  1. Use Azure Deploy button to create a valid Azure VNET, subnet, UDR.
  2. Use Azure portal to configure Managed Instance
  3. Use Azure Deploy button to create VM with installed SSMS/SQL Operation studio

Also, in https://docs.microsoft.com/en-us/azure/sql-database/#5-minute-quickstarts we have link to ARM Deployment link that can be used to create full environment, managed instance and VM using single deploy button.

Please try it if you need to configure and create managed instance.

SQL DBA Tools

Dear All,

Take a look at and share with customers/friends who need scripts/migration plans etc….. dbatools is a free PowerShell module with over 300 SQL Server administration, best practice and migration commands included. https://dbatools.io/ ,https://dbatools.io/functions/ and https://dbatools.io/introducing-dbachecks/ ( with PowerBI dashboard )

command index

 

Also refer the some good blog found https://www.sqlskills.com/

 

Power BI Desktop August 2018 Feature Summary

Power BI Report Server – For On-Premise BI Solutions

Hi All,

Power BI Report Server is now part of Power BI Premium. Power BI Premium, with Power BI Report Server will get you covered with a complete solution. Power BI Premium provides dedicated capacity in the cloud and enhanced performance – without requiring per-user licenses for those consuming reports. And, it includes Power BI Report Server for on-premises reporting too.

Try this link to get started with Power BI Report Server (Download FREE trial). You just have to fill small form and that will kick the download. And good thing is – you can use any valid email address of yours for this download to work.

What Power BI Report Server comprises of: Power BI Report Server is an on-premises report server with a web portal in which you display and manage reports and KPIs, along with the tools to create Power BI reports, paginated reports, mobile reports, and KPIs.

 

See the comparison of Power BI Report Server with SQL Server Reporting Services (SSRS)
https://docs.microsoft.com/en-us/power-bi/report-server/get-started#comparing-power-bi-report-server

See the comparison of Power BI Report Server with Power BI Service (i.e. www.powerbi.com)
https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

Don’t forget to see the licensing terms
https://docs.microsoft.com/en-us/power-bi/report-server/get-started#licensing-power-bi-report-server

Get yourself familiarized with features of Power BI Report Server
https://docs.microsoft.com/en-us/power-bi/report-server/get-started

If you still want to get a complete glance of it then watch a video presentation from Microsoft Ignite session here.