Incremental Data loading through ADF using Change Tracking
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
2022-04-18 (first published: 2020-10-13)
16,150 reads
Articles
SQL Server Graph Tables – Cross Database Surprises
Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
2022-04-18
Webinar | Kick start your DevOps Initiative
Without someone on your team experienced at putting DevOps into practice, it can be difficult to know how to get started. Join Microsoft Data Platform MVP, and AWS Community Builder Grant Fritchey to discover his top tips on how to kick start DevOps in your organization.
2022-04-18
Flyway Gotchas
Explaining some of the 'gotchas' that can trip up the unwary Flyway user, and how to avoid them. One or two of these you'll encounter quickly, such as the case-sensitivity of parameters and arguments. Others, such as potential problems with undo scripts or running scripted callbacks, only when you are tackling more complex development processes.
2022-04-15
Tips and tricks with DAX table functions in paginated reports
There are several common challenges when creating paginated reports from Power BI datasets. In this article, Adam Aspin explains how to work around several of these issues.
2022-04-15
How to create a table using SQL Server Management Studio
In this article we walk through things you should know to create new tables in SQL Server using the SQL Server Management Studio interface.
2022-04-13
ICYMI: Dealing with Database Data and Metadata in Flyway Developments
In case you missed it! Before you get very far with database development you need to be clear about your strategy for handling data. In this article I'll explain some of these issues in general terms, and then demonstrate how you can navigate these problems easily with Flyway.
2022-04-13
Basic Git for DBAs: Making Changes in GitHub
In this article, learn how to work with your repo online at GitHub.
2022-04-11 (first published: 2020-07-14)
5,039 reads
Basic Git for DBAs: Managing PowerShell Scripts
This next article in the git series looks at managing powershell code in Git.
2022-04-11 (first published: 2020-08-27)
5,041 reads
Basic Git for DBAs: Merging Code Between Branches
This article will cover a basic set of code merges between different branches.
2022-04-11 (first published: 2020-07-23)
4,292 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers