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
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using dbachecks for CIS Security Checks
Well back at the end of 2019 I finished writing most of the checks...
How to tell if Change Data Capture (CDC) is working as expected
By DesertDBA
I’m not sure how many of you use Change Data Capture (CDC) on your...
Forums
Can secondary data file (.ndf) be created by default during sql installation?
Primary data file, sitting on its own drive, has two files: .mdf and .ndf....
Extended Events stop writing to Ring Buffer in 10 minutes.
It hardly goes over 1000 collected rows, and just stops further logging without any...
left join causing results to be multiplied
Hello, Hello, the query below is giving me some trouble. the results of the...
Ask SSC