Tim Lenz

SQL Database Administrator at Aurora Mental Health Center
Has 10+ Years Of Experience

Badges

User Activity

About 3 years ago

Answered a question: How can we easily recover from a ransomware attack?

The key to recovery from a Ransomware attack is the boy scout motto "Be Prepared". In our case, not only did we have backups at the DR site but both the Production site and DR site each had a NAS on a different subnet with different Admin passwords that had backup copies…

Almost 4 years ago

Answered a question: What were your main pain points during the Backup and Recovery solution purchase process?

I think @Martin Mash gave the overall concerns and another good question was how much the business is willing to pay for the protection they want What we found was using a dual protection solution. One solution was Veeam for Microsoft Hyper-V VMs and hardware on-premise…

About 4 years ago

Answered a question: What is your primary use case for Zerto?

After a car hit a power pole and knocked out the Data Center in our building, management realized the value of Zerto and being able to failover in about an hour to the DR site and be back up and running on our mission-critical applications. This was very helpful as power…

About 4 years ago

Replied to Tim Lenz What is your experience regarding pricing and costs for SQL Server?

@PeterJones Hi Peter, I saw your post about the data warehousing which inspired me to give my opinion and experience. Not sure where you are in Eastern Europe but I do have a goal to someday visit a friend in Romania that I met with Toastmasters.

About 4 years ago

Answered a question: What is your experience regarding pricing and costs for SQL Server?

When looking at the cost of licensing SQL Server the most important thing is to not buy more than you need. Whether you are in the cloud or on-premises you need to know if you can get by with the Standard Edition rather than the Enterprise Edition. When evaluating we found…

Over 4 years ago

Contributed a review of SQL Server: Easy to set up, fairly cost-effective, and scales well

Over 4 years ago

Answered a question: Can you recommend a disaster recovery automation tool?

We use a combination of Veeam for Hyper-V Hosts and VMs and Zerto for VMware VMs. Everything is on-site except for Exchange which was moved to the cloud when we upgraded to M365 with a backup also in the cloud For automation, both Zerto and Veeam work with minor help and…

Over 4 years ago

Answered a question: Why is disaster recovery important?

The Healthcare industry seems to be the new target for hackers and ransomware. With our DR plan in place, we were able to recover 80% of the files and 100% of the database data (by having a plan that had been based on best practices): most of the lost files were due to…

Over 4 years ago

Replied to Bret Mantey When should an enterprise choose a Disaster Recovery-as-a-Service (DRaaS) solution?

@Bret Mantey gives some excellent points but the biggest advantage when giving a presentation to management is the cost of being down. Your CFO should be able to give a cost per hour of lost revenue for downtime then the math is pretty simple to compare DRaaS to all the…

Almost 5 years ago

Answered a question: What advice do you have for others considering Veeam Backup & Replication?

While Veeam is a good Backup and Replication solution that we use for our Hyper-V VMs we also keep SQL Server backups as a separate solution. The backup is good for a DR and HA solution but for Ransomeware and Database corruption be sure to have a separate solution for…

Over 5 years ago

Answered a question: Can Continuous Data Protection (CDP) replace traditional backup?

While CDP is a good idea it does not protect if the database gets corrupted. This is the second purpose of the database backup scenario. The Grandfather, Father, Son, and off-site storage are the second level of protection against Ransomware too. My experience is that it…

Almost 6 years ago

Contributed a review of HPE Zerto Software: Continuous streaming keeps us up to date a lot faster

Experience

Reviews

Over 4 years ago

SQL Server

Easy to set up, fairly cost-effective, and scales well

Almost 6 years ago

HPE Zerto Software

Continuous streaming keeps us up to date a lot faster

Answers

About 3 years ago

Backup and Recovery

How can we easily recover from a ransomware attack?

Almost 4 years ago

Backup and Recovery

What were your main pain points during the Backup and Recovery solution purchase process?

About 4 years ago

Backup and Recovery

What is your primary use case for Zerto?

About 4 years ago

Relational Databases Tools

What is your experience regarding pricing and costs for SQL Server?

Over 4 years ago

Disaster Recovery (DR) Software

Can you recommend a disaster recovery automation tool?

Over 4 years ago

Disaster Recovery (DR) Software

Why is disaster recovery important?

Almost 5 years ago

Backup and Recovery

What advice do you have for others considering Veeam Backup & Replication?

Over 5 years ago

Cloud Backup

Can Continuous Data Protection (CDP) replace traditional backup?

About me

Over 30 years experience in the IT Industry with a various range of positions. Started as a Fortran and COBOL programmer before going to Visual Basic. Account Executive for GTSI working with several Military accounts. Worked as a Help Desk Manager for a small company of ~100 with 150% turnover yearly. Completed my MCSE and MCDBA certifications and worked as a System Administrator and DBA for several years. Technical support for VMware ITBM software. Now the DBA/SMO/PMO for Aurora Mental Health Center (AuMHC.org)

Employers

US Air Force / CO Air National Guard
G.T.S.I.
J.C.I.T.
Veterans Administration (VA)
VMware
Aurora Mental Health Centers

Education

Metropolitan State University of Denver (MSU)
Denver University (DU)