Date Function Formatting

As you can see in our last example there are tons of different formats that can be used in the date feature. Below is a summary of the variable used in date, and what each does. Remember they ARE CaSe sEnsItIVe:
DAYS
d - day of the month 2 digits (01-31)
j - day of the month (1-31)
D - 3 letter day (Mon - Sun)
l - full name of day (Monday - Sunday)
N - 1=Monday, 2=Tuesday, etc (1-7)
S - suffix for date (st, nd, rd)
w - 0=Sunday, 1=Monday (0-6)
z - day of the year (1=365)
WEEK
W - week of the year (1-52)
MONTH
F - Full name of month (January - December)
m - 2 digit month number (01-12)
n - month number (1-12)
M - 3 letter month (Jan - Dec)
t - Days in the month (28-31)
YEAR
L - leap year (0 no, 1 yes)
o - ISO-8601 year number (Ex. 1979, 2006)
Y - four digit year (Ex. 1979, 2006)
y - two digit year (Ex. 79, 06)
TIME
a - am or pm
A - AM or PM
B - Swatch Internet time (000 - 999)
g - 12 hour (1-12)
G - 24 hour c (0-23)
h - 2 digit 12 hour (01-12)
H - 2 digit 24 hour (00-23)
i - 2 digit minutes (00-59)
s 0 2 digit seconds (00-59)
OTHER e - timezone (Ex: GMT, CST)
I - daylight savings (1=yes, 0=no)
O - offset GMT (Ex: 0200)
Z - offset in seconds (-43200 - 43200)
r - full RFC 2822 formatted date

How to: Uninstall SQL Server Express 2005

In this topic, you will learn how to completely uninstall Microsoft SQL Server 2005 Express Edition (SQL Server Express). 

To uninstall SQL Server Express

1. Click Start, and then click Control Panel.
   
2. Open Add or Remove Programs.
   
3. Select Microsoft SQL Server 2005, and then click Remove.
   
4. The Component Selection page appears. By default, the Remove SQL Server 2005 instance components check box is selected. Select the instance that you want to remove.
   
5. To remove the Workstation components, select the Workstation Components check box.
   
6. The Confirmation page appears, listing the components that will be removed. Click Finish to complete the process of uninstalling SQL Server Express.
   You will see the System Configuration Check and Setup Progress pages as the uninstall process is completed.
   
7. To remove SQL Native Client, click Start, click Control Panel, and then click Add or Remove Programs.
   
8. Select Microsoft SQL Native Client, and then click Remove.
   
9. You will see a dialog box confirming whether you want to remove SQL Native Client. Click Yes.
   SQL Native Client is removed from the list of Add or Remove Programs.

Windows XP Pro SP3

Serial Keys:

  Q8QC9-HDV94-QWBW8-KHR7Y-9V2RT
  H8T36-VRH33-JV2BM-YXXCP-HDRJJ
  WVWF7-3M8TH-GG3H4-XYW39-PXTFY
  G4VY8-JGMWQ-FVDMW-4YCDJ-4QGF3
  HVDT2-VVX8Q-8W7QT-2GJRF-7DRJT

Security Products

Folder Lock® - The Fastest Encryption on Earth!

Folder Lock is a file encryption software that offers fastest way of encrypting and password protecting files and folders. You can either choose to encrypt important files from techies or lock your files, pictures and private data from casual users. Folder Lock comes with locking, encryption, shredding, stealth mode, hack attempt monitoring, portability, plug & play support, history cleaning, and more than 20 privacy features all tailored to special needs for people wanting privacy and security.

Download Here!

USB Block® - Prevent theft of your data!

USB Block is a data leak prevention tool that prevents leakage and copy of your data to USB Drives, External Drives, CDs/DVDs or other such portable devices. Once installed, USB Block lets you block all such drives and devices that do not belong to you. With USB Block, you can share your PC with anyone without fear of data theft. USB Block also lets you create a list of devices and drives you authorize with a password so that only your USB drives or CDs can be accessed on your computer.

Download Here!

USB Secure®- securing flash data!

USB Secure can password protect USB and other flash drives. Protection is PC independent, doesn't require installation and doesn't require administrator rights at the other end. Never again worry about lost or stolen USB drives if you have protected it with USB Secure. USB Secure works with all types of portable media like USB Flash drives, Thumb drives, Memory sticks, External drives and Memory Cards.

Download Here!

Folder Protect - protect Files and Folders

Folder Protect lets you password protect folders, files, drives & programs. It offers 'Data in Use' security and lets you choose whether you want to write protect, delete protect, access protect or hide your data. The program also offers Safe Mode locking, stealth mode and hotkeys, auto-protection and password prompt on access of protected item. Folder Protect offers features that set it apart from other password protection software.

Download Here!

The Ultimate Copy Protection for your Files!

Copy Protect is a copy protection software program that lets you prevent illegal copying of your media files. The program supports most audio, video, document and picture file formats. Copy Protect works by converting your media files into executable applications that run only in the drive they are made for. A copy protected file is useless and won't run if copied and executed from another drive or computer, thus preventing illegal distribution

Download Here!

Currently, innumerable rumors about the next version of Windows are circulating and Windows 8 MOSH is one of them. Such rumors indicate the importance of Microsoft Corp. in the world of IT. This is so because Microsoft, the technology giant, is a center of hope for the trillions of people worldwide. Microsoft has a tradition of introducing new and progressive products every time. This is the reason that people have a lot of expectations from Microsoft.


One more thing that is escalating the curiosity of people is which features of Windows 7 are going to be amended by Microsoft in the new version of Windows. So, this time it is being speculated that Microsoft is going to introduce a new graphical user interface that is code-named Mosh. Paul Brian Thurrott, a technology reporter and the news editor for Windows IT Pro magazine, is a real man from whom these speculations come. According to the Thurrott’s reporting, the new tile-based interface will be for devices like slates and tablets.

You cannot get any idea about Windows 8 mosh unless you do not know the concept of a user interface. In the field of information technology, a program that allows the user to interact with the system is called a user interface. So in simple terms, a user interface controls a display for the user. The common examples of a user interface are light pen, computer desktop, mouse, light pen, and a keyboard, etc.


In short, to check the validity of Windows 8 mosh, we have to wait for some time.

Library System

An SPC Library System usually comprises a relational database, software to interact with that database, and two graphical user interfaces (one for patrons, one for staff). Most Library System separate software functions into discrete programs called modules, each of them integrated with a unified interface. Examples of modules might include:

• acquisitions (ordering, receiving, and invoicing materials)
• cataloging (classifying and indexing materials)
• circulation (lending materials to patrons and receiving them back)
• serials (tracking magazine and newspaper holdings)
• the OPAC (public interface for users)

RGB - using JSrollbar

This how to implement a RGB color in java. It combines the values of each JScrollbars namely: redScroll, greenScroll, blueScroll.

Download this java implementation.

PHP Tutorial

PHP Tutorial - 1 - Installing PHP

UltraISO  is an ISO CD/DVD image file creating/editing/converting tool and a bootable CD/DVD maker , it can directly edit the CD/DVD image file and extract files and folders from it, as well as directly make ISO files from your CD/DVD-ROM or  hard disk. At the same time, you can maintain the ISO bootable information, thus creating your own bootable CD/DVDs. You now have the power to make and  edit your own ISO files, and then burn them to CD/DVD for your own needs.

     UltraISO is in sole possession of the intellectualized ISO document format analyzer, it can process at the present time almost all types of image files, including  ISO and BIN, it may even support new image files which are yet to be created. UltraISO can open these image files, directly extract files and folders, edit it and convert other image files to the standard ISO format.

    UltraISO uses the double window unification user contact interface, you have the choice to only use the quick buttons and/or the mouse Drag & Drops, you can handle any CD/DVD image file easily.

Download it UltraISO.

Video Guide:

Google Voice

Want to have a free call anywhere in America? Here is GOOGLE VOICE to connect to the people inside USA with a free rate call.
Google Voice is a telecommunications service by Google launched on March 11, 2009 and normally available only to US residents. A mistakenly-filed FCC report from October 2009 indicated that Google Voice had some 1.4 million users, 570,000 of which used the service 7 days a week. This has been confirmed by Google.

The service is configured and maintained by the user in a web-based application, styled after Google's e-mail service, Gmail. Google Voice currently[update] provides free PC-to-PC voice (and, optionally, also video) calling worldwide between users of the Google Voice and Video Chat browser plugin (available for Windows, Intel-based Mac OS X, and Linux), and free PC-to-phone calls into North America (this service will remain free at least until the end of 2011).

Procedure:
    1. You must have a G-Mail account. If you don't have, just click here http://gmail.com.
    2. Now, download this setup and install it in your computer.
    3. Lastly, just sign in your G-Mail account and you can use now your GOOGLE VOICE.

FACEBOOK Desktop

Microsoft has released a powerful Facebook desktop client, based on Silverlight 4. Facebook Logo We had already reviewed many Facebook applications for desktop in the past like Fishbowl, Notifications 2 or ISeeYoo. Most of these are mere notification or status update applications for Facebook. But the current Facebook desktop client from Microsoft is way ahead of these applications. The features packed in this desktop client with the simplicity and ease of use, can challenge any Adobe Air based application very easily.

The client is still a developer preview release and is available for download on Windows and Mac.

NOTE: Before you can install this rich facebook client application you need to install SILVERLIGHT in your desktop.

Download SILVERLIGHT first.

Here is the link to navigate and install the application.

What is DYNAMIC WEBSITE?

Most business websites these days are DYNAMIC meaning that the web pages are dynamically built pages that allow user interaction. This is required for example for an online shopping cart.

They are usually built with a programming language such as ASP, PHP or JAVA. This code "creates" the HTML that is displayed in the browser. XHTML and XML are standards which are probably eventually replace HTML. However most sites are still "output" in HTML because this is visible in most browsers.

DYNAMIC SITES are often database-driven. This means that the site content is stored in a database and the dynamic code "pulls" the content from a database.

MSO LIP 2007 – Filipino

The Office Language Interface Pack (LIP) is a translated User Interface that installs on top of a copy of Microsoft Office 2003, 2007 or 2010, and can be downloaded and installed for free. With the LIP download, you can use Microsoft Excel, OneNote (Office 2010 only), Outlook, PowerPoint and Word features in a different language. After you have installed the LIP, you can change languages through Microsoft Office Language Preferences to see a translated user interface.

Nearly all available LIP languages also include a spelling checker. Translated Help is not part of the LIP download package, but may be available as a separate download for your selected language.

Click here to download the package.

WB Presents - THE RITE

Inspired by true events, "The Rite" follows skeptical seminary student Michael Kovak (Colin O'Donoghue), who reluctantly attends exorcism school at the Vatican. While he's in Rome, Michael meets an unorthodox priest, Father Lucas (Anthony Hopkins), who introduces him to the darker side of the faith. "The Rite" is a supernatural thriller that uncovers the devil's reach to even one of the holiest places on Earth.


Watch the THE RITE OFFICIAL TRAILER.

WPF 4

Windows Presentation Foundation (WPF) is a next-generation presentation system for building Windows client applications with visually stunning user experiences. With WPF, you can create a wide range of both standalone and browser-hosted applications. An example is the Contoso Healthcare Sample Application that is shown in the following figure.

The core of WPF is a resolution-independent and vector-based rendering engine that is built to take advantage of modern graphics hardware. WPF extends the core with a comprehensive set of application-development features that include Extensible Application Markup Language (XAML), controls, data binding, layout, 2-D and 3-D graphics, animation, styles, templates, documents, media, text, and typography. WPF is included in the Microsoft .NET Framework, so you can build applications that incorporate other elements of the .NET Framework class library.

This overview is intended for newcomers and covers the key capabilities and concepts of WPF. Experienced WPF developers seeking a review of WPF may also find this overview useful.

Microsoft Visual C#

Microsoft Visual C# is Microsoft's implementation of the C# specification, included in the Microsoft Visual Studio suite of products. It is based on the ECMA/ISO specification of the C# language, which Microsoft also created. While multiple implementations of the specification exist, Visual C# is by far the one most commonly used. In most contexts, an unqualified reference to "C#" is taken to mean "Visual C#."

The term Visual denotes a brand-name relationship with other Microsoft programming languages such as Visual Basic, Visual FoxPro, Visual G# and Visual C++. All of these products are packaged with a graphical IDE and support rapid application development of Windows-based applications.

Visual C# is currently used in development of Windows and Xbox Live games via Microsoft XNA, which allows game developers to create and share their games with other gamers.

My Installers

Latest Applications that I used in my computer:
      * Internet Download Manager v5.19 Build 3

      * Windows Media Player 11
      * Winrar v3.3
      * Gimp 2
      * TeamViewer 5.0.87
      * Chikka Version 4
      * Chikka Version 5
      * USB Disk Security
      * VLC Player
      * UltraISO

JAVA: Magic Square

In recreational mathematics, a magic square of order n is an arrangement of n2 numbers, usually distinct integers, in a square, such that the n numbers in all rows, all columns, and both diagonals sum to the same constant. A normal magic square contains the integers from 1 to n2. The term "magic square" is also sometimes used to refer to any of various types of word square.

Normal magic squares exist for all orders n ≥ 1 except n = 2, although the case n = 1 is trivial, consisting of a single cell containing the number 1. The smallest nontrivial case, shown below, is of order 3.

Click here to download the file.

OUTPUT:

Microsoft Silverlight

Microsoft Silverlight is an application framework for writing and running rich Internet applications with emphasis on multimedia, animations, and graphics, with features and purposes similar to those of Adobe Flash. The run-time environment for Silverlight is available as a plug-in for most web browsers. While early versions of Silverlight focused on streaming media, current versions support multimedia, graphics and animation, and give developers support for CLI languages and development tools.

The current version 4 was released in April 2010. It is compatible with multiple web browsers used on Microsoft Windows and Mac OS X operating systems. Mobile devices, starting with Windows Phone 7 and Symbian (Series 60) phones, were expected to be supported in 2010. A free software implementation named Moonlight, developed by Novell in cooperation with Microsoft, is available to bring Silverlight versions 1 and 2 functionality to Linux, FreeBSD and other open source platforms. However, because of redistribution and patent concerns, Linux distributors such as Fedora have decided to exclude Moonlight.

Silverlight Sample Video