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.
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Assignments aren’t just tasks to submit—they’re opportunities to build understanding, discipline, and problem-solving skills....
Comments posted to this topic are about the item What's new in R 4.6
Comments posted to this topic are about the item Interesting Changes in R, which...
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers