Index cleanup : Harder than it looks
I’m not the first person to write about cleaning up unused or redundant indexes.
Prevent SQL Injection
SQL Injection continues to be a problem and Steve has a few thoughts today on how to reduce your vulnerabilities.
Introducing PASS Summit Charitable Organization Scholarship
To help mark Redgate’s 25th Birthday, the company has launched a new initiative to foster knowledge and skills in the data industry.
SSIS in One Hour: Hands-On Tutorial
The goal of this tutorial is to enable ETL developers to obtain practical knowledge to exploit SSIS in transforming and combining data through hands-on exploration to be ready for real-world challenges in managing information.
A Checklist for Learning
A checklist can be helpful, but it needs to be more than a list of things if it's going to drive your career.
Hiring in IT and Relevance of Domain Experience
When choosing to hire someone, do you want experience or freshness? A few thoughts from someone that had to go through this recently.
Introducing the pre-con schedule for PASS Summit 2024
The speakers and sessions have just been announced for PASS 2024! We’re delighted to share the pre-con schedule for Monday, November 4, and Tuesday, November 5, 2024. Check out the full pre-con line up and the incredible speakers taking part and secure your spot today.
Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces
Let’s see the steps needed to move a dataflow from one workspace to another. For a matter of example, let’s consider the dataflow access a lakehouse on the Dev environment. When copied to the Test environment, the new copy needs to be linked to a new dataflow in the Test environment.
Getting and keeping fit
Don't worry, this is a technical editorial, but the initial analogy starts a bit personal. For the past decade, I've been on a journey to get fit, facing setbacks along the way, such as surgery complications and broken bones, torn cartilage, and, most recently, broken metal implants. Throughout this time, my overall physical fitness has […]
Creating a Comma-Separated List (SQL Spackle)
Learn how to create a comma separated list of values in this short SQL Spackle article by Wayne Sheffield.
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers