Related resources for SQL
  • Vector Similarity Search in Azure Cosmos DB for PostgreSQL with pgvector & Azure AI Vision3/14/2024 4:31:40 AM. In this session, we will discuss about vector search with Azure AI Vision and Azure Cosmos DB for PostgreSQL.
  • Querying Azure SQL Databases In Databricks Spark Cluster3/13/2024 8:44:48 AM. We will see the entire steps for creating an Azure Databricks Spark Cluster and querying data from Azure SQL DB using JDBC driver. Later we will save one table data from SQL to a CSV file.
  • Inserting List of Records into Single SQL Column As XML File In ASP.NET MVC3/13/2024 8:39:38 AM. This tutorial guides you through the process of converting a list of records into XML and inserting it into a single SQL column, streamlining data storage and retrieval in your application.
  • How to Fetch Daily, Weekly, Monthly, and Yearly based Data in SQL3/12/2024 10:59:03 AM. In SQL, fetching data based on specific time intervals like day, week, month, and year is essential for meaningful analysis.
  • Basics of Azure Databricks: Data Analytics in the Cloud3/11/2024 10:31:10 AM. Azure Databricks stands at the forefront of cloud-based data analytics platforms, revolutionizing the way organizations manage, process, and derive insights from massive datasets. Azure Databricks, ex
  • Benefits of Temporary Tables over Table Variables in SQL Server3/10/2024 8:15:37 AM. The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handl
  • Code Only Design using ADO.NET Entity Framework 4.0 3/7/2024 8:43:43 AM. This code snippet implements Code Only Design in ADO.NET Entity Framework 4.0, connecting to a SQL Server database, configuring entities, and binding data to a GridView with exception handling.
  • Remote Access Of The Database Using SQL Server 3/7/2024 8:36:49 AM. Remote access to SQL Server databases enables users to connect to and manage databases from a location outside the physical server. It involves configuring network settings, security measures like aut
  • How To Secure PII Data In SQL Server Using .NET Assembly3/6/2024 10:46:18 AM. In this article, we will learn PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number, etc. When you are working with financial
  • How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)3/6/2024 10:45:53 AM. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario
  • Display SQL Data Using Knockout in ASP.Net3/6/2024 10:41:07 AM. In this article, we will learn how to fetch SQL data in ASP.NET and display it dynamically using Knockout.js. Utilize AJAX to retrieve data as JSON and bind it to HTML elements, creating an interactiv
  • Practical Introduction To Entity Framework: Day 23/6/2024 10:30:54 AM. This article provides a comprehensive guide on executing stored procedures using Entity Framework. It covers creating stored procedures in SQL Server, adding entity models to projects, and calling aut
  • Renaming the Column in SQL Server3/6/2024 10:28:46 AM. Renaming columns in SQL Server is a fundamental task in database management. This comprehensive guide provides step-by-step instructions, syntax examples, and best practices to effectively rename colu
  • Understanding FORMATMESSAGE() Function in SQL Server3/6/2024 4:58:24 AM. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • Importing Access Database into SQL Server 20123/5/2024 10:40:07 AM. Destructuring simplifies value extraction from objects/arrays. React's event handling enables dynamic responses to user interactions, crucial for interactive UIs. Components manage state/props, fa
  • How to Enable Remote Connections in SQL Server 20053/5/2024 10:39:30 AM. This article provides guidance on enabling remote connections in SQL Server 2005, addressing the common error message encountered when attempting a remote connection. It outlines the security precauti
  • Covering Indexes And Filtered Indexes In SQL3/5/2024 10:36:56 AM. Hello Learners. I hope you all are doing great. This article describes the Covering Indexes and Filtered Indexes. I would like to tell you that these type of Indexes can only be created as NONCLUSTERE
  • SQL Server Error Logging From A Stored Procedure3/5/2024 10:28:44 AM. In this article, we will learn effective error handling in SQL Server stored procedures. Utilize RAISERROR to log errors, manage exceptions, and maintain robust error reporting mechanisms for enhanced
  • Enhance SQL Server Stored Procedure Performance – Tuning Tips3/5/2024 9:26:01 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
  • SQL CTE to Rank Sales by Products using Fabric Data Warehouse3/5/2024 5:03:37 AM. This video shows how to author Common Table Expressions in Fabric Data Warehouse to Rank Sales by Products.
  • Securing Remote Access to SQL Server3/5/2024 4:16:02 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
  • SQL Server Effective Database Tune up and Maintenance3/4/2024 11:31:33 AM. This document provides essential tips for effectively maintaining a production database, aimed particularly at developers who may not be professional database administrators. It covers topics such as
  • SQL Server Performance Tuning: Data Compression3/4/2024 11:30:53 AM. In this article, you will learn about Data Compression in SQL Server. Learn SQL Server Performance Tuning, Types of Data Compression like Row Compression, Page Compression, Dictionary Compression.
  • Improving SQL Performance Using Covering Indexes3/4/2024 11:29:49 AM. In this article we will try to understand what a covering index is, how to avoid the expensive key lookup operations, and how it can improve our T-SQL performance multi fold times.
  • SQL Tuning - Effective Strategies with Practical Examples3/3/2024 5:01:15 AM. SQL Tuning — Effective Strategies with Practical Examples
  • Product Management Application using .NET Core and React JS with CRUD Operations3/2/2024 9:31:29 AM. In this article, learn to create a product management web API with CRUD operations using .NET Core 6 and React JS. Utilize SQL Server for the backend and Axios for API consumption.
  • An Instant API using Data API Builder2/29/2024 11:34:05 AM. In the session, you will learn how to create an applications API layer from a single configuration file.
  • How to Open, Read or View MS SQL Error Log File2/29/2024 10:47:38 AM. Explore methods to open, read, or view SQL Server Error Log File. Get the best solution to open or view the SQL Server Log File of MS SQL Server in easy steps.
  • How to search the data from the associated external content type in SharePoint 20102/29/2024 10:36:46 AM. In this article, we will be seeing how to search the data from the associated external content type. Searching data from associated external content types in SharePoint 2010. Learn to create ECTs, and
  • SQL Server Data Types for Performance, Memory Efficiency2/28/2024 6:49:09 AM. "Embark on a journey to unlock SQL Server's full potential through savvy data type selection. Enhance performance and streamline operations with optimal choices.
  • Quick SQL Refresher 2/28/2024 4:39:54 AM. The Quick SQL Refresher provides a concise cheat sheet for SQL, covering essential concepts, keys, commands (DDL, DML, DQL, DCL, TCL), constraints, clauses, T-SQL fundamentals, joins, functions, excep
  • CRUP Operation with Dapper Using ASP.NET Core2/27/2024 10:41:54 AM. Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a ba
  • How To Install SQLite On Windows 112/23/2024 6:55:34 AM. Learn how to easily install SQLite on your Windows 11 system. Download the setup, configure environment variables, and use the command prompt to set up the SQLite shell for efficient database manageme
  • Azure Document DB CRUD Operation2/21/2024 11:38:53 AM. This article explains how to create documents into SQL (DocumentDB) API. Before starting, we need to understand what is documentDb and how it works. SQL (DocumentDb) API is one of API comes under Azur
  • Blazor - Create SPA With Azure Database For MariaDB Server2/21/2024 8:27:24 AM. We will create a MariaDB database service in Azure and connect MariaDB in a Single Page Blazor application. Azure Database for MariaDB is a relational database service in the Microsoft cloud. Azure Da
  • Blazor - CRUD Using PostgreSQL And Entity Framework Core2/20/2024 3:13:20 PM. We will see the CRUD actions in Blazor framework with PostgreSQL database and Entity Framework Core. We will create a sample Patient app with all CRUD actions.
  • Tips to Launch Your SQL Mission2/20/2024 11:34:01 AM. This article consists of roadmap to embark on an exhilarating journey to master SQL which is the universal language of data management and analysis. In this comprehensive guide, we'll delve deep i
  • ASP.NET Core - Expense Manager Using EF Core And Highcharts2/20/2024 7:31:47 AM. We will create a personal expense manager using Asp.NET Core 2.1 and Entity Framework core Code first approach with the help of Highcharts to show the expense summary chart and a modal dialog to handl
  • Installing and Configuring XAMPP on Windows 112/20/2024 6:51:27 AM. This article provides a comprehensive guide on installing XAMPP, the popular PHP development environment, on Windows 10/11. XAMPP includes Apache, MySQL, PHP, and Perl, making it a convenient solution
  • Deploying A Blazor Application On Azure2/19/2024 10:00:19 AM. This comprehensive guide walks through the process of deploying an ASP.NET Core-hosted Blazor application on Azure, covering steps from creating an SQL database server to publishing the application.
  • Cloud Security: Secure Access from your Applications to Azure SQL2/19/2024 4:47:28 AM. In this session, you will discover the differences between authentication on-premises and in the cloud and learn how to go way beyond the basic user/password for authentication.
  • SQL Server Migration Strategy into Azure SQL PaaS Database2/16/2024 3:47:43 AM. This article outlines a strategic approach to migrating SQL database workloads from on-premises to Azure cloud services. It covers the high-level migration roadmap, choosing the right migration path,
  • Difference Between UNION and UNION All (SQL Server)?2/12/2024 11:55:50 AM. UNION merges and filters out duplicates from various SELECT queries, whereas UNION ALL combines them without eliminating duplicates, providing quicker results but retaining all rows, including duplica
  • Analysis of T-SQL and PL/SQL2/12/2024 4:03:24 AM. This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for effici
  • New Modifications and Improvements to the Azure Stream Analytics No-Code Editor 2/11/2024 8:22:36 AM. Explore real-time analytics with Azure Stream Analytics, a Microsoft Azure service for processing and analyzing streaming data. Learn about input sources, SQL-like query language, output destinations,
  • The Amazing Adventure of MongoDB Queries2/9/2024 9:21:46 AM. This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, executi
  • How to Find Blocked Deadlocks in SQL?2/9/2024 8:42:19 AM. The SQL query utilizes dynamic management views (DMVs) like sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_connections, and sys.dm_exec_sql_text to monitor and manage active sessions, connect
  • Difference Between Raw SQL and Dapper 2/8/2024 8:55:42 AM. Explore the trade-offs between using raw SQL queries and leveraging Dapper, a micro-ORM for database access in C# development. Delve into performance, code maintainability, and efficiency to make info
  • Create ASP.NET Web App With SQL Database In Azure2/7/2024 4:50:27 AM. In this article, you will learn to create an ASP.NET web app with SQL Database on Azure! Prerequisites include a Microsoft Azure Account and Visual Studio 2013/2015. Follow the steps to create a SQL D
  • Mastering T-SQL Rank Functions2/6/2024 9:28:41 AM. SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential nu
  • Top 10 Most Used SQL Queries2/6/2024 6:39:43 AM. In this article you will learn about the top 10 most used SQL Queries. SQL Server is an interface which helps to communicate with the system’s database using queries.
  • Requirements to Install SQL Server 20142/6/2024 6:28:59 AM. In this article I explain what are requirements to install SQL Server 2014
  • DATEPART Function in SQL Server2/6/2024 6:26:51 AM. This SQL Server tutorial explores the Datepart function, a built-in function for extracting portions of a DateTime field, demonstrated through practical examples for various date and time components.
  • Automated Deployment of SQL Server Database through Azure Devops2/6/2024 4:04:30 AM. Explore an automated deployment solution for SQL Server databases using Azure DevOps. This guide details the setup of a self-hosted agent, granting necessary server access, and configuring a release p
  • Data Vault Design in Azure SQL - Read PII with Customer Keys2/5/2024 11:00:54 AM. Data Vault design in Azure SQL - Utilizing Customer keys to read PII information in databases. Ensuring data security in the cloud era is crucial, especially with the rise in data attacks. Protecting
  • 🖥️ How to Create an Web App in Microsoft Azure?2/5/2024 9:42:03 AM. In this article, we will see how to create a web app in Microsoft Azure in step by step. Azure Web App, a fully managed PaaS from Microsoft Azure, simplifies web app deployment. Learn how to create an
  • SQL Joins for Efficient Database Queries2/5/2024 5:54:13 AM. Explore SQL joins, including inner, natural, left outer, right outer, full outer, and cross joins. Learn their usage, syntax, and differences to master relational database querying for effective data
  • Optimize SQL Database Performance2/1/2024 8:40:21 AM. "Unlocking Database Efficiency: A Guide to Performance Optimization in SQL" is a concise and insightful resource that provides practical guidance on enhancing the efficiency of SQL databases
  • Full-Stack Web Development in ASP.NET Core 8 MVC1/30/2024 4:10:26 AM. Full-stack web development refers to the practice of designing, developing, and deploying both the client-side (front-end) and server-side (back-end) components of a web application. In this, develope
  • Implement CRUD Operations in .NET Core 8 with Dockerized MSSQL Server1/25/2024 5:31:16 AM. In this article, I'm going to implement the basic CRUD Operations using .Net Core Web API & the Dockerized MSSQL Server. This article guides you through implementing CRUD operations in ASP.NET
  • Run MS SQL Server on Docker 📦1/24/2024 6:27:51 AM. In this article, I'm going to show how to install Docker on Windows 11 and run the MS SQL server on it.
  • Lazy Loading In ASP.NET Core 7 Web API1/22/2024 9:09:14 AM. ASP.NET Core 7 Web API. Lazy loading is a technique where related data is only loaded from the database when it is explicitly requested. In Entity Framework Core, lazy loading can be achieved by marki
  • Working with SQL Lite Database in Asp.NET Core Web API 1/21/2024 1:32:23 PM. SQLite is a self-contained, serverless, and zero-configuration relational database management system (RDBMS). It is a lightweight, open-source, and embedded database engine that does not require a sep
  • 🖥️ A Guide to Web Attack Incident Handling1/17/2024 9:02:52 AM. In this article, we will explore various types of web attacks, including Denial of Service (DoS) and Distributed Denial of Service (DDoS), SQL Injection, Cross-Site Scripting (XSS), Command Injection,
  • Building a Secure PHP MySQL Signup/Login Website with Email Verification1/15/2024 8:48:49 AM. Creating a secure signup/login system is essential for any web application that involves user authentication. In this article, I'll guide you through building a PHP MySQL login/signup website with
  • OPENJSON in SQL Server1/15/2024 5:50:12 AM. SQL Server's OPENJSON function is a powerful tool for working with JSON data in relational database systems. It allows users to parse and transform JSON-formatted strings into tabular data, making
  • Partitioning in PostgreSQL: What, Why, and How1/11/2024 4:44:32 AM. PostgreSQL partitioning enhances database management by dividing large tables into smaller, manageable partitions. Learn the benefits and types (range, list, hash, composite) for efficient data organi
  • JWT Authentication Using Refresh Token Series - 1 [Login Feature] In .NET Core 6.0-ADO.NET-SQL1/10/2024 10:39:54 AM. In this series of articles, we'll focus on a hands-on, practical implementation of JWT authentication with refresh tokens in .NET Core 6.0 using ADO.NET and SQL, emphasizing real-world scenarios a
  • Union and Union All1/10/2024 6:55:52 AM. This article will tell you the use of union and union all and difference between them and some key points that are important to follow in union and union all syntax.
  • Interface Segregation Principle1/10/2024 6:15:27 AM. The Interface Segregation Principle advocates breaking down a large interface into smaller, client-specific interfaces. This ensures that no class is compelled to depend on methods it doesn't use,
  • SQL Functions and Examples.1/10/2024 6:08:41 AM. This article provides you with many built-in SQL functions including aggregate functions, date functions, string functions, control flow functions, window functions, and math functions.
  • Identifying the Root Cause of SQL Server Problems1/10/2024 5:17:17 AM. Finding issues in SQL Server involves troubleshooting and identifying the root cause of problems. Troubleshooting SQL Server issues involves comprehensive steps. Check error logs, use SQL Server Manag
  • Deleting Duplicate Records Using CTE1/9/2024 7:00:44 AM. In this article we will understand how to delete duplicate rows and records from table using Common Table Expression (CTE) in SQL Server.
  • Understanding the One-Way Nature of HASHBYTES in SQL1/5/2024 10:48:17 AM. This article delves into the cryptographic world of hashing algorithms, emphasizing the irreversible nature of these functions. Learn why HASHBYTES, a widely-used function for creating hash values in
  • What is WebSQL?1/4/2024 11:55:46 AM. Explore the fundamentals of WebSQL, a deprecated but once widely used client-side storage solution for web applications. Learn its basics, from setting up a database to CRUD operations with SQL.
  • Create a Powerful RESTful API for SQL Server CRUD Operations1/4/2024 7:57:08 AM. Discover the world of building simple and effective APIs that talk to SQL Server databases. Learn how to safely handle data, improve performance, and get hands-on with coding examples for each CRUD op
  • Safely Changing the Instance Name of SQL Server1/4/2024 5:24:47 AM. Changing the instance name of a SQL Server involves several steps and should be done with caution. Secure process for changing the instance name of SQL Server. This guide ensures a smooth transition,
  • Query to Find and Drop User-Defined Stored Procedure1/3/2024 9:53:53 AM. In this article, we will learn about dangerous SQL scripts that iterate through user-defined stored procedures, views, functions, and user-defined types, dropping them one by one. Caution: Do not run
  • Connecting Postgres Database to Mobile App with Flutter and Dart1/3/2024 9:18:11 AM. Postgres Database to connect with your mobile app using Flutter and Dart
  • Connecting MySQL Database to Mobile App with Flutter and Dart1/3/2024 7:20:56 AM. MySQL Database to connect with your mobile app using Flutter and Dart
  • Truncate All Table Data in MSSQL1/2/2024 10:49:45 AM. In this article we will learn about how to truncate all tables in a SQL Server database using dynamic SQL. Exercise caution, as this operation deletes all data without the possibility of rollback. Lea
  • Azure Cosmos DB Interaction through Python1/2/2024 9:01:56 AM. This article speaks about the techniques to interact with Cosmos DB using Python. Azure Cosmos DB, a fully managed NoSQL and relational database for modern app development. Learn how to build a Python
  • Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET1/1/2024 7:47:53 AM. Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET: Best Practices and Code Examples
  • Consistency Levels in Azure Cosmos DB with an Example12/27/2023 8:15:56 AM. In this article, we will learn about the Azure Cosmos DB multiple consistency levels, including strong, boundless, session, consistent prefix, and eventual, with an example and scenario.
  • How To Create a WCF Service12/26/2023 8:48:44 AM. How can I create a WCF service that manages employee details while interacting with an SQL database, including the necessary SQL table script for employee information storage?
  • Table(s): Temp Table, Table Variable and CTE (Common Table Expression)12/26/2023 7:51:55 AM. This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
  • Cross Tab Report in Fabric Data Warehouse using PIVOT Operator12/26/2023 5:02:06 AM. The Pivot operator allows transforming rows into columns and performing aggregation on data. It improves the readability and clarity of the query. This video shows how to create cross-tab report in Fa
  • Creating Dynamic PIVOT Query in SQL Server12/23/2023 11:50:26 AM. In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
  • Inner Join SQL Query in Fabric Notebook using PySpark12/22/2023 5:15:40 AM. This video shows how to write inner join SQL Query in Microsoft Fabric Notebook using Spark.
  • Schemas in PostgreSQL12/20/2023 5:56:28 AM. Understanding Schemas in PostgreSQL. Explore the power of PostgreSQL's schemas—logical groupings of database objects. Learn how to create, manage, and leverage schemas for effective data organizat
  • MySQL: Unveiling its Versatility and Robustness for Diverse Use Cases12/20/2023 4:10:36 AM. Explore MySQL's diverse use cases in web applications, e-commerce, CMS, data warehousing, telecommunications, and finance. Dive into its key features, architecture, and crucial queries for efficie
  • Implement Entity Framework A Code First Approach in .Net 8 API12/18/2023 11:14:53 AM. In this article, we are going to discuss. How to implement Entity Framework a code first approach in .Net 8 API. In this approach, model classes and their relation are created first using the ORM des
  • Optimizing SQL Queries: CTE vs Temporary Tables for Speed12/17/2023 7:22:44 AM. In Microsoft SQL Server, there are different methods to enhance query performance: Common Table Expressions (CTE) and temporary tables.
  • Data Pipeline to Copy Data from Azure SQL Database to Fabric Data Warehouse12/13/2023 5:03:20 AM. Moving data in-between and across different technologies is one of the jobs of data engineers. In this new video, I demoed how to create data pipeline to copy data from Azure SQL Database to Fabric Da
  • Row Constructors in PostgreSQL12/13/2023 4:27:10 AM. Explore the power of row constructors in PostgreSQL, enabling efficient row-wise data manipulation. This guide covers syntax, applications in SELECT, INSERT, UPDATE, DELETE statements, and common use
  • CrateDB: Powering the Internet of Things12/11/2023 6:06:56 AM. CrateDB, an open-source distributed SQL database, is spotlighted for its efficacy in handling IoT complexities. This article explores use cases, including time-series data, analytics, and scalability,
  • Reduction Consumed Storage in SQL DB12/11/2023 5:10:53 AM. The simple way to reduce consumed DB storage on production app, with data migration and without dramatic changes in DAL (no additional services are required)
  • Bind Data In WebGrid Control Using Stored Procedure In ASP.NET MVC 4.0 And SQL Server12/7/2023 9:19:11 AM. In this article, you will learn how to bind the data in WebGrid control, using stored procedure in ASP.NET MVC 4.0 & SQL Server 2012.
  • How Configure User’s Profile in Server 201912/7/2023 6:22:57 AM. This article guides you through configuring user profiles on Windows Server 2019 for effective access control and privilege enforcement. Learn step-by-step procedures, including logon hours, log-on to
  • Getting Started with SQL Server 2022 SSDT 17.812/7/2023 6:12:21 AM. It breaks down complex concepts into easy-to-understand terms: SSDT, SSIS, SSAS, SSRS, ETL, SSOX, MDS, TDS and OLAP.