SQL Introduction

SQL stands for “Structured Query Language”. It is a query language used for accessing and modifying information in the database. IBM first developed SQL in 1970s. It has become a Standard Universal Language used by most of the relational database management systems (RDBMS). Some of the RDBMS systems are: Oracle, Microsoft SQL server, Sybase etc. Most of these have provided their own implementation thus enhancing it’s feature and making it a powerful tool. Few of the sql commands used in sql programming are SELECT Statement, UPDATE Statement, INSERT INTO Statement, DELETE Statement, WHERE Clause, ORDER BY Clause, GROUP BY Clause, ORDER Clause, Joins, Views, GROUP Functions, Indexes etc.


SQL Data Manipulation Language (DML)

SQL data manipulation language (DML) is a main part of SQL statements. SQL DML allows you to retrieve data from the database tables in relational database management system (RDBMS). In addition, SQL DML allows you change or delete data from the database tables by using UPDATE and DELETE statements. Here are all the SQL statements related to the SQL data manipulation language:


SQL Data Definition Language (DDL)

SQL Data definition language is a subset of SQL statements. SQL Database definition language allows yout to create, alter or remove different kind database objects such as tables, views, indexes. 

 

Data Control Language (DCL)

SQL Data Control Language (DCL) is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.

 

Transactional Control Language

SQL Transactional Control Language (TCL) is used to manage different transactions occurring within a database.

 

Leave a comment

Introduction to Azure Service Fabric

Cloud Avenue

Azure Service Fabric is platform as a service (PaaS) offering from Microsoft for developers to build and host scalable distributed systems. Service Fabric is a core of many of the Microsoft Azure cloud services such as Cosmos DB, SQL Server, Azure Event Hub, Azure IOT Hub, Cortana, Skype for Business, Power BI and others. The same can be used to write your own highly available and highly scalable services.

Microservices

The concept of Microservices is to decompose complex applications into independent services wherein each service is a self-contained, complete functional unit that can be evolved or even reconstructed without impacting other services.

  1. Introduction to Service Fabric-reliable services, allowing you to both lift and shift your applications, enables scaling, disaster recovery, resilience, and is a core to understanding Service Fabric.
  2. Introduction to Service Fabric-reliable actors, actors is an emergent program in paradigm, which simplifies programming of scalable applications used in massively…

View original post 580 more words

Leave a comment

Move Azure resources to another subscription or resource group

Cloud Avenue

This article is about moving resources to another subscription or another resource group in the same subscription. This can be done using Azure portal, PowerShell, Azure CLI or the REST API.

To move resources, the source resource group and the target resource group both are locked during the operation and resources can’t be added, updated, or deleted in the resource groups but they are not frozen. For example, if a SQL Server is moved to a new resource group, the applications using the database will not experience any downtime. They would still be able to access the database(s). However, changing the location of the resource is not possible.

View original post 233 more words

Leave a comment

Creating a SignalR Service on Azure

Cloud Avenue

Real-time technologies have become integral part of many the applications today. This need can easily be sorted out using Azure SignalR Service. The Azure SignalR Service is an Azure service based on ASP.NET Core SignalR.

Please read my article Fully managed SignalR Service on Azure – in Preview to read more about Azure SignalR service. This article is focused on how to create a SignalR service on Azure portal.

  • To create a new Azure SignalR Service resource, got to Azure portal. In the upper left side of the page, click + Create a resource.SignalR_1

  • In the Search the Marketplacetextbox, type SignalR Service and press enter.SignalR_2

  • Click SignalR Service in the results and click Create.SignalR_3

  • In the new SignalR settings page, add the following settings for your new SignalR resource.SignalR_4

  • Click Create. The deployment may take couple of minutes to complete.
  • Once the deployment is…

View original post 46 more words

Leave a comment

Fully managed SignalR Service on Azure – in Preview

Cloud Avenue

ASP.NET Core SignalR is an open source library for ASP.NET Core developers that makes it extremely simple to add real-time web functionality, ability for server-side code to push content in real-time, to the connected clients. As a result, clients are updated without polling the server, or submitting a new HTTP request for updates.

Real-time technologies have become integral part of many the applications today. This need can easily be sorted out using Azure SignalR Service. The Azure SignalR Service is an Azure service based on ASP.NET Core SignalR. Microsoft Azure SignalR Service is currently in Public Preview.

View original post 364 more words

Leave a comment

Delivering Messages Made Easy With Azure Service Bus

Cloud Avenue

Integrating two different systems is often complicated and comes up with lots of challenges with respect to the availability of both systems, processing speed, scaling and many more. Amongst many recommendations for designing and developing applications for the cloud, enabling asynchronous communication between multiple services plays a vital role in achieving the reliability, scalability and the efficiency of the system.

Azure Service Bus – A managed Queuing system on Azure Cloud

Azure Service bus is a highly scalable service that helps to achieve asynchronous messaging and exchanging data among decoupled systems. Moreover, since it is a Platform as a Service (PaaS) offering from Microsoft, thus, you don’t have to manage the Infrastructure and configuration. Azure cloud manages all this for you.
Among all others, the most important feature of Azure Service Bus queue is that it guarantees messages to be delivered in FIFO order, which many other queuing solutions…

View original post 125 more words

Leave a comment

Azure CDN to Improve your website’s performance and responsiveness

Cloud Avenue

What is a content delivery network?

A content delivery network (CDN) is a network distributed and interconnected servers that deliver pages and other Web content to a user much faster, based on the geographic locations of the user. The goal is to distribute web content to provide high availability and high performance. The CDN has become critical component of modern web applications and today the majority of web traffic is served through CDNs, including traffic from major sites like Facebook and Amazon. It also provides protection to the site from malicious attacks.

View original post 379 more words

Leave a comment

Using Service Bus Explorer to manage and test Service Bus Queues, topics, relays, event hubs and notification hubs

Cloud Avenue

Azure Service Bus

Azure Service bus is a highly scalable service that helps achieving asynchronous messaging and exchanging data among decoupled systems. The purpose of this service is to make Integration reliable and highly available with the help of message queuing. It is a Platform as a Service (PaaS) offering from Microsoft azure. You can refer my article “Windows Azure Service Bus Brokered Messaging to read Service Bus into details. This article focuses on administer and monitor service bus namespace and messages without writing code, with the help of Service Bus Explorer tool, written by Paolo Salvatori.

Service Bus Explorer

Service Bus Explorer is the tool that allows you to connect to Azure Service Bus and administer messaging entities much quickly and easily. It can be used with Service Bus managed namespaces hosted by both Azure and Windows Server. The tool provides great features including import/export functionality or the…

View original post 322 more words