(Nat Sundar) I have a requirement to search for multiple file extensions in a folder. However, in SQL Server Integration Services (SSIS) there is a limitation that the “Foreach File Enumerator” can filter only one type of file. Are there any workarounds to search for multiple file extensions?

(Thomas LaRock) In the last post, we reviewed the options for upgrading SQL Server 2016. After upgrading SQL Server you will need to perform a series of tasks to verify that database is ready to be handed over to the end users for further testing. This post will provide you a checklist of items to r

(Chris Webb) If you use Power BI to connect to a data source such as SQL Server in DirectQuery mode, you’ll find that by default you cannot use the complete range of DAX functions inside your calculations.

(blobeater) A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server vNext https://blobeater.blog/2017/02/03/sql-server-vnext/, more specifically around the Adaptive Query Processing feature.

(Pinal Dave) Here is another blog based on client’s interaction via Skype. They informed me that they are trying to execute the command ALTER DATABASE SET PARTNER while attempting to set up mirroring between two servers, we see the following mirroring error recorded in the secondary error log:

(Paul White) Pretty much every computed column related performance problem I have encountered over the years has had one (or more) of the following root causes:

(Thomas LaRock) In the last post, I mentioned that when upgrading SQL Server 2016 you have two options: in-place or side-by-side. With in-place upgrades, there is no need to worry about the transferring of data to a new server.

(Jack Vamvas) Question: When I’m using Powershell Get-ChildItem I get a recordset to get all files in directory. It also returns all the folders in the currrent directory. I’d like to be able to return only folders and exclude all files.

(Tim Smith) We have several APIs where we extract data and the sources are not always consistent in timing and data. Sometimes an API that we extract from is offline for a period of time, but our users still want to see the most recent data we have. In other times, we receive data from an API that a

(Pinal Dave) This blog is a response to a comment on our blog. Have you ever encountered below error related to media set?