Faryl O'Neil
Overnight Mid-Level DBA
Faryl has 7+ years of SQL Server experience and has worked briefly with Oracle once upon a dream. He has a passion for putting words to paper and explaining complicated concepts in simple terms.
Foundations of Disaster Recovery Planning (Part 3)
SUMMARY: Effective Disaster Recovery (DR) planning requires the dedicated team to follow specific, sequential instructions that detail exactly how recovery will unfold, while regularly reviewing and testing the procedure to ensure organizational readiness for any... read more
Foundations of IT Disaster Recovery Planning (Part 2)
SUMMARY: Robust IT disaster recovery planning requires organizations to meticulously define both the essential human stakeholders—including a multi-role disaster recovery team—and the detailed physical and virtual locations of all application infrastructure to ensure... read more
Foundations of IT Disaster Recovery Planning (Part 1)
Summary Organizations must create a solid IT disaster recovery (DR) plan by firmly establishing the plan’s scope and setting clear Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO). This ensures preparedness for system failures ranging from... read more
Understanding and Preventing SQL Server Deadlocks
SQL server deadlock is a common issue that database administrators often encounter, causing significant disruptions in database operations. This article aims to demystify the concept of SQL server deadlocks, particularly focusing on the nuances between traditional... read more
Page Splits and How to Optimize Index Space in SQL Server
If you’re noticing a significant drop in performance, as well as frequent index fragmentation, you might have an issue with page splits, especially if your fill factor is set to default on all of your indexes. What Are Page Splits? Page splits occur when there... read more