SQL - Improve Query Performance

Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the query plan; in some cases you can improve query performance by using UPDATE STATISTICS or the stored procedure sp_updatestats to update statistics more frequently than the default updates.

USE db_reports;
GO
UPDATE STATISTICS tb_applicationusage;
GO

VMWARE-FREE: failed to lock the file cannot open the disk

The Error is:

Failed to lock the file
Cannot open the disk '/media/remy/WD My Book/Laptop-Remy/Laptop-Remy.vmdk' or one of the snapshot disks it depends on.
Module DiskEarly power on failed.
Failed to start the virtual machine.

The Solution is:

Need to verify that there are no .lck files or folders in the VM's directory.

Clone an SQL Server database on the same server in SQL Server 2008 Express

Install Microsoft SQL Management Studio, you can download it for free from Microsoft website: Version 2008 Microsoft SQL Management Studio 2008 is part of SQL Server 2008 Express with Advanced Services Version 2012 Click download button and check ENU\x64\SQLManagementStudio_x64_ENU.exe Version 2014 Click download button and check MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe Open Microsoft SQL Management Studio Backup original database to file (db -> Task -> Backup). Create empty database with new name (clone). Click to clone database and open restore dialog (see image) Select Device and add the bakcup file from step 1. 4.Change destination to test database Change location of database files, it must be different from the original. You can type directly into text box, just add postfix. 6.Check WITH REPLACE and WITH KEEP_REPLICATION   Source : http://stackoverflow.com/questions/3829271/how-can-i-clone-an-sql-server-database-on-the-same-server-in-sql-server-2008-exp

Microsoft ACE OLEDB 12.0 connection strings

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97

↯ Problems connecting?

Get answer in the Excel 97 Q & A forum

Excel 2000

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97
• 
  

Excel 2002

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97

Excel 2003

• Excel 97-2003 Xls files with ACE OLEDB 12.0

  You can use this connection string to use the Office 2007 OLEDB driver (ACE 12.0) to connect to older 97-2003 Excel workbooks.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xls;
Extended Properties="Excel 8.0;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 97

Excel 2007

• Xlsx files

  Connect to Excel 2007 (and later) files with the Xlsx file extension. That is the Office Open XML format with macros disabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Treating data as text

  Use this one when you want to treat all data in the file as text, overriding Excels column type "General" to guess what type of data is in the column.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
  If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash.
  To always use IMEX=1 is a safer way to retrieve data for mixed data columns. Consider the scenario that one Excel file might work fine cause that file's data causes the driver to guess one data type while another file, containing other data, causes the driver to guess another data type. This can cause your app to crash.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsb files

  Connect to Excel 2007 (and later) files with the Xlsb file extension. That is the Office Open XML format saved in a binary format. I e the structure is similar but it's not saved in a text readable format as the Xlsx files and can improve performance if the file contains a lot of data.
  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;
Extended Properties="Excel 12.0;HDR=YES";
  You can also use this connection string to connect to older 97-2003 Excel workbooks.
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsm files

  Connect to Excel 2007 (and later) files with the Xlsm file extension. That is the Office Open XML format with macros enabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;
Extended Properties="Excel 12.0 Macro;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

Excel 2010

• Xlsx files

  Connect to Excel 2007 (and later) files with the Xlsx file extension. That is the Office Open XML format with macros disabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Treating data as text

  Use this one when you want to treat all data in the file as text, overriding Excels column type "General" to guess what type of data is in the column.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
  If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash.
  To always use IMEX=1 is a safer way to retrieve data for mixed data columns. Consider the scenario that one Excel file might work fine cause that file's data causes the driver to guess one data type while another file, containing other data, causes the driver to guess another data type. This can cause your app to crash.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsb files

  Connect to Excel 2007 (and later) files with the Xlsb file extension. That is the Office Open XML format saved in a binary format. I e the structure is similar but it's not saved in a text readable format as the Xlsx files and can improve performance if the file contains a lot of data.
  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;
Extended Properties="Excel 12.0;HDR=YES";
  You can also use this connection string to connect to older 97-2003 Excel workbooks.
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsm files

  Connect to Excel 2007 (and later) files with the Xlsm file extension. That is the Office Open XML format with macros enabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;
Extended Properties="Excel 12.0 Macro;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

Excel 2013

• Xlsx files

  Connect to Excel 2007 (and later) files with the Xlsx file extension. That is the Office Open XML format with macros disabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Treating data as text

  Use this one when you want to treat all data in the file as text, overriding Excels column type "General" to guess what type of data is in the column.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";
  If you want to read the column headers into the result set (using HDR=NO even though there is a header) and the column data is numeric, use IMEX=1 to avoid crash.
  To always use IMEX=1 is a safer way to retrieve data for mixed data columns. Consider the scenario that one Excel file might work fine cause that file's data causes the driver to guess one data type while another file, containing other data, causes the driver to guess another data type. This can cause your app to crash.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsb files

  Connect to Excel 2007 (and later) files with the Xlsb file extension. That is the Office Open XML format saved in a binary format. I e the structure is similar but it's not saved in a text readable format as the Xlsx files and can improve performance if the file contains a lot of data.
  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=c:\myFolder\myBinaryExcel2007file.xlsb;
Extended Properties="Excel 12.0;HDR=YES";
  You can also use this connection string to connect to older 97-2003 Excel workbooks.
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

• Xlsm files

  Connect to Excel 2007 (and later) files with the Xlsm file extension. That is the Office Open XML format with macros enabled.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;
Extended Properties="Excel 12.0 Macro;HDR=YES";
  "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.

  • Excel 2007
  • Excel 2010
  • Excel 2013

Access 97

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2000

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2002

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2003

• Standard security (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• With database password (mdb file)

  This is the connection string to use when you have an Access 97 - 2003 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.

  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• DataDirectory functionality (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.mdb;
Persist Security Info=False;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

• Network Location (mdb file)

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\serverName\shareName\folder\myAccessFile.mdb;
  • Access 2000
  • Access 2002
  • Access 2003
  • Access 97

Access 2007

• Standard security

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• With database password

  This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
  Note! Reports say that a database encrypted using Access 2010 - 2013 default encryption scheme does not work with this connection string. In Access; try options and choose 2007 encryption method instead. That should make it work. We do not know of any other solution. Please get in touch if other solutions is available!

  • Access 2007
  • Access 2010
  • Access 2013

• DataDirectory functionality

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• Network Location

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;
  • Access 2007
  • Access 2010
  • Access 2013

Access 2010

• Standard security

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• With database password

  This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
  Note! Reports say that a database encrypted using Access 2010 - 2013 default encryption scheme does not work with this connection string. In Access; try options and choose 2007 encryption method instead. That should make it work. We do not know of any other solution. Please get in touch if other solutions is available!

  • Access 2007
  • Access 2010
  • Access 2013

• DataDirectory functionality

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• Network Location

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;
  • Access 2007
  • Access 2010
  • Access 2013

Access 2013

• Standard security

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• With database password

  This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.
  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
  Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
  Note! Reports say that a database encrypted using Access 2010 - 2013 default encryption scheme does not work with this connection string. In Access; try options and choose 2007 encryption method instead. That should make it work. We do not know of any other solution. Please get in touch if other solutions is available!

  • Access 2007
  • Access 2010
  • Access 2013

• DataDirectory functionality

  Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\myAccessFile.accdb;
Persist Security Info=False;
  • Access 2007
  • Access 2010
  • Access 2013

• Network Location

  Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=\\server\share\folder\myAccessFile.accdb;
•  

Source: https://www.connectionstrings.com/ace-oledb-12-0/ 

Enable PING Windows 8

How to Enable Ping Reply/Response in Windows 8 and 8.1 – Simple Steps

By Dinesh

By default Windows 8 and 8.1 come with enabled Windows firewall which will not respond to ping requests from other networked devices. Even though you can access network shares from your Windows 8 desktop or laptop but still it will not respond to ping request  by saying ‘Request Timed Out’ message.  Here is the simple way to enable ping reply or response in Windows 8 and 8.1  by modifying ICMP Echo rule without completely disabling Windows firewall.
In Windows 7 we had to create a rule to enable ping but Windows 8/8.1 got built-in rule which needs to be enabled.  By completely disabling firewall in Windows 8 will respond to ping requests, but its not the recommended way of doing in terms of network and computer security. Disabling the firewall just for ping request will put the computer in high network threats and attacks.

Enable Only ICMP Echo Requests in Windows 8/8.1 to Responds Ping commands

1) Open Windows firewall settings.  Search for ‘firewall’ in search (from charm bar) and click Windows firewall. It can be accessed from Control Panel also.

2) Here you can completely turn off the firewall, so ping reply will work but it’s not recommended and we are not going to do it.
Select Advanced settings to open more and advanced Windows firewall settings.

3) There are pre made ICMP Echo rules available in Inbound Rules, we just need to enable that.
You must consider two facts while enabling the rule,
a) Network protocol type ( Is it IPv4 or IPv6?)
b) Network location type ( Is it Private or Public or Domain network?)
Mostly we would be needing to enable ping on Private or Domain network only, not for Public network. Select the correct rule matching in your scenario and enable it by right clicking and select Enable Rule.


That’s it, we have just enabled the ping response or reply in Windows 8 or 8.1 without disabling the Windows firewall.  If you like to disable again and do not want your computer to respond ping ( ICMP Echo requests), right click on the same rule and disable it.

source: http://www.sysprobs.com/how-to-enable-ping-reply-response-in-windows-8-simple-steps

Koneksi antar LAN di Mikrotik

Koneksi antar LAN di Mikrotik

1. ##Cara Menggabungkan 2 LAN Network agar bisa ping, share folder data menggunakan Mikrotik##
2.  
3. 1. Bismillah
4. 2. Copy paste command dbawah ini di New Terminal > Login Winbox > Pilih Menu New Terminal
5.  
6. /interface ethernet
7. set 1 name=ether2-IP1
8. set 2 name=ether3-IP2
9.  
10. /ip address
11. add address=192.168.1.1/24 disabled=no interface=ether2-IP1 network=192.168.1.0
12. add address=192.168.2.1/24 disabled=no interface=ether3-IP2 network=192.168.2.0
13.  
14.  
15. /ip firewall nat
16. add action=masquerade chain=srcnat disabled=no out-interface=ether2-IP1
17. add action=masquerade chain=srcnat disabled=no out-interface=ether2-IP2

 

source: http://installjaringan.com/index.php?My_Daily_Note:Tips_seputar_IT:Koneksi_antar_LAN_di_Mikrotik

Visual Basic Chart Control Activation

VB2010 Chart control requires  .NET Framework 4.0.
To determine what .NET Framework version your application uses, follow these steps:

1.  
1. Right click the  Solution explorer  
2. Select Properties  
3. In Properties select Compile  
4. Click the Advanced Compile Options button
5. There is a drop down for Target framework  
6. It needs to be set to 4.0 framework for the charts, drop down for selecting 4.0 framework.

Source: https://social.msdn.microsoft.com/Forums/en-US/213e272a-3d29-42c1-9b01-7f3b26a3be49/visual-basic-chart-control-activation?forum=MSWinWebChart

SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’

To enable ‘Ad Hoc Distributed Queries’:
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO

Finally ..after upgrade firmware Unifi AP is connected

Konversi Tanggal Format Indonesia ke English Ms. Excel

Dari hasil export suatu program menghasilkan format tanggal berupa text dalam format Indonesia. Untuk merubah ke format English dari Ms Excel maka dapat dilakukan dengan cara dari Menu DATA->Text to Columns.

Kemudian pilih data format taggal D/M/Y.

Setelah selesai, Selanjutnya kita bisa memilih format tanggal sesuai keinginan.

Sehingga tampilannya seperti dibawah ini:

To find duplicates on field.

SELECT [KodeSupplier], COUNT(*) as duplicate
    FROM [TBL_KODESUPPLIER]
    GROUP BY KodeSupplier 
HAVING      (COUNT(*) > 1)

KodeSupplier    duplicate
001.swadaya         2
1.0000.0000.0000    2
1.0000.0000.0001    2
1.0000.0000.GM01    2
1.0000.0000.GM02    2
1.ABZDZ.CDZZ.305    2
1.ABZZ.BZZZ.3113    2
1.ABZZ.BZZZ.3114    2
1.ABZZ.BZZZ.3116    2
1.ABZZ.BZZZ.3117    2
1.ABZZ.BZZZ.3118    2
1.ABZZ.BZZZ.3119    2
1.ABZZ.BZZZ.3120    2
1.ABZZ.BZZZ.3121    2
1.ABZZ.BZZZ.3122    2
1.ABZZ.BZZZ.3123    2
1.ABZZ.BZZZ.3124    2
1.ABZZ.CDZZ.3041    2

Red Hat / CentOS: Check / List Running Services

List all known services (configured via SysV)

chkconfig --list

List service and their open ports

netstat -tulpn

Turn on / off service

ntsysv
chkconfig service off
chkconfig service on
chkconfig httpd off
chkconfig ntpd on

Ms SQL Server - Save (Not Permitted) Dialog Box

Save (Not Permitted) Dialog Box

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

The Save (Not Permitted) dialog box warns you that saving changes is not permitted because the changes you have made require the listed tables to be dropped and re-created.
The following actions might require a table to be re-created:

• Adding a new column to the middle of the table
  
• Dropping a column
  
• Changing column nullability
  
• Changing the order of the columns
  
• Changing the data type of a column
  

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.

Source : https://msdn.microsoft.com/en-us/library/bb895146.aspx

Find Your Missing USB Drive in Windows XP

Useful link: http://www.howtogeek.com/howto/windows/find-your-missing-usb-drive-on-windows-xp/

Have you ever plugged in a USB drive or any external device with a hard drive and wondered why you cannot see it in My Computer?
More than likely the cause is that Windows renamed the drive to a letter that is already in use. This will happen if you have several card readers, thumb drives or external hard drives attached. It will also happen if you are on a network and have mapped drives.
To find the drive and then rename it, you’ll want to right-click on My Computer and select Manage.

How to create exclusion rules in Kaspersky Internet Security 2015

The Trusted zone is a list of objects that are excluded from scan scope of Kaspersky Internet Security 2015. You can form the trusted zone by various settings.  Depending on the objective, your list may be composed of objects included in:

• Exclusion rules
• Trusted applications

 

 Source : http://support.kaspersky.com/11146#block2
 

Mengatasi Download Counter 4shared menjadi 1 Detik

1. Buka console di browser Anda, bisa menggunakan console di firebug (tinggal pencet F12) atau console bawaan browser
2. Kalau sudah terbuka, masukkkan script dibawah ini pada kotak concole

1	Events.fireEvent("change.seconds.left",1);

3. Klik Run
4. Lihat download counternya, langsung berubah jadi angka 1 , kalau mau langsung 0 detik, ubah aja angka 1 menjadi angka 0

Source: https://herupurwito.wordpress.com/2015/01/13/mempercepat-download-counter-4shared-menjadi-1-detik/

Single USB2.0 Port Fast Ethernet Print Server TL-PS110U

First install this device to Network is getting error, LAN switch became crashed after print some documents..try to investigate what wrong. The port protocol that being used was Raw, then changed to LPR and it works fine. Just curious what difference Between LPR and RAW. Here is the definition:

 

LPR vs RAW

Two common networking computer protocols are LPR and RAW protocols. Both LPR and RAW protocols are involved with network printing. The concept of network printing is printing documents and papers by multiple users without using a direct connection or cables between computers and printers.

The LPR protocol is a shortened term for Line Printer Remote protocol. The LPR protocol serves as a system that allows computers and printers to work with each other in a network. The word “remote” in a whole term implies that a print job from a computer in another place can be carried out and performed in a printer that is not in the same space as the other machine as long as the two are attached to the same network.

The LPR protocol works by using a TCP/IP connection (transmission control protocol/Internet protocol) and LPD (Line Printer Daemon). The TCP/IP serves as the channel for the order or instruction to go from the computer to the printer while the LPD is software or a program installed inside the computer to allow the user to print a document or any kind of material using instructions in the computer.

The LPR protocol is initially designed for the UNIX computers, but it has been used after its development in other computer systems and platforms. It is often referenced as RFP1179. It can be used as the protocol for systems that don’t support RAW or other alternative protocols.

This particular type of protocol allows print queues since it can receive print jobs from numerous computers and users. However, in terms of errors, the protocol only displays a single and undetailed error status report. The example for this is a dialog box that says “Printer Error” with no specific details about the said error.

RAW protocol is one of the common computer languages that documents are translated into and then sent to a networked printer. The printer interprets the protocol and prints the document. RAW protocol is used when the computer user wants to print a complicated document which entails more than texts or letters. The protocol enables the computer to translate the document into RAW form before sending it to the printer which understands the given language and job.

The RAW protocol is the default protocol for systems that do not use Windows OS and for Standard TCP/IP. It is characterized and known as Port 9100. The advantage of this protocol is that it sends data without further processing and has smaller packet headers. The protocol also has fewer networks overhead.
Both RAW and LPR protocols need drivers in order to perform the task of printing the document after the computer gives the command to print.

Source : http://www.differencebetween.net/technology/protocols-formats/difference-between-lpr-and-raw/

Ping - General Failure on Windows 7

Uncheck the Kaspersky NDIS Filter option of your NIC card properties, this should fix your PING issue when running under Windows 7. If you don't need NDIS just remove the option from your install package so that it doesn't get installed.

Source:  http://forum.kaspersky.com/lofiversion/index.php/t158101.html

2x+3y=0

Solution for 2x+3y=0 equation:

Simplifying
2x + 3y = 0

Solving
2x + 3y = 0

Solving for variable 'x'.

Move all terms containing x to the left, all other terms to the right.

Add '-3y' to each side of the equation.
2x + 3y + -3y = 0 + -3y

Combine like terms: 3y + -3y = 0
2x + 0 = 0 + -3y
2x = 0 + -3y
Remove the zero:
2x = -3y

Divide each side by '2'.
x = -1.5y

Simplifying
x = -1.5y

EaseUS Disk Copy - Free clone hard drive software

Good software to clone your hard disk..Download at: http://mail.easeus.com/easeus/download.php