DBAs get paid for performance but we keep our jobs with recovery. Being able to recover data is the most important job function you have as a DBA. If you can’t recover your data because database backups are missing, or corrupt, then you should consider a new line of work. The year is 2015 and we … Read more
Last week I was fortunate enough to attend Enterprise Data World in Washington DC. I was not just at EDW as an attendee, I was also presenting two sessions. Since it was my first EDW that meant I had no idea what to expect either as an attendee or as a presenter. On top of that I was … Read more
This week I will be attending Enterprise Data World in Washington, DC. I’m excited to have been given the opportunity to present not one but TWO sessions at the premiere data management conference in the world. On Wednesday, April 1st, I will be presenting a session titled “Designing For Performance or How I Learned To Stop Worrying … Read more
When you create a database in SQL Server and do not specify a file location for your data and log files SQL Server will rely on the default database file locations as defined in the server properties.
It’s the classic twist in horror stories from 40 (or more) years ago, back in a time when most homes only had one phone line and the idea of calling your own home was something reserved only for phreakers. Here’s a clip of a movie scene from 1974 called “Black Christmas” (skip to 4:29 in … Read more
Rogue data is data that is either maintained outside of, or has simply left, the control and security measures used by your company. I have yet to meet any data professional that is comfortable with the idea that their data may have gone rogue. This is especially true whenever the subject of Cloud architecture is … Read more
