How Many Days Can You Survive?
A disaster in LA affected many companies, some of which were innocent bystanders to the event. Steve talks about the need to have some plans in place.
2023-06-05
98 reads
Disaster Recovery (DR)
Three Mile Island And Your Databases
Grant takes a few lessons for database DR from a nuclear accident in the US.
2022-08-06
88 reads
How Often Do You Update During Issues?
When a disaster occurs and your staff is working on it, what cadence of updates should your customers expect?
2022-08-01
165 reads
2022-07-08
91 reads
Scripting Makes Mistakes Easier Than Ever
A major outage from Atlassian because of a bad script has Steve thinking about the challenges of recovering from mistakes. When we are making changes to portions of our data and we need to plan for mistakes to occur and ensure we can restore the data.
2022-04-22
175 reads
Backup Architecture
Continuous backup in Cosmos DB doesn't quite work as Steve would expect. He has a few comments on why it is important you know how your backup and restore system works.
2022-02-21
291 reads
Incident Review
After an outage, how do you respond to the issue in the future? A good review of the incident should be a learning opportunity.
2021-09-29
133 reads
How Paranoid Are You About Backups?
Sometimes just running a backup isn't enough, especially in this era of ransomware. Steve has a few thoughts on backup strategies and recovery skills.
2021-08-09
342 reads
Incident Response Data
Being prepared for a disaster might mean having a way to collect data when something occurs.
2021-05-12
171 reads
Impact Minutes
When downtime strikes, we may have to make decisions about which systems to focus our efforts upon. Steve talks about the impact of a disaster on your choices.
2021-01-28
70 reads
Blogs
FDD 2023 – Session Materials
You can find the slides for my session at Future Data Driven summit at...
Quick Filtering in SSMS–#SQLNewBlogger
By Steve Jones
I saw someone limit the databases they see in SSMS, which isn’t something I...
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
Forums
Convert Binary or Hex field to show text information
Hi all, I have an SQL database table with events, and within it a...
Write https request to azure blobstorage
Hi All, I have been trying to download a csv file which is produced...
High tempdb usage alternatives
Hi We have an stored procedure which runs frequently and it contain logic in...
Ask SSC