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

Hands-On-Lab: Slowly Changing Dimensions in SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Slowly Changing Dimensions in SSIS. A dimension is considered to be a Slowly Changing Dimensions in SSIS when the attributes change over a period of time. The SCD are categorized based on the methodology of historical records maintenance. Slowly Changing Dimensions in SSIS transformation helps [...]

Hands-On-Lab: Implementing Incremental Data Load and Inner Join in SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Implementing Incremental Data Load and Inner Join in SSIS. In this Lab, we’ll learn about two of the most used transformation in SSIS, Lookup and Merge Join Transformations. In the first exercise, we’ll learn to implement incremental data load using Lookup Transformation. Incremental data load [...]

Hands-On-Lab: Error and Event Handling in SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Error and Event Handling in SSIS. In this lab, we’ll learn to effectively use precedence constraints, implement error and event handling and logging. Precedence Constraints are the arrows used to connect two or more tasks in Control Flow and Data Flow. Precedence constraints govern the [...]

Hands-On-Lab: Calling Web Service From SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Calling Web Service From SSIS. In this lab, we’ll learn how to call a web service from SSIS. In the first exercise, we will learn how to use SSIS inbuilt component Web Service Task to call the Web Service and get the data in XML [...]

SQLMaestros Bulletin: August 12, 2020

Spotlight: Learn about DPS 2020 Training Classes. Click Here. Hi There, Here is the SQLMaestros Bulletin of 12 August, 2020. SQL Video Tutorials Index Tuning – Page Splits & Fragmentation - Click Here. How To Enable Global Trace Flags In SQL Server – Click Here. All videos are available on SQLMaestros.com. Hands-On-Labs Advanced Data Cleansing [...]

Hands-On-Lab: Advanced Data Cleansing In SSIS

Hello Friends, Here is another popular lab from Hands-On-Lab library: Advanced Data Cleansing In SSIS. In this lab, we’ll learn to implement DQL Cleansing transformation and the DQS knowledge base to clean dirty data. DQS Cleansing transformation helps in cleansing the dirty data. It takes the knowledge base created in the Data Quality client with [...]

Hands-On-Lab: XML and Xquery in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: XML and Xquery in SQL Server. Extensive markup language(XML) is a language used to encode the documents in such a way that both Humans and Machines can read the data. XML was designed to store and transport the data. XQuery is a query used to [...]

Hands-On-Lab: Working with NULL in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Working with NULL in SQL Server. NULL is not a value, it only means that a value was not provided when the row was created. Special attentions need to be taken into account when dealing with nulls in SQL Server. One needs to remind that [...]

Hands-On-Lab: Working with Date and Time Datatypes in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Working with Date and Time Datatypes in SQL Server. This lab focusses on date and time datatypes and functions available in SQL Server and how to effectively use the functions to solve real-world problems. The lab is divided into four exercise. In the first exercise, [...]

Hands-On-Lab: Views in SQL Server

Hello Friends, Here is another popular lab from Hands-On-Lab library: Views in SQL Server. In Transact-SQL (T-SQL) a view allows us to create a virtual representation of table whose contents are defined by the query. The query that defines the view can be joined from one or more tables. Once a view is created we [...]

SQLMaestros Bulletin: August 4, 2020

Follow SQLMaestros on Twitter & LinkedIn Hi There, SQL Video Tutorials Database IO Cost – Read & Writes - Click Here. Tracking Page Splits using Extended Events – Click Here. All videos are available on SQLMaestros.com. Hands-On-Labs User Defined Functions - Click Here. TOP & APPLY Operators in SQL Server – Click Here. All labs [...]