Action Over Knowledge
A big part of success is making an effort. Steve discusses the need to do things and not passively let life pass you by.
A big part of success is making an effort. Steve discusses the need to do things and not passively let life pass you by.
This article explains metadata driven pipelines and shows an example in Microsoft Fabric.
I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times
This article shows how to import and export a list of registered servers from SSMS.
Today, Kendra Little talks about code reviews and why they should be done early.
Learn how to use different Spark SQL string functions to manipulate string data with explanations and code examples.
Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]
Today, Grant talks about reasons that companies don't upgrade.
You have dropped a column and wondering why you haven't recovered any space? Let's take a look.
In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code.
Have you ever wanted to filter a visual by selecting a range of values...
By Steve Jones
I wrote a post recently about pruning branches in git. That’s part of the...
By James Serra
I talked about Microsoft Fabric shortcuts in my blog post Microsoft Fabric – the...
Introduction In the digital age, cryptocurrencies have emerged as revolutionary financial instruments, challenging traditional...
Comments posted to this topic are about the item Truncate tables where Referential Integrity...
Hi all, We have a SSIS package that does 2 things in parallel: moves...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers