Extend Microsoft Access Applications to the Cloud

Chapter 9. Looking under the hood at Microsoft Azure SQL Database

In this chapter:

SQL Server Management Studio

ODBC drivers

Connecting to Microsoft Azure SQL Database

Schemas

Security in SSMS

Linked Microsoft SharePoint lists

Manually creating an ODBC DSN connection

Linking from the desktop to use an ODBC connection

Creating DSN-less connections with program code

Extracting information on relationships

Validation rules

Data macros under the hood

Views and table-valued functions

Summary

I mentioned in earlier chapters that behind the Office 365 interface your data is held in an Azure SQL Database. Microsoft Azure SQL Database is Microsoft’s cloud platform for the SQL Server database engine. In this chapter, we will look in more detail at what ...