Viewing 15 posts - 1 through 15 (of 55 total)
Hi, well for a beginner it is not so much self explanotory. I have Excel on French reginol settings, the formula generates an error. I maneged to correctly issue the...
April 7, 2022 at 8:10 am
Erin, very interesting post. However, I followed instructions and XE session created but when I read the details of the output of the session, it mentions events without indicating the...
December 22, 2021 at 8:35 pm
Great, got it, but shouldn't we have something like
0 > 45 days ago
X > Current
90 > 45 days in the future
so it might look like this
-45 > 45 days ago
0...
May 26, 2021 at 9:29 am
I tried the following but results confused me more, got only 0s and 90, how should this interpreted
Here is the modified code as your suggestion
May 25, 2021 at 5:41 pm
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?
May 25, 2021 at 5:33 pm
So many thanks, but how we can get data to used in excel and not spatial?
May 25, 2021 at 3:10 pm
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...
May 25, 2021 at 2:09 pm
Hi Pablo, can you please the script that helps plot the graphs, I am not so strong in this stuff, thanks
May 25, 2021 at 6:58 am
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...
March 16, 2021 at 12:34 pm
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...
March 6, 2021 at 7:32 pm
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...
February 26, 2021 at 9:25 am
No response is correct, I agree with ilyaioffe
February 22, 2021 at 7:46 am
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
December 13, 2020 at 6:42 pm
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 =...
August 23, 2020 at 2:56 pm
Viewing 15 posts - 1 through 15 (of 55 total)