One of the very common things that is needed in SQL Server is performing a restore of a database. It's also one of the most important things that needs to take place. So why isn't this a simpler process? Steve Jones wonders why we can't make this a simpler process.
2009-11-02
112 reads
The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.
2014-12-26 (first published: 2009-11-02)
539 reads
2009-10-30
76 reads
It's another holiday and time for another blooper reel from the past month. Happy Halloween from SQLServerCentral.
2009-10-29
60 reads
Sharepoint is a product that many IT people despise, but it's a popular seller for Microsoft. Steve Jones thinks that Sharepoint's growth is a good thing for DBAs as well.
2009-10-28
260 reads
Today we have a guest editorial from Rodney Landrum. Rodney and his team of DBAs manage 110 active servers, throughout a regionally dispersed organization. How many DBAs would you expect to be on Rodney's team...?
2009-10-27
646 reads
The DBA news of the week contains some interesting thoughts on DR and virtualization plans. Steve Jones comments on why you should care about these topics.
2009-10-26
224 reads
An open letter asks Google to change their default protocol to be more secure. Are there things that we might want to do inside SQL Server to make it more secure by default? Any low hanging fruit that would help the platform?
2009-10-26
47 reads
What type of previous experience makes a good DBA? Is it necessary to have other experience? Steve Jones asks the question in today's Friday poll.
2009-10-23
201 reads
With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
2009-10-22
115 reads
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
By James Serra
A bunch of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
We’re running SQL Server 2019 with database compatibility level 150, and after recent tuning...
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
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