This is the second article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git Basic Git for DBAs: Sharing Files Through GitHub Basic Git for DBAs: the Basics of Branches Basic Git for DBAs: Making Changes in GitHub Basic Git […]
2022-04-11 (first published: 2020-06-09)
6,477 reads
Learn what a branch is in git and how you can create these, share them, and begin working with copies of your code.
2022-04-11 (first published: 2020-06-16)
7,719 reads
Steve continues his series on Git for DBAs by looking at code review and pull requests.
2022-04-11 (first published: 2020-08-06)
5,203 reads
2022-04-11
17,379 reads
We'll step through the process of using Flyway Teams to support database branching and merging, where the team split the development effort into isolated, task-based branches, and each branch has its own development database.
2022-04-11
In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery.
2022-04-11
To guarantee the order of a result set, you must use an ORDER BY clause. In this article, Greg Larsen explains what you need to know about ORDER BY.
2022-04-08
Now’s the time to save your seat at the world’s largest hybrid conference for data platform professionals, taking place November 15-18! Join attendees from around the globe who are gathering in-person and online for a full week of world-class training, networking, and data-platform focused events. Register today to take advantage of discounted launch pricing, available for a limited time.
2022-04-08
2022-04-06
48,461 reads
In this article we look at the SQL functions COALESCE, ISNULL, NULLIF and do a comparison between SQL Server, Oracle and PostgreSQL.
2022-04-06
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers