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...
In part 3 of our Azure SQL database change management (CICD) series we cover testing your code using tSQLt and GitHub Actions.
Refer to part 1 and part 2 for the prerequisites.
A GitHub account
Visual Studio Code
.NET Core SDK
Fork the GitHub Project
We will be using tSQLt in this ...
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...
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...
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. ...