Steps to Import MariaDB Objects and Data into SQL Server MariaDB is a derivative of MySQL with the intent to keep this open source as well as compatible with MySQL. Sometimes it is necessary to import objects and data from MariaDB to SQL Server. In this example, we will work through the steps in SQL Server Integration Services (SSIS) to import the table structure and the data.
Introduction to Business Intelligence Markup Language (BIML) for SSIS Every ETL project has some repetitive tasks, but with SSIS out-of-the-box, you are forced to create multiple individual packages which is very time consuming due to the lack of easy code reuse. In this tip we show how you can get reuse using Business Intelligence Markup Language.
Evolution of SQL Server Self Service Business Intelligence Learn how Reporting has evolved into Business Intelligence (BI) on the SQL Server platform then determine how your current solution measures up. In this session, we will discuss the self-service BI continuum along with the associated technology options, challenges, opportunities and more. Learn the best practices from the field to overcome some common challenges for getting reporting out to the user community.