Installing SSDT for Visual Studio 2017
I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it....
2018-06-19
3,910 reads
I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it....
2018-06-19
3,910 reads
On Thursday June 7th I’ll be giving a webinar for MSSQLTips.com (7PM UTC). The topic is Introduction to Biml – Generating your...
2018-05-29
242 reads
Techorama 2018 is over, sadly enough. It was a great conference: lots of awesome speakers and sessions and very nicely...
2018-05-25
264 reads
We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server...
2018-05-15 (first published: 2018-05-08)
1,909 reads
I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate...
2018-05-15
287 reads
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...
2018-05-11 (first published: 2018-05-02)
3,964 reads
A quick blog post for future reference, because I know I’ll bump into this again someday.
When you’re working with a...
2018-03-29 (first published: 2018-03-22)
1,841 reads
UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade...
2018-03-20 (first published: 2018-03-08)
3,861 reads
As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data...
2018-03-15
278 reads
The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the...
2018-03-13
295 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