SQL Data Resources

Share

Related resources for SQL Data

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
Export Microsoft SQL Data To CSV Using Python11/1/2022 5:40:41 AM. In this article, you will learn how to create REST API to read Microsoft SQL table and export the result to CSV file using Python. I have created a simple Microsoft SQL table for this demo named as Em
CURD Azure SQL Database Dapper And Repository Pattern Using ASP.NET Core 6 MVC9/14/2022 11:23:03 AM. In this article, will learn CURD (Create, Update, Read and Delete) operation which common for all the applications. Here will understand Azure SQL Database, Dapper Micro-ORM (Object Relation Mapper) a
How To Create Azure SQL Database Using Azure Portal8/30/2022 6:58:17 AM. Azure SQL Database is a relational database as a service (DaaS) based on the latest stable version of the Microsoft SQL Server database engine.
How To Resize Azure SQL Database7/7/2022 4:54:39 PM. In this article, you will learn how to Resize the Azure SQL Database.
How To Restore Same Database With Different Names In SQL Server6/29/2022 4:44:49 AM. This tutorial will show you the steps to restore the same database with different names in SQL Server
Configuring A Failover Group For A Production Database In Azure6/15/2022 1:27:37 PM. In this article, you will learn how to configure a failover group for a production database in azure.
How To Use Azure SQL Database In Power BI Reports6/10/2022 12:20:11 PM. In this article, you will learn how to Use Azure SQL Database in Power BI Reports.
Insert, Update, Delete, Display Data in MySQL Using C#5/12/2022 2:49:18 PM. This article shows how to insert, update, delete and display data in MySQL.
Restore SQL Server Backup File With C#4/6/2022 11:41:53 AM. In this article, I would like to show how to restore a SQL Server Backup file in C#.
Create Azure SQL Server And DTU Based SQL Database With TDE State Enabled Using PowerShell Script4/4/2022 12:15:21 PM. This article is focused on creating an Azure SQL Server to a newly created Resource Group and then creating a SQL Database of Basic Edition with DTU capacity with its TDE (Transparent Data Encryption)
Create A Transactionally Consistent Clone Of A Database In Azure SQL Database3/26/2022 10:30:41 AM. In this article, you will learn how to create a transactionally consistent clone of a database in Azure SQL database.
Creating SQL Server Backup File With C#2/4/2022 11:06:25 AM. In this article, I would like to show how to create SQL Server Backup file in C#.
Easy Way To Build Single Database In Azure SQL Database1/21/2022 2:50:33 PM. Easy way to build a single database in Azure SQL Database
Advanced Entity Framework Core - Output EF SQL Queries To The Console And Tips To Setup Dbcontext With The Development In Mind1/11/2022 3:12:51 AM. When you work with abstractions over SQL Database you may be wondering what does Entity Framework constructs from your Linq queries. To get a clue on it here are 3 options. Tips to setup DbContext wit
Azure SQL Database - Create Single Serverless Database12/20/2021 7:08:18 AM. In this article, we'll learn about Azure SQL Database and how to create a serverless database in Azure.
Azure Data Studio - Create, Query And Delete In Azure SQL Database 12/16/2021 2:36:12 PM. This article dives in creating tables, working with queries and delete the data in Azure SQL Database from Azure Data Studio
Azure Data Studio - Connecting To Azure SQL Database12/15/2021 2:16:12 PM. In this article, we’ll learn to connect and access the Azure SQL Database through the Azure Data Studio.
Filter Real-Time Error Rows From CSV To SQL Database Table In Azure Data Factory - Part Two12/9/2021 11:06:14 AM. In this article, you will learn about Filter Real-Time Error Rows from CSV to SQL Database Table in Azure Data Factory.
Use Dynamic Data Masking To Protect Sensitive Data In Azure SQL Database9/1/2021 11:07:42 AM. In this article, you will learn how to use dynamic data masking to protect sensitive data in Azure SQL database.
Azure AD Authentication For Azure SQL Server Managed Databases8/10/2021 12:55:31 PM. In this article, you will learn about Azure AD Authentication for Azure SQL Server Managed Databases.
How Azure Can Help Your Company Expand In Multiple Regions (2 Of 5)7/19/2021 2:26:46 PM. In today’s article, I am going to start guiding you by implementing the proposed architecture by creating an Azure SQL database resource in our main company’s database in Montana, replicating it in Eu
Add Azure Cache for Redis to Your Azure SQL Performance Tuning Toolbox7/14/2021 2:35:12 PM. Using Cache in Azure to offload your repeatable workloads
How Azure Can Help Your Company Expand In Multiple Regions - Part I7/3/2021 6:04:53 AM. This month, I want to do something different. Typically, I discuss standalone topics related to an overall theme without really connecting each of them. But this time, I will guide you through a real-
How To Connect Azure SQL Data With Power BI Via Direct Query6/29/2021 6:58:24 AM. In simple words It's allow to connect data directly from the source repository, known as DirectQuery.
How To Create A Single Database In Azure SQL Database6/19/2021 5:05:28 PM. In this article, you will learn how to create a single database in Azure SQL Database
How to Bind Data From MySQL Database to GridView in ASP.Net 4.55/25/2021 11:38:33 AM. This article shows how to bind data from a MySQL database to a GridView in ASP.Net 4.5.
Various Types of Search on Database and Display Results on GridView5/25/2021 6:35:19 AM. This article explains how to apply various types of search on a database and display the results in a GridView.
Simple MySQL Transaction in ASP.Net5/24/2021 6:43:08 AM. In this article, I explain how to insert data into multiple tables using a MySQL Transaction in ASP.NET.
Business Continuity And Disaster Recovery In Azure For SQL Database5/19/2021 12:40:03 PM. Today, we dive into the Business Continuity and Disaster Recovery services and features needed for enterprise grade system.
Learn About Azure SQL Database5/12/2021 1:43:32 PM. In this article you will learn about Azure SQL Database.
Getting Started With MongoDB For Beginners4/22/2021 2:04:51 PM. MongoDB has been developed since 2007 by MongoDB. This company was then working on a Cloud computing system, widely distributed data computing, similar to the service Google's Google App Engine. I
Configuration PostgreSQL Database On Heroku 2/5/2021 2:51:34 PM. Heroku offers a free plan for PostgreSQL databases hosting on their server. Very effective and easy way quickly hosted free PostgreSQL database on a server for experimentation or prototyping. In this
Overview of Open Source Postgre SQL Database1/29/2021 10:10:38 AM. This article provides a brief overview of Postgre SQL Database.
How to Create a PostgreSQL Server on Google Cloud Platform SQL Database Service1/29/2021 6:10:05 AM. In this article, you will learn how to create a PostgreSQL Server on the Google Cloud Platform SQL Database service.
What is Azure SQL Database?1/11/2021 9:59:27 PM. Learn what Azure SQL database is, and when and why you should use it.
Export SQL Data to Excel Using ASP.Net11/24/2020 4:12:39 AM. This article explains how to export SQL Data to Excel using ASP.NET.
Data Binding in WPF DataGrid Control Using MySQL Database11/23/2020 7:23:10 AM. This article explains how to use a DataGrid control in WPF and binding to a DataGrid in a WPF 4.5 application.
MySql database connectivity with ASP.Net11/1/2020 9:02:26 AM. In this we will learn how to connect MySql database with ASP.NET.
Connecting to a MySQL Database in ADO.NET10/30/2020 1:57:58 AM. In this article I will explain Connecting to a MySQL Database in ADO.NET.
How To Quickly Change Azure SQL Database Service Level Objectives8/30/2020 3:01:55 AM. In this article, you will learn how to Quickly Change Azure SQL database service Level Objectives

Topics