SQL Server Blog

Home/SQL Server Blog/

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 [...]

Extended Events Tips & Tricks

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin. SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

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 [...]

Hands-On-Lab: Managing Relationships in Power BI

Hello Friends, Here is another popular lab from Hands-On-Lab library: Managing Relationships in Power BI. To create logical connections between multiple sources for better analysis, we create relationships between the sources. The data from different data sources can then be joined for further analysis. This process of creating relationships comes under data modelling. In this [...]

Hands-On-Lab: Financial Dashboard in Power BI

Hello Friends, Here is another popular lab from Hands-On-Lab library: Financial Dashboard in Power BI. The financial analysis is important for every business in order to work efficiently. It would be even better if all the financial analysis of the business comes up in single dashboard. Power BI empowers us to create such financial dashboards [...]

Bulletin #6: Aug 25, 2020

Spotlight: First List of Breakout sessions for DPS2020 Published. Click Here. Prices increase on Aug 28. Book Today. Hi There, Here is the SQLMaestros Bulletin of 25 August, 2020. SQL Video Tutorials Index Tuning – Index Column Sort Order - Click Here. Query Tuning – Implicit Conversion – Part 1 – Click Here. Query Tuning [...]

Bulletin #6: Aug 25, 2020

Spotlight: First List of Breakout sessions for DPS2020 Published. Click Here. Prices increase on Aug 28. Book Today. Hi There, Here is the SQLMaestros Bulletin of 25 August, 2020. SQL Video Tutorials Index Tuning – Index Column Sort Order - Click Here. Query Tuning – Implicit Conversion – Part 1 – Click Here. Query Tuning [...]

Hands-On-Lab: Task Group Sequence and For Loop Containers in SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Task Group Sequence and For Loop Containers in SSIS. SSIS Containers are used for different purposes; some are used to group tasks together like Sequence Container or Group. We can also use Sequence Container to run the child tasks either sequentially or in parallel. Other [...]

Hands-On-Lab: SSIS Foreach Loop Container

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Foreach Loop Container. SSIS Containers are used for different purposes; some are used to group tasks together like Sequence Container. Other Containers like Foreach Loop Container is used to run a loop for each member of a specified enumerator. This lab is divided into [...]

Hands-On-Lab: SSIS Data Loading – Part 1

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Loading – Part 1. Extracting and loading data is one of the first step in an ETL process. SSIS allows to extract and load data from many different data sources. However, in this lab, we’ll learn to extract data from Excel and XML [...]

Hands-On-Lab: SSIS Data Flow Transformations – Part 2

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Flow Transformations – Part 2. The Fuzzy lookup transformation is used to perform data cleansing such as standardizing data, correcting data or finding missing values. The Fuzzy grouping transformation is used to find duplicate records. In the first exercise, we’ll use Fuzzy lookup [...]

Hands-On-Lab: SSIS Data Flow Transformations – Part 1

Hello Friends, Here is another popular lab from Hands-On-Lab library: SSIS Data Flow Transformations – Part 1. Data Flow Task is used to move data from a source to a destination while applying various transformations on the data being moved as and when required. The lab talks about available sources, transformations and destinations available in [...]