Prevent Accidental Data Deletion in Azure Storage Container with Soft Delete Features
Learn about enabling soft-delete for your Azure Storage containers.
The Need for 256GB
Today Steve wonders how many of you really need 256GB of RAM in Standard Edition.
Choosing Between SQL Server Integration Services and Azure Data Factory
In this article we look at the similarities and differences of SSIS and Azure Data Factory and provide some insight as to when you would use one over the other.
The Redgate Advocates Predict… 3 Key Challenges to Overcome in 2022
Read what Grant, Steve and Kathi predict will be the biggest challenges for data professionals to overcome this year.
Most of Us Are Vulnerable
Security is hard, and while data professionals might not be responsible for network issues, we ought to be aware that there could be vulnerabilities that might attack our systems.
Playing popular game of Wordle using T-SQL
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
Playing popular game of Wordle using T-SQL
Popular and addictive game of Wordle is now written in Transact SQL script. With this script, you can now play this game on Microsoft SQL Server, using your favourite editor - SSMS, ADS, VS Code, and enjoy playing the game during free time, or whilst waiting for the other SQL query to complete.
Stairway to SQL PowerShell Level 11: SQL Server Maintenance Using SQL PowerShell
This level will demonstrate simple techniques to perform a few important SQL Server maintenance tasks using PowerShell. We'll barely scratch the surface of what's possible but I hope it will whet your appetite.
Reporting on Changes Made by Flyway Migration Scripts
Phil Factor demonstrates some PowerShell tasks that will produce a high-level overview, or narrative, of the main differences in the metadata between two versions of a database, during Flyway Teams migrations.
SQL Identity Column Gaps and Conversion in SQL Server, Oracle and PostgreSQL
Learn about identity column sequence gaps and changing an existing column to an identity column in SQL Server, Oracle and PostgreSQL.
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers