Case sensitivity in data can trip us up unknowingly and Integration Services is no exception. Depending on the components we’re using we may notice different behaviour. Without understanding the way case sensitivity is treated within SSIS packages, we may see unexpected results with string comparisons. Let’s clear things up and dive into a few examples […]
I recently had an issue when sourcing data in Power BI from a server which was accessed by a DNS alias. Here I’ll demonstrate the issue and how to resolve it. After entering the server details, we could be greeted with the message below: The server name provided does not match the server name on […]
One of the benefits which comes with a Managed Instance is having backups taken care of for you. That also includes restores. Particularly useful is a one-click (ish) restore for a specific point in time. Restoring a database is as easy as creating a new database, as its part of the same workflow. From the […]
Data quality and consistency is key to the services we support and solutions we deliver. A gremlin which can undermine that is duplicate data. Let’s start the new year dealing with duplicate data and having a good clear-out. For our example we’ll consider an Order Product table which contains an OrderID and ProductID, and the combination of these should […]
Andy Brownsword 