Erik Veerman's Blog, page 2

Azure Files Premium + SQL Server Failover Cluster instance = simplified OnPremise to Cloud

One of the issues that many of our customers face when attempting to migrate OnPremise instances to the Cloud is the lack of a simple "shared storage". Although there are some alternatives supported by third-party software or SDS solutions that allow us to configure a Failover Cluster instance in Azure, these are highly complex, therefore adding significant further costs to the solution's TCO.

The post Azure Files Premium + SQL Server Failover Cluster instance = simplified OnPremise to Cloud appeared first on SolidQ Blogs.

Azure Database integrated authentication with SSIS

En muchos escenarios se nos presenta la necesidad de usar autenticación integrada para acceder a los orígenes de datos necesarios para alimentar nuestro sistema analítico. Con el uso cada vez más extendido de Azure, como al menos parte de nuestra infraestructura, algunos de estos orígenes van a estar alojados en bases de datos en Azure. En este caso vamos hablar de un error real que hemos tenido en la configuración y uso de la autenticación integrada contra bases de datos Azure con SSIS.

The post Azure Database integrated authentication with SSIS appeared first on SolidQ Blogs.

Power BI Bookmarks! What are they for? How can I use them?

In this entry, we will show you how to create bookmarks and different scenarios where they may be useful. Bookmarks are basically used to store the status of a specific report page including the filter selection and the visibility of the different objects, allowing the user to return to that same status by simply selecting the saved bookmark.

The post Power BI Bookmarks! What are they for? How can I use them? appeared first on SolidQ Blogs.

PowerBI Bookmarks! What are they for? How can I use them?

In this entry, we will show you how to create bookmarks and different scenarios where they may be useful. Bookmarks are basically used to store the status of a specific report page including the filter selection and the visibility of the different objects, allowing the user to return to that same status by simply selecting the saved bookmark.

The post PowerBI Bookmarks! What are they for? How can I use them? appeared first on SolidQ Blogs.

Power BI Dataflows: How does the new tool work?

¿Conoces la nueva funcionalidad de Power BI? los llamados dataflows, que ya existen en otros servicios como Office 365.

The post Power BI Dataflows: How does the new tool work? appeared first on SolidQ Blogs.

“On the fly” backup and restores without requiring intermediate storage

I'm sure that the most "senior" readers will remember the possibilities available in old SQL Server versions to do backups using named pipes. And by older versions, I mean "really old", since this functionality was marked as obsolete in SQL Server 7 and, although it remained in SQL 2000, it was completely removed from SQL Server 2005 and later versions.

The post “On the fly” backup and restores without requiring intermediate storage appeared first on SolidQ Blogs.

Converting Excel files into csv and uploading files using SSIS

Convertir un solo fichero Excel a csv se hace rápidamente de forma manual guardando el archivo como .csv desde Excel, el problema es cuando tienes que realizar este proceso con muchos ficheros Excel o necesitas que este cambio de formato se realice de forma automática.

The post Converting Excel files into csv and uploading files using SSIS appeared first on SolidQ Blogs.

Measure the Strength of Association Between Two Categorical Variables: Mosaic Plot and Chi-Square Test

How to measure the strength of association between two categorical variables

The post Measure the Strength of Association Between Two Categorical Variables: Mosaic Plot and Chi-Square Test appeared first on SolidQ Blogs.

Power BI (Audit) Usage Analytics; Get the most out of your Dashboards!

SolidQ has developed a powerful tool through Power BI itself that gives abundant information on the use of the organization´s Dashboards and Reports. Power BI Usage Analytics allows us to know, for example, whether a Dashboard is being used or not, if it is used a lot or a little, who uses them and at what times, what Workspace is used more, as well as compare uses of Reports / Dashboards between several dates, etc

The post Power BI (Audit) Usage Analytics; Get the most out of your Dashboards! appeared first on SolidQ Blogs.

Creating PowerPoint presentations from R

Create a PowerPoint presentation and insert a series of graphics and text programmatically, using the OfficeR and rvg packages together. Take advantage of the occasion to present (for those who do not know) the 'Pipe' operator, very useful when nesting functions.

The post Creating PowerPoint presentations from R appeared first on SolidQ Blogs.