DBA ramblings, tips and scripts to make the work of a DBA smarter and better.
“The more that you read, the more things you will know. The more that you learn, the more places you’ll go.” Dr. Seuss
Feel free to browse the site with the helpful SQL scripts provided. Hope these will help to make your DBA life a little easier.
I have been working as a SQL Server Database Administrator for the past 20 years. I love what I do and the flexibility of a DBA’s work schedule that lets me have a healthy work life balance. All the after hours work as a DBA has its pros and cons but hey – when life gives your lemons (after-hours outage), you make lemonade (just go with the work until it gets resolved…lol)
I am available for any SQL Server Administration consulting work. Please feel free to contact me via the contact us page. Look forward to hearing from you.
A Dazzling Oasis in the Desert
A Dazzling Oasis in the Desert: Unveiling the Palm Jumeirah Dubai, the land of shimmering skyscrapers and audacious ambition, boasts many marvels. But none quite capture the city’s spirit like the Palm Jumeirah, a breathtaking archipelago of artificial islands shaped like a palm tree. This man-made wonder, visible even from space, is a testament to […]
Teens and Screens
Teens and Screens: Finding Balance in a Digital World Teenagers and screens – it’s a relationship that can be both rewarding and challenging. From staying connected with friends to exploring endless entertainment options, screens offer a world of possibilities. But with great power comes great responsibility, and for teens, finding a healthy balance between screen […]
How to Handle a Lying Co-worker
Working with a Pinocchio in the Office: How to Handle a Lying Co-worker We’ve all encountered them: the office fibber, the master of tall tales, the colleague whose truth meter perpetually flickers between “mostly false” and “outright fabrication.” Working with a lying co-worker can be a major headache, eroding trust, creating tension, and potentially hindering […]
Dealing with the Bullshitter in Your Life
Taming the Tornado of Talk: Dealing with the Bullshitter in Your Life We all know them: the masters of hot air, the weavers of tales spun from thin thread, the champions of empty pronouncements. The bullshitter, in all their blustery glory, can be a frustrating force to navigate, whether they’re a colleague, a friend, or […]
Top 10 things to do in Dubai
Dubai is a city of superlatives. Home to the world’s tallest building, the Burj Khalifa, the largest indoor ski slope, Ski Dubai, and the most luxurious hotels, Dubai is a must-visit for any traveler looking for a truly unforgettable experience. But beyond the glitz and glamour, there’s also a rich culture and history to be […]
Does my Azure SQL Managed Instance has a read-only replica
Here are two SQL scripts you can use to check if your Azure SQL Managed Instance has a read-only replica: 1. Using sys.dm_fts_mirroring_endpoints: This script queries the sys.dm_fts_mirroring_endpoints dynamic management view, which contains information about mirroring and read-only replica endpoints. It filters for endpoints that are currently in the “Synchronizing” state and are not local […]