loader from loading.io

Episode 171: SQL Server Encryption

SQL Data Partners Podcast

Release Date: 05/22/2019

Episode 191: Power BI Row-Level Security show art Episode 191: Power BI Row-Level Security

SQL Data Partners Podcast

Wouldn’t it be nice if you could filter the rows a user sees in Power BI? What’s that? You’ve already implemented Row-Level Security at the database level? Well, that actually won’t help you in Power BI. Yikes. In this episode we discuss ways to filter by records in Power BI and why it might be so confusing to implement what at first glance seems like a straightforward request.

info_outline
Episode 190: SQL Server 2019 show art Episode 190: SQL Server 2019

SQL Data Partners Podcast

Getting released just before the end of the year, SQL Server 2019 is now available in general release. While at first glance, it appeared this release was all about Big Data Clusters, and rightfully so--it brings 'cloud first' options to on-premises scenarios; however, it is not the only big feature. In this episode, Javier Villegas guides us as we dive into some of the performance enhancements--and run out of time. This just means we need a few more episodes to dig into more features.

info_outline
Episode 189: Power BI Common Data Model show art Episode 189: Power BI Common Data Model

SQL Data Partners Podcast

Moving data is fairly straightforward; however, mapping data from one source to another can be extremely challenging. In an attempt to help self-service BI users, Microsoft has introduced a Common Data Model. This may not be as approachable for organizations which already have a data warehouse; however, for those who are in the Microsoft suite of tools and looking to report on that data in Power BI, the Common Data Model may be the jump start to get the model you need to get going.

info_outline
Episode 188: Databricks show art Episode 188: Databricks

SQL Data Partners Podcast

A couple of years ago, Netflix offered a reward for anyone who could improve the algorithm for choosing a movie. The team that came in second took what they learned from it and created a company -- Databricks. In this episode, we focus on Databricks; why it is popular, what it can be used for, and considerations for its use.

info_outline
Episode 187: Power BI Performance Tuning show art Episode 187: Power BI Performance Tuning

SQL Data Partners Podcast

Make it go faster! Visualizations are great, but when users start complaining about the load times on reports, it can be a tough exercise to figure out the issues. In this episode, we discuss ways you can measure the speed of your Power BI reports. We also get into some of the fundamentals of data storage for Power BI.

info_outline
Episode 186: Analytics & Security: Find Pain Points, Make a Plan show art Episode 186: Analytics & Security: Find Pain Points, Make a Plan

SQL Data Partners Podcast

2020 dawns a first for our podcast. We've had questions before; however, this episode the team tackles two questions from longtime listener Trent Adams. The context of his questions surround the concepts of IT having the ability to provide new functionality to the business and the business appearing to be uninterested in moving forward. We discuss the best way to identify pain points and ways to introduce new technology without imposing new rules/processes on the business.

info_outline
Episode 185: DBATools in a Month of Lunches show art Episode 185: DBATools in a Month of Lunches

SQL Data Partners Podcast

Why write a book, when you already have a site full of documentation? In this episode we chat with Rob Sewell about his project to write a book, DBATools in a Month of Lunches. He gives us some insights on what the book is about, how it is different than documentation, and how the process of making the book available in pieces has helped the creative process.

info_outline
Episode 184: Where do people get stuck with Power BI? show art Episode 184: Where do people get stuck with Power BI?

SQL Data Partners Podcast

You've seen the visualizations and want to dive in--perhaps you were assigned the task. However you started with Power BI, chances are you might get stuck at some point. In this episode, we chat about strategies you can employee to help ensure success. Have a take on this? Hit us up on social media. We'd love to hear from you.

info_outline
Episode 183: SQL Server Big Data Clusters show art Episode 183: SQL Server Big Data Clusters

SQL Data Partners Podcast

SQL Server 2019 is out and one of the most interesting additions is SQL Server 2019 Big Data Clusters. In this episode, Kevin Feasel covers the marriage of SQL Server and Apache Spark. We discuss what Big Data Clusters are (and how it's not a SQL Server feature or an edition of SQL Server, but a thing in itself), cover some of the architecture behind the solution, and explain how we can use them. The show notes for today's episode can be found at . Have fun on the SQL Trail!

info_outline
Episode 182: XEvents show art Episode 182: XEvents

SQL Data Partners Podcast

The very first podcast episode I recorded was about Extended Events. We've had several new versions of SQL Server since that time, so I thought it was time to bring up the subject again. We are joined by MVP Jason Brimhall and he shares his insights on Extended Events, what has changed, and how to get started.

info_outline
 
More Episodes

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!