Community. I believe we’re all created for it. I believe most people thrive when they find it. In fact, for many people, community has been their lifeline over the last year. Truth be told, however, community is hard to build and maintain. When I jumped onto a new career path in September 2020 as a … Read more
Amazon Babelfish promises to help customers seamlessly move from SQL Server to PostgreSQL. I’m not excited about it, but probably not for the reasons you think!
Custom Data Connectors can support multiple kinds of authentication. For most modern web apps, OAuth is the obvious choice and the Power Query SDK, coupled with the authentication examples (here and here), make it easy to setup. Unfortunately, two apps that I have recently created Custom Data Connectors for were partway through an OAuth implementation. … Read more
The more complex a Power BI Custom Data Connector gets, the more cumbersome the main Power Query file becomes. Without the ability to make a true “project” structure and include or directly reference functions from other files at this point, I wanted to find a way to keep things a little more organized. In the … Read more
I’m thrilled to share that I’ve completed my first Pluralsight course, Programming SQL Server Triggers and Functions, and it has finally been published for subscribers to enjoy! I began the journey of authoring my first course with Pluralsight September 2018 and officially started production of this course in February of this year. It was certainly … Read more