I chat with Microsoft MVP Chris Bell about database security and some seemingly cavelier attitudes some organziations have about keeping data safe. We hit some of the methods SQL Server has to protect your data. Chris also unveils his security analzyer you can use in your environment to see what areas might need to be addressed.
You can check the full show notes at http://sqldatapartners.com/2015/09/01/episode-07-sql-server
Robert Verell and I chat about good security practices and the principle of least privilege. We discuss Robert's rule to never give anyone db_owner, other groups and Robert's home grown group to give instead of db_owner.
Be sure to check out http://sqldatapartners.com/2015/08/19/principleofleastprivilege/ for the show notes.
We finish up our conversation with MVP Tim Radney on backup options with discussions on encryption and Azure. Tim also shares his favorite tools and his super hero power of choice.
Erik Véliz, the creator of SQL Server Booster is looking for folks to help with his lastest update. Check out sqlserverbooster.com for more info.
Also be sure to check out http://sqldatapartners.com/2015/08/11/episode04 for the shownotes and a chance to win Tim's book.
I chat with MVP Tim Radney about Backup and Recovery options in SQL Server. We chatted for quite awhile and I ended up making two episodes out of our conversation. This episode focuses on why we backup and some core ideas. Advanced features will be in episode 04. You can register to win a copy of Tim's book on Backup and Recovery by visiting sqldatapatners.com/podcast. Also be sure to check out the very cool offer from SQL Skills at the end of the session.
I was in Argentina for the SQLSaturday event in May of 2015 and made friends with Javier Villegas, a 20 year veteran in the DBA world. While extended events have been around for some time, many are still getting used to this new feature and I talk with Javier about how he uses extended events and how we might get started.
Be sure to check out http://sqldatapartners.com/2015/08/05/podcast-episode-02-extended-events/ for show notes and links to content discussed in this episode.