Skip to main content

Posts

Showing posts from January, 2013

Limiting search results by site

Experts Exchange has the irritating marketing tactic of posting a discussion article that often seems to match exactly what I'm looking for, but the response to the question requires registration.  Since the answer to most any question is likely somewhere else on the Internet as well it's possible to restrict search results from even showing anything from this site. Here's how to do it.  At least Bing , Duck Duck Go , Google , and Yahoo have the ability to specify a "sites" argument in a search.  It can be used to either force results from a specific site to be included or excluded.  The real nice part is that the syntax is the same for all of them, so including the following snippet into a search string can eliminate search results from Experts Exchange: -site:experts-exchange.com NOTE:  Whether pages are included or excluded depends on the (-) operator preceding the limiter. The following example could be used to search for how to use the SQL TOP c

Formatting date representations in DBeaver

The open source database client DBeaver has the ability to specify a format in which to present date and time values in results sets.  The tables defined here identify the date and time parts and what they will represent when used as part of the mask. To open the settings: Select File | Preferences Expand the Common item Choose the Date Formats item From the settings on the right side of this dialog, look for the Type pop-up menu and the Settings Name/Value fields.  There is a Name/Value combination for each item in the Type pop-up menu.  A custom mask can be supplied for the desired presentation of date and time data. Shorthand Description Example Date d Day without leading zero 7 dd Day with leading zero 07 M Month without leading zero 1 MM Month with leading zero 01 MMM Abbreviated month Jan MMMM Formal month January yy Short year 13 yyyy Full year 2

Connecting to SQL Server with jTDS using Windows Authentication

UPDATE:   At one point the tip in this article to set the USENTLV2 flag to true was accurate, but it appears it is no longer necessary, at least as far as DBeaver 's use of the driver is concerned.  If it solves an authentication problem, then great.  The expectation is that, an update in one of the packages that make this sort of connection possible has resolved the issue that at one time made this flag necessary. Connecting to Microsoft SQL Server using jTDS with a username and password that's managed by the database manager is pretty straightforward.  It may become a little more problematic however, when trying to use Windows authentication when connecting from a Windows machine. Do not supply a username and password. Set the USENTLMV2 property to true. NOTE:   Step 1 assumes a connection being made from a Windows machine.  If the connection is being made from something else, user credentials may actually be necessary. If the connection is being set up u

Get used to vertical photos and videos

Integrating cameras into mobile devices has been going on for quite a number of years now.  In that time the cell phone [mobile] camera has become quite a convenient feature.  However, an unexpected side-effect is that the perception of a "normal" orientation for a picture or a video is shifting. The expectation is that at some point in the near future the "natural" orientation of our photo and video content will switch to vertical instead of the far more practical, and pleasing, horizontal. It's almost as though the first camera appeared in a cell phone simply because the creators thought to do it.  Then, after the fact, the uses for the shooter were realized.  Today, people snap pictures on their mobile devices of nearly everything, and new services have sprung up around the Internet to cater to this doohickey.  Thanks to the mobile camera we have shots and footage of nearly everything now.  And as we continue to find new uses for our mobile cameras, we'

Google updates Contacts to leverage Voice

Google has updated its Contacts service to leverage its Voice service.  Users are now able to call or text contacts right from a contact's record.  By extension, this means that the contacts feature in the company's Voice service is being replaced by its existing Contacts service as well. The company has no doubt been using the same contacts data for each service, but now the two remain separate but are properly integrated with one another.  To use the new feature, simply search for a contact and hover over the desired phone number, and either a phone or a chat bubble will appear. Google voice controls Click the communication method you want and a Voice dialog will appear to finish the action with. Google voice dialog For now, the traditional contacts control in Voice as well as the new Contacts control are present.  It's reasonable to assume this will be the case for at least a couple of months.  It may also be the case that not all users are being

Eclipse KB: PDT fails to install with Juno

Issue Eclipse PDT 3.1.x fails to install on Eclipse Juno for Ubuntu 12.10. Cause Unknown, but the errors reported indicate a broken path of some sort.  It may be a broken path in a URL the package manager is using.  Or it may be a broken path in the package itself. Solution Point Eclipse to the PDT-specific repository. http://download.eclipse.org/tools/pdt/updates/release Environment Eclipse version 4.2 Juno Ubuntu PDT version 3.1.x Ubuntu version 12.10 Details The install software feature of Eclipse has a predefined repository for Juno with the following URL. http://download.eclipse.org/releases/juno This repository has an option for the PHP Development Tools (PDT) package under the following path. Programming Languages | PHP Development Tools (PDT) SDK Feature Installing PDT from this repository fails.