Latest Server related questions

Score: 0
FlashAgain avatar
Difference between DB having user-password protection, DEK, TDE
pr flag

I am a total noob in systems and have questions about DEK.

What are differences(or advantages of one over the other) between knowing your username and password for your DB(mysql or mariadb) and DEK. What exactly is DEK and TDE?

Score: 0
James avatar
SQL Server 2014 enterprise edition suddenly stop accepting the connections
us flag

We are seeing that our server will suddenly stop accepting new connection from SQL Server. The server itself is still accessible via RDP, but sharepoint portal/SSMS and any other remote SQL connection will timeout. Configuration manager shows that SQL Services are running, but if you attempt to stop/ restart the services manually, it will hang. Restarting the server will sometimes let the services go ba ...

Score: 0
Fabian Raj avatar
How to list all function apps and it's storage account
in flag

Is there anyway to combine both commands below where it lists all the function app together with the storage account used for it?

This command gets all the function app in the subscription

az functionapp list 

This command gets the storage account used by the function app

az functionapp config appsettings list --name <appname> -g <rg> --query "[].{name:name, value:value}[?name=='AzureWeb ...
Score: 0
Jonathan avatar
How to preserve file access time when using `chmod`
cn flag

I would like to know how can I preserve file access time ("atime") when using "chmod". Sometimes I need to use the code below:

chmod -R 777 /directory

It works fine, however all the files inside that directory have the access time ("atime") changed to the current time. Do you have any idea?

NOTE: I am using CentOS 8.

Score: 0
CLP avatar
Windows Defender 2019 - Configuring
ru flag
CLP

I've been tasked with getting Windows Defender configured to get it's updates via MECM. Some context, we have around 40 servers in our Azure tenant running Windows Server 2019, Defender is enabled, and it's currently getting its definition updates from an M$ source (I assume) We have an on-premise MECM/SCCM infrastructure, and currently, the Windows10 fleet defender updates is managed via SCCM/MECM; we  ...

Score: 0
James avatar
error 17054 severity 16 state 1 sql server 2014 enterprise edition
us flag

Our new database is just inaccessible. I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL Agent, and SQL Server services were stopped, and then tried to restart it just hung and because of that, I have to do a reboot. It is a production server and this is a recurring issue. It happened a month a ...

Score: -1
Kumas avatar
SQL - How to avoid reading value from XML column due to performance issue
mx flag

I am new to SQL , could you please suggest me how do I improve below SQL code, I have observed using SQL profiler - XML reading operation is taking too much of time.

Kindly let me know how do I rewrite the below code, so that I can see improvement in the performance.

Here - edata is the XML Column And below code is part of my main stored procedure , only below code is having an issue with performanc ...

Score: 1
How does a lazy unmount actually work?
ug flag

During recent testing, I couldn't unmount an NFS mount after removing the NFS server or blocking the IP address of the server on PREROUTING raw, with iptables.

--force didn't work. Running mount to print all mounts showed it was still there.

But --lazy did.

Plenty of results to be found telling a person to do this. And that the manpage describes --force in particular for NFS servers that won't hang u ...

Score: 0
ACL to block certain vcloud pages unless from certain IPs
sg flag

I have a need to block a tenant URL in vcloud and have managed to do this for the direct attempts, ie vcloudaddress.com/tenant/tenantname, but I can't seem to block the

/login/?service=tenant:tenantname&redirectTo=blahblahblah

I need to wildcard, it but how do I do that in HAProxy-speak?

This is what I have at present:

acl trusted_ip src IP1

acl trusted_ip src IP2

acl trusted_ip src IP3

acl truste ...

Score: 0
yucer avatar
Can't connect ssh via wireless interface but t works using eth0
in flag

Suddenly I can't connect via ssh to a server using my wireless interface but I can do it using the eth0 interface with a cable connected directly to my router.

From my wireless interface I got:

$ ssh -vvv my_server
OpenSSH_8.9p1 Ubuntu-3, OpenSSL 3.0.2 15 Mar 2022
debug1: Reading configuration data /home/user/.ssh/config
debug1: /home/user/.ssh/config line 38: Applying options for my_server
debug1: ...
Score: 0
sam avatar
Why are 1.92/3.84/7.68TB hard drives the standard?
uz flag
sam

For SSD drive, I often see specifications like 200GB, 400GB, 800GB, 1.6TB, 1.92TB, 3.84TB, 7.68TB (For example, HPE 7.68TB SATA 6G Read Intensive SFF SC Multi Vendor SSD)

Is there a hardware/architectural reason that makes it go from 1.6TB to 1.92TB, instead of having 3.2/6.4TB hard drives?

The Stunning Power of Questions

Much of an executive’s workday is spent asking others for information—requesting status updates from a team leader, for example, or questioning a counterpart in a tense negotiation. Yet unlike professionals such as litigators, journalists, and doctors, who are taught how to ask questions as an essential part of their training, few executives think of questioning as a skill that can be honed—or consider how their own answers to questions could make conversations more productive.

That’s a missed opportunity. Questioning is a uniquely powerful tool for unlocking value in organizations: It spurs learning and the exchange of ideas, it fuels innovation and performance improvement, it builds rapport and trust among team members. And it can mitigate business risk by uncovering unforeseen pitfalls and hazards.

For some people, questioning comes easily. Their natural inquisitiveness, emotional intelligence, and ability to read people put the ideal question on the tip of their tongue. But most of us don’t ask enough questions, nor do we pose our inquiries in an optimal way.

The good news is that by asking questions, we naturally improve our emotional intelligence, which in turn makes us better questioners—a virtuous cycle. In this article, we draw on insights from behavioral science research to explore how the way we frame questions and choose to answer our counterparts can influence the outcome of conversations. We offer guidance for choosing the best type, tone, sequence, and framing of questions and for deciding what and how much information to share to reap the most benefit from our interactions, not just for ourselves but for our organizations.