Make SQL Server stored procedure results visible with SET NOCOUNT ON

Often, SQL Server stored procedures use the “SET NOCOUNT ON” command to improve performance. This command prevents DONE_IN_PROC messages from being sent to the client. In certain situations involving multiple iterations in loops, disabling such messages may noticeably boost performance and reduce network traffic. Hence, most discussions about SET NOCOUNT ON focus on the performance…

Details

Switch the user interface back to light gray (CC)

If you aren’t a fan of the default dark gray interface in InDesign Creative Cloud, you can customize it to your liking. Choose Edit > Preferences > Interface to display the Interface preference settings. Choose one of the options in the Color Theme pop-up menu: Light, Medium-Light, Medium-Dark, Dark, and Custom. Also note, you can…

Details

Avoid this common prototype mistake

When working with a constructor function in JavaScript, you can use its prototype property to add new methods and properties. But sometimes, prototype can seem confusing, because when you try to access it from a given object, you may get an error saying that it’s undefined. The reason for this is that only constructor functions…

Details

A handy utility to access web APIs and web server information

When working with web APIs or diagnosing website problems, often it’s useful to send HTTP requests through the command line, rather than through a browser. One of the most straightforward ways to do that is with the cURL utility, which you can download from http://curl.haxx.se/download.html. (You can also install it as add-on through Cygwin.) If…

Details

Guard against DoS with embryonic connection limits

One strategy for preventing denial-of-Service (DoS) attacks is to limit the number of embryonic connections. These are TCP connections where the handshake hasn’t been completed yet. DoS attacks may attempt to flood an interface with TCP SYN packets, initiating the handshake but not completing it. On ASA, you can limit the number of allowed embryonic…

Details

Centralize access point administration

Configuring multiple access points individually can be tedious and error-prone. To centralize administration, some access points have a cluster option, so that one configuration applies to all APs. However, more recently, Cisco Aironet APs require a separate piece of hardware, called a wireless LAN controller, in order to be clustered. A wireless LAN controller is…

Details

Fix SharePoint web application 401.1 Access Denied errors

If a SharePoint web application isn’t set up correctly, users may receive 401.1 Access Denied errors when logging in. The error can be confusing because it suggests that the user’s credentials are wrong, when they may actually be correct. A typical cause for this problem is that SharePoint Web Front End servers (WFEs) in a…

Details

Combat bounced email with these troubleshooting tips (MS Outlook)

Although your company higher-ups can read your email and block it, most likely, you’ve run into a different problem. While we strongly caution against sending personal email from your work account, the bottom line is that your email system isn’t working as it should. We’ll go through the most common culprits behind returned, or bounced,…

Details

When isolation isn’t enough to protect critical systems

A common security assumption is that systems that are walled off from the Internet aren’t vulnerable to outside attack. While isolating critical infrastructure from the Internet is a good step, it’s not foolproof. A number of factors can create hidden network connections, which may especially jeopardize older systems that weren’t designed to handle the security…

Details

A quick way to read file contents in Linux

Sometimes, you may want to read the contents of a short file in the command line without having to go into and out of a text editor. This saves keystrokes and also avoids any visual interruption to your shell environment. One easy way to do this in Linux is with sed. While sed is often…

Details

Click away with Excel 2010’s new Screenshot feature

Software has become pretty user friendly, but there are times when you wish you could just click-and drag between software programs. For instance, maybe you want to capture a news headline for the date of your stock portfolio spreadsheet. The Internet changes so quickly that you might not know or remember what the news headlines…

Details