Post
Ask Question
Related resources for SQL
  • 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
  • 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
  • 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-
  • Database, Data Warehouse, and Data Lake: A Comparative Analysis10/2/2024 4:49:26 AM. Databases handle structured, real-time transactional data. Data warehouses focus on structured, historical data for analytics. Data lakes store raw, unstructured data, which is ideal for advanced anal
  • SQL Vs DAX: Calculating Total Sales & COGS using SQL and DAX10/1/2024 6:54:09 AM. This videos show how to use SQL and DAX languages to compute Total Sales and Total Cost achieving the same result in Fabric Warehouse and Power BI.
  • Types of Keys in SQL10/1/2024 6:09:16 AM. In SQL, keys play a crucial role in maintaining data integrity and defining relationships between tables. Common types include the Primary Key, which uniquely identifies records; the Foreign Key, link
  • A Detailed Explanation of COUNT in SQL Server10/1/2024 5:10:59 AM. This article explores the differences between SQL counting methods: COUNT(*), COUNT(1), COUNT(column_name), and COUNT(DISTINCT column_name). It highlights their purposes, performance considerations, a
  • Insert Master-Detail Data using Transact-SQL10/1/2024 4:54:39 AM. This document explains how to utilize SQLXML in SQL Server 2000 for efficient batch operations with XML data. It outlines the process for creating stored procedures to insert, update, and delete recor
  • How to Decide Between Relational Database and NoSQL Databases?9/30/2024 7:12:38 AM. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, ma
  • Rank and Dense_Rank Function in SQL Server9/30/2024 4:48:24 AM. RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION
  • How to Send Mail Using SQL Server: Part 39/27/2024 10:16:21 AM. In this third installment of our series, "How to Send Mail Using SQL Server," we delve into the configuration and implementation of Database Mail. Learn how to set up SMTP settings, create m
  • How To Execute SQL In SharePoint 2013 And Office 365 Using Nintex WorkFlows9/27/2024 10:13:52 AM. This article guides you through executing SQL in SharePoint 2013 and Office 365 using Nintex Workflows. It covers creating a Dev Testing list, adding the "Execute SQL" action, and configurin
  • Selection Based Crystal Report using Stored Procedure9/27/2024 10:11:28 AM. This project demonstrates creating a Crystal Report in a Windows Form application. It includes setting up a SQL database connection, populating a ComboBox with data, generating reports using parameter
  • Inserting Form Data Into DataBase Using Stored Procedure In ASP.NET C#9/27/2024 10:10:24 AM. Learn how to insert form data into a database using stored procedures in ASP.NET with C#. This guide covers setting up a form, handling user input, creating a stored procedure, and securely inserting
  • How To Add Dependency Injection In Your Sitecore Application9/27/2024 8:17:09 AM. Dependency Injection (DI) is a design pattern that enhances code maintainability and reusability by allowing developers to create loosely coupled components. It facilitates unit testing and supports v
  • SQL Stored Procedure vs. Azure Data Factory Data Flow9/27/2024 7:32:23 AM. This article compares SQL Stored Procedures and Azure Data Factory (ADF) Data Flows for creating staging tables and migrating data to Dynamics 365 (D365). It examines their differences in execution ti
  • Getting Started with Azure SQL Database – A Beginners Guide9/27/2024 7:19:23 AM. A quick introduction to Azure SQL Database that showcases some key offerings and highlights the flexibility and scalability that comes with it.
  • Interesting Query (3) --- Get Rolling Average9/26/2024 10:31:45 PM. This article will discuss Interesting Query (3) --- Get Rolling Average
  • Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse9/26/2024 9:45:47 AM. In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to -- Enabling System Assigned Managed Identity required to publish data to Fabr
  • How To Get Unique Records Without Using Distinct In SQL Server9/26/2024 4:35:41 AM. In this guide, you'll learn how to retrieve unique records in SQL Server without using the DISTINCT keyword. We'll explore alternative methods like GROUP BY, ROW_NUMBER(), and Common Table Exp
  • Create Dynamic Pivot Table Using Store Procedure9/25/2024 6:58:27 AM. Learn how to create a dynamic pivot table using a stored procedure in SQL. This guide covers transforming rows into columns dynamically, automating pivot table creation, and efficiently querying large
  • Visualizing MySQL Date-Time Data with CanvasJS in PHP9/25/2024 5:31:31 AM. Learn how to create CanvasJS charts using date-time values from a database in PHP. This comprehensive guide covers setting up your database, fetching data, converting PHP timestamps to JavaScript time
  • Schedule Background Jobs Using Hangfire In ASP.NET Core9/24/2024 9:04:17 AM. Hangfire is an open-source library for ASP.NET Core that simplifies scheduling and monitoring background tasks like data processing and email reminders. By using Hangfire, you can create fire-and-forg
  • Check Disk Space Utilization by Tables in SQL Server Database9/23/2024 8:53:17 AM. In this guide, learn how to effectively check disk space utilization by tables in a SQL Server database. We’ll cover essential SQL queries and techniques to analyze table sizes, identify storage usage
  • Advanced ADF: Integrate Multiple Category of Files Leveraging FILTER and other Activities9/23/2024 6:37:08 AM. In this episode, I am going to walk you through how to integrate multiple category of files in ADLS Gen2 to Azure SQL Database via Azure Data Factory data pipeline activities focusing on filter and o
  • Concurrency in SQL Server9/20/2024 4:06:27 PM. This article will discuss Concurrency in SQL Server
  • Database Backup With Compression in SQL Server9/20/2024 9:18:22 AM. This article explains how to perform database backup compression in SQL Server 2012 using SQL Server Management Studio or a Transact-SQL statement. It provides a step-by-step guide to visually create
  • How to Keep SQL Server Table Columns in Sync9/19/2024 4:29:35 AM. how to keep columns in sync across SQL Server tables using efficient methods like triggers, SQL scripts, and the MERGE statement.
  • Create Backup and Restore Database in SQL Server9/18/2024 9:01:35 AM. This tutorial covers essential techniques for backing up your databases, restoring them when needed, and ensuring data safety. Master these skills to safeguard your SQL Server environment effectively.
  • Bulk Insert From ASP.NET Web Form Using C#9/17/2024 10:39:37 AM. To insert bulk records into a database from a web form, create a ProductsSold table. Design a web form with GridView, TextBoxes, and Buttons to add and display products. Use a DataTable in ViewState t
  • Overview Of Data Gateway In Power BI9/16/2024 11:19:33 AM. A Power BI Gateway connects on-premise data sources, such as SQL Server or SharePoint, to online services like Power BI. It ensures secure communication, supports both Personal and Enterprise Modes, a
  • Data Virtualization from Azure Blob Storage in Azure SQL Database9/16/2024 5:17:34 AM. This solution enables Azure SQL Database to directly access and read files from Azure Blob Storage using External REST Endpoints, bypassing the need for physical data loading. It leverages database-sc
  • Entity Framework In MVC - Part Three9/12/2024 12:12:57 PM. This article explains the Code First approach in MVC using Entity Framework. It covers creating a new database from domain classes, reverse engineering an existing database to generate POCO classes, a
  • Entity Framework Core Feature - Global Query Filters9/12/2024 5:59:39 AM. Learn how to implement Global Query Filters in Entity Framework to apply automatic filters at the model level. This feature is commonly used for scenarios like soft delete and multi-tenancy, ensuring
  • Configure SQL Server Session State In ASP.NET Core9/12/2024 5:49:48 AM. This guide covers setting up SQL Server as a session storage provider, configuring the connection string, enabling session middleware, and ensuring session persistence for scalable web applications.
  • CRUD Operation Using Repository Unit Of Work Pattern9/12/2024 5:44:14 AM. Create an ASP.NET MVC project in Visual Studio 2013, add a class library, and set up a SQL Server database. Implement Entity Framework with an EDMX model, then use the Repository pattern for CRUD oper
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode9/12/2024 5:10:58 AM. This article explains how to configure a Data Gateway for an On-Premise SQL Server Database using Power BI's Recommended Mode. It covers the installation steps, including downloading and setting u
  • SQL Vs DAX: Calculating Total Sales & COGS using SQL and DAX9/11/2024 8:13:50 AM. This videos show how to use SQL and DAX languages to compute Total Sales and Total Cost achieving the same result in Fabric Warehouse and Power BI.
  • Database Mail Configuration in SQL Server 20089/10/2024 10:16:49 AM. Learn how to configure Database Mail in SQL Server 2008 with this guide. Discover step-by-step instructions for setting up email profiles, configuring SMTP settings, and managing mail settings using S
  • Real Time Use Of Context Menu Strip In Windows Form Application9/9/2024 11:35:42 AM. Learn how to use ContextMenuStrip in a Windows Forms application to delete records from a DataGridView. This tutorial covers setting up a context menu, handling right-click events, and executing a del
  • Relations between Dataset in DBMS9/6/2024 12:45:34 PM. A relationship in DBMS links two or more data sets. This article explores types of relationships: one-to-one, one-to-many, and many-to-many, and their implementations in databases.
  • SQL Data Analysis Using Azure Synapse Built-in Serverless Pool9/6/2024 6:06:58 AM. In this video, I demonstrated how to perform SQL Data Analysis in Azure Synapse Analytics using built-in serverless pool.
  • SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause9/5/2024 12:51:37 PM. This article will discuss the issue that SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause
  • Export Data Table To Excel in ASP.Net MVC 49/5/2024 11:09:19 AM. This article demonstrates exporting a Data Table to Excel in ASP.NET MVC. It covers creating a new project, adding a ClosedXML reference, and setting up models and controllers. It details fetching dat
  • Export Data From Database Table to Excel File in ASP.Net MVC9/5/2024 10:55:56 AM. Exporting data from a database to Excel in ASP.NET MVC involves creating a database, setting up a model, and designing a view. Use SqlConnection and SqlDataAdapter to fetch data and Microsoft.Office.I
  • How To Implement CKEditor In ASP.NET MVC9/5/2024 10:45:12 AM. CKEditor is a powerful, browser-based WYSIWYG editor that simplifies HTML content creation. It integrates seamlessly with ASP.NET MVC, allowing users to easily create and manage rich text content.
  • Temporary Tables vs Table Variable in SQL Server9/5/2024 7:20:02 AM. In this article you will learn about Temporary Tables and Table Variables in SQL Server 2008. Temporary tables come in two types: Local (prefixed with "#", accessible only to the current con
  • What are Temporary Tables in SQL Server?9/5/2024 7:19:46 AM. Temporary tables in SQL Server, stored in tempdb, assist with short-term data management. They come in Local (scope limited to current connection, prefixed with "#") and Global (accessible t
  • SQL Subqueries: Correlated, Scalar, and EXISTS/NOT EXISTS9/4/2024 9:30:54 AM. Subqueries in SQL are powerful tools for complex queries. They include correlated subqueries, which depend on the outer query’s results, scalar subqueries that return single values, and EXISTS/NOT EXI
  • Database Mail in SQL Server 2008R29/4/2024 8:38:30 AM. Database Mail in SQL Server 2008 R2 enables sending emails directly from SQL Server using SMTP. It supports job alerts, query results, and file attachments, ensuring consistent, scalable, and secure e
  • GridView Paging Sample in ASP.NET9/4/2024 8:21:34 AM. Learn how to implement various paging styles in ASP.NET GridView using C#. This guide covers binding SQL Server data to a GridView, enabling paging, and customizing pager settings like Numeric, NextPr
  • Configure SQL Server Database Mail for Sending Emails9/4/2024 7:01:19 AM. This guide covers the step-by-step process for setting up Database Mail, including creating and managing mail accounts, profiles, and ensuring your SQL Server can successfully send email notifications
  • Learn Common Table Expressions (CTE) in SQL9/4/2024 6:25:07 AM. Common Table Expressions (CTEs) in SQL are a powerful tool for simplifying complex queries. They allow you to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DE
  • Advance Chat Application with .NET and SignalR9/2/2024 8:30:14 PM. Build an advanced real-time chat app with .NET 8, SignalR, and MS-SQL. This guide covers creating a chat app with one-to-one and group messaging, utilizing ASP.NET Identity for user roles and permissi
  • Introduction to SQL Server & Its History9/2/2024 7:10:06 AM. Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
  • ADF: Provision Snowflake Database Table in Azure SQL DB and Create Power BI Report9/2/2024 7:08:05 AM. In this data engineering and data analysis episode, I covered how to provision single snowflake database table in azure sql database and then use Power BI desktop to connect to the data to create Powe
  • Learn Database Mail in SQL Server8/29/2024 10:53:40 AM. Database Mail in SQL Server is a robust feature that enables sending emails via an SMTP server without relying on MAPI clients like Outlook. It offers secure SSL encryption, asynchronous processing, e
  • Understanding SQL Triggers: A Practical Guide with a New Example8/28/2024 8:38:05 AM. Discover how triggers can automate tasks, enforce business rules, and maintain data integrity in your database. Perfect for both beginners and experienced developers looking to deepen their SQL skills