Finding SQL Server Installs with Powershell, Again
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
922 reads
But the SQL Listener isn’t started!
Yep, I heard you loud and clear. There is more than one way to find...
2013-04-15
922 reads
Do It In Bulk
I usually don’t run queries on just one server. Most of the time I need to get...
2013-04-12
1,256 reads
Old Dog, New Tricks
I’ve been writing tools for SQL Server for a lot of years. Some of these tools were...
2013-02-27
2,403 reads
Finally a REAL keyboard for my iPad!
I can’t tell you how long I’ve wanted a real keyboard that my iPad...
2012-11-28
1,276 reads
Again, frustration.
After almost breaking my arm patting myself on the back getting past my last SAP BW issue I found that...
2012-11-19
1,179 reads
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,840 reads
Here In A Flash!
Its been a crazy last few years in the flash storage space. Things really started taking off...
2012-11-07 (first published: 2012-11-05)
2,727 reads
Why do some things have to be so hard?
I have been asking myself that question for the better part of...
2012-11-01 (first published: 2012-10-30)
3,459 reads
Shared Consolidated Storage Systems – A Brief History
Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes...
2012-10-30 (first published: 2012-10-26)
2,486 reads
If it happens two times then you know the first time wasn’t a fluke.
Today was my anniversary date for the SQL Server...
2012-10-02
1,007 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
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