Ronny Meeusen

29 May 2018 Azure hybrid solutions with on-premise SSRS Server

For the moment, SSRS (SQL server reporting services) is currently not an Azure component. Will it be available in the near future…? I don’t know. SSRS- functionalities become available in other dashboards and reporting tools like Power BI. Today, you’ll need to work with an on-premise installed SSRS server or you'll have to setup one in an Azure VM.

15 May 2018 Store documents in Azure Blob storage using SQL

One little step in a migration track from on-premise to Azure is related to binary files like images, pdf and others. These files are often stored on many different places. When these files are stored in SQL, you probably have already created a variety of SQL procedures. But you can also use Azure blob-storage.

13 May 2018 Using Azure Blob storage in SSRS reports

Attractive reports are not only showing the hard material statistics and numbers. Visualization of your data leads more and more to graphical decision making. One particular part of your reports are images for logo’s, product images etc. When moving to the cloud, where do we need to store and find our data and images?

11 May 2018 Hybrid cloud solutions

I truly believe in the azure environment. The possibilities are huge and growing every day. Do we all need to migrate to the cloud ‘sito-presto’…yes, I think so. Why I’m so sure about this, is easy to explain. The most important reasons for me are: cost-efficient architecture possibilities and lower maintenance due to very stable architecture solutions.

29 Nov 2016 Dynamic bulk copy staging package

The most commonly created packages are data copy packaging from one source DB to a staging target DB. Instead of creating multiple packages (with or without BIML), a META data free solution can be made using the .NET SqlBulkCopy class.

22 Nov 2016 Dynamic bulk copy SSIS package

Using the .NET SqlBulkCopy class, you can easily create a parameterized package to copy a bunch of tables at once. Instead of creating multiple packages, we can also create a generic package that covers the complete set of tables we want to copy.

15 Nov 2016 Meta driven SSIS and bulk copy SSIS packages

ETL processes have a lot of common parts between them. One important part of it that’s frequently repeated is a data copy sub-process to copy table(s) data from one server/database to another. Sometimes full table copies, in other cases with specific data selection. For every table or selection, you create the process in one or several packages/control flows and/or data tasks. There is not much special to say about small tables, but large tables are another matter.

08 Nov 2016 Using SQL filetables with entity framework

Recently I had a problem on a project where we needed to securely store documents. It was the first time for the customer to do such a thing. Telling them this was not so hard, I convinced them to us SQL file tables to store these documents securely in an SQL server database.