Notepad++ - source code editor for Windows (FreeWare)

Notepad++ is a source code editor for Windows. It is distributed as free software. The project is hosted on SourceForge.net, from where it has been downloaded over sixteen million times.[1]

This project, based on the Scintilla editor component, is written in C++ with only Win32 API calls using only the STL in order to increase performance and reduce program size. The aim of Notepad++ is to reduce overall power consumption by using efficient binaries that require less CPU power.[2]

Notepad++ is available only for the Microsoft Windows operating system. However, users can still get Notepad++ to work on other platforms like Linux and Mac OS X, using software such as Wine.

Programming languages
Notepad++ supports syntax highlighting and syntax folding for 48 programming, scripting, and markup languages.[2] It attempts to automatically detect the language that a given file uses, using a modifiable list of file extension bindings. Users may also manually set the current language, overriding the extension's default language. The program also supports autocompletion for a subset of the API of some programming languages.

Users can also define their own language (for syntax highlighting) and its respective API (for autocompletion) by using the built-in User Language Define System.[2] Users may configure the syntax highlighting's font styles per element, per language, and the resulting formatted script may be printed in full-color (WYSIWYG). Additionally, Notepad++ displays indent guidelines when source code is indented with tab characters, and highlights closing braces, brackets and tags.

Some of its features include:

• Auto-completion (language and file)
• Bookmarks
• Syntax highlighting (and brace and indent highlighting)
• Drag-and-drop
• File status auto-detection
• Regular expression find and replace
• Split screen editing ("View/Clone") and synchronized scrolling
• Zooming
• Spell checker (requires Aspell)
• Tabbed document interface
• FTP Browser (plug-in included in standard installation)
• Support for various file formats including unicode.
• Find and replace text or text strings of text over multiple documents simultaneously.

Although Scintilla does not support multiline regular expression search and replace, Notepad++ does contain support for plugins which help mitigate this fact.

Notepad++ home page
Notepad++ download

7-Zip File Archiver and Compression Utility (FreeWare)

7-Zip (aka 7zip) is a file archiver with a high compression ratio.

7-Zip Features

• High compression ratio in new 7z format with LZMA compression
• Supported formats:
• Packing / unpacking: 7z, ZIP, GZIP, BZIP2 and TAR
• Unpacking only: ARJ, CAB, CHM, CPIO, DEB, DMG, HFS, ISO, LZH, LZMA, MSI, NSIS, RAR, RPM, UDF, WIM, XAR and Z.
• For ZIP and GZIP formats, 7-Zip provides a compression ratio that is 2-10 % better than the ratio provided by PKZip and WinZip
• Strong AES-256 encryption in 7z and ZIP formats
• Self-extracting capability for 7z format
• Integration with Windows Shell
• Powerful File Manager
• Powerful command line version
• Plugin for FAR Manager
• Localizations for 74 languages

7-Zip is open source software. Most of the source code is under the GNU LGPL license. The unRAR code is under a mixed license: GNU LGPL + unRAR restrictions. Check license information here: 7-Zip license.

You can use 7-Zip on any computer, including a computer in a commercial organization. You don't need to register or pay for 7-Zip. But you can make a donation to support further development of 7-Zip.

7-zip home page.
7-zip download.
7zip Windows 7 (64 and 32 bit)
7zip Windows 2008 (64 and 32 bit)

BartPE (Bart's Preinstalled Environment)

BartPE (Bart's Preinstalled Environment) is a lightweight variant of Microsoft Windows XP or Windows Server 2003 32bit operating systems, similar to a Windows Preinstallation Environment, which can be run from a Live CD or Live USB drive.

A BartPE system image is created using PE Builder, a freeware program created by Bart Lagerweij. It requires a legal copy of Windows XP or Windows Server 2003. Additional applications can be included in the image using plugins.

As a Live CD or USB, BartPE allows a user to boot Windows, even if a hardware or software fault has disabled the installed operating systems on the internal hard drive — for instance, to recover files. It can also be used to scan for and remove rootkits, viruses and spyware (that have infected boot files), or to reset a lost administrator password.

Description
As with Windows Preinstallation Environment, BartPE operates by loading system registry files into RAM, and not writing any registry changes back to boot media. Thus, both operating systems require no hard drive or network access. This also allows them to be run from non-writable media such as a CD-ROM.

Since each instance of BartPE is a new installation, the BartPE "boot" disk needs original Windows setup files in order to operate. The Bart PE Builder application interprets and condenses files from a Windows setup CD to create the BartPE installation. It can build from a Windows XP Pro or Home Edition CD, or from a preinstalled Windows XP version (without a CD).[1]

Additional applications can be included in the BartPE setup through the use of "plugins". A plugin contains setup information for a specific application, so that it can be included on the media and installed along with Windows at each BartPE boot. Currently there are a few hundred plugins available in addition to the dozen-odd that are included by default with BartPE. Since BartPE represents a totally independent operating environment, the most obvious application examples involve backup, restoration, diagnosis and error-correction of systems with malfunctioning primary storage drives. Plugin programs can nominally be added to the capacity of the BartPE media.

BartPE is known to have certain incompatibilities with the Windows XP CDs shipped with most Dell PCs. The Dell versions include changes to the Windows setup files that can cause the BartPE build process to fail. Two patches are currently available to correct the known problems.

BartPE cannot create Vista Live DVDs.

Download BartPE

Stop 7B - Hundreds of BSOD Error Messages

Great resource for troubleshooting Windows Stop messages:
http://stop7b.blogspot.com/2009/06/hundreds-of-bsod-error-codes.html

GNU WGet for Windows (Windows 7, Vista, XP, etc.)

Whether you need a quick-and-dirty way to download a file via HTTP, HTTPS or FTP; or test a web page or recursively download a whole site, WGET is a great tool for the task.

GNU Wget is a free software package for retrieving files using HTTP, HTTPS and FTP, the most widely-used Internet protocols. It is a non-interactive commandline tool, so it may easily be called from scripts, cron jobs, terminals without X-Windows support, etc., on both Windows- or *nix-based systems.

GNU Wget has many features to make retrieving large files or mirroring entire web or FTP sites easy, including:

• Resume aborted downloads, using REST and RANGE
• Use filename wild cards and recursively mirror directories
• NLS-based message files for many different languages
• Optionally converts absolute links in downloaded documents to relative, so that downloaded documents may link to each other locally
• Runs on most UNIX-like operating systems as well as Microsoft Windows
• Supports HTTP proxies
• Supports HTTP cookies
• Supports persistent HTTP connections
• Unattended / background operation
• Uses local file timestamps to determine whether documents need to be re-downloaded when mirroring
• GNU Wget is distributed under the GNU General Public License.

Wget has an extensive set of options, the full list of which can be viewed from the command line with "wget --help."  Here are a few useful examples

Example 1 - Download the default page for given site to your current directory:

wget powercram.com

Example 2 - Recursively download the default page plus an additional level based on links from the default page:

wget -r -l 2 powercram.com

Example 3 - This will do as in example 2, additionally specifying username and password if required by site:

wget -r -l 2 --random-wait --http-user=powercram --http-password=powercram powercram.com

Example 4 - WGET can be used to recursively mirror your site, including download all the images, css and javascript, etc., and localize all of the URLS (so the site works on your local machine).  You can even save all the pages as .html files.

- To mirror your site:

wget -r http://www.powercram.com

- To mirror the site and localize all of the URLs:

wget --convert-links -r http://www.powercram.com

- To mirror the site and save the files as .html:

wget --html-extension -r http://www.powercram.com

Download WGet for Windows, install it, play with it and have some fun.

GNU wget runs on any version of Windows, including 2000, 2003, XP, Vista, Windows 7.

More

• How To Use Wget - Includes Several Examples Using Wget

Discover Twitter Apps

"oneforty is your Twitter outfitter"

Great list of tons of resources for all things Twitter.

They are currently tracking 1685 apps that make Twitter even better.

SQL: How to extract Year, Month, Day, Hour, Minute and Seconds from a DateTime

The DATEPART function accepts two parameters :

DATEPART ( datepart , date ) where
datepart - specifies the part of the date to return. For eg: year, month and so on
date - is the datetime or smalldatetime value

QUERY

SELECT
DATEPART(year, GETDATE()) as 'Year',
DATEPART(month,GETDATE()) as 'Month',
DATEPART(day,GETDATE()) as 'Day',
DATEPART(week,GETDATE()) as 'Week',
DATEPART(hour,GETDATE()) as 'Hour',
DATEPART(minute,GETDATE()) as 'Minute',
DATEPART(second,GETDATE()) as 'Seconds',
DATEPART(millisecond,GETDATE()) as 'MilliSeconds'

Note: When using a smalldatetime, only information up to the 'minute' gets displayed. Seconds and milliseconds are always 0.

SQL Server count items per day or per hour

Here are a couple of quick SQL statements to return counts based on entries or items or transactions per day or per hour. You can tailor as desired.

-- Count items per day

SELECT Year, Month, Day, COUNT(Day) AS "Items per Day"
FROM
(
SELECT DATEPART(YEAR,CreatedOn) Year, DATEPART(MONTH,CreatedOn) Month,
DATEPART(DAY,CreatedOn) Day
FROM tableName
) temp
group by Year, Month, Day
order by Year desc, Month desc, Day desc

------------------------------------------------
-- Count items per hour

SELECT Year, Month, Day, Hour, COUNT(Hour) AS "Items per Hour"
FROM
(
SELECT DATEPART(YEAR,CreatedOn) Year, DATEPART(MONTH,CreatedOn) Month,
DATEPART(DAY,CreatedOn) Day, DATEPART(HOUR, CreatedOn) Hour
FROM TableName
) temp
group by Year, Month, Day, Hour
order by Year desc, Month desc, Day desc, Hour desc

Keywords:
sql server something per day
sql count per hour
sql count per month
sql count time of day
"sql server" count
sql server day count
count per hour in sql
count records per hour per day sql
day,hour,minute format in sqlserver
entries per day sql select

SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime

Get Current Date & Time

select GetDate()

SQL Server 2000/2005

SELECT
CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond,
CONVERT(VARCHAR(8),GETDATE(),101) AS DateOnly
GO

SQL Server 2008

SELECT
CONVERT(TIME,GETDATE()) AS HourMinuteSecond,
CONVERT(DATE,GETDATE(),101) AS DateOnly
GO

Manually sync clock on Ubuntu Linux

You may manually sync the clock using the following

sudo ntpdate servername

where servername can be any public or private time server.

Example

sudo ntpdate pool.ntp.org