SQL Data Resources

Share

Related resources for SQL Data

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
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
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
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
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
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,
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
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
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.
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
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.
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
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.
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
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
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
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
Real-Time Pageview Tracking With .NET Core8/21/2024 5:28:26 AM. Learn how to implement real-time pageview tracking in your .NET Core application. This guide covers setting up live monitoring of website traffic, capturing pageview metrics, and integrating real-time
Why You Should Learn Azure Cosmos DB?8/20/2024 12:26:01 PM. Discover why learning Azure Cosmos DB is essential for modern data management. With its global distribution, scalability, and multi-model capabilities, Cosmos DB offers unmatched performance and high
SQL Server on Azure VMs vs Managed Instance vs SQL Database8/12/2024 11:18:45 AM. Based on the type of the cloud service each Relational azure service use and different aspects formulated the differences and uses cases when to use each database solution.
Difference Between Primary Key and Unique Key in SQL8/12/2024 9:38:24 AM. Primary Key and Unique Key are essential in relational databases for data integrity. A Primary Key uniquely identifies each row and cannot be NULL, while a Unique Key ensures column values are unique
Azure Data Factory: Clean and Transform Multiple Data using Dataflow8/8/2024 4:14:34 AM. In this Data Engineering episode, I covered how to use Azure Data Factory Dataflow to read, appends multiple CSV files from ADLS Gen2, clean and transform the data and sink to the Azure SQL Database f
Implement CI/CD for SQL Server with Visual Studio and Azure DevOps8/2/2024 8:44:29 AM. Implementing Continuous Integration and Continuous Deployment (CI/CD) for SQL Server databases ensures that database changes are automatically built, tested, and deployed to various environments.
What are Azure Resources and Resource Groups8/2/2024 6:21:11 AM. Azure Resources are individual cloud services like virtual machines, app services, and storage accounts. Each resource serves a specific purpose, such as data storage or application hosting. Azure Res
Basics of Working With Windows Azure Table Storage8/2/2024 5:08:21 AM. Learn how to efficiently store and manage large datasets in the cloud, explore key features, and get practical tips for data organization, querying, and performance optimization in Azure Table Storage
Training a Small Language Model AI Using Text Files, C#, and SQL Database7/29/2024 10:57:22 AM. This article guides you through training a small language model AI using text files, C#, and an SQL database. It covers preparing text data, setting up an SQL database, tokenizing data with C#, and q
Azure Cosmos DB for Modern Applications7/10/2024 1:59:24 PM. Dive into Azure Cosmos DB with our comprehensive guide tailored for modern applications. Explore its scalable NoSQL capabilities, global distribution, multi-model support, and robust partitioning stra
Implementing MongoDB with .NET7/8/2024 7:45:54 PM. Learn to implement CRUD operations, manage data efficiently, and leverage the power of MongoDB's NoSQL capabilities alongside the robust .NET framework for scalable backend development.
Audit Trail And Data Versioning With C# And MVC6/26/2024 10:24:23 AM. This article describes implementing an audit trail and data versioning system using C# reflection and SQL databases. It focuses on medical records applications, outlining database setups, MVC applicat
Implementing MongoDB with .NET6/26/2024 6:35:29 AM. Learn essential techniques for data persistence, leveraging MongoDB's document-oriented structure, implementing CRUD operations with C#, and optimizing performance using the MongoDB .NET driver.
Integrating Azure SQL Database with Azure Functions6/17/2024 9:26:04 AM. Azure SQL Server is a fully managed database service by Microsoft Azure, offering scalability, high availability, and robust security features. It integrates seamlessly with Azure Functions for buildi
DuckDB: The Powerful Embedded Database for Analytics6/16/2024 8:32:17 AM. DuckDB is a high-performance, embedded database designed specifically for data analytics. It offers in-memory processing, SQL support, and columnar storage, making it ideal for analytical queries and
Automate MySQL Database Updates with Cron Jobs in Node.js6/13/2024 7:59:28 AM. Learn how to automate MySQL database updates using cron jobs in Node.js with this comprehensive step-by-step guide. Discover how to schedule tasks, write automated scripts, and maintain your database
Fetching Data From XML File To SQL Database6/12/2024 7:01:05 AM. This article provides tips on creating an SQL table using an XML file and importing data into it. It covers creating a DataTable from an XML file, generating an SQL table from the DataTable, and using
Database Options in Google Cloud Platform (GCP)6/11/2024 9:07:16 AM. GCP offers diverse database services tailored for various needs, from relational databases like Cloud SQL and AlloyDB for structured data to NoSQL options like Firestore and Cloud Bigtable for large,
Mongo DB Indexing Strategies with Real-time Scenarios6/3/2024 9:45:25 AM. MongoDB, a scalable NoSQL Database, uses indexing to optimize query performance. Indexing involves creating data structures to expedite data retrieval operations on collections, enhancing efficiency.
How To Quickly Change Azure SQL Database Service Level Objectives5/3/2024 9:01:57 AM. To swiftly adjust Azure SQL Database Service Level Objectives (SLOs), utilize Azure Portal's intuitive interface or T-SQL commands for efficient performance tuning. Consider migrating between DTU
Getting Started Wth MongoDb Atlas4/26/2024 12:00:41 PM. Learn how to get started with MongoDB Atlas, a cloud-based database service that offers a scalable and flexible solution for managing NoSQL databases. Explore data modeling, cluster configuration, and
Ingest Data into Azure SQL Database using SSMS4/25/2024 6:43:37 AM. This video shows how to ingest data into Azure SQL Database using SQL Server Management Studio.
Create, Copy, Rename And Delete SQL Database In Azure4/13/2024 6:14:54 PM. Learn to manage SQL databases in Azure: create, copy, rename, and delete. Follow step-by-step instructions using Azure portal and SQL Server Management Studio. Efficiently handle database tasks for ef
Create A Database Project From Existing SQL Database 4/11/2024 7:03:00 AM. In this post, we will see how to create a database project from existing SQL database. We will modify the project by adding a table into the project and add seed data through post deployment script. W
Learn About Power BI Data Source Options And SQL Database Connection - Part One4/4/2024 7:25:57 AM. Explore Power BI's diverse data source options and its seamless connection to SQL databases in this informative series. Learn about querying, data integration, visualization, and more in Part One,
Contained Database - No Need For Server Level Logins Anymore3/28/2024 10:34:38 AM. Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained database is a database that is completely un-reliant on the instance of SQL
Save Money On Your Azure Monthly SQL Database Bill3/28/2024 10:33:58 AM. Optimize Azure SQL Database costs by leveraging pricing tiers, reserved capacity, and performance tuning. Monitor resource utilization, scale efficiently, and implement cost-effective strategies to sa
What Is Automatic Tuning In Azure SQL Database3/28/2024 6:37:39 AM. Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many times they were of questionable merit. We have all seen the dreaded dta_index names
SQL Data Discovery And Classification In SSMS3/28/2024 6:32:31 AM. SQL Data Discovery and Classification in SSMS allows users to identify and categorize sensitive data within databases, aiding in compliance with regulations like GDPR. Enhance data security and govern
Configuring Git in Azure Data Studio for SQL & Synapse Pools3/21/2024 8:30:14 AM. In this article, we'll delve into the process of configuring Git to manage database objects within a Synapse Dedicated Pool environment (or Azure SQL Database) using Azure Data Studio.
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.
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
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.
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
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.
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
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
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
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?
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
How to create a Microsoft Azure SQL Database in serverless compute tier from the Azure Portal12/3/2023 1:28:43 PM. This article focuses on the swift creation of a serverless Azure SQL Database via the Azure Portal.
Improving SQL Table Data Performance11/1/2023 12:11:56 PM. This article discusses strategies and best practices for optimizing SQL table data performance. Topics covered include indexing, normalization, partitioning, data types, query design, monitoring, hard
ASP.NET Core Web API for CRUD Operations with MySQL9/25/2023 8:20:01 AM. Creating a CRUD (Create, Read, Update, Delete) API in ASP.NET Core with a MySQL database is a common scenario in web development. In this article, we'll walk through building a complete ASP.NET Co
Event Trigger Power BI Entities Refresh via Azure SQL Database9/23/2023 9:49:07 AM. Event Trigger Power BI Entities Refresh via Azure SQL Database
Grant Admin Access on a Schema in Azure SQL Database9/22/2023 11:23:28 AM. Grant Admin Access on a Schema in Azure SQL Database. This guide explains how to grant admin access to an Azure AD group for a specific schema within the Azure SQL Database, including necessary SQL st
Simplify Your Data Access with Dapper.NET8/31/2023 9:56:55 AM. Discover the agility of Dapper.NET, a micro-ORM. Harness its speed and raw SQL support for streamlined, high-performance data retrieval, even for stored procedures.
Quickly Determining Azure SQL Database Size8/22/2023 6:40:17 AM. In this article, I'll show you a quick and easy way to determine how much space your Azure SQL Databases are consuming.
How to Connect a SQL Server Data Source to Grafana and Creating a Dashboard8/16/2023 8:48:33 AM. One such powerful integration is connecting a SQL Server data source to Grafana, enabling users to display, analyze, and monitor data from their SQL databases in a visually appealing and informative m
How to Import a MySQl Database Table Into Excel?8/10/2023 4:58:09 AM. In this article we will learn how to import a database table into Excel in a MySQL server.
Display Data In GridView Using MySQL8/6/2023 8:53:15 AM. In this article we have to create an ASP.NET website using the DropDownList with the help of the GridView.
Install MySQL Connector in Visual Studio 20128/3/2023 9:33:13 AM. This article shows you how to install the MySQL Connector, create a MySQL database and check the MySQL version.
How To Import Large SQL Database Files Into MySQL Using Command Line8/3/2023 6:36:30 AM. In this article you will learn how to Import large SQL Database Files into MySQL using Command Line.
Microsoft Azure Synapse Analytics and Data Warehousing8/2/2023 7:28:11 AM. Learn about the significance of data warehouses as centralized data repositories, their key features, and their role in enabling data reporting, analysis, and business intelligence (BI) in diverse ind
What Are NoSQL Databases8/1/2023 10:01:23 AM. NoSQL databases are the databases that do not use SQL as their primary data access language. Graph database, network database, object database, and document databases are common NoSQL databases. This
How to Retrieve Data From MYSQL Database in C#7/31/2023 8:38:44 AM. Install MySQL Connector/NET: Before you start, make sure you have MySQL Connector/NET installed in your C# project. You can download it from the MySQL website or use NuGet to install the package.
Functions In SQL Server: A Beginner's Guide7/24/2023 8:59:25 AM. This article explains how to create functions in SQL Server using the SQL function operator.
How To Configure SMTP O365 Migration Using TLS 1.2 For SQL Database Mail7/6/2023 4:49:23 AM. This article will explain to you how exactly you need to configure TLS 1.2 as a default protocol and setup SMTP O365 migration using SQL 2012 Database mail and above versions for Windows Server 2012 a
How to Create Azure SQL Server Database in the Microsoft Azure Portal?6/22/2023 10:40:30 AM. Step by step details to create azure sql database server in the Microsoft Azure Portal
How to Connect to Azure SQL Database in the Azure Data Studio?6/5/2023 6:51:18 AM. Step by step process to connect to Azure SQL Database in the Azure Data Studio
Demystifying Azure SQL Database Service: Quick Start Comprehensive Guide5/10/2023 8:26:24 AM. In this article describes about how to create and deploy Azure SQL Database service.
DataBase Connectivity In JavaScript5/5/2023 5:27:20 AM. In this article I will explain how to connect to a SQL database with JavaScript and how to get data from the database.
Introduction To MySQL5/1/2023 10:12:53 AM. In this article, we will read about Introduction to MySQL, its advantages and disadvantages.
How To Connect To Azure SQL Database With MuleSoft4/29/2023 12:26:32 PM. In this article, you will learn how to connect to Azure SQL Server database with MuleSoft SQL database connector.
Fetch MySQL Data Using Database Connector in MuleSoft4/29/2023 12:24:04 PM. In this article, you will learn how to get MySQL data using Database Connector in MuleSoft.
What is SQL? Learn SQL and Download Free SQL Book3/20/2023 12:22:18 AM. SQL stands for Structured Query Language. This article teaches you the basics of SQL and how to write SQL queries.
Getting Started With Azure SQL Database2/28/2023 10:33:15 AM. In this article, you will learn about Azure SQL Database.
SQL Server Text Data Manipulation2/28/2023 5:47:07 AM. In this article I explain most of the SQL Server functions for manipulating text.
Creating Your First Azure SQL Database And Configure Firewall Settings2/16/2023 10:38:10 AM. In this article, we will try to understand Azure SQL database service, and also create our first Azure SQL Server database. We will also configure require firewall settings to connect Azure SQL using
Generate and Publish SQL Database Scripts2/16/2023 5:50:48 AM. This article helps to generate and publish SQL Database scripts.
Creating An Azure SQL Database2/14/2023 10:36:37 AM. In this article, you will learn about Azure SQL Database. SQL Database is a high-performance reliable cloud database. It is a managed cloud databaseas-a-Service (SaaS) that uses the SQL Server databa
SQL Server Integration Services (SSIS) - Transforming SQL Data to Excel Sheet2/14/2023 4:15:28 AM. In this article, we will see how data can be transferred from SQL Server DB to an Excel sheet.
DATABASEPROPERTYEX Function in SQL Server2/13/2023 5:11:03 AM. In this article, I would like to show how to extract the metadata about a database in SQL Server.
How To Get SQL Server Database Size In C#2/7/2023 8:58:25 AM. This article shows how we can determine the size of an entire database using C# and the size of each and every table in the database using a single SQL command.
Execute A Stored Procedure Programmatically2/3/2023 8:10:44 AM. In this article, I will explain how to create a Stored procedure (SP) and execute an SP programmatically.
Connecting to MySQL Using C#.NET1/4/2023 10:07:58 AM. This article shows you how to connect to a MySQL database using the MySQL Connector for .NET. I will also show you how to update MySQL database records using C#.
Tips to Improve SQL Database Performance1/2/2023 4:16:56 AM. Performance of data-centric apps heavily rely on the performance of backend API and database. Here are some tops to improve SQL performance.
How To Recover Deleted Data In Azure SQL Database12/12/2022 7:08:48 AM. In this article, you will learn how to recover deleted data in azure sql database.
Difference Between Char, Nchar, Varchar and Nvarchar Data Types in SQL Server12/9/2022 4:11:55 AM. Do you wonder the difference between nvarchar vs varchar? This article discusses the differences between CHAR, VARCHAR, NCHAR and NVARCHAR data types. CHAR vs VARCHAR, NCHAR vs NVARCHAR, difference be

Topics