(Koen Verbeeck) At our company we’re using Azure Data Factory as the orchestrator for our data pipelines in Azure. We need to load flat files from various locations into an Azure SQL Database. The schema of the flat files can change per type of file and even the delimiter changes sometimes.

(Pinal Dave) During the recent consulting engagement Comprehensive Database Performance Health Check with my client, one of the DBA was busy with Always On deployment. He asked me if I can help him with some pointers.

(Svetlana Golovko) We need to migrate our SQL Server Analysis Services (SSAS) instances from SQL Server 2012 to SQL Server 2017. What are the steps? What are the potential issues? Is there a difference for multidimensional and tabular models upgrade?

(Jason Brimhall) The weather is starting to warm and Spring is upon us. It feels like a great time to take a stroll outside in the warming sun and maybe do a little window shopping on our way to the March (2020) blog party called TSQLTuesday.

(Pinal Dave) One of my clients contacted me for an error that appeared while performing a distributed transaction over a linked server. The interesting part was that the linked server was local SQL Server, this is also called a loopback linked server.

(Nisarg Upadhyay) AzCopy is a command-line tool that is used to upload and download blobs/files from or to the Azure Blob Storage.

(Kenneth Fisher) When I’m working with a tool I like a clean startup. And by that I mean don’t automatically open anything. I’ll let you know if I need a connection to object explorer, an open query, whatever.

(Scott Murray) What advanced features are available in the Power BI Q&A functionality? Also, how does the new Q&A visual work?

(Itzik Ben-Gan) This article is Part 4 in a series about NULL complexities. In the previous articles (Part 1, Part 2, and Part 3), I covered the meaning of the NULL as a marker for a missing value, how NULLs behave in comparisons and in other query elements, and standard NULL handling features that

(Pinal Dave) Choosing a Processor for SQL Server is always a challenge and I often find DBAs and organizations struggling with the same. I have request SQL Server Expert Glenn Berry (b|t) to help us in selecting the right CPU. I am confident that this blog will help us select the right Processor (CP