QL Resources

Share

Related resources for QL

QUALIFY Databricks SQL Filtering Window Functions Results1/27/2025 4:29:53 AM. In this Databricks video, I covered how to use the Databricks SQL QUALIFY with window functions in SELECT list and in QUALIFY clause.
How to Fix Recovery Pending State in MS SQL Server Database1/24/2025 11:32:57 AM. Learn about the causes of SQL Server's "Recovery Pending" state, methods to resolve it, and preventive measures. Explore manual fixes, recovery tools, and best practices to ensure databa
Understanding Precision in SQL Server Calculations1/24/2025 5:28:27 AM. Learn why SQL Server calculations can produce different results depending on the approach used. Discover how single-step and multiple-step calculations handle precision and rounding, and how to achiev
Modern ADO .Net with SQLite in VB and C#1/22/2025 9:55:43 AM. This article demonstrates how to connect SQLite with ADO .NET in C# and VB, showcasing database operations such as creating tables, inserting records, and reading data. It uses the Microsoft.Data.Sqli
Create, Insert and Query Nested Data Structures in Databricks SQL1/22/2025 8:59:37 AM. In Databricks SQL, nested data structures like arrays and structs allow you to elegantly manage and query complex, hierarchical data with ease, transforming intricate datasets into insightful, actiona
How to Create A Pivot Table in PostgreSQL1/22/2025 8:22:08 AM. This article covers using crosstab functions, grouping, and SQL queries to pivot rows into columns, making it easier to analyze complex datasets. Perfect for data analysis and reporting tasks in Postg
Differences Between TRUNCATE and DELETE in SQL Server1/22/2025 8:14:06 AM. Learn the key differences between TRUNCATE and DELETE in SQL Server, two commands used to remove data from tables. Understand their syntax, performance impact, transaction logging, and use cases.
How to Implement Search Function in PowerApps1/22/2025 8:09:51 AM. Learn how to implement a dynamic search function in Power Apps to filter data from sources like SharePoint. This article covers step-by-step instructions for adding search features, improving usabilit
Fabric Data Factory: On-Prems Folder to Fabric SQL Database1/20/2025 9:45:15 AM. In this Data Engineering episode, I covered how to connect to files resident in on-prems folder and transform the data using Factory Data Factory dataflow gen2 and publish to the new SQL Database for
SQL Server – Query Performance – Database Maintenance can Help1/15/2025 3:19:58 AM. To improve query performance in an ASP.NET MVC application using SQL Server, periodic database maintenance steps like updating statistics and defragmenting indexes are essential. This includes manual
Working with GraphQL API in .NET 8 Using HotChocolate1/13/2025 7:06:02 AM. This article covers setting up a GraphQL server, defining queries and mutations, integrating with .NET 8 applications, and optimizing your API development process. Explore HotChocolate’s features for
Local and Global Temporary Tables in SQL Server1/13/2025 6:55:28 AM. Discover the differences between local and global temporary tables in SQL Server. Learn how to create, use, and manage temporary tables effectively.
Transaction in SQL Server1/13/2025 5:32:43 AM. This article covers the basics of SQL transactions, including BEGIN, COMMIT, and ROLLBACK commands, ACID properties, isolation levels, and error-handling techniques for effective database management.
How to Dockerize Your Django App1/11/2025 6:00:08 AM. This beginner-friendly article teaches you how to Dockerize your Django app. With Docker, you can simplify development, ensure consistency, and optimize deployments.
Azure SQL Database - Configure Job using Elastic Agents1/7/2025 8:41:35 AM. This article covers setting up Elastic Job agents, creating jobs, and automating tasks across multiple databases. Streamline database management, schedule tasks efficiently, and enhance performance wi
Create Database-Scoped Users for Microsoft Entra Security Groups1/6/2025 7:24:39 AM. In modern cloud environments, managing access to databases at scale can be challenging. By integrating Azure SQL with Microsoft Entra (formerly Azure Active Directory) Security Groups, you can streaml
Automate Data Integration from ADLS Gen2 to Snowflake using TASKS1/6/2025 5:34:47 AM. In this end to end data engineering episode, you will learn how to implement automated data integration in Snowflake using TASK.
Database Dictionary (1-2-1) --- Using Dynamic SQL Script1/4/2025 1:53:53 PM. This article will discuss when to use dynamic SQL Script and the conditions.
Advanced 4-Level CTEs using Fabric T-SQL Notebook1/2/2025 12:47:52 PM. In this episode, I demonstrated how to author 4-level advanced CTEs query using the new Microsoft Fabric T-SQL Notebook.
How to Set Up DynamoDB in AWS?1/2/2025 7:33:42 AM. Amazon DynamoDB is a fully managed, serverless NoSQL database service offering fast performance, scalability, and flexibility. It supports key-value and document data models, with global availability
A Fix to SQL Server Error 18456 - Login Failed12/31/2024 2:32:42 PM. This article is to discuss A Fix to SQL Server Error 18456 - Login Failed.
AI_GEN Function in Databricks SQL12/31/2024 5:14:12 AM. This video walks you through how you can use the new ai_gen function in Databricks SQL which leverages on generative AI models to process and respond to to user-provided prompts
Using Derived Column Task in SQL Server Integration Services12/30/2024 4:50:34 AM. The Derived Column Task in SQL Server Integration Services (SSIS) allows you to transform or modify data within your ETL process. It enables the creation of new columns or updates to existing ones usi
How to Set Up and Use AWS RDS for Beginners12/27/2024 9:08:08 AM. Learn how to create an AWS RDS database with this beginner-friendly guide. AWS RDS simplifies database setup and management, supporting engines like MySQL, PostgreSQL, and MariaDB.
Hello World! In 20 Different Programming Languages12/24/2024 9:01:37 AM. In this article, we are going to see how to print “Hello World” in 20 different programming languages. Explore how to print "Hello, World!" in 20 popular programming languages, showcasing sy
Conditional Split in SQL Services Integration Services (SSIS)12/23/2024 9:16:38 AM. Conditional Split in SQL Server Integration Services (SSIS) allows you to route data based on specific conditions within a data flow. It is used to direct data into different paths, enabling dynamic d
Create FTP Task in SQL Server Integration Services 12/19/2024 11:18:54 AM. Learn how to create and configure an FTP Task in SQL Server Integration Services (SSIS). This task simplifies automated file transfers using the FTP protocol, making it essential for ETL processes.
SQL Exists: Usage, Syntax, and Examples12/19/2024 4:30:17 AM. The "SQL EXISTS" clause is used to test whether a subquery returns any records. It's commonly used in conditional statements to improve query performance. This article covers the syntax,
Unlocking Faster INSERT Operations in SQL Server with TABLOCK12/17/2024 6:48:30 AM. In this article learn how using the TABLOCK hint in SQL Server can significantly speed up INSERT operations by reducing logging overhead and enabling parallel insertions.
SQL Server ACID Properties12/16/2024 8:24:34 AM. Understanding SQL Server ACID(Atomicity, Consistency, Isolation, Durability) Properties. This article explains ACID properties—Atomicity, Consistency, Isolation, and Durability—highlighting their impo
Bulk Insert Example with Two SQLite DB Files using .NET12/13/2024 5:06:10 AM. Learn how to merge two SQLite databases in C# using bulk insert/update. This method reads data from one DB and updates or inserts it into another, achieving efficient data merging.
Understanding the AI_EXTRACT SQL Function in Databricks12/12/2024 7:17:56 AM. This article dives into the mechanics of AI_EXTRACT, its syntax, and various use cases with examples. AI_EXTRACT in Databricks extracts structured data, like names and dates, from unstructured text us
Modern Featured Entity Framework With SQLite DB Example 12/11/2024 10:31:03 AM. Learn to build a .NET Core application using C# async/await and SQLite with Entity Framework. Implement CRUD operations, handle asynchronous tasks, and explore efficient database interaction using Vis
SQLite Database with .NET Example12/10/2024 9:51:01 AM. SQLite is a lightweight, file-based relational database ideal for small web, mobile, and .NET applications. This guide demonstrates SQLite integration, CRUD operations, and database handling using C#.
Automating Table Creation using SSIS12/10/2024 8:44:47 AM. In this article, we will see how to create a database table in SQL Server using the SSIS package. Learn how to create a database table in SQL Server using an SSIS package. Follow step-by-step instruct
Real-Time Notifications in Amazon Aurora PostgreSQL12/10/2024 6:46:05 AM. In this article, we are going to learn about Implement real-time notifications (Transactional Outbox Pattern) in Amazon Aurora PostgreSQL
Understanding Triggers in SQL Server12/9/2024 7:29:47 AM. SQL Server triggers are automated procedures executed on DML/DDL events. This guide explores trigger types, real-world examples, and implementations for logging, validation, and restriction in SQL Ser
Token Caching in .NET 8 with Microsoft Entra ID12/7/2024 3:22:18 AM. Learn how to optimize .NET 8 web apps with token caching using Microsoft Entra ID. Discover in-memory and distributed caching strategies to boost performance, reduce latency, and improve scalability i
Unit Test (2) --- TSQLT12/7/2024 2:51:50 AM. This article will discuss TSQLT Unit Test.
INSERT INTO and SELECT INTO: Which is Better?12/6/2024 5:50:06 AM. In this article, we’ll explore the differences between these two methods, their impact on temporary tables, and practical recommendations for SQL developers, data engineers, and DBAs. Using examples f
ASP.NET Core CRUD using Dapper, .NET 8 using SQL Server12/5/2024 7:18:42 AM. Learn to build a CRUD (Create, Retrieve, Update, Delete) application in ASP.NET Core MVC using .NET 8 and Dapper ORM. This guide covers creating models, repositories, controllers, and Razor views with
What is a CTE, and How Do You Write a CTE in SQL Server?11/29/2024 8:23:30 AM. A Common Table Expression (CTE) in SQL Server is a temporary result set that can be referred to within a SELECT, INSERT, UPDATE, or DELETE query. CTEs simplify complex queries by breaking them into ma
Learning SEQUENCE in SQL Server11/28/2024 6:02:51 AM. A SEQUENCE in SQL Server is a user-defined object that generates a sequence of numeric values in a specified order. Unlike identity columns, SEQUENCE objects are independent of tables, offering flexib
Explaining CTE in SQL Server11/27/2024 8:21:27 AM. Common Table Expressions (CTEs) in SQL simplify complex queries by creating temporary result sets. They can be used in SELECT, INSERT, UPDATE, and DELETE statements, supporting scenarios like hierarch
Renaming a Database in SQL Server11/27/2024 5:11:47 AM. Renaming a database in SQL Server is vital for tasks like aligning naming conventions, testing, or version control. It involves setting the database to single-user mode, ensuring no active connections
Using ROLLUP and CUBE with Spark in Microsoft Fabric11/26/2024 10:30:55 AM. In this article, we will Discover how these SQL features can help generate hierarchical summaries, enhance data insights, and improve reporting in big data environments.
Rank Functions in SQL server11/26/2024 6:44:08 AM. In this article, we will learn about Rank functions in SQL Server, like RANK(), DENSE_RANK(), ROW_NUMBER(), and NTILE(), are used to assign rankings to rows within a result set.
JSON Data Handling in SQL Server11/26/2024 4:58:34 AM. SQL Server supports JSON for managing semi-structured data. You can store JSON in NVARCHAR(MAX) columns, parse it with JSON_VALUE, JSON_QUERY, and OPENJSON, and modify it using JSON_MODIFY.
How to incrementally load data from Microsoft Fabric Lakehouse to Warehouse11/25/2024 5:00:00 AM. In this end-to-end data engineering episode, I demonstrated how to incrementally load data from Microsoft Fabric Lakehouse to Warehouse using Dataflow and Data Pipeline.
New Features in SQL Server 2025: A Guide for Data Engineers11/24/2024 5:46:37 AM. SQL Server 2025 introduces advanced AI integration, vector support, and performance upgrades like optimized locking and enhanced columnstore indexing. New features include JSON data type, regular expr
Data Cleansing in SQL Server11/24/2024 5:13:36 AM. Learn the essentials of Data Cleansing in SQL Server to enhance data quality and reliability. This guide covers techniques like removing duplicates, handling null values, standardizing formats, and tr
Exploring SQL Databases in Microsoft Fabric11/22/2024 11:29:28 AM. Microsoft Fabric now integrates SQL databases, bridging transactional and analytical workloads in a unified platform. It enables cloud-native data storage in OneLake, supporting Parquet and Delta form
Comparison Between SQL and MongoDB Database11/22/2024 5:23:46 AM. SQL and NoSQL(MONGO) DB Comparison. This article compares MS SQL Server and MongoDB, highlighting their development, data models, schemas, performance, and query mechanisms, aiding in understanding th
User-Defined Functions in SQL Server11/21/2024 5:14:12 AM. SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single valu
Temporary Tables vs Table Variables in SQL Server Explained11/19/2024 10:49:20 AM. This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
Unlocking the Power of the SELECT Feature in SQL Server11/18/2024 12:04:57 PM. This article explores the basics of the SQL Server SELECT statement, demonstrating how to query data from tables using practical examples. Learn how to fetch specific columns, improve query performanc
Types of APIs and Essential API Testing Tools11/18/2024 8:41:55 AM. Learn about essential API testing tools such as Postman, SoapUI, and JMeter, which help ensure the functionality, performance, and security of APIs through effective testing and automation.
Enhance SQL Server Stored Procedure Performance – Tuning Tips11/18/2024 3:51:42 AM. Covering indexes and filtered indexes in SQL optimize database performance by efficiently retrieving data for queries. Covering indexes include all needed columns, while filtered indexes target specif
Data Professionals to LLM/GPT Prompting for Everyday Tasks11/17/2024 10:52:39 AM. A guide for data professionals on leveraging Microsoft OpenAI with Python for efficient workflows and enhanced data analysis. Focuses on prompt design, including clear instructions, context, and tempe
Beginner's Guide to CRUD Operations in .NET Core 8 Web API11/12/2024 7:30:14 AM. This guide walks you through creating a .NET Core 8 Web API for managing employee data with full CRUD operations. Using Entity Framework Core, you’ll define models, connect to a SQL database, create e
SSRS (4) --- SQL Server Database Project in Visual Studio11/11/2024 8:37:33 PM. This article is to discuss: SQL Server Database Project in Visual Studio
Hacking MySQL for Big Data11/8/2024 11:14:47 AM. In this video, we will go through the things that make MySQL & its counterparts capable of performing well on bigger data sets.
Integrate MySQL and Snowflake for Real-Time Insights11/8/2024 4:38:58 AM. This guide covers migrating data from MySQL to Snowflake, highlighting two methods: using Estuary Flow for real-time data sync with minimal setup, and a manual CSV export/import for smaller datasets o
Understanding Distributed and Monolithic SQL Architectures11/5/2024 10:01:52 AM. In this article, we explore the key differences between distributed and monolithic SQL architectures. We delve into their respective advantages and disadvantages, focusing on scalability, performance,
Exploring the New T-SQL Enhancements in SQL Server 202211/5/2024 5:39:41 AM. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and opt
Creating Azure SQL Database with Tables11/4/2024 4:59:13 AM. In this video, I demo how to create Azure SQL database, create and insert records into the table, and query the data.
Implement a RAG Solution Using Azure SQL Database11/1/2024 11:03:43 PM. In this brief video I walk you through the components of retrieval augmented generation (RAG). I talk about embeddings and vectors and even show you how they are created. Finally, I'll show you
BIT Functions New T-SQL Enhancements in SQL Server10/30/2024 5:58:33 AM. In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
Securing Remote Access to SQL Server10/30/2024 5:39:48 AM. Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protec
Windowing Enhancements New T-SQL Enhancement in SQL Server10/29/2024 6:29:27 AM. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
Create a Model with Database Table in .NET 8 using EF Core10/28/2024 7:16:12 AM. This article guides you through creating a data-driven application using .NET 8 and Entity Framework Core. You'll learn to define a model, configure a DbContext, set up a SQL Server connection str
Efficient Data Handling in SQL Server with Table-Valued Parameters10/27/2024 5:52:26 AM. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
Manage Azure SQL Roles with Azure Data Studio10/26/2024 5:43:14 AM. Azure SQL Database is a managed cloud database service enabling secure, scalable applications. With Azure Data Studio, a free, cross-platform tool, database admins can view and manage user roles and p
TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
SQL Data Analysis in Databricks Notebook10/25/2024 6:09:40 AM. This video dives into performing SQL Data Analysis in Databricks Notebook.
GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
Domain-first GraphQL API Platforms for Your .NET Stack10/24/2024 12:00:55 PM. In this video, we'll demo how .NET developers can use modern architecture and data storage to build scalable GraphQL APIs for real-time data and AI integration.
Redis: RedisString and RedisJSON10/23/2024 8:19:31 AM. RedisString has long been the basic and most common data type in Redis. Recently, RedisJSON has gained popularity as a module that allows you to store, query, and manipulate JSON data natively.
Check Constraint in SQL Server 201210/16/2024 9:55:46 AM. A Check Constraint in SQL Server enforces Domain Integrity by ensuring valid values for specific table columns. It restricts invalid data entries, rejects values that don't meet set conditions, an
STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL Server10/16/2024 9:01:22 AM. The STRING_SPLIT() function in SQL Server, introduced in 2016, allows for splitting delimited strings into rows. The 2022 enhancement introduces an optional ordinal parameter, enabling retrieval of ea
Databricks: Provision and Analyze Azure SQL Database Table10/16/2024 7:38:47 AM. In this video, I covered how to read and analyse Azure SQL Database Table in Databricks Notebook.
Is PostgreSQL the Future of Databases?10/16/2024 5:00:45 AM. This article explores whether PostgreSQL is the future of databases, highlighting its advantages in scalability, performance, and innovation. Discover how it compares to other database systems in toda
Least and Greatest New T-SQL Enhancements in SQL Server10/15/2024 11:42:36 AM. Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
Write Data from Fabric Dataflow Gen2 to Azure SQL Database10/15/2024 5:16:17 AM. In this new video, I am going to walk you through how to write data from Fabric Dataflow Gen2 to Azure SQL Database.
How To Delete Duplicate Rows From A Table In SQL Server10/12/2024 5:29:23 AM. This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the o
Get All Instances of SQL Server in C#10/11/2024 12:29:27 PM. If you're writing a Database Manager application or simply want to retrieve all the instances,this trick might come in handy.
DATETRUNC New T-SQL Enhancements in SQL Server10/9/2024 6:48:59 AM. This new feature simplifies date truncation by allowing developers to truncate dates to specific intervals, such as year, month, or day. It improves query performance and data manipulation in SQL.
Mastering SQL Query Generation with Azure OpenAI10/9/2024 6:07:40 AM. Leverage Azure OpenAI to transform natural language into SQL queries seamlessly. By integrating Azure OpenAI and Azure SQL Database, you can simplify data querying and enhance accessibility. Learn how
Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)10/8/2024 8:54:22 AM. In this article you will learn how to upload your App to Windows Store (Step by Step), backup and restore your database using SQL Server Management Studio (Step by Step).
How To Send Mail Using SQL Server: Part 210/8/2024 8:32:47 AM. This tutorial demonstrates how to send emails using SQL Server 2008. It covers configuring an email profile, selecting data from a student table (tblStudents), and binding that data to an HTML-formatt
Read Multiple PARQUET Files from GCS to Azure SQL Database using Azure Data Factory10/7/2024 4:56:25 AM. In this Data Engineering episode, I covered how to read multiple sales parquet files resident in Google Cloud Storage to Azure SQL Database leveraging Azure Data Factory.
Exploring Aggregate Functions in Azure Cosmos DB10/7/2024 4:43:48 AM. Aggregate functions in Cosmos DB allow efficient data summarization and analysis across multiple documents. They perform calculations such as AVG, COUNT, SUM, MAX, and MIN to retrieve meaningful insig
DATE_BUCKET Function New T-SQL Enhancements in SQL Server10/5/2024 6:28:43 AM. This article will delve into the DATE_BUCKET function, its syntax, and its practical use cases using the AdventureWorks2022 sample database. We’ll also compare DATE_BUCKET with other similar T-SQL fun
IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server10/4/2024 6:15:00 AM. The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data int
A Fix To PolyBase Issue In SQL Server 2019 Developer Edition10/3/2024 1:16:46 PM. This article will introduce the problem, the reason and the fix related to a PolyBase issue when installing the SQL Server Developer Edition 2019.
Generate or find Connection String from Visual Studio10/3/2024 11:44:59 AM. This guide covers various methods, including using the Connection String Builder, accessing app.config and web.config files, and integrating with SQL Server and Entity Framework. Mastering connection
NTile Function in SQL Server10/3/2024 11:44:37 AM. The NTile function in SQL Server divides a result set into a specified number of groups, assigning ranks to records within each group. Unlike Dense_Rank, NTile focuses on groups rather than individual
Creating Stored Procedures with Managed Code10/3/2024 11:41:01 AM. This article demonstrates how to create a stored procedure in Microsoft SQL Server 2005 using managed code in C#. It details the process of setting up a SQL Server project in Visual Studio, writing th
How to Use a Cursor in SQL?10/3/2024 11:08:13 AM. A cursor in SQL is a database object that allows row-by-row processing of query results. It enables you to iterate through a result set, perform operations on each row, and manage data more efficientl
Enhance Search with Azure SQL DB FAISS and Hugging Face Model10/3/2024 6:32:45 AM. In this article, learn how to enhance search capabilities by integrating Azure SQL Database, FAISS, and Hugging Face models. We’ll walk through querying data, generating embeddings using the 'all-

Topics