What is a good Disaster Recovery Plan?
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees...
2017-07-19
150 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
151 reads
Balanced Power Saving T-SQL script
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
172 reads
Where To From Fundamentals?
The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little...
2017-06-28
345 reads
Why You Need A Test Environment
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
131 reads
How to write a DELETE query
My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My...
2017-06-14
142 reads
How to write an UPDATE query
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
130 reads
How to write an INSERT query
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
390 reads
How to write a SELECT query
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
160 reads
Querying a Database
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
100 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