Azure Key Vault Logging
Following up from last week’s post on Azure Key Vault in this blog I will show you how to the...
2019-02-20
223 reads
Following up from last week’s post on Azure Key Vault in this blog I will show you how to the...
2019-02-20
223 reads
I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL...
2019-02-13
181 reads
A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule...
2019-02-08 (first published: 2019-01-23)
2,738 reads
Keys and secrets (AKA passwords) are an essential part of data protection management not only on-premises, but within the cloud...
2019-02-06
243 reads
Azure offers a lot of value-added services included with the price of what you pay . One of the things really,...
2019-01-30
273 reads
We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table....
2019-01-15 (first published: 2019-01-03)
2,454 reads
Ever need to have a test database on hand that you can allow others to query “real like” data without...
2019-01-02 (first published: 2018-12-19)
2,680 reads
SQL Server 2019 brings a very exciting new feature that, is long overdue. Resumable online index create is one of...
2018-12-13 (first published: 2018-11-28)
2,229 reads
SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for...
2018-12-12
315 reads
Data exploration and documentation can be cumbersome, classifying data can be one of those tedious but necessary things. With the...
2018-12-05
925 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