2017-05-29
33 reads
Editorial
The Rate of Change of Data
Phil Factor argues that the database should be the primary source not only of the current data values, but also of the volatility of the data, its rate of change. Surely, then, it makes sense for the database to control the caching strategy.
2017-05-29
91 reads
Do I Need to Learn Linux and R and Python?
The SQL Server platform is growing, but Steve Jones notes that this might not really affect our jobs.
2017-05-26
845 reads
Audio Attacks
We will start to deal with more and more types of data. Steve Jones worries about the possibility of hacking.
2017-05-25
63 reads
2017-05-24
141 reads
Naming Conventions for the Cloud
Today Steve Jones looks at how you might track the various items you use in the cloud.
2017-05-23
215 reads
Listening and Taking Action
Microsoft has changed SQL Server in response to the community. Read about some of the enhancements.
2017-05-22
75 reads
2017-05-22
55 reads
Pseudonymisation
Pseudonymisation is a form of data masking, a technique that becomes more important to data professionals all the time.
2017-05-19
1,900 reads
Data Privacy and Security: The Implications of GDPR
There may be new changes to our jobs as data professionals because of GDPR in the European Union.
2017-05-18
136 reads
Blogs
The Mystery of the Locked-Up Database -Scooby Dooing Episode 6
No Scooby-Doo story is complete without footprints leading to a hidden passage. In SQL...
The Challenge of Implicit Transactions: #SQLNewBlogger
By Steve Jones
I saw an article recently about implicit transactions and coincidentally, I had a friend...
SQL Server Is Slow – Part 2 of 4(?)
By Kevin3NF
The 10-Minute Outside-In Triage Don’t Blame SQL First It’s 9:05 AM and your helpdesk...
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