SQL Database Resources

Share

Related resources for SQL Database

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.
Functions In SQL Server8/20/2019 9:29:53 AM. This article explains how to create functions in SQL Server using the SQL function operator.
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.
Introduction to Azure SQL Database (PaaS)7/8/2019 1:15:57 AM. In these videos, we will learn about Azure SQL Database, types of Azure SQL database, purchasing models, migration of it from On-premise to Cloud, and the limitations of Azure SQL Database.
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.
Connecting To MySql Database In Strapi9/4/2017 12:22:36 AM. This article helps you to create a connection to the My SQL database using the Strapi; this is an article for the beginners where the basic connection can be created with the existing MySQL database.
Load Twitter Data Into SQL Database8/15/2017 10:44:40 AM. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that
Compare Azure SQL Database And Azure SQL Data Warehouse8/5/2017 1:17:53 PM. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
How To Use Visual Studio For Azure SQL Database7/31/2017 11:33:02 AM. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
How To Use Query Editor For Azure SQL Database In Azure Portal7/24/2017 5:21:46 PM. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
Creating An Azure SQL Database And Connecting Through SQL Server Management Studio7/23/2017 11:59:20 AM. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
Connecting And Working With Azure SQL Database Using Visual Studio 20177/12/2017 10:40:08 AM. This article shows how to connect and work with the Azure SQL Database. In this article, I am going to demonstrate how to connect and work with the Azure SQL Database using Visual Studio 2017.
Creating And Using Azure SQL Server And Azure SQL Database7/9/2017 1:36:31 AM. This article helps you in creating and using SQL Server and SQL database.
Deploying An Azure SQL Database In Microsoft Azure Portal7/3/2017 12:06:20 PM. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.
How To Create Azure SQL Database And Access It Through Visual Studio Code6/28/2017 5:55:04 AM. In this article, I’m going to cover how to create Azure SQL database and how you can access it through Visual Studio code.
Simple Insert Select Update and Delete in ASP.NET Using MYSQL Database5/22/2017 11:00:54 AM. This article explains how to insert Select, Update and Delete data into a MySQL database from an ASP.NET web application.
Creating Azure SQL Database5/10/2017 10:20:54 AM. This article enables you to create an Azure SQL database.
Fetch Data From Azure SQL Database Using Nintex Workflow NWC (Nintex Workflow Cloud)3/30/2017 12:37:12 AM. Fetch data from Azure SQL database using Nintex Workflow NWC (Nintex Workflow Cloud).
Creating An Azure SQL Database As A Federated Data Source In Azure Data Lake Analytics - Part Two2/15/2017 3:33:09 PM. In this article, you will learn how to create an Azure SQL database as a federated data source in Azure Data Lake Analytics.
Creating an Azure SQL Database As A Federated Data Source In Azure Data Lake Analytics2/13/2017 9:58:50 AM. In this article you will learn how to create an Azure SQL database as a federated data source in Azure data lake analytics.
Introduction To SQL Database Query Editor In Azure Portal2/1/2017 10:22:28 AM. In this article, you will learn how to use SQL Database Query Editor in Azure Portal.
Create Azure SQL Databases And Connect To The Local System1/9/2017 11:58:29 AM. In this article you will learn how to create Azure SQL Databases and connect to the local system.
Azure SQL Database - Restore DB From Long Term Retention Backup11/24/2016 12:14:42 PM. In this article, you will learn how to restore DB from Long Term Retention Backup.
Create A SQL Database In ASP.NET Web Form Using Visual Studio 2015 Update 311/5/2016 5:11:40 PM. In this article, you will learn how to create SQL database in ASP.NET, using Visual Studio 2015.
Creating New SQL Database And Table With Azure10/11/2016 10:56:36 AM. In this article, you will learn how to create new SQL database and table with Azure.
Getting Started With Azure SQL - Part Three10/6/2016 2:26:09 PM. In this article, you will learn how to delete Azure SQL database and Azure SQL Server.
How To Create Azure SQL Database (Cloud)9/19/2016 12:39:32 AM. This video tutorial explains how to create Azure SQL database (Cloud).
Create A New Azure SQL Server-Level Firewall - Part Three9/12/2016 1:48:43 PM. In this article, you will create a new Azure SQL Server-level Firewall, using Azure portal.
Create A New Azure SQL Database – Part Two9/11/2016 4:06:21 PM. In this article you will create a New Azure SQL Database by using Azure Portal.
MySql Database In ASP.NET Using C# With ODBC Connector9/11/2016 1:26:47 PM. In this article, we are going to learn, how to connect MySql database in C# .NET with ODBC Driver.
Create Backup (.BAK) File Of SQL Database Using SQL Server Job Agent9/6/2016 11:14:33 AM. In this article, you will learn simple steps to create backup files of SQL database, using SQL JOB.
AngularJS CRUD Operations With Web API Using SQL Database8/17/2016 1:53:49 AM. In this article you will learn CRUD operation in MVC with AngularJS using Web API with SQL Server database.
Creating Microsoft Azure SQL Database8/15/2016 9:53:27 AM. In this article, you will learn, how to create Microsoft Azure SQL Database.
Create And Setup A SQL Database Using Azure Cloud8/2/2016 10:43:57 AM. In this article, you will learn how to create and setup a SQL database, using Azure Cloud.
Create And Manage Azure SQL Database7/26/2016 1:50:10 PM. In this article, you will learn how to create and manage Azure SQL Database.
Integrate Azure SQL Database With .NET Website7/15/2016 2:06:49 PM. In this article, you will learn how to integrate Azure SQL Database with .NET website.
Integrate Azure SQL Database With PHP Website7/15/2016 1:58:02 PM. In this article, you will learn how to integrate Azure SQL Database with PHP website.
Getting Started With SQL Database On Microsoft Azure7/14/2016 1:20:57 PM. In this article, you will learn about SQL database on Microsoft Azure.
Migrating On-Premise SQL Server Database To Azure SQL Database5/17/2016 10:05:32 AM. In this article you will learn how to migrate On-Premise SQL Server database to Azure SQL database.
How To Import Large SQL Database Files Into MySQL Using Command Line4/30/2016 5:25:10 PM. In this article you will learn how to Import large SQL Database Files into MySQL using Command Line.
Create SQL Database In Azure And Connect It With SSMS4/27/2016 4:05:16 PM. In this article, you will learn how to use Azure Portal to create a database and host it on SQL Server Management Studio.
Save And Retrieve Dynamic TextBox Values In GridView to SQL Server4/18/2016 5:23:11 PM. In this article you will learn how to save and retrieve dynamic TextBox Values in GridView to SQL Server.
Distinguish Temporal Tables In Azure SQL Database4/4/2016 11:26:09 AM. In this article you will learn how to distinguish temporal tables in Azure SQL Database.
Getting Started With Azure SQL Data Warehouse4/4/2016 11:03:53 AM. In this article you will create a SQL Data Warehouse in just a few steps by using Microsoft Azure.
Archive SharePoint List Items To SQL Database using CSOM - Part Two3/9/2016 12:45:15 PM. In this article you will learn how to archive SharePoint List Items to SQL Database using CSOM.
Archive SharePoint List Items to SQL Database Using CSOM: Part One3/9/2016 9:41:36 AM. In this article you will learn how to archive SharePoint List Items to SQL Database Using CSOM.
Insert, Update, Delete, Display Data in MySQL Using C#2/15/2016 1:39:39 PM. This article shows how to insert, update, delete and display data in MySQL.
Create A Provider Hosted SharePoint Add-In With SQL Database in Azure2/5/2016 6:47:15 AM. In this article we’ll see how to create a provider hosted SharePoint add-in, hosted in Office 365 with an ASP.NET MVC web application, which is using the Azure database.
Using MySQL Database With UWP1/26/2016 9:34:57 AM. In this article you will learn how to use MySQL database with UWP.
Create ASP.NET Web App With SQL Database In Azure1/16/2016 2:35:14 PM. In this article you will learn how to create ASP.NET Web App with SQL database in Azure.
Import Data From Excel File To SQL Server12/15/2015 8:13:56 AM. This article is about importing excel file data into your SQL server database.
Python With SQL Server Database10/26/2015 3:46:26 AM. This article explains you how to store your data into SQL Server database and retrieve that.
Save Records Using jQuery, Web Services, and JSON Objects10/7/2015 1:03:12 PM. In this Article we will Learn how to save employee records in SQL database using Client Side technologies and webservices.
Link MySQL Database To Azure Virtual Machine And WordPress9/24/2015 6:52:45 AM. In this article we will explain you how you can link your existing MySQL database to Azure virtual machine and configure in WordPress.
Use of SQL Azure In Visual Studio 2015 Step By Step Guide9/23/2015 4:24:17 AM. In this article you will learn how to create SQL database on Windows Azure. Microsoft Windows Azure provides a feature to create SQL database which works like PAAS on cloud.
Introduction To NoSQL Databases9/3/2015 3:35:32 AM. This article provides an introduction to NoSQL databases.
Connect Microsoft Azure SQL Database Using C#9/3/2015 1:29:24 AM. In this article you will learn how to connect Microsoft Azure SQL Database using C# programming.
MongoDB - Day 8 (Find Method Part 2)8/8/2015 3:02:48 PM. In this article you will learn about the find method in MongoDB.
MongoDB - Day 5 (Data Types in MongoDB)8/6/2015 4:17:36 PM. In this article you will learn about various data types in MongoDB databases.
Overview of NoSQL Database8/3/2015 5:45:42 PM. In this article you will learn about NoSQL databases.
Create Menu and SubMenu Using Database Table6/26/2015 8:11:26 PM. In this article we will learn how to create menus and submenus using a database table.
Overview of Open Source Postgre SQL Database5/14/2015 1:02:34 AM. This article provides a brief overview of Postgre SQL Database.
SQL Server Database Basics Query Command 5/3/2015 1:46:08 PM. This article provides some SQL Server database basic information including database creation, data table creation and basic query information.
Introduction to MongoDB4/19/2015 5:06:04 AM. In this article we will learn the basics of MongoDB.

C# Corner

Topics