I don’t blog anymore, but not because I work at Microsoft
Last year I had a health scare that got my blood pressure at 200-and-something over 100-and-something, soon to be wired up to an IV drip, put through a CT...
2023-09-08
40 reads
Last year I had a health scare that got my blood pressure at 200-and-something over 100-and-something, soon to be wired up to an IV drip, put through a CT...
2023-09-08
40 reads
One of the advantages of being on the Database Docs team at Microsoft is that I get to work with amazing people, which means we can respond quickly to...
2023-09-05
102 reads
This is a list of links, in no particular order, that you should read in no particular order. But read all of the words at the end of these...
2023-04-24
132 reads
On 14 February 2023, Microsoft released updates for all supported versions of SQL Server in the form of a General Distribution Release (GDR). A GDR is an out-of-band update...
2023-02-24 (first published: 2023-02-15)
1,267 reads
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions. For 2023, the deadline...
2023-02-20 (first published: 2023-02-01)
136 reads
Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta support today for Apple’s...
2023-01-25 (first published: 2023-01-12)
185 reads
I have turned off comments on this site. All existing comments have been removed. Even the nice ones from awesome people, and the helpful ones, and the ones answering...
2022-09-16
66 reads
Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan Kehayias. The chart has...
2022-08-15 (first published: 2022-08-03)
393 reads
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the hardiest data storage designed...
2022-05-25
40 reads
Normally I write these posts on a Friday evening. Sometimes it’s later than that, but always before Monday so that my editor can give it some attention before I...
2022-04-27
22 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