Quick Tips

A little something about everything

internet marketing and website development made simple..

Microsoft SQL Server Management Studio Maintenance Plans error: 'Agent XPs' componet is turned off

If you did not set the ..

Full Error:

'Agent XPs' component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Agent XPs' by using sp_configure. For more information about enabling 'Agent XPs' see "Surface Area Configuration" in SQL Server Books Online. (Object Explorer)

Fix Options:

  1. if using GUI open services, locate SQL Server Agent, double click and set startup type to automatic then click start.
  2. if you prefer to use command line you can just do the following on the master database:
    EXEC sp_configure 'show advanced', 1; 
     RECONFIGURE; 
     EXEC sp_configure 'allow updates', 0; 
     RECONFIGURE; 
     EXEC sp_configure 'Agent XPs', 1; 
    RECONFIGURE; 
    GO

HTC ONE (M7) back and home button issues, work intermittently

Several solutions exist because their can be several causes to this issue:

  1. recalibrate your keyboard, be sure not to touch close to the back or home keys. To do this touch and hold the "," key while the keyboard is open then go to Advanced and click the calibration option.
  2. Do a software update
  3. Turn off the power save mode
  4. Make sure the screen cover is not covering the back ad home buttons.

If none of these work call HTC and get a replacement.

How to target specific browsers within certain platforms, such as mozila & safari within mac for CSS design

You would first need to target the operating system which can be best accomplished by using javascript such as:

if(navigator.userAgent.indexOf('Mac') > 0) {

//code

}

Now in order to target the browser version you can use things such as if ie triggers for internet explorer

<!--[if (gt IE 6)&(lte IE 7)]>
<link href="/css/IE.css" rel="stylesheet" type="text/css">
<![endif]-->

or webkit for mozila or safari

@media screen and (-webkit-min-device-pixel-ratio:0) {
your css here
}

final code to target internet explorer on mac would look something like this:

if(navigator.userAgent.indexOf('Mac') > 0) {

<!--[if (gt IE 6)&(lte IE 7)]>
<link href="/css/IE.css" rel="stylesheet" type="text/css">
<![endif]-->


}

 

 

 

Slow Network Performance on Windows Server 2008 R2 or 2012 VPS RDP

Many things can cause these issue, here are a few things you can do to improve performance on your Windows Server 2012 VPS on Hyper-V.

  1. Make sure both your switch and NIC are set to the same speed, Auto can cause lots of issues.
    • Verify your router service speed. If you do not manage the router check with the person or company that manages it. Otherwise if you have a cisco router you can follow this basic commands.
      > password
      > enable
      > password
      > show interface [InterfaceName#/#] capabilities (example: FastEthernet#/#)
      > exit
    • Verify what speed your switch is running, if the switch is not yours ask your service provider. Assuming you have a cisco switch login to the switch via terminal or  telnet session, if the value for the switch is different than the router then you will need to use admin credentials. Then you will need to edit config mode for the correct interface. Here are some basic instructions. (If you screw up your network because you don't know what you are doing I am not liable! you have been warned)
      > password
      > Enable
      > password
      > Show interface (interfacename example: FastEthernet#/#) capabilities
      > Config Interface (interfacename example: FastEthernet#/#)
      > Speed 100 (this number should match your router service speed)
      > duplex full (this should match your router duplex)
    • To do this on your server simply open network and sharing center, select "change adapter settings", click advanced tab. Now scroll down until you find something like "Speed Duplex" and set this to the same as your switch. (ie 100Mbps Full Duplex, or if you have a Gigabit switch 1 Gbps Full Duplex".
  2. Jumbo Packet / Jumbo Frames should be disabled in most cases for best performance.
  3. Receive Buffers can be increased in increments of 64 if you have sufficient system memory to support the increase. Maximum is generally 2048 or 8MB for VPS.
  4. Transmit Buffers can be increased to provide improved performance. Maximum is generally 16384 or 8MB for VPS.
  5. Preferred NUMA node can be adjusted to a specified node other than System Default if the default node is under heavy load to improve system network performance.
  6. Max Number of RSS Processors (this setting can have an impact on CPU performance if you have a large number if cores, in some cases it may be best to specify a lower number of cores. If you notice that core #1 is at 100% utilization you can try increasing this number.)
    • In some cases you may also have to increase the Maximum Number of RSS Queues if your CPU #1 is at 100% to see if it has a positive impact.
  7. Offload (Offloading lowers CPU load and in most cases has little network performance benefit when disabled so you should leave them enabled)
    • IPsec Offload can lower CPU usage.
    • IPv4 Checksum Offload
  8. Decreasing Interrupt Moderation Rate will increase CPU utilization. (if you have CPU to spare you can decrease this to the lowest value or disable and adjust from that point)
  9. Enable or disable flow control can make a slight difference in performance depending on your adapter(s).