Episode 180: PolyBase in SQL Server 2019

SQL Server 2022 has been announced and we are excited to start unpacking the new features. For this episode, we start with a very interesting feature--Bi-directional HA/DR to Azure SQL. We have the ability to failover to the cloud now—the trick is, getting back is not as simple. Now, the on-premises version will be compatible with Azure SQL Managed Instance, and this will give move options for DR—and make setting it up even easier. The show notes and video for this episode can be found at https://sqldatapartners.com/2021/12/15/episode-239-bi-directional-ha-dr-to-azure-sql. Have fun on the SQL Trail!

15 Joulu 202134min

Part 2 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address before turning users loose with Power BI. In this conversation, Brandon Michals helps us take a look at three areas of consideration: your company, your people, and your data. Spending the time to think through and take the appropriate action in each of these areas will go a long way towards helping your organization achieve a successful Power BI implementation. The show notes and video for this episode can be found at https://sqldatapartners.com/2021/12/01/episodes-237-and-238-getting-started-with-power-bi. Have fun on the SQL Trail!

8 Joulu 202131min

Part 1 Power BI has been described as a "self-service" BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address before turning users loose with Power BI. In this conversation, Brandon Michals helps us take a look at three areas of consideration: your company, your people, and your data. Spending the time to think through and take the appropriate action in each of these areas will go a long way towards helping your organization achieve a successful Power BI implementation. The show notes and video for this episode can be found at https://sqldatapartners.com/2021/12/01/episodes-237-and-238-getting-started-with-power-bi. Have fun on the SQL Trail!

1 Joulu 20211h 6min

Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We're smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon further inspection, we found it was easier for us to focus on what we do—database administration, and let the developers focus on what they do—build software. This episode explores our choice of SolarWinds SQL Sentry as the monitoring standard for SQL Data Partners. The show notes for today's episode can be found at https://sqldatapartners.com/2021/11/17/episode-236-database-monitoring-with-sql-sentry. Have fun on the SQL Trail!

17 Marras 202142min

Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode this week and opened it up for a Q&A session. We touch on database monitoring, memory grants, what we miss about being in an office, and even SharePoint (Gasp!). The show notes for this episode can be found at https://sqldatapartners.com/2021/11/03/episode-235-sql-trail-2021-in-person-qa. Have fun on the SQL Trail!

3 Marras 202125min

As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you can communicate and influence. It's a scary thought, but your ability to negotiate with the business directly often determines if your projects get funded. Those skills are arguably as important as your T-SQL. In this episode, we chat with Blythe Morrow about strategies you can incorporate to better communicate with those around you. The show notes for this episode can be found at https://sqldatapartners.com/2021/10/06/episode-234-communication-tips-for-the-it-pro/. Have fun on the SQL Trail!

7 Loka 20211h 1min

Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to the podcast to educate us and our listeners on a product that can help us parse, process and format our SQL queries. The show notes and video can be found at https://sqldatapartners.com/2021/09/15/episode-233-scriptdom. Have fun on the SQL Trail!

15 Syys 202146min

Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters or public speaking group, so we give some thoughts on preparation, soliciting feedback, audience engagement, and handling criticism. I should point out that public speaking is WAY different from recording videos. We hope you find the information useful. Did we miss anything? Let us know! The show notes and video for today's episode can be found at https://sqldatapartners.com/2021/09/01/episode-232-giving-technical-presentations. Have fun on the SQL Trail!

1 Syys 202154min