Big Data Cluster is similar to SQL Server on Linux with Polybase, so you can only connect to Hadoop, Oracle, Teradata and Cosmos, you can't connect to other ODBCs.

It is also important to note there is a 32-bit and 64-bit installer, you can use either of them. If it is the 64-bit version, the connection options must be...

In the book "Hands-On Data Virtualization with Polybase" you learn how to install SQL Server on Windows Server Core running on Docker Windows, so you don't rely on Microsoft.

In the book "Hands-On Data Virtualization with Polybase" you learn how to install SQL Server on Windows Server Core running on Docker Windows, so you don't rely on Microsoft.

Hi eliassal, you can easily modify the script to substract 45 days from the X value, then you will get what you want. Just remember the value of in...

Hi eliassal, yes the code looks good, so you have the database name, the starting point (day 0, 45 days ago, with size 47 for StackOverflow2013), and the final point...

Hi eliasal, in that case you can rewrite the query as follows:

SELECT [Name], 0, b
  FROM [lr] GROUP BY [Name], [m], b
 UNION ALL
SELECT [Name], 90,...

• This reply was modified 2 years, 6 months ago by  Pablo Echeverria.

Hi eliassal, this is calculated in the CTEs named [slope] (calculates m) and [lr] (linear regression), then you can see in the next statement it is grouped by [m] and...

Hi eliassal, can you please clarify your request?

I miss seeing more articles daily, but it's understandable the fatigue you're facing, I would like to see more people supporting this project to give you a rest.

Hi dplaut 49149, just ignore them, these are GUID for the graphics generated in another tab, just switch to the plotted graphics.

Hi matthew.cartwright, you can use "FOR XML" and "STUFF" to generate a string out of multiple rows, you can find an example in this tip where I did the same:...

Hi dplaut 49149, after plotting the data I tell my customer which databases are growing fast and the space requirement for next month, with a graph. I can also tell...

Hi Jim, it looks like it is possible to create the linked server to Azure Analysis Services in the same way, see this link: https://querysurge.zendesk.com/hc/en-us/articles/115003937746-Configuring-Connections-Microsoft-SQL-Server-Analysis-Services-using-Linked-Servers

I totally agree with you, Steve.