After 170 episodes, we bring back Louis Davidson to talk about database design and get his thoughts on how we can get better at planning for our data.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/10/16/episode-178-database-design. Have fun on the SQL Trail!
As the data platform continues to evolve, so do certifications. In this episode we chat with Rick Heiges about the new role-based certifications and how they fit into Microsoft's cloud platform. We revisit how certifications still play a role in career development and how certifications have changed. Also, Kevin gives us his experience with taking an exam at home.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/06/12/episode-173-new-data-certifications. Have fun on the SQL Trail!
From a SQL Server perspective we have many ways to identify problem areas. In this episode, we discuss ways to diagnose performance issues in Power BI. They are certainly making many strides; however, the tools won't feel as mature as they do in SQL Server. We review usage metrics, audit logs, the new Data Gateway monitoring tool and monitoring options in Power BI Premium. The Performance Analyzer had just been released and while we don't go into great detail, we'll be sure to include it in the show notes.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/06/05/episode-172-power-bi-monitoring/. Have fun on the SQL Trail!
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
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!
Azure SQL Data Sync has been generally available for almost a year now. Have you heard of it? Are you using it? Microsoft's page tell us that "Data Sync is useful in cases where data needs to be kept up-to-date across several Azure SQL databases or SQL Server databases." When you want to learn about a new product or feature, who better to ask than the Senior Project Manager in charge of it? Today we chat about Azure SQL Data Sync with Xiaochen Wu from Microsoft. He explains how it works, why you might want to use it, it's current limitations and what's in the pipeline in the way of improvements. It's an exciting time to be in technology and a great conversation!
The show notes for today's episode can be found at http://sqldatapartners.com/2019/04/24/episode-167-azure-sql-data-sync. Have fun on the SQL Trail!
The number one reason organizations choose Power BI is the ability to visualize data; however, even with all the immediate choices, many report developers desire to create custom visualizations. In this episode, we chat about custom visualizations for Power BI: how to get them, how to pick them, and when (if ever) you would consider building your own. Have a favorite custom visualization you have used? Let us know!
The show notes for today's episode can be found at http://sqldatapartners.com/2019/04/17/episode-166-custom-visuals. Have fun on the SQL Trail!
Why should I care about this episode? I know many of you are going to ask that question. Artificial Intelligence is getting lots of buzz and in this episode we invite Hope Foley from Microsoft to discuss why and how AI is relevant to those in the data platform community. We get a little help from Kevin Feasel as we try to connect the dots between all the hype and how this can and will affect you in the future. Did we do a good job? Let us know and contribute to the conversation.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/03/27/episode-165-artificial-intelligence. Have fun on the SQL Trail!
DAX is the acronym for Data Analysis Expressions, and it is the formula language used throughout Power BI. In this episode we talk about DAX concepts and how they are simple and straightforward, but can be confusing for those coming from a relational database background. DAX uses some unique programming concepts and patterns which can make it difficult to fully use and understand. We talk about some experiences getting started with this language and ideas on how you can get started.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/03/20/episode-164-the-dax-episode. Have fun on the SQL Trail!
Are you experiencing challenges managing Very Large Databases (VLDBs), or anticipate challenges with future growth? In this episode, we are joined by Aaron Hayes to discuss the practical advice on managing very large databases in SQL Server, focusing on common problem areas we have found, along with our own experiences. Topics include storage layout decisions, unique tuning challenges, HA/DR implications, and database restores, along with the challenges of getting backups, re-indexing and DBCC checks into your maintenance windows. No comparisons here -- we are sure you will enjoy the discussion regardless of your database size.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/03/12/episode-163-very-large-databases. Have fun on the SQL Trail!
In this corner, coming in with all its Excel glory we have Power Query! And in this corner we have a new programming language, DAX! Have you ever felt like there is a tug of war going on between these two technologies? In this episode, the team discusses the two technologies, what they do, when -- and perhaps more importantly, WHY might you use them.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/27/episode-162-power-query-vs-dax. Have fun on the SQL Trail!
How do you migrate 8,000 databases on a single instance in an environment that doesn't tolerate downtime? Today's episode focuses on migration strategy and how our guest Andy Levy faced the challenge of moving all those databases in the time constraints given him by the business. We also talk about some of the strategies Andy employs to administer and monitor all those databases.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/20/episode-161-migrating-upgrading-8000-databases. Have fun on the SQL Trail!
The traditional model for Power BI is to pay per user, but what if you want to use the reports in your web app and don't know who all the users would be? In this episode the team explores Power BI Embedded -- how it differs from the traditional service, what you need to set it up, and some reasons why you might explore this option over the others.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/13/episode-160-power-bi-embedded. Have fun on the SQL Trail!
So what happens when you want to use data from two different sources, manipulate it (transform it) and then present the data in Power BI -- and you don't know how to use SSIS? Well, it turns out you can use Power BI dataflows. In this episode we explore the topic of dataflows with our guest, Matthew Roche, and talk about the scenarios and types of folks dataflows was intended for.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/02/06/episode-159-power-bi-dataflows. Have fun on the SQL Trail!
For only 10 bucks a month you can start visualizing your data and finally get the dashboard your executives have been waiting for!! What's that? You need to refresh the data--perhaps even multiple times a day? Oh, well it's still $10 a month, but you are also going to install a gateway. What's that you say? Well, in this episode we begin our discussion on Power BI with one of the first components you will need outside of the Power BI Desktop for your users to start interacting with updated data. We discuss what it is, some of the requirements, and our experiences setting one up.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/01/23/episode-158-gateways. Have fun on the SQL Trail!
I can still remember working in high school when you had to 'dial in' to the internet and Microsoft bought the rights to the Rolling Stones song 'Start Me Up' for the release of their highly anticipated software Windows 95. It was a complete game changer for me and shaped my professional life with the releases of the Windows Server Operating System. While you could never just wing it, the GUI provided a rich interface and the ability to explore features without having to know all the syntax to execute the functionality. You can image the surprise I felt when Microsoft came out with Windows Core--an operating system with no GUI. While you may not have adopted Windows Core yet, our guest, Frank Henninger, suggests you should reconsider. We chat with him about the benefits, some of the challenges, and how we can better take advantage of using Windows Core.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/01/10/episode-157-windows-server-core. Have fun on the SQL Trail!
How well do you connect with others? We generally think pretty good of ourselves and at first glance you may give yourself a pretty high score. While there is no test you can take to compare your results to mine, the way you connect with others can have a profound influence in the workplace and we are each judged by the people we come in contact with. Our guest in this episode, Linda Groszyk, talks with us about some of the ways social intelligence can impact us, how we can get better at it and who we can reach out to if we need help.
The show notes for today's episode can be found at http://sqldatapartners.com/2019/01/02/episode-156-social-intelligence. Have fun on the SQL Trail!