Category: sql

Slack Integration with an Azure WebApp, Azure SQL and real-time communication

enter image description here

Introduction

I am a Microsoft Student Partner at the Microsoft Innovation Center from the “Politehnica” University of Bucharest.

Part of our responsibility is giving technical presentations to students about various technologies. We also have a lab at the University where we give the presentations and spend most of our time and where other students can come and work on their projects.

Up until in September, we used Facebook for almost all of our communication (I know, my feelings as well).

Read more →

Azure SQL + Entity Framework in a Console Application

Introduction

Today, we are going to create an Azure SQL Database that we are going to use from a C# console application, using Entity Framework Code First approach.

Azure SQL vs SQL Server on a VM

Microsoft Azure offers two methods for using an SQL database:

  • Azure SQL Database – offered in a way that falls between Platform as a Service (PaaS) and Software as a Service (SaaS) – you develop your application using the built-in functionality and features of the database. You have services like logging, monitoring, scaling, geo-replication and you have the ability to pay-as-you-go.
  • SQL Server on a Virtual machine – Infrastructure as a Service (IaaS) – allows you to create an Azure VM with SQL Server installed and you are responsible for managing both the OS and the SQL Server.

Read more →