News, Technology, Computer, General: 2011

Monday, December 5, 2011

Shrink & Truncate Log File SQL 2005

Problem

Shrink log file cannot effectife resize truncate log file in sql, use to query step this type. With decrease log size them.

Solution
This Step can used in here :
1) Get Name for name in show result

USE <database>
exec sp_helpfile

2) Execution resize increasing log data size with query :

USE <database>
GO
BACKUP LOG <database> WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE ("name log", 1)
GO
DBCC SHRINKFILE ("name data", 1)
GO
exec sp_helpfile

3) See size capacity in log file.

Sunday, December 4, 2011

Port Forward / NAT Remote Desktop with Modem Linksys Problem

Problem
If anytihing to do remote computer other site in office location. Example: can access office A in Jakarta city and Office B Medan City. We used Remote desktop connection (RDP). Setting allow RDP port in linksys.

Solution
1) Open modem setting, example : 172.16.10.6
2) select single port fordwarding. Select Application and gaming --> add application : RDP, External port : 3389, internal port: 3389, protocol : tcp/udp, ip address: 172.16.10.15
3)Save settings. See Picture

4) select port triggering and application : rdp , start port : 3388, end port: 3389, protocol : tcp and udp, ip address : 172.16.10.15

5) Save settings. See Picture

Thursday, December 1, 2011

Problem share printer 0X0000000d canon mp250

Problem
if you are connnect printer from other computer ms windows xp to ms windows vista or ms windows 7. example used printer canonmp250 and problem found with detail : operation failed with error 0X0000000d (see picture)

Solution
1) Install driver in computer printer location (Computer A), ip address : 172.16.10.16 and share this printer
2) Install driver in computer get share with (Computer B) and used port LPT1
    Get printer with share :
    Start --> Run --> cmd
    net use LPT1 \\172.16.10.16\canonmp2 /persistent:yes
3) Create Batch file and save startup menu start.

Wednesday, November 30, 2011

Connection C# and SQL Server 2005

Programming in C# .NET in ms visual studio net 2003 used SQL server 2005 connection :
1) Create database hwsw in sql server 2005 with table inventory and field is : idinventory, nameinventory, transaction inventory. etc
2) Create Form in C# net and drag datagrid in toolbox, with source code below:
             string connectionString = "Data Source=172.16.10.14;Initial Catalog=hwsw;Integrated   Security=False; User id=xxx;Password=xxxx";
            string sql = "SELECT * FROM inventory";
            SqlConnection connection = new SqlConnection(connectionString);
            connection.Open();
            sCommand = new SqlCommand(sql, connection);
            sAdapter = new SqlDataAdapter(sCommand);
            sBuilder = new SqlCommandBuilder(sAdapter);
            sDs = new DataSet();
            sAdapter.Fill(sDs, "inventory");
            sTable = sDs.Tables["inventory"];
            connection.Close();
            dataGrid1.DataSource = sDs.Tables["inventory"];
            dataGrid1.ReadOnly = true;
            save_btn.Enabled = false;

Thursday, November 24, 2011

Send email automatic with blat

Every day we can check connection server by email, and .log file server can be send my email automatically. See below command prompt we used basic. Step by step used blat send email :

1. Download program blat in http://www.blat.net
2. copy to drive c: in folder blat
3. Create script and save blat.bat
del c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log
echo "---------------STATUS SERVER----------------" >> c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log
ping -n 1 172.16.10.1 >nul &&(echo Router is ON>> c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log )||( echo Router is -------OFF>> c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log )
c:\ReportServer\blat.exe c:\ReportServer\log_RPing\ping_%date:~7,2%%date:~4,2%%date:~10,10%.log -t mnasrul@gmail.com -s "Report Daily Server Ping %date:~7,2%%date:~4,2%%date:~10,10%" -f h20026@ddssz.com -server mail.duduuuu.com

4. Create schedule in windows
5. See email send by blat report my server status :

--STATUS SERVER--: Router is ON & DB-SVR is ON

Tuesday, November 22, 2011

Virtual Box (virtual pc)

Virtual Box is a virtual machine for used pc installation, management, configuration, such as operating system windows xp, linux etc. with virtual box we can make problem and handling data error with customer presentation.
Using virtual any operating system to analyst and learning about information technology implementation program, after we make program coding for Axapta and implement for windows server or windows 7 and debug. For analyst viruses windows can implement to and change theme. See picture left them.

a great brother

a great brother!

Sunday, November 20, 2011

Setting Email Gmail in MS Outlook 2007

Friends! email from gmail.com have to configure with POP3 in Outlook Email and you don't every login if you access gmail account in yours computer. This step by step to configure access email with pop3 - outlook setting :

1. login account in gmail --> Setting --> Porwarding and POP/IMAP --> enable pop for all mail --> Save Changes

2. Open MS Outlook 2007 --> Add New MAil Account --> Manually Configure Settings or additional server Types [checklist]-->next -->add in account email and password,

your name : mnasrul
email address : mnasrul@gmail.com
account type : pop3
incoming mail server : pop.gmail.com
Outgoing mail server : ......list in internet service provider (ISP), examp : smtp.telkom.net
user name : mnasrul
password : ***********

--> more setting -->advanced --> this server requires an encrypted connection (SSL) [centang] ...995 not 110 --> ok

Congratulation!!! your finish setting gmail account in MS outlook 2007

Remote Desktop Connection

Local Remote Computer is a way to access two or more different computers through the medium of computer networks, if we want to access a computer with different conditions place on the computer B, then this can be done by step:

1) Connect two computers / UTP cable more with media

2) Setting IP to each computer (eg: computer A and computer B)

3) Setting Remote Access on computer A

4) Accessing computer A on computer B

IP address

PC A : 192.168.1.5

PC B : 192.168.1.6

allow remote from computer A, see picture :

right click --> my computer -->Remote--> check “Allow users to connect remotely to this computer” --> ok.

remote computer B to computer A :
Start --> Run [mstsc]

next input : 192.168.1.5

Klik Connect

Thursday, August 4, 2011

Check Computer Hardware

Introduction

Sometimes we need a computer data such as brandmotherboard, cpu, ram capacity, hard drive capacity, brand bios,and others.

We can use cpu-z applications from http://www.cpuid.com/.
from the testimony of his official website:

What is CPU-Z
CPU-Z is a freeware That gathers information on some of themain devices of your system. CPU
Name and number.
Core stepping and process.
Package.
Core voltage.
Internal and external clocks, clock multiplier.
Supported instruction sets.
Cache information.
mainboard
Vendor, model and revision.
BIOS model and date.
Chipset (northbridge and southbridge) and sensor.
Graphic interface.
memory
Frequency and timings.
Module (s) specification using SPD (Serial Presence Detect):vendor, serial number, timings table.
System
Windows and DirectX version

You can use it free, just download the file cpu-z on the site http://www.cpuid.com/

Picture 1. Detail my CPU

Picture 2. Detail Motherboard

Monday, August 1, 2011

Security Network With Clear OS

Introduction
ClearOS is a family of operating systems for the enterprise, small business, and home. There are three editions to choose from depending on your needs and suitable to your abilities. They are: ClearOS Enterprise, ClearOS Home, and ClearOS Core.

ClearOS Core is a multipurpose, enterprise-ready platform designed for businesses. It features scalable network technologies. It is managed using traditional Linux tools. ClearOS Core features web, database, high availability and desktop features.

The open source revolution in the software industry has made it possible to provide all versions of ClearOS at no cost. ClearOS Enterprise and ClearOS Home include out-of-the-box features including: antivirus, antispam, VPN and content filtering are built right into the software -- no need for expensive third party add-ons. With ClearOS, you can avoid costly vendor lock-in and proprietary formats; instead, you can embrace open standards and protocols.

Yes. All the features that you see listed over there on the right are free to use and install. ClearOS is built on open source software, so when you install the antivirus engine - for example - you also get the open source updates that come with it! ClearCenter provides enhancements to these core open source features - for example more in-depth antivirus signature updates - but these do not take away from the underlying open source software.

Multi-WAN
VPN - PPTP, IPsec, OpenVPN
DMZ and 1-to-1 NAT
Stateful Firewall
Local DHCP and DNS Servers

Antimalware - Antivirus, Antiphishing, Antispyware
Antispam
Bandwidth Management
Intrusion Protection, Intrusion Prevention, Intrusion Detection
Protocol Filtering including Peer-to-Peer Detection
Content Filter
Web Proxy
Access Control

Download clearOS : http://www.clearfoundation.com

Source Copy : http://www.clearfoundation.com

Wednesday, July 20, 2011

How To Install IIS Server

Introduction

IIS (Internet Information Server) is web protocol server can be used to IIS program to manage web site under windows operating system.

Start --> Control Panel --> add remove Programs --> add/remove components