Does Version Control Scare You
Steve finds a lot of people don't use version control and don't want to learn how to use it.
Stairway to Snowflake Level 7 - Snowflake Tables
In this next level of the Stairway to Snowflake we examine the wide variety of table types that exist in the platform.
SQL STRING_AGG Function Use and Examples
The STRING_AGG function concatenates strings separated by a specified separator. This was introduced with SQL Server 2017.
SQL Server 2022 Build List
This is a list of the builds for SQL Server 2022. There are other build lists available here. A list of all the builds that I can find and install on my Build VM. If you find a build not listed here, please let the webmaster know (webmaster at sqlservercentral.com). All builds are listed in reverse […]
Helpful Management Studio Settings and Features
Learn a few tips and tricks to make your work with SSMS much more efficient and helpful.
Securing the DevOps Pipeline Part 2: Hardening Kubernetes and Cloud Security
In Part 2, we shift our focus to securing containerized deployments and cloud infrastructure. We will cover Kubernetes security hardening, real-time monitoring, infrastructure as code (IaC) security, and shifting security left to catch misconfigurations early. These strategies will help your team secure workloads in production and respond to potential threats before they lead to a security breach.
Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere
As someone who has had the honor of delivering keynotes at both Oracle and SQL Saturday data events, I’ve spent time with professionals on both sides of the database world. I’ve held the title of database administrator, developer, engineer and architect for structured, transactional giants and the analytics-heavy ecosystems of eight different database platforms, (not […]
Are Data Breaches Inevitable?
Steve examines the idea that we might all have a data breach at some point.
How to Safely Remove a SQL Server Data File Without Downtime
Learn how to safely remove a SQL Server .ndf data file without any downtime using DBCC SHRINKFILE (EMPTYFILE). This hands-on tutorial walks through real-world Azure-based setup, data redistribution, and storage cleanup — ideal for DBAs managing enterprise SQL Server environments.
Blogs
Speaking at the NYC Lunch and Learn DevOps Devour Hour
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Forums
Deadlocks and Backups - Need help
Hey everyone, please excuse my ignorance, I'm just .NET developer and have used SQL...
Does Version Control Scare You
Comments posted to this topic are about the item Does Version Control Scare You
Unlimited Text
Comments posted to this topic are about the item Unlimited Text
Question of the Day
Unlimited Text
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers