You’ve got first name, last name, full name, birth date, address, email, phone, tax ID or Social Security Number, driver’s license number, medical evaluation notes, MAC address, and IP address columns in a table. So, what would you encrypt in this table? In this episode, our guest, Tom Norman discusses various encryption options and how he goes about choosing what to encrypt. As there are more and more security breaches, the ability to encrypt data is as important as ever.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/05/22/episode-171-sql-server-encryption. Have fun on the SQL Trail!

Two years ago blogger Jay Killeen observed, "And with modern languages and modern applications such as PowerBI and Power Query you should be safe to assume there would be modern tooling. You would be wrong." In this episode, Eugene and I explore the challenges with Devops in Power BI and some ways we and others have implemented to help us deal with versions and team development of reports. Companeros, you can also win a SQL Data Partners T-shirt if you post on social media using the hashtag #sqltrail.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/05/15/episode-170-devops-with-power-bi/. Have fun on the SQL Trail!

One of the great abilities we have with Power BI is connecting to multiple data sources. Authors can actually publish data sources for others to use in their reports. Developers then get to mix and match our reports with all that data; however, there will be times we don't want everyone to see all the data sources. In today's episode, we discuss Power BI privacy levels, what they are and what they can--and can't do for you.

The show notes for today's episode can be found at http://sqldatapartners.com/2019/05/01/episode-168-data-privacy-settings. Have fun on the SQL Trail!