Reputation
Next tag badge:
96/100 score
31/20 answers
Badges
17 113 183
Newest
 Guru
Impact
~2.6m people reached

May
7
comment SP_UsageAndHealth Database, What Is It and Can I Shrink It?
You may need to take a transaction log backup before you can shrink it, or if you can't do that, change the recovery model from FULL to SIMPLE, shrink the transaction log, and then back to FULL again. But you need to be aware of the implications of doing this, it's not something that you would normally do, and it's not something you should do lightly.
May
7
comment SP_UsageAndHealth Database, What Is It and Can I Shrink It?
Normally you wouldn't shrink an SQL database, but when it comes to shrinking a 1,500GB database back down to 50GB I think that's justified. Shrinking a database should not have any data integrity issues so it should be a perfectly safe option (just schedule an index rebuild after the shrink).
May
7
comment Server Room Temperature Control
81f == 27c. This is perfectly fine for a small room. Nothing is going to fail at those temps. Uncomfortable to spend extended periods in? Depending on your temperament, maybe. But how long do you spend in a rack cabinet anyway?
May
4
comment Rescue Configuration for Cisco 3925
Is it storing its configs on an external flash? My other thought is that if the console port has reverted to default settings, which could have been reconfigured in the running-config that your router had before it rebooted.
Apr
30
comment Is a VM with 2 CPUs really faster than one with 4 CPUs?
@AngryHacker yes SQL server can use all 4 cores very efficiently assuming you have appropriate MAXDOP settings. However depending on the workload, an overly taxed SQL server is often a sign of bad database design - bad indexes, no clustered indexes, too many indexes, no optimisation, etc. (not always, but often).
Apr
29
comment Install a SATA SSD in hot swap server
You don't need to power cycle to set up RAID if you have installed the Dell Server Administrator tools. You can configure it via the web interface then.
Apr
29
comment IBM DS3400 - how replace a good disk
Guaranteed way to get it into fault mode: yank it out
Apr
28
comment A service like a router between 2 WAFs. This exists?
Thats called a reverse proxy. There are loads of them.
Apr
22
comment the same certificates are sold at different prices?
@Paul sure some of them offer insurance and others offer more detail in the certificate (and other things like EV). But the encryption is identical.
Apr
20
comment SSH: Permission denied (publickey,gssapi-with-mic,password)
Whilst this may theoretically answer the question, it would be preferable to include the essential parts of the answer here, and provide the link for reference.
Apr
20
comment Use PowerShell to create a web page from an array
@JoelT you can perform all actions on your own questions. I can see you've already given this the checkmark, but you should also be able to upvote it.
Apr
16
comment Connecting MPLS Link to Local Network
You're probably in over your head. I'd be asking your MPLS provider if they have a networking specialist that you can hire for a day to get this working for you.
Apr
16
comment Linux-SSSD: always getting incorrect password when su'ing to domain users, but why?
Probably because your answer looks a lot like spam
Apr
15
comment Determine hostname of Windows system on network
Additionally, the item on the pipeline does differ between the two. The first is Selected.System.Management.ManagementObject where name is a property, and the second is just System.String (shown by Get-Member)
Apr
15
comment Determine hostname of Windows system on network
@JimB the last one returns literally just the name, the other one returns NAME ------ [name] (pretend there's line breaks in there). I probably phrased it poorly.
Apr
15
comment Determine hostname of Windows system on network
Which versions of Windows?
Apr
14
comment Solving an asymetric HA Firewall/router
Close. You can force them to prefer one over the other by sending a longer AS path on the non-preferred route. Then you will know which one they prefer, and set that preference lower. As for keepalived, I'm assuming this is just for the internal interface, correct? My knowledge of that part of the setup is pretty slim so I'll leave that up to you I'm afraid.
Apr
14
comment Solving an asymetric HA Firewall/router
Ah, right. So they want you to do HA by sending a longer route from one interface. Then when the primary goes offline, it's OK because they still have another route to your system. They might also have communities you could use for this, but prepending a private AS would do similar thing.
Apr
14
comment ntopng: How to view rsync traffic
As far as I'm aware you shouldn't need to do anything, as ntop-ng just shows whatever the collectors receive, and typically the collectors run at Layer 3.
Apr
14
comment Solving an asymetric HA Firewall/router
You'll probably need the assistance of your upstream provider. Often these links are provided with etherchannel/LACP enabled for both the ports, which it is going to expect to negotiate with the active link on the other side. If they configure the links as active/passive instead then you shouldn't have to worry about any asymmetric routing.