How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts.
What’s the difference between Site Reliability Engineering and DevOps? In this article, Grant Fritchey defines each one and compares them.
Learn the basics of Git in this article if you've never used this version control system before. We will cover setting up a repo, adding files, changing them, and getting your history.
SQL Server supports a number of different logical operators. These operators can be used for testing Boolean conditions that return true, false and unknown in your T-SQL code. Logical operators are useful for defining constraints to limit the rows be processed when selecting or updating data. This chapter will provide an overview of the logical […]
When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.
With ambitious expansion plans, PointsBet needed an expansive overview of its server estate, whether on Azure or on-premises, anywhere around the world. Find out how SQL Monitor rose to the challenge.
There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?
We used to work in offices, now we work at home. Do we need a third space? Steve does.
Learn how you can use Change Tracking to incrementally load data with Azure Data Factory
Louis Davidson explains how to get around an interesting issue when doing cross-database queries involving graph database tables.
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Hi as shown below a replication target requires a primary key. if we want...
Comments posted to this topic are about the item Local Agents
Comments posted to this topic are about the item Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers