A few days ago, one of my customers reached out to me on Yahoo Messenger (yes, it still exists) and asked how to identify what the potential data loss is when DBCC CHECKDB reports corruption of a SQL Server database. My common response is the usual “it depends” in that there are cases when DBCC CHECKDB may recommend using […]
The side effect of learning something new is that you feel like you were smarter today than you were yesterday. OK, wait, let me take that back. The irony of learning something new is that you feel like there’s a lot more that you don’t know. It’s easy to think that we already know what we […]
This video is a compilation of different database recovery techniques that SQL Server DBAs should be familiar and comfortable with. We will look at recovering a database to a specific point in time, isolating critical objects or using table partitioning as an HA/DR option (more commonly called online piecemeal restore) and performing page-level restores. I […]
I’ve made it official last week on my LinkedIn profile. It’s been interesting to see the different comments I got after my LinkedIn status change. But what’s really exciting is the journey and the story behind it. I have worked for Pythian since November 2008 – started out as a SQL Server DBA until eventually moving on to […]
This month’s T-SQL Tuesday is hosted by Kenneth Fisher (blog | twitter) and the topic is security. Security is a topic that I’m pretty serious about and have decided to join in the conversation. Security is one of those subjects that most DBAs have to deal with regardless of specialty. So, as something we all have […]