Unexpected Shorthand Date Implicit Conversions
I do my best work in the mornings. Evenings are pretty good too once I get a second wind.
Late afternoon are my nemesis for getting any serious technical or...
2018-10-23
1 reads
Blog Posts
Webinar: The end of support for SQL Server 2008
Coeo is a partner with Redgate Software. Tomorrow they are hosting a webinar on what your position will be if...
2018-10-23
389 reads
ASF 015: Kalen Delaney interview
Introduction Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California....
2018-10-22
97 reads
Azure SQL DB – Failed to update database because the database is read-only
Quite an interesting situation I found myself in where I was perplexed for about 5 minutes. I was connected to...
2018-10-22
421 reads
Database Fundamentals #19: JOINS
The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but...
2018-10-22 (first published: 2018-10-08)
2,965 reads
Some Thoughts on How to Prepare to Serve on the PASS Board of Directors
From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I...
2018-10-22
247 reads
SQL Server 2019 Big Data Clusters
At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include...
2018-10-22
1,864 reads
SQL Server 2019 Big Data Clusters
At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include Apache Spark and Hadoop Distributed File System (HDFS) for...
2018-10-22
1,015 reads
The Security Weak Link
I saw this cartoon, which I think is great: Data Security. It’s from John Klossner, and it perfectly shows that...
2018-10-22 (first published: 2018-10-11)
2,127 reads
This is a company that practises what they preach
How good is a company at engaging with their user base? Obviously when things are going great then it’s wins...
2018-10-22
951 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