Reputation
1,424
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 7 6
Newest
 Yearling
Impact
~48k people reached

  • 0 posts edited
  • 1 helpful flag
  • 25 votes cast
Apr
11
answered How to streamline Windows (2008R2) Updates
Apr
8
awarded  Yearling
Mar
7
answered Retrieve current domain user's full name
Feb
9
comment SQL Server in “Recovery Pending” status after reboot
@KeithStein Windows Defender has both an on demand scanner (which is what the history shows) and an on access scanner (aka, "real-time protection"). The on access scanner will automatically lock and scan any data file when a program tries to open it. Since SQL Server data and log files are so large, it's not at all uncommon for the scanner to take longer than SQL Server's timeout. That's why the exclusions are important.
Feb
8
answered SQL Server in “Recovery Pending” status after reboot
Dec
4
comment MySQL: Why would I have to repeatedly FLUSH HOSTS after a few minutes?
This line in the MySQL doc stands out to me: "When more than max_connect_errors errors occur successively for a given host while connecting to the MySQL server, MySQL assumes that something is wrong and blocks the host from further connection requests. Flushing the host cache enables further connection attempts from the host."
May
15
comment Powershell script issue
You might have success with Copy-Item -LiteralPath. You might also have success with this advice: stackoverflow.com/questions/2482771/…
May
8
comment Compare-Object gives false differences
Note that as of PowerShell v2, the -SyncWindow property has a default value of [int32]::MaxValue.
Apr
8
awarded  Yearling
Mar
8
comment Unable to install Powershell 4
It may have been this issue, where the installation was simply incomplete somehow.
Feb
13
comment Should I defrag my RAID volumes?
I wouldn't say that SSDs don't need defragmenting, since it's trivial to show significant differences between sequential and random access data rates. Wear leveling will come in to play eventually, but only as the media ages, just like bad sector detection does on a spinning metal disk. However, in the general/common case, clusters/extents that are logically sequential on the volume will be physically sequential sectors on the media, again just like spinning metal. Depending on use case, it may be beneficial.
Jan
25
comment Windows Server 2008 - File Permissions and Administrator
@Bibi195 I guess my question would be: what are you trying to accomplish by removing Full Control? Are you trying to prevent casual privacy violations? Do you have non-sysadmins with Administrator permissions? Or are you just trying to administer Windows like it was Linux? Because there's a lot of philosophical differences that resulted in design differences between the platforms, so not every practice is portable. It's perfectly possible to secure Windows, but you don't necessarily do it by copying what you do on Linux.
Jan
25
comment Windows Server 2008 - File Permissions and Administrator
@Bibi195 The latter. Much of an Administrator's authority comes from the fact that they have full control of the file system, particularly %windir% and %programfiles%. The best practice option is to have sysadmins have two accounts: one in Users that they log in with and use normally, and one in Administrators that they elevate to as needed. However, that's a lot of overhead, and not everything works with RunAs or UAC elevation. It's putting hoops up that are harder to jump through than sudo or su, so many locations have sysadmins log in as Admins and rely on UAC as much as possible.
Jan
25
answered Windows Server 2008 - File Permissions and Administrator
Sep
4
awarded  Citizen Patrol
May
7
comment is it possible to check how many DIMM slots are filled in a pc motherboard, remotely?
For those looking for a PowerShell answer, you can use Get-WMIObject Win32_PhysicalMemory to access the same data as wmic memorychip.
Apr
8
awarded  Yearling
Oct
26
awarded  Great Answer
Apr
8
awarded  Yearling
Feb
8
comment How do I get SQL Server to release its memory?
If your sysadmin doesn't understand what Page Faults represent and why having memory consumed but no real Page Faults taking place is not a problem, I don't know how to help you. You can't fix stupid. One thing you can do, however, is to use sp_configure to configure the max memory down when you're not using the system, and the configure it back up when you need it. This seems pretty silly, however. sp_configure is generally something you should set once and leave alone.