Azure Services

Azure includes many services in its cloud computing platform. Compute services: This includes the Microsoft Azure Cloud Services (web and worker roles), Azure Virtual Machines, Azure Websites, and Azure Mobile Services. Data services: This includes […]

Cloud Offering

Cloud computing usually is classified in three categories: SaaS, PaaS, and IaaS. SaaS: Software as a Service SaaS is software that is centrally hosted and managed for the end customer. It usually is based on […]

Comparison of on-premises versus Azure

With an on-premises infrastructure, you have complete control over the hardware and software that you deploy. Historically, this has led to hardware procurement decisions focused on scaling up; that is, purchasing a server with more […]

Overview of cloud computing

With an on-premises datacenter you have to handle and manage everything, including purchasing and installing the hardware, virtualization, installing the operating system and any required applications, setting up the network (including running wires), configuring the […]

Create PIVOT From SQL Server Table

In this article, I will explain you how to create a pivot from two columns (Sales date and Sales Amount) in sql Table. Create a table “Monthly_Sales” by using the following Query. Create table Monthly_Sales( […]

Get All Table names from SQL Server Database

In this article, I will explain how to get all table names from SQL Server Database. The below mentioned query will list all the table names available in the database. select Table_Catalog, Table_Schema, Table_Name, Table_Type […]

Get All Stored Procedures names from SQL Server Database

In this article, I will explain how to get all stored procedure names from SQL Server Database. The below mentioned query will list all the stored procedures (Routines) available in the database. select Routine_Catalog, Routine_Schema, […]