(Jason Brimhall) Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper into it. That happened to me recently and caused me to preempt my scheduled post and work on writing up something entirely different.

(Chris Webb) While the integration of the Power Query engine into Analysis Services Tabular 2017 and Azure Analysis Services with modern data sources will certainly bring a lot of benefits, I think it’s fair to say that the implementation has not been entirely painless.

(Melissa Coates) This is a quick post to share a few scripts to find what is currently executing in Azure Data Factory. These PowerShell scripts are applicable to ADF version 1 (not version 2 which uses different cmdlets).

(Pinal Dave) Not every problem might have a solution, and we must use a workaround to move forward. This blog is also related to one such error message which I observed while installing a clustered instance of SQL Server.

(blobeater) Today I found out that it is now possible to enable the setting optimize for ad-hoc workloads at the database level when using Azure SQL Database. Traditionally this was always set at the server level for locally based SQL Servers.

(Shreyas R Gowda) A few days back, I was working on an issue where in my client applied the patch KB3045318 on his SQL server instance running on SQL server 2012 SP1 build.

(Pinakin Patel) In a previous tip, Implement SQL Server High Availability and Disaster Recovery on Amazon EC2, we discussed hardware and software requirements and installed the .NET Framework and Failover Cluster Feature in each of the Elastic Compute Cloud (EC2) instances.

(Pinal Dave) Microsoft has recently announced a very interesting feature for security of your SQL Server. I really loved this new feature – SQL Vulnerability Assessment.

(Melissa Coates) As we are approaching the end of 2017, many people have resolutions or goals for the new year. How about a goal to get organized…in your data lake?

(Jason Brimhall) No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit more. No matter how many times we hand an audit report over to the auditor, there is always “just one” more report we have to provide.