This article explains step one: migrating our monolithic, centralized repos to Git, then implementing a Release Flow branching strategy for parallel development work streams, and a Pull Request workflow to control an automated build and release process.
This tip drills down on how to process JSON files with SQL Server and demonstrates an approach for extracting key values from JSON nested key-value pairs.
The last two weeks have brought a (seemingly) daily deluge of difficult news in the tech sector. Microsoft, Google, Facebook, and Amazon have all had significant layoffs with many friends in the #SQLFamily and data community being impacted. In times of uncertainty and heightened anxiety, it’s essential to have a group you can turn to […]
I am an amateur radio operator. In the US this is commonly referred to as a ham, or a ham radio operator. My call sign is KC1KCE, as issued by the US government through the FCC. And yeah, I can hear you now, a ham is the geek equivalent of a cross-fitter. How do you […]
Culture is important retaining employers. Companies are finding this more valuable every day.
In this article, Glen Cooper provides code that allows you to process a tree, or undirected graph of data. Lots of hierarchies fall into this category and the ability to process them is valuable in many reporting situations.
In this article, we look at how to do a point in time restore using TSQL and SSMS to recover a database to a particular point in time.
When faced with choices, it's important to understand the capabilities and limitations of your options.
In part 2, we discuss the concepts of structure, tooling, and indexing for your data ingestion pipelines.
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers