Backups after a DR Restore – MCM
If you have a disaster, and you need to restore to some point in time prior to the last log...
2011-02-21
794 reads
Blog Posts
Blowing Kisses: Un-SQL Friday #003 Roundup
We at MidnightDBA sure do love a blog party, and what’s better than a blog party about love? I invited the...
2011-02-21
640 reads
Data Driven Subscriptions for SSRS Report with Parameters from multiple data sources
Just to give the context of the problem I faced recently.. our application is very data intensive, GB of data received...
2011-02-21
647 reads
Hello, My Name is Hugo and I haven't Blogged in Two Months
Oh gracious sin 🙂
No apologies, just that life gets in the way from volunteer work.
My regular political passions have gotten in...
2011-02-21
745 reads
How Should the PASS Nominating Committee Be Selected?
Over the past few months, the Elections Review Committee (ERC) has been looking into how the community should select its future leaders in the PASS organization. We started with...
2011-02-21
3 reads
How Should the PASS Nominating Committee Be Selected?
Over the past few months, the Elections Review Committee (ERC) has been looking into how the community should select its...
2011-02-21
651 reads
How to Avoid SQL Server 2008 Lingering Evaluation Installs - Validation Before Applying SP2 (10.0.2531 to 10.0.4000)
We wound up in a nasty situation recently where SP2 could not be applied to an instance of SQL Server. ...
2011-02-21
1,608 reads
London UK SQL Server User Group – It’s Back!
"We're back with a Bang!"
In case you missed it, being tucked away amongst all the other UK SQL Server User...
2011-02-21
632 reads
Moore’s Law May Be The Death of NAND Flash
"It ain’t what you don’t know that gets you into trouble. It’s what you know for sure that just ain’t...
2011-02-21
1,003 reads
Pragmatic Transition: Lighthouses and Shipwrecks
Sometimes your mistakes are the greatest lessons...
This is the next post in my series about transitioning from a DBA to...
2011-02-21
684 reads
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