Info

SQL Data Partners Podcast

In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry. I want to introduce new and familiar topics and talk about them in a way you may have not considered. We are all on different stages as data professionals. I hope you will join me on the SQL Trail, compañeros--you won't regret it.
RSS Feed Subscribe in Apple Podcasts
SQL Data Partners Podcast
2019
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: May, 2019

Companeros, welcome to the SQL Data Partners Podcast, a podcast dedicated to SQL Server related topics which is designed to help you become familiar with what’s out there, how you might use features or ideas and how you might apply them in your environments.

May 22, 2019

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!

May 15, 2019

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!

May 8, 2019
These are dark times. Drastic measures must be taken. In this episode, we talk about--coding. *Queue scary music* Last year I bumped into Sean McCown and found out he had coded himself a GUI for his MinionWare product. This left me both impressed and stumped. We talk with Sean, Eugene, and Kevin about why they decided to learn a coding language and I give some of my hesitations for not picking up a coding book.
 
The show notes can be found at http://sqldatapartners.com/2019/05/08/episode-169-should-you-learn-to-code. Have fun on the SQL Trail!
May 1, 2019

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!

1