SQL Data Partners Podcast

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.

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

Steve Jones, the editor from SQL Server central and I talk about the need to build your own brand and we share a few ideas on how to do that. We talk about Steve's brand and how he built that over time and some options available to allow you the most opportunities possible. This episode is a must have for those looking to kick it up a notch on the opportunity meter.

Be sure to check out the show notes at http://sqldatapartners.com/2015/08/25/episode-06-build-your-personal-brand.

We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been including Artificial Intelligence or AI in more and more of its marketing material. In this episode we'll dive into the definition of AI, what features are currently available, how we can leverage those technologies, and where we think this might go in the future. One of the challenges we currently face is all the buzz and excitement around AI. From a data platform vantage point, we started with analytics and training models to analyze the data. Microsoft has suddenly slapped Artificial Intelligence on some of the feature sets and confuses the issue a bit.

We are excited to have Mike Chrestensen from Duke Health as our episode guest to help us sort it all out. Mike has begun leveraging AI in his work and I think he gives some interesting thoughts on how he has used it to help his team go faster. We hope you enjoy the episode. As always, we welcome your feedback and thoughts.

The show notes for today's episode can be found at Episode 268: AI and the Future of the DBA. Have fun on the SQL Trail!

After a brief hiatus, we are back on the air to continue the conversation and let me tell you--we have a great conversation lined up for this episode. The discussion around what will happen to the relational database, and by extension us as administrators continues to get quite a bit of traction. Even within SQL Server, we are starting to see more features that don't fit the traditional relational mode and a podcast listener inquired about getting our thoughts. As I thought about a guest for this episode, I didn't want to get someone tied to a product. They, like me, would be biased and I wanted to get someone a bit removed from the situation.

Our guest today is Andrew Snodgrass, the research vice president at Directions and we chat about the future of the relational database and what the future of the data environment we manage might look like. I hope you will find his insights valuable as an outsider. While we don't get into the specifics of what databases are mostly like to be around, Andrew does give us administrator some idea's on what technologies we should start exploring.

What are your thoughts around the future of the relational database? Join the conversation and let us know!