Viewing 15 posts - 1 through 15 (of 19 total)
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.
December 29, 2021 at 3:20 pm
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...
October 19, 2021 at 3:35 am
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.
August 14, 2021 at 10:10 pm
July 11, 2021 at 4:40 am
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...
May 26, 2021 at 10:43 pm
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...
May 25, 2021 at 6:05 pm
Hi eliasal, in that case you can rewrite the query as follows:
SELECT [Name], 0, b FROM [lr] GROUP BY [Name], [m], b UNION ALLSELECT [Name], 90,...
May 25, 2021 at 4:00 pm
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...
May 25, 2021 at 2:26 pm
Hi eliassal, can you please clarify your request?
May 25, 2021 at 1:13 pm
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.
April 28, 2021 at 8:04 pm
Hi dplaut 49149, just ignore them, these are GUID for the graphics generated in another tab, just switch to the plotted graphics.
March 17, 2020 at 1:57 pm
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:...
March 17, 2020 at 1:33 pm
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...
March 17, 2020 at 1:27 pm
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
December 20, 2019 at 3:50 pm
I totally agree with you, Steve.
May 23, 2018 at 6:31 am