sqlmadmin

Home/SQLMaestros Admin

About SQLMaestros Admin

This author has not yet filled in any details.
So far SQLMaestros Admin has created 69 blog entries.

Hands-On-Lab: Transform Data Using Azure Data Factory

Hello Friends, Here is another popular lab from Hands-On-Lab library: Transform Data Using Azure Data Factory. Azure Data Factory is a cloud-based data integration service that automates the movement and transformation of data. We can create data integration solutions using the Data Factory service that can read data from various data stores, transform/process the data, [...]

Hands-On-Lab: Move Data Between On-Premise and Cloud using Azure Data Factory

Hello Friends, Here is another popular lab from Hands-On-Lab library: Move Data Between On-Premise and Cloud using Azure Data Factory. Azure Data Factory is a cloud-based data integration service that automates the movement and transformation of data. We can create data integration solutions using the Data Factory service that can read data from various data [...]

LIVE Training by Amit Bansal | This Thursday | Bulletin #9

SQLM Bulletin #9. September 15, 2020. Spotlight: New Training Classes Announced @ DPS 2020. Click Here Hi There, Here is the SQLMaestros Bulletin of 15 September, 2020. Highlights of Today’s Bulletin This Thursday, LIVE Training on Implementing SQL Server Extended Events. Join Us Virtual Symposiums are announced on Advanced Analytics, AI & SQL Performance Tuning. [...]

Hands-On-Lab: Securing Azure SQL Databases

Hello Friends, Here is another popular lab from Hands-On-Lab library: Securing Azure SQL Databases. Microsoft Azure SQL Database is a DBaaS (Database as a service) or PaaS (Platform as a Service) offering from Microsoft. Azure SQL Database is largely compatible with on premise SQL Server and supports most of the SQL Server features. Azure SQL [...]

Hands-On-Lab: Migrating On-Premise SQL Server Database To Azure SQL Database

Hello Friends, Here is another popular lab from Hands-On-Lab library: Migrating On-Premise SQL Server Database To Azure SQL Database. Microsoft Azure SQL Database is a DBaaS (Database as a service) or PaaS (Platform as a Service) offering from Microsoft. Azure SQL Database is largely compatible with on premise SQL Server and supports most of the [...]

Hands-On-Lab: Azure SQL Database Backup and Restore

Hello Friends, Here is another popular lab from Hands-On-Lab library: Azure SQL Database Backup and Restore. Azure Microsoft Azure SQL Database is a DBaaS (Database as a service) or PaaS (Platform as a Service) offering from Microsoft. Azure SQL Database is largely compatible with on premise SQL Server and supports most of the SQL Server [...]

Today, LIVE Training by Amit Bansal | Bulletin #8

SQLM Bulletin #8. September 10, 2020. Spotlight: New Training Classes Announced @ DPS 2020. Click Here Hi There, Here is the SQLMaestros Bulletin of 10 September, 2020. We kick-started FREE LIVE Training last Thursday and got tremendous response. Today, Thursday, we are LIVE again. Details below. Highlights of Today’s Bulletin LIVE Training today on Implementing Extended Events [...]

Hands-On-Lab: Load Data into SQL Data Warehouse with Data Factory

Hello Friends, Here is another popular lab from Hands-On-Lab library: Load Data into SQL Data Warehouse with Data Factory. Azure Data Factory is a cloud-based data integration service that automates the movement and transformation of data. In this lab we will load data from On-Premises SQL Server database to Azure Data Warehouse using Azure Data [...]

Hands-On-Lab: Create and Manage Azure SQL Data Warehouse

Hello Friends, Here is another popular lab from Hands-On-Lab library: Create and Manage Azure SQL Data Warehouse. Azure SQL Data Warehouse is a cloud based, scale-out, relational database capable of processing massive volumes of data. SQL Data Warehouse combines the SQL Server relational database with Azure cloud scale-out capabilities. It uses T-SQL and other Microsoft [...]

Extended Events Tips & Tricks (GUI)

In this video blog post, you will see a couple of tips and tricks related to SQL Server Extended Events Graphical User Interface. You will learn things like, Filtering, Grouping, Aggregation, Bookmarks, Saving/Opening Settings, Exporting XEvents data to a table, and more. Overall, the idea is to show you how you can be more productive [...]

Hands-On-Lab:Predicting Diamond Rates with Azure ML Studio

Hello Friends, Here is another popular lab from Hands-On-Lab library: Predicting Diamond Rates with Azure ML Studio. In this lab, we’ll learn to use linear regression in Azure Machine Learning studio to predict the diamond rates. There is a diamond rates dataset with rates assigned to each carat weight. We’ll first plot a linear regression [...]

Hands-On-Lab: Implementing Linear Regression with Azure Machine Learning Studio

Hello Friends, Here is another popular lab from Hands-On-Lab library: Implementing Linear Regression with Azure Machine Learning Studio. Linear Regression is a model for predicting values based on independent variable. Linear regression is a common type of statistical method that has several applications in business. A regression analysis involves plotting a line over the set [...]

Hands-On-Lab: Web and Social Analytics Dashboard in Power BI

Hello Friends, Here is another popular lab from Hands-On-Lab library: Web and Social Analytics Dashboard in Power BI. Online marketing is perhaps the most important channel for the modern marketer. This marketing dashboard examines the correlation between website performance and social performance. This is an important activity, as too often social marketers focus on their [...]

Hands-On-Lab: Streaming Data From SQL Server To Power BI

Hello Friends, Here is another popular lab from Hands-On-Lab library: Streaming Data From SQL Server To Power BI. In this lab, we’ll learn to implement real time streaming dashboards in Power BI. Real time streaming in Power BI can be done two ways, using the Power BI REST API or Pubnub. In this lab, we’ll [...]

Bulletin #7 | Free LIVE Training by Amit Bansal

SQLM Bulletin #7. September 1, 2020. Spotlight: First List of Breakout sessions for DPS2020 Published. Click Here. Hi There, Here is the SQLMaestros Bulletin of 1 September, 2020. We are kick-starting a new initiative – FREE LIVE Training. Details below. LIVE Training Implementing Extended Events by Amit Bansal. Hosted by SQLMaestros. Click Here. LIVE Geek [...]

Hands-On-Lab: Shape and Transform Data in Power BI

Hello Friends, Here is another popular lab from Hands-On-Lab library: Shape and Transform Data in Power BI. Using Power BI Desktop, we can import data and change appearance of data to any shape. In this lab, we learn to shape and transform the data in Power BI. In this lab, we will learn to Rename [...]

Hands-On-Lab: Sales Dashboard in Power BI

Hello Friends, Here is another popular lab from Hands-On-Lab library: Sales Dashboard in Power BI. In this lab, we’ll learn to prepare a sales dashboard for SQLMaestros HOLs sales. In the first exercise, we will learn to create total sales by cities visualization. In the second, third and fourth exercise we’ll analyze the total downloads [...]

Hands-On-Lab: Power BI Administration

Hello Friends, Here is another popular lab from Hands-On-Lab library: Power BI Administration. Administration does the important role in organizations for auditing, security and for various other purposes. In this lab, we’ll learn to administer the Power BI in order to perform admin operations, implement Row level security and Manage Data Capacity in Power BI [...]