kiran sabneforSQL Developer Blogmssqlserver.hashnode.net·Mar 8, 2022SQL Server Nested CTE with examplesAfter 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 subqueries. Like...Discuss·455 readsSQL Server CTESQL
kiran sabneforSQL Developer Blogmssqlserver.hashnode.net·Apr 10, 2022Track Data Changes in SQL Server with Change TrackingSQL 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 known as CT,...Discuss·207 readsAuditSQL
Alexandre Nedelectechwatching.hashnode.net·Feb 22, 2022How to provision an Azure SQL Database with Active Directory authenticationIn 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? In a previous article, I already talked about co...Discuss·65 readsPulumidotnet
Ankurankuraxz.hashnode.net·Mar 31, 2023Python & SQL ft. Azure, DataGripFor a start, many different databases are available, and they can be classified based on their scale or type of data they store or where they are hosted. In this example we are looking at a Relational SQL-based Database called PostgreSQL, and how to ...Discuss·27 readsAzure
Sneh Bhattmytwocents.hashnode.net·Jan 25, 2023Azure SQL Database query ideas - finding queries currently running on the DBThis 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... Finding queries currently running on the database...DiscussAzure SQL Database Query IdeasAzure SQL Database
Cloud4DevOpscloud4devops-qa.hashnode.net·Jan 6, 2023Options of SQL inside Azure (Azure SQL)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 by one !!!...Discuss·79 readsAzureazure sql
Raul Naupariraulnq.hashnode.net·Dec 26, 2022Migrating a database from Microsoft Azure SQL to Amazon Aurora (PostgreSQL)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 our life easier. AWS Database Migration Service (A...Discuss·48 readsAWS
Josef Richbergsqlrunner.hashnode.net·Nov 5, 2022Moving dates to a weekending dateIn 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 the date to align with the weekly date. Our weekly d...Discuss·164 readsAzure SQL Database
Josef Richbergsqlrunner.hashnode.net·Oct 17, 2022Composite Models in PowerBI -- The solution to poor search performance in SSASWith 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 SQL Server i...Discuss·148 readsAzure Analysis Services
kiran sabneforSQL Developer Blogmssqlserver.hashnode.net·Apr 10, 2022Track Data Changes in SQL Server with Change TrackingSQL 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 known as CT,...Discuss·207 readsAuditSQL
kiran sabneforSQL Developer Blogmssqlserver.hashnode.net·Mar 10, 2022Compare and Find Row changes in SQL Server with CHECKSUM(), BINARY_CHECKSUM(), HASHBYTES()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 like when a ...Discuss·401 readsSQL
kiran sabneforSQL Developer Blogmssqlserver.hashnode.net·Mar 8, 2022SQL Server Nested CTE with examplesAfter 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 subqueries. Like...Discuss·455 readsSQL Server CTESQL
Alexandre Nedelectechwatching.hashnode.net·Feb 22, 2022How to provision an Azure SQL Database with Active Directory authenticationIn 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? In a previous article, I already talked about co...Discuss·65 readsPulumidotnet
