SQL Resources

Related resources for SQL

Database Dictionary (1-2-1) --- Using Dynamic SQL Script
George
2d
Event-Driven CQRS with C# 14 and the SQL Outbox Pattern
John Godel
3d
.NET Aspire Integrations (SQL Server Integration in Aspire Applications)
Nitin Pandit
4d
Real-Time Data Retrieval from APIs Using SSIS
Aradhana Tripathi
4d
Microsoft Fabric Warehouse Integration in VS Code for Devs
Abiola David
5d
Advanced ETL from OLTP Databases to a Data Warehouse with C# 14
John Godel
6d
What’s New in Grafana 12.0
Sarthak Varshney
1w
Vibe Coding with AI: Using Prompt Engineering to Build a Full C# Database Solution
John Godel
1w
Build & Deploy Azure Function Using C# and Integration with Azure SQL
Sagar Rane
1w
NoSQL vs. SQL: Which One to Use
Tural Suleymani
2w
Search and Removal of Item from Local List in MAUI [GamesCatalog] 16
Emanuel Martins
2w
Listing Information from the Local DB in MAUI .NET 9 [GamesCatalog] - Part 15
Emanuel Martins
2w
Advanced C# Database Tricks for Power Users
John Godel
2w
Understanding Change Data Capture (CDC) and Its Types
Jay Krishna Reddy
2w
Connect to Fabric SQL Database in Power BI Desktop
Abiola David
2w
Artificial Intelligence and Education: Shaping the Future of Learning
John Godel
2w
Leveraging Databases with .NET 9 in Financial Applications
John Godel
3w
SQL Server CLR Integration and SSIS Automation with C#
John Godel
3w
Advanced Database Programming with C# 14 and Microsoft SQL Server
John Godel
3w
Order of Execution in LINQ Queries
Vishal Yelve
3w
Execution Process of SQL Queries vs Stored Procedures
Maria Joshua Roy
3w
Updating an Object in the Local Database in MAUI .NET 9 [GamesCatalog] - Part 11
Emanuel Martins
3w
Adding Objects to a Local Database in MAUI .NET 9 [GamesCatalog] - Part 10
Emanuel Martins
Apr 16
.NET 8 - System.Linq.Dynamic.Core – using SQL LIKE
Mark Pelf
Apr 11
Create Foreign Keys Dynamically in SQL Server Database
Mukesh Sagar
Apr 10
Setting Up and Using a Local SQLite Database in MAUI .NET 9 [GamesCatalog] - Part 9
Emanuel Martins
Apr 03
Make Predictions using AI Forecast Function in Databricks
Abiola David
Apr 02
Azure Synapse Analytics Serverless and Dedicated SQL Pools
Pavan Nalluri
Apr 02
Mitigate OWASP A03:2021 – Injection Web Security Tips
Ayush Gupta
Apr 01
Understanding Numeric Functions in SQL
Dashrath Hapani
Mar 27
Understanding Conversion Functions in SQL
Dashrath Hapani
Mar 27
Creating DataFrames in PySpark Using Fabric Notebook
Abiola David
Mar 27
Explanation of Date and Time Functions in SQL
Dashrath Hapani
Mar 26
Understanding System-Versioned Tables in SQL
Dashrath Hapani
Mar 25
Prevent Accidental Data Deletion with Two Simple Strategies
Mohammad Hasan Hosseini
Mar 25
Mastering SQL String Functions
Dashrath Hapani
Mar 25
Automating SCD Type 4 in Azure SQL Database with Azure Data Factory
Tharunkumar Magudeeswaran
Mar 24
Understanding Parameter Sniffing in SQL Server
Siddhesh Chavan
Mar 24
Databricks FileStore to SQL Warehouse [Automation]
Abiola David
Mar 21
Understanding Aggregate Functions in SQL
Dashrath Hapani
Mar 21
Understanding Scalar Functions in SQL
Dashrath Hapani
Mar 21
SQL Tag Library in Java Server Page
Ashish Bhatnagar
Mar 21
Understanding SQL Execution Plans
Dashrath Hapani
Mar 20
Understanding SQL CTE (Common Table Expression)
Dashrath Hapani
Mar 19
Explicit Loading in ASP.NET Core Web API
Sardar Mudassar Ali Khan
Mar 18
Implementing SCD Type 4 in Azure SQL Database: A Step-by-Step Guide
Tharunkumar Magudeeswaran
Mar 17
Real-Time Streaming Data in Databricks [End to End Project]
Abiola David
Mar 06
Setting Up Microsoft Entra Service Principal for Azure RBAC and Connecting to Fabric SQL Database
Tharunkumar Magudeeswaran
Mar 03
Automate Email Sending Using SSIS Script Task
Aradhana Tripathi
Feb 28
Eliminating Unnecessary DELETE Operations
Monica Rathbun
Feb 28
Azure SQL Database: Scalable & Secure Cloud Solution
Muhammad Imran Ansari
Feb 26
Boost SQL Server Performance with Memory-Optimized Tables
Jayraj Chhaya
Feb 25
Getting Started with EF Core: Part 1
Anup Hosur
Feb 24
Entity Framework Core 9: Ultimate Performance Tuning & Best Practice
Rijwan Ansari
Feb 21
How to Encrypt the SQLite DB File using AES
Sangeetha S
Feb 17
Power of Dapper in .Net Core
Subarta Ray
Feb 16
Explaining Aggregate Functions in SQL
Morteza Mousavi
Feb 14
Getting Started with dbt (Data Build Tool) in Microsoft Fabric
Tharunkumar Magudeeswaran
Feb 12
Databricks Unity Catalog: Mastering Metastore and Namespace
Wilson Mok
Feb 10
Explain SSIS Designer for Newbies
Aradhana Tripathi
Feb 07
Delta Live Table Pipeline in Databricks [SQL]
Abiola David
Feb 05
Reduce NULL Storage in SQL Server with Sparse Columns
Dashrath Hapani
Feb 05
A Better .NET SQL Builder: KnightMoves.SqlObjects
Ricardo Pena
Feb 04
Set up dbt for Fabric SQL Database
Nandan Hegde
Feb 04
Data Build Tool (DBT) - Kickstart
Tharunkumar Magudeeswaran
Feb 03
Unlocking the Power of SQL for ETL
Aradhana Tripathi
Feb 03
Prepare and Execute Cross Warehouse Queries in Fabric using T-SQL Notebook
Abiola David
Feb 03
Installing and Using GitHub Copilot in Azure Data Studio
Satheesh Elumalai
Feb 02
ETL Pipeline using Microsoft SQL Server Integration Services
Aradhana Tripathi
Jan 31
JSON Data with Python in SQLite Database
Sangeetha S
Jan 29
Exploring Snowflake SQL New Capabilities Using SELECT Statement
Kapil Singh Kumawat
Jan 29
QUALIFY Databricks SQL Filtering Window Functions Results
Abiola David
Jan 27
How to Fix Recovery Pending State in MS SQL Server Database
Amit Mohanty
Jan 24
Understanding Precision in SQL Server Calculations
Jayeshkumar Sahani
Jan 24
Modern ADO .Net with SQLite in VB and C#
Sangeetha S
Jan 22
Create, Insert and Query Nested Data Structures in Databricks SQL
Abiola David
Jan 22
How to Create A Pivot Table in PostgreSQL
Suraj Vishwakarma
Jan 22
Differences Between TRUNCATE and DELETE in SQL Server
Tuhin Paul
Jan 22
How to Implement Search Function in PowerApps
Shiv Sharma
Jan 22
Fabric Data Factory: On-Prems Folder to Fabric SQL Database
Abiola David
Jan 20
SQL Server – Query Performance – Database Maintenance can Help
Mark Pelf
Jan 15
Local and Global Temporary Tables in SQL Server
Dashrath Hapani
Jan 13
Transaction in SQL Server
Dashrath Hapani
Jan 13
How to Dockerize Your Django App
Sarthak Varshney
Jan 11
Azure SQL Database - Configure Job using Elastic Agents
Praveen Sreeram
Jan 07
Create Database-Scoped Users for Microsoft Entra Security Groups
Praveen Sreeram
Jan 06
Automate Data Integration from ADLS Gen2 to Snowflake using TASKS
Abiola David
Jan 06
Advanced 4-Level CTEs using Fabric T-SQL Notebook
Abiola David
Jan 02
How to Set Up DynamoDB in AWS?
Babita
Jan 02
A Fix to SQL Server Error 18456 - Login Failed
George
Dec 31
AI_GEN Function in Databricks SQL
Abiola David
Dec 31
Using Derived Column Task in SQL Server Integration Services
Aradhana Tripathi
Dec 30
How to Set Up and Use AWS RDS for Beginners
Raveena Attri
Dec 27
Hello World! In 20 Different Programming Languages
Onkar Sharma
Dec 24
Conditional Split in SQL Services Integration Services (SSIS)
Aradhana Tripathi
Dec 23
Create FTP Task in SQL Server Integration Services
Aradhana Tripathi
Dec 19
SQL Exists: Usage, Syntax, and Examples
Jaimin Shethiya
Dec 19
Unlocking Faster INSERT Operations in SQL Server with TABLOCK
Naveen Kumar
Dec 17
SQL Server ACID Properties
Amit Mohanty
Dec 16
Bulk Insert Example with Two SQLite DB Files using .NET
Sangeetha S
Dec 13

Topics

Database Dictionary (1-2-1) --- Using Dynamic SQL Script

Event-Driven CQRS with C# 14 and the SQL Outbox Pattern

.NET Aspire Integrations (SQL Server Integration in Aspire Applications)

Real-Time Data Retrieval from APIs Using SSIS

Microsoft Fabric Warehouse Integration in VS Code for Devs

Advanced ETL from OLTP Databases to a Data Warehouse with C# 14

What’s New in Grafana 12.0

Vibe Coding with AI: Using Prompt Engineering to Build a Full C# Database Solution

Build & Deploy Azure Function Using C# and Integration with Azure SQL

NoSQL vs. SQL: Which One to Use

Search and Removal of Item from Local List in MAUI [GamesCatalog] 16

Listing Information from the Local DB in MAUI .NET 9 [GamesCatalog] - Part 15

Advanced C# Database Tricks for Power Users

Understanding Change Data Capture (CDC) and Its Types

Connect to Fabric SQL Database in Power BI Desktop

Artificial Intelligence and Education: Shaping the Future of Learning

Leveraging Databases with .NET 9 in Financial Applications

SQL Server CLR Integration and SSIS Automation with C#

Advanced Database Programming with C# 14 and Microsoft SQL Server

Order of Execution in LINQ Queries

Execution Process of SQL Queries vs Stored Procedures

Updating an Object in the Local Database in MAUI .NET 9 [GamesCatalog] - Part 11

Adding Objects to a Local Database in MAUI .NET 9 [GamesCatalog] - Part 10

.NET 8 - System.Linq.Dynamic.Core – using SQL LIKE

Create Foreign Keys Dynamically in SQL Server Database

Setting Up and Using a Local SQLite Database in MAUI .NET 9 [GamesCatalog] - Part 9

Make Predictions using AI Forecast Function in Databricks

Azure Synapse Analytics Serverless and Dedicated SQL Pools

Mitigate OWASP A03:2021 – Injection Web Security Tips

Understanding Numeric Functions in SQL

Understanding Conversion Functions in SQL

Creating DataFrames in PySpark Using Fabric Notebook

Explanation of Date and Time Functions in SQL

Understanding System-Versioned Tables in SQL

Prevent Accidental Data Deletion with Two Simple Strategies

Mastering SQL String Functions

Automating SCD Type 4 in Azure SQL Database with Azure Data Factory

Understanding Parameter Sniffing in SQL Server

Databricks FileStore to SQL Warehouse [Automation]

Understanding Aggregate Functions in SQL

Understanding Scalar Functions in SQL

SQL Tag Library in Java Server Page

Understanding SQL Execution Plans

Understanding SQL CTE (Common Table Expression)

Explicit Loading in ASP.NET Core Web API

Implementing SCD Type 4 in Azure SQL Database: A Step-by-Step Guide

Real-Time Streaming Data in Databricks [End to End Project]

Setting Up Microsoft Entra Service Principal for Azure RBAC and Connecting to Fabric SQL Database

Automate Email Sending Using SSIS Script Task

Eliminating Unnecessary DELETE Operations

Azure SQL Database: Scalable & Secure Cloud Solution

Boost SQL Server Performance with Memory-Optimized Tables

Getting Started with EF Core: Part 1

Entity Framework Core 9: Ultimate Performance Tuning & Best Practice

How to Encrypt the SQLite DB File using AES

Power of Dapper in .Net Core

Explaining Aggregate Functions in SQL

Getting Started with dbt (Data Build Tool) in Microsoft Fabric

Databricks Unity Catalog: Mastering Metastore and Namespace

Explain SSIS Designer for Newbies

Delta Live Table Pipeline in Databricks [SQL]

Reduce NULL Storage in SQL Server with Sparse Columns

A Better .NET SQL Builder: KnightMoves.SqlObjects

Set up dbt for Fabric SQL Database

Data Build Tool (DBT) - Kickstart

Unlocking the Power of SQL for ETL

Prepare and Execute Cross Warehouse Queries in Fabric using T-SQL Notebook

Installing and Using GitHub Copilot in Azure Data Studio

ETL Pipeline using Microsoft SQL Server Integration Services

JSON Data with Python in SQLite Database

Exploring Snowflake SQL New Capabilities Using SELECT Statement

QUALIFY Databricks SQL Filtering Window Functions Results

How to Fix Recovery Pending State in MS SQL Server Database

Understanding Precision in SQL Server Calculations

Modern ADO .Net with SQLite in VB and C#

Create, Insert and Query Nested Data Structures in Databricks SQL

How to Create A Pivot Table in PostgreSQL

Differences Between TRUNCATE and DELETE in SQL Server

How to Implement Search Function in PowerApps