So this code should replace

SELECT [Name], GEOMETRY::STGeomFromText('LINESTRING(0 '+CAST( AS VARCHAR(53))+',90 '+CAST([m]*90+ AS VARCHAR(53))+')',0) [Geom]
FROM [lr] GROUP BY [Name], [m], 

If I am not mistaken?

So many thanks, but how we can get data to used in excel and not spatial?

You indicate in one of your links "the storage needs for the next 45 days using the instructions "Forecasting, Identifying Trends with Linear Regression · Advanced SQL · SILOTA", how...

Hi Pablo, can you please the script that helps plot the graphs, I am not so strong in this stuff, thanks

So Steve, what is the benfit of being able to write python code that we can't execute correctly unless using notebooks. Is there a workaround to be able to execute...

Nice and useful work. Clear steps, I followed them and everything works like a charm. It would be very interesting to alternate the colors of the rows to be more...

Hi Andy, I have a server where I have 2 instances, default and a named 1. When I execute the styatement

SELECT *

FROM sys.dm_os_performance_counters

WHERE counter_name = 'User Connections';

In the default, I...

No response is correct, I agree with ilyaioffe

Hi, good ideas, however, you indicate "with a script I had in my previous article, which looks like this.........." but nothing follow

Thnaks for your help

Hi FRank, useful post, all works fine except when I try the best way by running

$SqlSqlConn = New-Object System.Data.SqlClient.SqlSqlConnection("Server = $Server; Database = $Database; Integrated Security =...

Thanks

Hi Imran, is it possible to provide the Invoice_Fixedwidth text file to play with the commands?

Theo, this is Salam, I am having the same thing in edge and Chrome, opened the file in notepad++, changed encoding to UTF-8 but it did not help, same thing...

Hi Ribert, the link to download V2 is corrupt (https://www.sqlservercentral.com/articles/baseline-collector-solution-v2), it lands us

http://www.sqlapprentice.net/download-bcs/

Not Found

The requested URL was not found on this server.

Additionally, a 404 Not Found...