RSSArchive for February, 2013

Feb

20

Disable Windows 8 Automatic Restart for Updates

Posted by 1 Comment

Currently there is no easy way to prevent Windows 8 from automatically restarting after installing updates. However, it can be done by a quick Group Policy edit. First, open the Group Policy Editor by hitting the Windows key and typing gpedit.msc:

Open gpedit.msc

 

Next, navigate to the following section:
Continue Reading

Feb

19

Take Screenshot on a Mac

Posted by Leave a Comment

There are a few quick ways to take a screenshot on a Mac. You can either save the images to the Desktop, or to the clipboard.

Command + Shift + 3: Full screenshot, save to Desktop
Command + Shift + 4: Select an area, save to Desktop
Command + Shift + 4 then press spacebar and click an app window: Screenshot of selected app, save to Desktop
Continue Reading

Feb

18

Disable WordPress Admin Bar for non-Admins

Posted by 1 Comment

If you want to disable the WordPress Admin Bar for regular users, all you need to do is add a couple of lines to your functions.php file.

1
2
3
if (!current_user_can('manage_options')) {
  add_filter('show_admin_bar','__return_false');
}

Continue Reading

Feb

18

Poll: How often do you check in your code?

Posted by Leave a Comment

How often do you check in your code?

View Results

Loading ... Loading ...

Feb

14

Enable or Disable a Table Index in SQL Server

Posted by 1 Comment

Sometimes you may need to temporarily disable an index before performing an action. To do so in SQL Server you can use the ALTER INDEX statement.

To disable the index:

ALTER INDEX index_name ON tablename DISABLE

To enable it again you just need to rebuild:

ALTER INDEX index_name ON tablename REBUILD

Feb

12

Scrolling Floating Sidebar in jQuery

Posted by 11 Comments

Making a sidebar that floats while scrolling for your website is quite simple using jQuery. A very basic markup of HTML, CSS, and Javascript are below. Click on the JS Fiddle link at the bottom to view a demo.

HTML: Two divs, a longer ‘divA’ on the left, and the floating ‘divB’ on the right, both wrapped in a container div.

1
2
3
4
<div id="container">
    <div id="divA"></div>
    <div id="divB"></div>
</div>

Continue Reading

Feb

1

Working With Duplicates in SQL Server

Posted by Leave a Comment

While none of our own databases would have issues with duplicate records, sometimes we have to work on those that are not so well designed. Below are a few handy queries for sorting out duplicate records.

First, an example of our table with duplicates highlighted:

SELECT * FROM Parts

Continue Reading