sql Resources

About sql

SQL stand for ( Structured Query Language ) which is a computer language for storing, manipulating and retrieving data stored in relational database management system. SQL is the standard language for Relation Database System. All relational database management systems like MySQL, MS Access, Oracle and SQL Server use SQL as standard database language. SQL is used for communicate with a database according to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL update data on a database, or retrieve data from a database. Some common relational database management systems which are used SQL queries. SQL have common commands such as Select, Insert, Update, Delete, Create, and Drop can be used in database.

Share

Related resources for sql

Convert SQL Server Data to JSON9/11/2022 7:12:47 AM. Learn how to Convert SQL Server Data to JSON using JSON PATH clause.
Introduction To SQL Server Dynamic Data Masking3/4/2021 11:33:45 AM. In this video, we will discuss SQL Server Dynamic Data Masking feature to hide\mask sensitive data.
Azure SQL: What to use when - AMA11/17/2020 4:31:15 PM. In this episode of Ask Me Anything series, we have with us Anna Hoffman who is a Data & Applied Scientist on the SQL Engineering team at Microsoft. She discusses about the different options for yo
Data Warehouse Star Schema In SQL9/24/2020 4:19:03 AM. We use a data warehouse for analysis, of data and most often, it's used in reporting the data. Mostly, historical and current data is used to store at one place, in a Data Warehouse.
Test - SQL Server Studio5/21/2020 2:45:54 AM. This is another test video
What is new in Agular 10 release4/20/2020 9:31:53 AM. JS frameworks and headless CMS are a bit like cereal boxes. Eventually, you just got to pick one — the right ones, if possible.
Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part One1/25/2018 4:20:02 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
Converting SQLite Database To Excel And Excel To SQLite Data In Android1/23/2018 11:39:19 AM. In this article, we will learn how to export Android SQLite Database to Excel or Import Excel into SQLite Database. We can use SQLiteToExcel library to perform these functionalities.
Introduction To SQL Server Pagination1/22/2018 12:12:44 AM. In this video, we will look into retrieving records in page wise from SQL Server using OFFSET-FETCH statement.
Cursor In SQL Server1/18/2018 6:42:27 AM. This article describes cursors, declaration of cursors, opening of cursors, fetching from cursors, closing of cursors and deallocating cursors.
Stored Procedures Vs User Defined Functions And Choosing Which One To Use1/16/2018 1:46:00 AM. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply function
Comparison Of Subquery And Joins1/15/2018 1:07:19 PM. Here, in this article, we are comparing the SQL Join and SQL Subquery.
Why Dynamic Query Is Bad1/15/2018 12:55:21 PM. In this article, we will be talking about Dynamic Query and why it is bad.
Xamarin.Forms - Deep Linking Application Using SQLite1/6/2018 11:56:53 AM. Android deep links open a specific page within an app and optionally pass data to it. Developers may find deep links particularly useful for actions such as clicking a notification or sending an app l
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
How To Install And Start The Reporting Services SharePoint Service In SharePoint1/5/2018 12:34:08 PM. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
Azure SQL Intelligence For Database Administrator And Developer1/5/2018 11:34:59 AM. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
Look At SQL Server Encryption - Part I1/5/2018 1:08:46 AM. In this video, we will look at SQL Server encryption followed by a demo where we will encrypt a column in the table.
FILESTREAM Feature In SQL Server1/4/2018 12:06:55 PM. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
R Services In SQL Server 20171/2/2018 7:08:35 PM. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no wor
Build Scalable Web Applications With Azure Database For MySQL12/26/2017 12:40:30 PM. Azure Database for PostgreSQL and Azure Database for MySQL bring together community edition database engines and capabilities of a fully managed service—so you can focus on your apps instead of managi
Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode12/23/2017 12:10:26 PM. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal Mode12/21/2017 10:37:04 AM. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
Querying ConsmosDB Using SQL API12/19/2017 7:05:50 PM. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join ope
Export SQL Result To A Text File12/18/2017 12:30:57 PM. This article gives an overview of how to export SQL query results to a text file.
Xamarin.Android - SQLite Database12/17/2017 2:55:49 PM. In this article, I shall show you how to handle all database CRUD operations using SQLite.
Xamarin Android - Working with Existing DB12/16/2017 1:17:49 PM. In this article, I shall show you how to retrieve user data from existing SQLite Database.
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
MySQL Data Access API Development Using Express.JS, Node.JS12/14/2017 12:25:22 PM. In this article, we are looking into introduction of Node.JS, Express.JS and then I am going to create Simple MySQL data access API using Express.JS, Node.JS.
Remove Duplicate Rows In SQL Server Using CTE12/11/2017 7:26:50 PM. In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
Roles And Responsibilities Of SQL Developer 12/9/2017 2:00:32 PM. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
Object-Relational Mapper For SQLite3 In Node.js12/7/2017 11:14:44 PM. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database developme
How To Control SQL Injection In PHP12/7/2017 1:50:18 PM. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applicatio
Audit Made Easy Without Audit Log - Part One12/7/2017 11:54:51 AM. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
Difference Between MySQL DATETIME And TIMESTAMP DataTypes11/29/2017 5:37:15 PM. A simple question that may come to one's mind while working with MySQL is "Whether to assign DATETIME or TIMESTAMP datatype for a column as both seem to store the same data?”. Even though the
How To Create A Stored Procedure In SQL Server Management Studio11/25/2017 1:13:40 PM. In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedu
Introduction To SSIS11/24/2017 3:55:03 PM. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data
Use SQL Server 2017 in Docker Containers11/21/2017 11:22:35 PM. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
Introduction To SQL Operations Studio And Connecting It With SQL Server11/21/2017 5:44:31 AM. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
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.
What Is SQL Operations Studio11/17/2017 7:08:25 AM. Learn and download SQL Operations Studio
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Three11/16/2017 11:03:33 PM. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificat
Auto Complete with ngTagInput using Web API in AngularJS11/16/2017 10:54:11 AM. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
SSMS 2016 - Enhanced Scrollbar11/15/2017 5:56:25 AM. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
DROP IF EXISTS In SQL Server 201611/13/2017 3:18:31 PM. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the objec
Masking Sensitive Data With SQL Server 201611/11/2017 5:59:13 AM. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side sec
Introduction Of New Useful Features In SSMS 201611/10/2017 12:25:37 PM. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work
Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data Warehouse11/9/2017 11:14:42 AM. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.
Configuring SQL Server 2016 Express On LAN For C# Connection String11/8/2017 11:26:20 AM. In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
Insert Bulk Records Into DataBase Using ASP.NET C#11/8/2017 5:14:39 AM. In this article we will learn how to insert bulk records into a database using ASP.Net C#.
ASP.NET Web API And SQL Server11/7/2017 5:39:00 AM. In this article, you will learn about ASP.NET Web API and SQL Server.
Step By Step Guide To Setup Sample SSAS Multi Dimension Cube11/6/2017 11:28:31 PM. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was Installed11/6/2017 11:33:52 AM. In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
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.
User-Defined Types In SQL Server10/29/2017 6:08:58 AM. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
Script For Login, Logout And View Using PHP, MySQL And Bootstrap10/29/2017 2:07:02 AM. This article shows how to make a login, logout and view script using PHP, MySQL and Twitter Bootstrap.
Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)10/25/2017 7:38:10 AM. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience
T-SQL - Display Decimal Numbers As Money10/17/2017 12:48:46 PM. In this article, we will show how to display decimal numbers as money with and without cents
Sharing A Solution To Generate Billcode10/16/2017 10:26:49 AM. Many of systems we use will generate plenty of billcodes everyday , and most of them include date(datetime) or a prefix to show their signification , such as specifying a billcode belongs to a special
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part Two10/14/2017 5:42:54 AM. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always
Getting Started With Azure SQL10/13/2017 1:03:50 AM. In this video we will learn how to get started with Azure SQL, by creating an Azure SQL server & SQL Database and then connecting it using SSMS.
T-SQL - Retrieve Task Hierarchy In Project Server10/12/2017 11:10:01 AM. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
How To Use DataList Control In ASP.NET With Example in C#10/8/2017 12:25:02 PM. In this article I’ll present a tutorial with an example, a way to use the DataList control in Asp.Net for the displaying of information/ records from the database with using SqlDataSource.
ASP.NET - Connect to MySQL Azure Database10/7/2017 1:42:24 AM. Using MVC, Entity Framework, ASP.NET Scaffolding, and Azure MySQL you can create a web application that stores your information on an MongoDB Azure database. This demo shows you how to create a web ap
Always Encrypted In SQL Server 2016 - Step By Step Guide - Part One10/6/2017 1:40:39 PM. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need t
How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)10/3/2017 5:35:21 PM. 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
Data mining and SQL Server 200510/3/2017 6:24:09 AM. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means
Data mining and SQL Server 200510/3/2017 6:24:09 AM. Data mining is a key member in the Business Intelligence (BI) product family in SQL Server 2005 . Data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic means
Azure NoSQL In ASP.NET Core 2.09/26/2017 10:48:43 AM. The sample code will require you to set up an Azure account, NoSQL database and collection.
Local Data Caching In ASP.NET Web Application9/25/2017 12:06:43 AM. In this article, you will learn some solutions about local data caching in ASP.NET Web Application .
Concept Of Views In SQL Server9/23/2017 12:31:13 AM. In this article you will learn about the concept of views in SQL Server.
How To Secure PII Data In SQL Server Using .NET Assembly9/21/2017 11:53:17 PM. 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 applications you face a scenari
How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data Warehouse9/21/2017 11:49:58 PM. I will share how you can start migrating your data into the Azure SQL Data Warehouse
35 Essential Basic-Advanced SQL Query-Questions Asked In Technical Interviews9/19/2017 2:12:56 PM. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
Encrypt And Decrypt User Password In SQL Server DB Using C# Winform Application9/18/2017 5:10:07 PM. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login for
Convert Rows To Columns Using Dynamic Pivot In SQL Server9/17/2017 1:34:22 PM. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
Create Log Backup Maintenance Plan In SQL Server 20169/17/2017 1:25:00 PM. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
Azure SQL Data Warehouse - Why Enterprises Should Now Consider It Seriously9/14/2017 12:25:53 PM. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
SQL Server DB Backup Using Stored Procedure In WinForm Application9/14/2017 11:13:59 AM. In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
Kickstart Azure Database For PostgreSQL9/10/2017 10:23:02 AM. This blog post will walk you through creating an Azure Database for PostgreSQL in Azure Portal. PostgreSQL is a powerful, open source object-relational database system and has capability to handle wor
Azure Cosmos DB With SQL Query Cheat Sheet PDF9/8/2017 2:26:14 PM. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly
How Should We Store Images And Blob Files In SQL Server9/7/2017 4:04:38 PM. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects
Find Out Creation And Modification Date Of Database Objects Like Tables And Stored Procedures9/7/2017 2:01:32 PM. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
How To Consume Web API Through SSIS Package9/7/2017 1:22:01 AM. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and proces
New String Function In SQL Server 20179/6/2017 4:43:54 PM. It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
How To Backup A Mirrored Database Using SQL Agent9/4/2017 4:57:00 PM. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery mode
Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” Statement9/4/2017 12:25:58 AM. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
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.
Working With JSON In SQL Server 20168/28/2017 4:35:33 PM. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popu
New Features In SQL Server 20178/28/2017 1:32:25 AM. There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new feat
Creating Login Form For Users With Image Uploading For Password Recall8/27/2017 10:53:05 AM. The article is an alternate method of creating a login form where the conventional way of giving a password hint will be given as a question. In this, you can add an image which can be your hint if yo
Availability Of Azure Database For MySQL And Azure Database For PostgreSQL In India8/26/2017 1:03:19 PM. In Indian data centers (Central and West India), the public preview of Azure Database for MySQL and Azure Database for PostgreSQL are available. And their services provide app developers the ability t
Understand Azure Cosmos DB - DocumentDB API (SQL)8/24/2017 2:53:20 PM. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service "for managing data at planet-scale." It builds upon and extends the earlier Azure DocumentDB, which was rele
Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#8/21/2017 4:37:24 PM. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to
Connecting Login Form In C# With Database For User Type Authentication8/15/2017 11:29:17 AM. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login 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
Record Table Changes Notification From SQL Server To WPF Client8/9/2017 1:10:56 AM. This article shows how to push record table changes to WPF clients using WCF Call Back Service.
SQL Azure With Entity Framework8/8/2017 8:33:10 PM. Exploring SQL Azure With Entity Framework
Create SQL Server Database Project With Visual Studio8/8/2017 8:24:37 PM. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.

Topics