© 2023 Hashnode
#azure-sql-database
This post is part of the blog series created primarily for database engineers, with the hope that it might help you get a head start on your development tasks. With that being said, let us dive in... …
We have so many options of SQL inside Microsoft Azure that you need to be careful when you decide which one to use. In this post, I would like to present the most important options of SQL that you can have inside Azure. Let's check out one …
Database migration, especially between heterogeneous engines, is always a complex task. Luckily for us, AWS offers a set of services/tools from the schema conversion until the data migration to make o…
In publishing, and I’m sure many other industries, we get data at both the daily level and the weekly level. To properly tie these two pieces of data you need to aggregate the daily data and adjust th…
With the release of composite models in PowerBI, I’ve been able to solve a long-standing issue with SQL Server Analysis Services: text search performance. In this article I am going to use our Azure Hyperscale instance (but any Microsoft SQ…
SQL Server provides three mechanisms to track data changes in the table objects. This mechanism is also a useful solution for implementing the audit and logging process for the SQL Server Instance. The mechanisms are Change Tracking also kn…
In this post, we will be looking at how to detect and identify row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), and HASHBYTE() functions. There are use cases where comparing or detecting row changes in the table is necessary li…
After understanding the basics of CTE, multiple CTEs, and the explanation in the previous post, in this post we will be exploring Nested CTEs in this post. As discussed, we can say that CTE is a named temporary set of rows similar to subque…
In this article, we will talk about how to provision an Azure SQL Database with authentication restricted to Active Directory users/groups/applications. We will use Pulumi to do that. Why this article…