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
In this article, we will review the benefits and drawbacks of using database partitioning (sharding) to help improve performance and maintenance tasks.
2023-01-13
In this article, we look at how to build a box and whisker plot chart using Power BI Desktop with a step-by-step walkthrough.
2023-01-13
A subquery is a type of query that is embedded—or nested—into a data manipulation language (DML) statement. The subquery itself is typically a SELECT statement, although you can also use a TABLE statement or VALUES statement. Even so, the SELECT statement continues to be the most common choice for subqueries, and that’s the one I focus on in this article.
2023-01-11
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
I recently took and passed the DP-700 exam, which is required for the Microsoft...
As a Consultant, I would typically answer with – it depends! Then a typical...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item How to Download and Restore...
Comments posted to this topic are about the item Tracking Table Sizes
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers