How to tackle database development in Flyway when databases make cross-server references. The technique uses synonyms to represent the remote objects, and local 'stub' objects to overcome the problems caused by 'missing references' when building the individual objects.
2023-01-27
Let’s talk about authentication between Azure Functions and resources used by Azure Functions and conclude with many poorly documented secrets about how to use User Assigned Managed Identity.
2023-01-25
However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them.
2023-01-25
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.
2023-01-23
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.
2023-01-23
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.
2023-01-20
In this article, I want to talk about a topic that you may never need. The only time I have really had need to look at the bits in a byte pattern. In (what is now) ancient versions of SQL Server didn't have such self-describing columns like in its metadata objects like it does now.
2023-01-18
If you're deploying SQL Server, you are likely running business-critical applications on it and you need to ensure it's protected from downtime and data loss.
2023-01-18
Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values.
2023-01-16
When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the Stack Overflow Users table:
2023-01-16
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hello friends. I’m new here, so if this is the wrong place for my...
Hi everyone! I've been working with a Fargate app recently and I've managed to...
Comments posted to this topic are about the item Coding Magic Values
Ask SSC