Azure SQL database

CTEs, Views or Temp Tables?

January 20, 2023 Jan 20, 2023 01/20/23

Davide Mauri

I've just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several comments there was the request to explain what is the difference between Common Table Expressions, Views and Temp Tables. This is quite a common question, and it is time to give it a simple, concise, and clear answer...

Connecting the Dots of Azure SQL CICD Part 3: Testing with tSQLt

December 5, 2022 Dec 5, 2022 12/5/22

Brian Spendolini

In part 3 of our Azure SQL database change management (CICD) series we cover testing your code using tSQLt and GitHub Actions. Prerequisites Check Refer to part 1 and part 2 for the prerequisites. Fork the GitHub Project We will be using tSQLt in this post, so I have created a GitHub project made up of several ...

Maximizing Azure SQL Database performance with a globally distributed Redis write-behind cache

November 14, 2022 Nov 14, 2022 11/14/22

Shreya Verma, Abhiman Tiwari

Azure SQL Database is a fully managed platform as a service (PaaS) relational database service. With Azure SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure. SQL Database can be the right choice for a variety of modern cloud applications because it enables you to...

Connecting the Dots of Azure SQL CICD Part 1: Getting Started

October 24, 2022 Oct 24, 2022 10/24/22

Brian Spendolini

Azure SQL CICD Part 1: Getting Started Continuous Integration (CI) and Continuous Delivery/Deployment (CD) are a set of principles or methodologies that empower development teams to deliver code faster, more reliably, and with fewer bugs compared to traditional software development such as the waterfall model. Teams that use...

Announcing General Availability of Change Data Capture (CDC) on Azure SQL Database

April 27, 2022 Apr 27, 2022 04/27/22

Abhiman Tiwari

We are excited to announce the general availability (GA) of change data capture (CDC) in Azure SQL Database. What is Change data capture (CDC)? CDC provides historical change information for a user table by capturing both the fact that Data Manipulation Language (DML) changes (insert / update / delete) were made and the changed data. ...

Azure SQL Devs’ Corner