Erik Veerman's Blog, page 5

Big changes are under way at SolidQ

I am excited to announce to our community and partners that I have moved on from my North American leadership role to a new role as our Corporate Chief Technology Officer. My new job is to align the long-term vision of what SolidQ does and how we do it, across all our international markets. Joining […]

Fixed some SQL Server Partition Management Utility Bugs

The SQL Server Partition Management Utility (http://sqlpartitionmgmt.codeplex.com/) is one of the best tool used to manage the partition-switch operations. It is a command line tool and can be integrated in a SSIS package or used to generate the T-SQL scripts needed in a regular “sliding window” partition management scenario. A blog post that shows how to use […]

Sometimes you need to store credentials

Of course storing passwords themselves is a bad idea, but what about something to authenticate users with? This is a simple implementation of BCrypt in SQL Server to get you started, remember to encrypt your traffic!

Azure ML through the eyes of an SSIS developer

Explore the Azure Machine Learning API through your favorite ETL tool. Some assembly required. This is a quick short version of a talk I gave at sql saturday in Gothenburg.

Connect Azure to your local network

In this article I show how it’s possible to connect a local network which is protected by NAT, to an Azure virtual network. This is useful for testing and developing solutions which depends on communication between a local network and Azure.

Pyramid Analytics & Power BI

Written by Patrick F Dubois, Consultant at SolidQ North America With a recent announcement from the folks at Pyramid Analytics of a strategic alliance with Microsoft, and the recent release of Microsoft’s PowerBI Desktop into a data hungry environment, the market for Self Service BI just became much more interesting. First, what is PowerBI and […]

SSDT: How to Solve the Circular References Issue

Today I’ll show you how to solve one of the most […]

Microsoft DataZen Mobile Platform Available to SQL Server Enterprise Customers for Free

Last month Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite. This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio. What’s more, is that they plan to make if free for SQL Server Enterprise customers who have Software Assurance agreements.

Watch for a series of articles about getting started with DataZen in SQL Server Pro Magazine online.

I presented a session at the PASS Global Summit in 2013 showcasing DataZen called “New York, London, Paris Munich; Everybody’s Talking About Mobile BI”.

SSAS Tabular Modeling Article Series on SQL Server Pro Magazine

I’ve just finished a series of four articles for SQL Se […]

How to Get Reports in Excel Without Exporting from Reporting Services

This topic has been a recurring theme for a very long t […]