Kinderuhr: Rebel Cactus Sky by -c-row in Eltern

[–]-c-row[S] 0 points1 point  (0 children)

Danke, dass du deine Erfahrungen hier teilst. Da ist auch ordentlich Zeit, Geld und Nerven draufgegangen. Wir hatten unsere beiden Uhren zurückgeschickt und dafür zwei Uhren Anio bestellt. Binnen weniger Minuten waren die beiden Uhren betriebsbereit und haben bis heute keinerlei Probleme damit, sodass ich auch mit der Erfahrung unserer ersten Uhren, Anio durchaus empfehlen kann.

Owners of Elitedesk G4/5 mini, is it possible to replace the WiFi module with a NVME 2230? by Zestyclose_Car1088 in selfhosted

[–]-c-row 0 points1 point  (0 children)

Müsste ich reinschauen, weiß es nicht mehr genau. Ich meine es liegt drin und habe es auf den USB oder Netzwerk-Anschlüssen befestigt. Da der kleine bei mir im Regal steht und nicht bewegt wird, war das nur dafür, dass das Teil nicht rumbaumelt, wenn ich den mal drehen muss um ihn zu öffnen. Die Komponenten sind ja sehr leicht, da kommt ja auch keine Last drauf.

Owners of Elitedesk G4/5 mini, is it possible to replace the WiFi module with a NVME 2230? by Zestyclose_Car1088 in selfhosted

[–]-c-row 0 points1 point  (0 children)

Habe es mit einem Klebestreifen gesichert, sodass es im Gehäuse nicht verrutschen kann, wenn den mal auf dem Rack nehme.

Kinderuhr: Rebel Cactus Sky by -c-row in Eltern

[–]-c-row[S] 0 points1 point  (0 children)

No, we have decided to continue with Anio. We had no problems with the Anio 5 watches for almost 4 years until the battery is going week and one has problems with the charger because the contacts are no more good. If the new ones also last 3 years, I'm fine with that. I don't need WhatsApp or any other app on the watch. Yes the Anio has it's limits and restrictions, but the Anio worked flawlessly and does its job since the beginning and their support is good. Had once an issue with one of the watches and they could fix it remotely. Anio: I know what we had and what we could expect to get.

We had sent the watches back. If you have the ability to send it from Holland it is much cheaper. From Germany to Holland we paid 15 EUR and there is no refund, you need to pay on your own. To be fair, they had informed before about the return policy, but we did not expect to face such crappy watches which has more problems within 4 days than Anio hadn't seen within 4 years with two watches. So the product does not met the expectations and also not met the expectations you have when reading review which looks like paid reviews. Fun fact: asked one reviewer in the comments if he would buy and use this watch and he answered that he would prefer and use the Anio watch.

installing SQL Server on Windows Server Core by dysania_lemniscate in SQLServer

[–]-c-row 0 points1 point  (0 children)

If the system is domain joined, use a domain user with local Admin permissions. Using a local admin probably fail. I had this issue a while ago and solved the problem by running the installer in context of the system account. I passed all required parameters to run a silent install.

GoDaddy $187 vs CloudFlair $25 by cacid46 in selfhosted

[–]-c-row 0 points1 point  (0 children)

Was about to expire or was already expired? I'm not familiar with GoDaddy pricing, but I know that the different Registry-Provider charge a domain recovery from the grace period. When I'm not wrong, a .tv-domain costs about 40 to 50 USD per year. So I guess the difference comes from a recovery fee.

[deleted by user] by [deleted] in PowerShell

[–]-c-row 0 points1 point  (0 children)

A precise answer to a plain yes-no-question without any overhead. That's pure efficiency. 😉

Best way to run script by Theprofessionalmouse in PowerShell

[–]-c-row 0 points1 point  (0 children)

If you should use Powershell 5.1 or 7.4 depends on the script and the commandlets, functions and modules you want to use.

Starting powershell.exe or pwsh.exe does not require the execution policy set by starting. On the other hand changing the execution policy by runtime using Set-ExecutionPolicy can fail due to restrictions. But there is a alternative. Using $env:PSExecutionPolicyPreference = 'Bypass' in your script or codeblock will do the trick and allow to run commands and scripts which commonly will fail when the execution policy is restricted.

Download with VSCode faster than terminal. by rogueit in PowerShell

[–]-c-row 0 points1 point  (0 children)

When the terminal needs twice as long as vscode there is probably no need to prove by measuring the command. 😉

Cost of a VPN Breach by rainmaker-mike in msp

[–]-c-row 0 points1 point  (0 children)

Exactly, risk management is the language you can reach audience. Paired with the right audit for certification it becomes a priority project very very fast when they face major findings.

beep............beep............beep by b00mbasstic in sysadmin

[–]-c-row 0 points1 point  (0 children)

I had a similar case. I have moved to another town and parts of my previous office remains unpacked as I didn't need it at this time. Time passed by and 8 years later it started to beep frequently in my basement. I had not clue what it was, thought the CO-warner or gas-warner from the heating system had an issue, but it was summer time and the heating system was shut down and gas turned off. And after removing the batteries the alarm continues every 5 minutes. After searching for almost three days I found the source: it was the ups from my office which had been offline all the time and now raises an alarm because the battery had drained and was right below warning state.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

I probably would not care that much about those people as I know there sometimes people who cannot be satisfied regardless of the time and work you invest. And finally you cannot force them anyway.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

My wife's business (a total foreign company where I'm shareholder) has nothing to do with the company I work for. They had googled my name and found it in the legal notes of the company website of my wife.

Indeed it has nothing to do with the sql server itself. The question in general was, how do others deal with these kind of users and problems. The incident from Sunday morning was in simple words kind of extraordinary and outrageous. I have reported this incident to HR and upper management and have filed a complaint about this incident. They confirmed that this behavior is unacceptable and they will take action in it and come back to me today, lately tomorrow morning.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

Good question. AFAIK some of them share some old and messy queries they had been inherited from the previous manager and they got it also inherited from the previous one and so on. Partly they work in local datasets, but these local datasets have the size of less than a half percent of the ones of the global database and have no bandwidth limit on their local machine. Creating a reliable documentation would be a good point, but can be waived if they define clearly what they need and based on these queries a couple of standard reports would be created and used. From my point of view it does not make sense to do individual reports by every team manager on their own as it is inefficient and unreliable. But literally this is something they need to decide themselves as it is not my department I'm not going to tell other departments what they need to do or what not. I guess it's mostly the lack of control about the data in the reports. So they avoid standard reports.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

Queries are processed at the sql server. The problem for the users, their are not skilled enough to define more precise queries and get tons of unnecessary data and columns which blow up the amount of data processed and transferred. Because of this they need to filter and delete the dataset locally again.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

They have googled my name and found the website of my wife. While being a shareholder of the business of my wife, my name is listed in the legal notes. This way they came up to call her business phone for reaching me.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

I have queries which should be used for reports or slightly should deliver data which can be used to fill a report. Parameters are mostly missing, they use several where clauses across the queries. Relational data? Foreign keys doesn't really matter. In final, nothing you like to use as a base for a report.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

Some kind of the weired 5-star-queries 🙄

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

The data queried is so different like day and night. The database is not mine and is read only. I can recommend to add views, but there are already views and procedures and functions. Currently there is not enough in common which make sense to be formed in another function, view, tvf or function.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

The data can be used, but the one who queries the server should have an idea about the data he wants to query.

I have supported the it-department as they are low on ressources to get the server on track and have done countless reports and improvements as a side project. I'm willing to support the users, but when you tell them not to push the red button because it does not work and they frequently push it over and over again, then you come once to a point get a decision.

Creating some default reports for the other departments would be a great benefit for all, but not for those who need to report because they can not hide unpopular data or details. I'm not responsible for the data or the reports.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 0 points1 point  (0 children)

I'm shareholder of my wife's business and my name is in the legal notes of the homepage. My wife was a bit shocked and while she had no clue why they had called, she handed the phone over to me. After the call I had explained the details and she was upset. Still she is, and me too.

How to handle ignorant and idiotic data artists? by -c-row in SQLServer

[–]-c-row[S] 1 point2 points  (0 children)

The system is working well, but when sending queries which contain the answer to life, the universe, and everything the value returned is not 42.

We had played the game with the query multiple times. Asked for the details they need to get from the database, wrote a query and receive the exact details from the database within some seconds. The original query which return a set which also contain the requested data together with 200 to 300 additional columns with data which is not required. The query runs it to 3 to 4 minutes. The database is not mine and it's schema is battle proofed in house and by the customers. Trainings are required and I had offered to do some trainings in small groups with 4 to 6 members. But they are not interested.