MTTD
Achieving high availability is hard. Today Steve discusses the challenges of five nines of uptime.
2024-06-27 (first published: 2019-09-11)
275 reads
Achieving high availability is hard. Today Steve discusses the challenges of five nines of uptime.
2024-06-27 (first published: 2019-09-11)
275 reads
A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.
2024-06-27 (first published: 2013-12-09)
2,839 reads
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
2024-06-26
87 reads
There's a survey available to give your input for what topics you'd like to learn about at the next SQL Saturday.
2024-06-24
90 reads
There are lots of companies moving databases to the cloud. Steve has a few thoughts on how to evaluate this for your company.
2024-06-21
110 reads
An alert from the US government says that SQL Injection isn't an acceptable problem.
2024-06-19
231 reads
2024-06-17
161 reads
Last week was supposed to be my turn to curate Database Weekly and write an editorial to go along with it. Graciously, Mr. Louis Davidson (@drsql) offered to switch weeks while I was in Cambridge, England with most of the Redgate Marketing team for our yearly global gathering at HQ. As a remote worker on […]
2024-06-15
42 reads
NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again
2024-06-14 (first published: 2015-08-27)
820 reads
Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.
2024-06-12 (first published: 2020-01-20)
3,672 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers