SQL Database Resources

Share

Related resources for SQL Database

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.
How To Configure SMTP O365 Migration Using TLS 1.2 For SQL Database Mail6/7/2022 2:08:26 PM. 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
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)
Connecting to MySQL Using C#.NET3/28/2022 10:51:10 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#.
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.
Quickly Determining Azure SQL Database Size7/21/2021 4:03:20 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 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 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
Functions In SQL Server2/8/2021 11:37:24 AM. This article explains how to create functions in SQL Server using the SQL function operator.
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.
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 Get The Entire Database Size Using C# In SQL Server10/13/2020 10:30:27 PM. 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.
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
Compare And Update SQL Server Database Project With Visual Studio8/24/2020 2:54:59 AM. In this article, you will learn how to create a SQL Server Database project using Visual Studio 2019 and how to compare and update the SQL Server Database Project from the remote SQL Server Database a
Caution When Dropping Unused Indexes On An Azure SQL Database8/13/2020 8:48:40 AM. In this article, you will learn how to drop Unused Indexes on an Azure SQL Database.
How to Import a MySQl Database Table Into Excel8/6/2020 2:01: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/2020 1:59:29 AM. In this article we have to create an ASP.NET website using the DropDownList with the help of the GridView.
What Is Azure SQL Database Serverless7/1/2020 10:51:03 PM. In this article, you will learn about Azure SQL Database Serverless.
MongoDB Data Types (Day 5)6/15/2020 1:08:05 AM. In this article, you will learn about various data types in MongoDB databases.
Using MongoDB With ASP.NET Core Web API6/1/2020 5:33:14 AM. A common term we hear nowadays is NoSQL databases. These are being very strongly promoted by all vendors. One of the most common NoSQL databases these days is MongoDB. In this article, we will discuss
How to Create an Azure Back-End for a Xamarin.Forms Application - Part Two4/9/2020 3:49:40 PM. This is the second and final part of the article about how to create an Azure Back-End for a Xamarin.Forms application.
DataBase Connectivity In JavaScript4/8/2020 11:41:25 AM. In this article I will explain how to connect to a SQL database with JavaScript and how to get data from the database.
MongoDB Advace Search (Day 8)3/29/2020 1:06:22 PM. In this article, you will learn about the find method in MongoDB.
Azure SQL Database - Great Choice For Modern Cloud Applications3/28/2020 1:20:47 AM. In this article, you will learn about Azure SQL Database - Great Choice for Modern Cloud Applications.
Performing CRUD Operations In Azure SQL Database2/24/2020 9:02:26 AM. In this article, i am going to explain about how to performing CRUD operations in Azure SQL Databases.
Creating A SQL Database In Azure Cloud2/24/2020 9:01:20 AM. In this article, i am going to explain about how to create a SQL database in Azure cloud
Python With SQL Server Database2/17/2020 3:31:31 AM. This article explains you how to store your data into SQL Server database and retrieve that.
Oracle Database Server To SQL Server Migration 2/11/2020 11:01:56 PM. In this article, you will learn about Oracle Database Server to Microsoft SQL Database Server Migration.
Create Your SQL Database In Azure Portal12/13/2019 9:36:47 AM. We can create the SQL database that we want with the help of Azure portal.
Create A Database Project From Existing SQL Database 12/8/2019 1:58:23 PM. 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
Create, Copy, Rename And Delete SQL Database In Azure11/26/2019 8:35:19 AM. In this article, you will learn how to create, copy, rename and delete a SQL database in Azure.
Comparing AWS SQL Server With Azure SQL Database - Scalability11/25/2019 8:25:18 AM. In this article you will learn about comparing AWS SQL Server with Azure SQL Database - Scalability.
How To Connect to a Database In TypeScript10/16/2019 6:38:31 AM. In this article I will explain how to connect to a SQL database with TypeScript in a web application and how to get data from the database in TypeScript.
Comparing AWS SQL Server With Azure SQL Database - Part Two10/15/2019 9:50:49 PM. In this article, you will learn how to compare AWS SQL Server with Azure SQL Database.
Comparing AWS SQL Server With Azure SQL Database10/15/2019 7:02:20 AM. In this article, I will provide an overview of some of the major differences between the AWS RDS SQL Server service and the Azure SQL Database service.
Getting started with Azure VM, Azure SQL Database and Nopcommerce 4.20 installation.10/9/2019 11:27:32 AM. In this article, we will learn about how to install Azure VM (Virtual Machine) and Azure SQL Database in Microsoft Azure Portal with Deployment of nopcommerce 4.20.
Data Architecture - Choosing The Right Database 9/23/2019 11:54:01 PM. This article describes basic design considerations and addresses necessary architectural concerns while choosing the right database for the Enterprise.
What Are NoSQL Databases9/19/2019 5:24:33 PM. 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
Backup and Restore an Azure SQL Database9/4/2019 1:01:52 AM. In this video, we will discuss how to take manually DB Backup and restore into the Local server environment and how to change the backup retention period.
Azure SQL Database In PaaS Model8/27/2019 8:42:02 AM. In this article, we are going to see how to build the Azure SQL Database without Virtual Machines.
Azure SQL Database IP Firewall Rules7/31/2019 2:00:31 AM. In this video, you will learn about the security features of Azure SQL Database. We will dive deep into Azure SQL Database IP Firewall rules.
Azure SQL Database DTU Calculator7/22/2019 10:20:25 PM. DTU Calculator provides information about service tier, performance level, and DTU recommendation based on your current on-premise workload.
Elastic Pools For Azure SQL Server Database7/16/2019 8:41:25 AM. In this video, we will get an overview of Elastic Pools in Azure SQL Server Database and how to use it in our application.
Tips to Improve SQL Database Performance7/4/2019 12:25:52 AM. The performance is main concern of any application. Database plays very important role in application. There are some points that can help us to improve the performance of SQL Server.
Get the Count or List of Columns of a Table in SQL Server7/2/2019 5:49:53 AM. In this article, I will show how to count the number of columns in a table that exists in your database.
Azure Active Directory User/Group And Azure SQL Database6/5/2019 9:53:20 AM. Azure Active Directory (AD) can be utilized to access several Azure resources like Azure SQL Database, Azure SQL Data Warehouse, Office 365, Salesforce, Dropbox, Adobe Create Cloud and more.
Azure SQL Database - Create And Connect SQL Database In The Azure Portal5/14/2019 7:05:35 PM. This article explains how to create and connect Azure SQL database to the Azure portal.
SQL Database Query Editor In Azure Portal - An Introduction1/16/2019 11:47:22 PM. Learn SQL Database Query Editor In Azure Portal.Query Editor is a great tool but it has very limited features. It has a subset of the functionality of SQL Server Data tools and SQL Server Management S
Use SQL Server Management Studio 🌐 To Connect Azure🛢️SQL Database12/31/2018 8:54:04 AM. In this article, we will learn how to use SQL Server Management Studio to connect and query the Azure SQL database.
Create A SQL Database 🛢️ In Azure Portal12/28/2018 9:48:45 AM. In this article, we will learn how to create an Azure SQL database in the Azure portal and create a sample database.
Introduction to NoSQL Concept12/25/2018 11:54:51 PM. This article introduces the NoSQL concept. There are many NoSQL databases available like MongoDB, Elastic Search and Hadoop and so on.
How to Save Image Path in Database Using MySQL & C#12/3/2018 11:22:57 PM. In this article we will first create a table in a MySQL database and then we will use a Windows Forms application to save an image into the My SQL database.
BizTalk SQL Database - Configuration Errors And Resolution11/29/2018 9:46:00 AM. This article is intended to be a knowledge base of BizTalk SQL database configuration Errors, Causes, and Resolutions documented in all stages/components of BizTalk. If database not configured in the
ASP.NET MVC 5 - Upload Image/File Into Database11/27/2018 10:55:00 PM. This article is about uploading of the image file into the database on ASP.NET MVC5 platform. I shall be demonstrating uploading of the image file into the database on ASP.NET MVC5 platform. This arti
Microsoft Azure: Load Data On Azure SQL Database11/16/2018 2:44:16 AM. This video is about loading data on Azure SQL database by using SQL Server Management Studio 2014.
Some Common Mistakes When Querying SQL Database11/12/2018 5:10:18 PM. When I started learning SQL, I found out several issues, which I thought to be interesting to share. For our needs, let us use AdventureWorks2012 database, which can be obtained here.
Querying Azure SQL Databases In Databricks Spark Cluster8/27/2018 9:29:51 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.
Save Money On Your Azure Monthly SQL Database Bill8/22/2018 8:42:27 AM. Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model (logical CPU’s). Both options allow you to scale up or down based on your compute and sto
How To Use Join Operation With Multiple SQL Database Tables Using LINQ8/15/2018 11:41:30 PM. In this article, I will demonstrate how we can perform join operation with multiple SQL database tables using Language-Integrated Query (LINQ).
Fetching Data From XML File To SQL Database6/7/2018 11:18:16 AM. Creation of SQL table by using xml file, and importing data from xml file to SQL table.
How To Create SQL Database In AWS5/4/2018 9:23:21 AM. In this article, we will see how to create SQL Server in AWS.
How To Create Your First SQL Database In Azure Platform5/3/2018 9:05:23 AM. In this article, we will discuss the Azure SQL Database and create our first SQL Database in Azure Platform.
Creating SQL Database In Azure Portal3/28/2018 12:15:44 AM. In this series, i am gonna teach you how we can develop RESTful API in Asp.Net and how we can consume this RESTful API in Xamarin.Android. In the first episode, i will create SQL database in Azure por
Pre-Deployment And Post-Deployment Script - SQL Database Project3/20/2018 9:56:35 AM. In this article, we will learn Pre-Deployment And Post-Deployment Script on SQL Database Project.
Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part One1/30/2018 11:08:03 PM. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. Thi
Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part Two1/30/2018 10:54:09 AM. Normally, you would want to put your css classes in the .scss file (i.e. YourWebpartName.scss) and import it into the YourWebpartName.ts file (this is actually done automatically during project creati
Store And Retrieve Using FILESTREAM From SQL Database1/6/2018 4:42:46 AM. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my prev
Create Your First Azure SQL Database Using Azure Portal 12/14/2017 12:29:33 PM. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question h
Creating A SQL Database And SQL Server On The Azure Portal11/20/2017 10:10:01 AM. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
How To Create A SQL Database In Azure11/3/2017 12:40:15 PM. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure data
Create An Azure SQL Database Using PowerShell11/3/2017 12:06:05 PM. A resource group is a logical container into which Azure resources are deployed and managed as a group. So let's create a resource group for that using New-AzureRmResourceGroup command.

Topics