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.
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
As for me, I'll keep writing whenever time permits. I don't expect every post...
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers