Stairway to Always On Level 2: Storage 101
In this new level of the stairway, we examine the storage knowledge you need for an Always On configuration.
Stairway to Always On Level 3: Infrastructure 101
In this next level of the Stairway to Always On, we will look at the components required to implement a Windows Server Failover Cluster.
Stairway to Always On Level 6: Analyse and Deploy an Always On Availability Group
In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.
Stairway to Always On Level 7: Combining FCIs with Availability Groups
In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.
Stairway to Always On Level 8: Segregate Mirror Traffic in AlwaysOn
this article details how to segregate the mirror traffic in an Always On group configuration
How to use Jupyter Notebook in VSCode
Learn how you can create and use a Jupyter Notebook in VS Code.
The Biggest Database Professional Challenges Today
What are the biggest challenges you face today? Steve asks the question and is hoping for a few answers from you.
Using Query Store to Identify CPU Intensive SQL Queries and Creating Proper Indexes
Learn how to use SQL Server Query Store to identify what resources are using CPU to help fine-tune queries and reduce the processing load.
Planes, Trains, and Automobiles
I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]
A Programmer's Attitude
The way we approach development can have a big impact on quality, as well as how smoothly our team works together.
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