Modernization Secrets for your SQL Server Data Warehouse

Why Modernize your SQL Server Data Warehouse? SQL Server data warehouses typically utilize SQL Server for database, SQL Server Integration Service (SSIS) for data integration, SQL Server Reporting Service (SSRS) for BI reports, and SQL Server Analytics Service (SSAS) for analytical needs. For legacy data warehouses developed with end-of-support versions of SQL Server, maintenance costs … Read more

How to use AI to modernize your PL/SQL code in Synapse or Snowflake

PL/SQL versus Synapse and Snowflake PL/SQL is a procedural language designed to be embedded in SQL statements. It is a powerful language that can be used to perform a wide range of tasks, including data manipulation, error handling, and complex logic. However, PL/SQL can also be difficult to maintain and update, especially for large and … Read more

What is Microsoft Fabric? Data Platform Overview and Best Practices

Overview of Microsoft Fabric Microsoft Fabric is an AI-powered analytics platform that integrates the best of Microsoft’s data and analytics tools, including Azure Data Factory, Azure Synapse Analytics, and Power BI. It offers a unified experience that enables organizations to seamlessly connect, prepare, analyze, and visualize data. Fabric allows users across the organization to leverage … Read more