(Kenneth Fisher) I recently had an interesting time getting the SQL Auth logins on a new instance working. I was doing a side by side upgrade and the only server principals used by the application were SQL Server authenticated logins. I tried over and over again but kept getting the same error.

(Thomas LaRock) All too often, we data professionals are our own nemesis when it comes to handling data and data management. Many data professionals and system administrators fail to recognize that the danger in our own habits increases the risk that the business will fall short of its goals.

(Nat Sundar) I read the previous tip to implement metadata driven SSIS development, but how do I extend the functionality to implement SSIS data flow transformations?

(Nakul Vachhrajani) Developing SSIS packages is quite easy – it’s mostly drag and drop and some minor configuration. Choosing the right transformations and components and making them work optimally is a task that is heavily dependent upon the use case at hand.

(Arun Sirpal) I was building some basic queries around time zone manipulation and I am happy to say that I enjoyed myself as I found a way to get a time based on a geographic region.

(Greg Larsen) Have you ever wondered how to find the worst performing TSQL queries on your instance? If you have, you are not alone.

(Eric Parvin) The build Command Line task available in the Task Gallery provides the Tool and Arguments options for configuration. The Tool option is where you specify the executable to run and the Arguments option are the values to be passed into the executable.

(Jon Gallant) This post will show you how to create a Power BI Embedded Workspace Collection via the new Azure CLI 2.0. People typically create Workspace Collections via the Azure Portal, but that requires clicks and take more time than just doing it in the command line.

(Simon Liew) The model deployment wizard in the SQL Server Master Data Services (MDS) web application only allows for the creation of a deployment package which contains model objects only. This tip describes the steps to copy both the MDS model objects and data.

(Arun Sirpal) This is an entry level post and a response to SQLEspresso’s blog challenge(http://sqlespresso.com/2017/01/10/ooops-was-that-was-me-blog-challenge) where we share mistakes from our “younger” days.