Use PowerBI modelling MCP Server to create AI agents with semantic modeling capabilities

Create a personalized learning plan with AI in Microsoft Learn documentation

37. How to validate whether a number is even or odd using an ADF pipeline?

FASTAPI in Python | Create REST API using FASTAPI framework in python | SWAGGER UI

Execute and monitor ADF pipeline via Python Code | Python | ADF | SDK

Received star award for creating Ripple effect

Podcast on AI with Microsoft leader | Rapid fire | Digital Disruption is a real thing

3. Word Frequency Counter | Python

2. Create an Expense tracker using Python

1. Organizes files in a folder based on their extensions | Python

23. How to merge source and target table dynamically in sql server

22. How to Merge data in SourceTable and TargetTable using Merge statement n SQL Server

21. How to unpivot the table in sql by dynamically taking the source columnnames

20. How to Unpivot table in SQL

19. How to Auto-Create Pivot Table Based on column Names Using Dynamic SQL

18. How to pivot the table in SQL by dynamically taking the columnnames

17. How to pivot table in SQL

16. How to aggregate rows into a single string using STRING_AGG() in SQL Server

15. How to create dynamic query to Search Across Multiple Columns in SQL table

14. How to filter records dynamically based on user input | Dynamic SQL | T SQL

13. How to calculate employee bonus based on performance ratings using Case statement in SQL

12. How to generate Employee Salary Payment Dates using loop in Stored proc

11. How to Update Data in SQL table using Stored Procedure

10. How to Update Table Data Dynamically Using Variables in SQL Server

9. How to UPDATE the column by REPLACING part of the string in SQL

8. How to Update the column value based on certain condition in SQL

7. How to delete duplicate records using Common Table Expression (CTE) in SQL server

6. How to identify duplicate records using NOT IN operator in SQL

5. How to detect the missing data using left outer join in SQL server

4. How to identify customers who have never made a transaction using sql query

3. How to identify duplicate records in SQL Table

2. How to download and restore AdventureWorks sample DB in SSMS

1. How to install SQL server and SSMS (SQL server management studio) in local

2. How to Get the number of transactions and sum of transactions by each customer

1. How to Retrieve the Most Recent Records in SQL

36. How to dynamically copy only matching files from ADLS to SQL

35. How to generate various formats of year, month, date and Hr using formatdatetime function in ADF

5. Narrow VS Wide Transformation in RDD | Pyspark | Apache Spark

4. RDD operations | Transformations and actions | Pyspark

3. RDD partitioning | Repartition() vs Coalesce

3. Use private endpoints to connect securely to Azure SQL Server

2. Connect to SQL Server through SQL Server Authentication

1. Create Azure SQL database with Microsoft Entra ID authentication

38. How to find the position of nth occurrence of a character in a string using mapping dataflow

34. How to Format datetime to a 12-hours clock and 24-hours clock

8. Found more columns than expected | Common Errors in ADF #adf

2. Read Multiple JSONs from ADLS and load into SQL using Logic apps

1. Read JSON data from ADLS and insert into SQL table using Logic apps

2. Resilient Distributed Dataset (RDD) in Pyspark

1. Introduction to Pyspark

37. How to concatenate data of multiple rows after grouping using mapping dataflow #adf #dataflow

33. How to Break Out of ForEach Loop on Activity Failure #adf

7. Self-Referencing Variable is not allowed #adf #datafactory

6. For Each activity do not run in parallel #adf #datafactory

How to pause all the dedicated SQL pools in subscription after a period of inactivity

5. Execute Pipeline activity fails to pass a parameter of array type to child pipeline

4. The specified SQL Query is not valid. The query doesn't return any data.

3. The expression cannot be evaluated because property doesn't exist.

2. Bad Request error in ADF | Message Null | Common errors in ADF

1. Failed to Delete Linked Service | Common Errors in ADF