InRik in a Data JourneybyRiccardo Perico·Oct 12VertiPaq Optimization: Data Ordering MattersData ordering in reading is a crucial optimization to keep your model thin
InRik in a Data JourneybyRiccardo Perico·Sep 9When AI Gets It Wrong: Why We Need to #StayRelevantA story about Microsoft Fabric, Managed Private Endpoints, conflicting documentation, and why humans still need to know when AI is wrong
InRik in a Data JourneybyRiccardo Perico·Aug 10Lateral Column Alias: When Snowflake Made Me Feel Like a SQL NewbieWhy moving between SQL platforms can still surprise you after 20 years
InRik in a Data JourneybyRiccardo Perico·Aug 5Cross-Tenant Managed Private Endpoints in Microsoft FabricSecurely access Azure Blob Storage across Microsoft Entra ID tenants using Managed Private Endpoints.
InRik in a Data JourneybyRiccardo Perico·Jul 7#tsql2sday #200 — I bet a query it’s bad if I see…I know we’re on the same page…A response icon1A response icon1
InRik in a Data JourneybyRiccardo Perico·Jun 24Mirror Azure SQL with Workspace Identity in Microsoft FabricUsing Workspace Identity to secure Azure SQL connectivity in Microsoft Fabric Mirroring
InRik in a Data JourneybyRiccardo Perico·Jun 6Power BI and Snowflake KeyPair authentication, mystery solvedDouble check the connection string!A response icon2A response icon2
InRik in a Data JourneybyRiccardo Perico·May 18Snowflake Wants Stronger Authentication. Your Connectors May Not Be ReadyA real-world look at ADF, Power BI & Fabric implementation
InRik in a Data JourneybyRiccardo Perico·Apr 24Integrating Microsoft Fabric with Google Cloud Storage in the real-worldAn architecture redesign to overcome DirectQuery headaches
InRik in a Data JourneybyRiccardo Perico·Apr 2Fabric Data Gateway: control or chaos?The update strategy makes the difference