tag:blogger.com,1999:blog-49994773179877511142024-03-13T07:20:14.272-07:00Salina & IT MindUnknownnoreply@blogger.comBlogger134125tag:blogger.com,1999:blog-4999477317987751114.post-66513549728898050662014-12-29T01:29:00.001-08:002014-12-29T01:29:18.135-08:00SQL - SUBSTRING (Transact-SQL)<b><u>Syntax</u></b><br />
<br />
<pre style="font-family: Consolas, Courier, monospace !important; font-size: 13px; line-height: 17.5499992370605px; overflow: auto; padding: 5px; word-wrap: normal;">SUBSTRING ( expression ,start , length )</pre>
<pre style="font-family: Consolas, Courier, monospace !important; font-size: 13px; line-height: 17.5499992370605px; overflow: auto; padding: 5px; word-wrap: normal;">
</pre>
<pre style="font-family: Consolas, Courier, monospace !important; font-size: 13px; line-height: 17.5499992370605px; overflow: auto; padding: 5px; word-wrap: normal;"><b><u>Arguments</u></b></pre>
<pre style="font-family: Consolas, Courier, monospace !important; font-size: 13px; line-height: 17.5499992370605px; overflow: auto; padding: 5px; word-wrap: normal;">
<dt style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 17.5499992370605px; white-space: normal;"><span class="parameter" style="font-style: italic;">expression</span></dt>
<dd style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 17.5499992370605px; white-space: normal;"><div style="color: #2a2a2a; line-height: 18px; padding-bottom: 15px;">
Is a <span class="input" style="font-weight: 700;">character</span>, <span class="input" style="font-weight: 700;">binary</span>, <span class="input" style="font-weight: 700;">text</span>, <span class="input" style="font-weight: 700;">ntext</span>, or <span class="input" style="font-weight: 700;">image</span> <a href="http://msdn.microsoft.com/en-us/library/ms190286.aspx" style="color: #03697a; text-decoration: none;">expression</a>.</div>
</dd>
<dt style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 17.5499992370605px; white-space: normal;"><span class="parameter" style="font-style: italic;">start</span></dt>
<dd style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 17.5499992370605px; white-space: normal;"><div style="color: #2a2a2a; line-height: 18px; padding-bottom: 15px;">
Is an integer or <span class="input" style="font-weight: 700;">bigint</span> expression that specifies where the returned characters start. If <span class="parameter" style="font-style: italic;">start</span> is less than 1, the returned expression will begin at the first character that is specified in <span class="parameter" style="font-style: italic;">expression</span>. In this case, the number of characters that are returned is the largest value of either the sum of <span class="parameter" style="font-style: italic;">start</span> + <span class="parameter" style="font-style: italic;">length</span>- 1 or 0. If <span class="parameter" style="font-style: italic;">start</span> is greater than the number of characters in the value expression, a zero-length expression is returned.</div>
</dd>
<dt style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 17.5499992370605px; white-space: normal;"><span class="parameter" style="font-style: italic;">length</span></dt>
<dd style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 17.5499992370605px; white-space: normal;"><div style="color: #2a2a2a; line-height: 18px; padding-bottom: 15px;">
Is a positive integer or <span class="input" style="font-weight: 700;">bigint</span> expression that specifies how many characters of the <span class="parameter" style="font-style: italic;">expression</span> will be returned. If <span class="parameter" style="font-style: italic;">length</span> is negative, an error is generated and the statement is terminated. If the sum of <span class="parameter" style="font-style: italic;">start</span> and <span class="parameter" style="font-style: italic;">length</span> is greater than the number of characters in <span class="parameter" style="font-style: italic;">expression</span>, the whole value expression beginning at <span class="parameter" style="font-style: italic;">start</span> is returned</div>
<div style="color: #2a2a2a; line-height: 18px; padding-bottom: 15px;">
</div>
<div style="line-height: 18px; padding-bottom: 15px;">
<b style="color: #2a2a2a;"><u>Sample:</u></b>
<span style="color: blue;">SELECT date, substring(recpt_desc, 1, 3), branch from DATABASE
where date='2014-12-03'
<span style="font-size: 13px;">order by branch
group by date, </span><span style="font-size: 13.3333339691162px;">substring(recpt_desc, 1, 3), branch;</span></span></div>
<div style="color: #2a2a2a; line-height: 18px; padding-bottom: 15px;">
</div>
<div style="color: #2a2a2a; line-height: 18px; padding-bottom: 15px;">
</div>
<div style="color: #2a2a2a; line-height: 18px; padding-bottom: 15px;">
</div>
</dd></pre>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-19425820205314841382014-05-11T20:48:00.001-07:002014-05-11T20:48:41.222-07:00MS SQL Server: Create SQL Job using Transact-SQL<h3 class="procedureSubHeading" style="color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 1.386em; font-weight: normal; margin: 0px; padding-bottom: 5px; padding-top: 5px;">
To create a SQL Server Agent job</h3>
<div class="subSection" style="color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px;">
<ol>
<li style="line-height: 17.549999237060547px;"><div style="line-height: 18px; padding-bottom: 15px;">
In <span class="label" style="font-weight: 700;">Object Explorer</span>, connect to an instance of Database Engine.</div>
</li>
<li style="line-height: 17.549999237060547px;"><div style="line-height: 18px; padding-bottom: 15px;">
On the Standard bar, click <span class="label" style="font-weight: 700;">New Query</span>.</div>
</li>
<li style="line-height: 17.549999237060547px;"><div style="line-height: 18px; padding-bottom: 15px;">
Copy and paste the following example into the query window and click <span class="label" style="font-weight: 700;">Execute.</span></div>
</li>
<li style="line-height: 17.549999237060547px;"><div class="subSection" style="font-size: 13px;">
<ol>
<li><div class="codeSnippetContainer" id="code-snippet-1" style="clear: both; min-width: 260px;" xmlns="">
<div class="codeSnippetContainerTabs" style="height: 23px; position: relative; vertical-align: middle; z-index: 1;">
</div>
<div class="codeSnippetContainerCodeContainer" style="border: 1px solid rgb(147, 147, 147); clear: both; margin-bottom: 12px; position: relative; top: -1px;">
<div class="codeSnippetToolBar" style="height: auto; width: auto;">
<div class="codeSnippetToolBarText" style="background-color: white; float: right; height: 0px; padding-left: 0px; padding-right: 0px; position: relative; top: -8px; vertical-align: top; width: auto;">
</div>
</div>
<div class="codeSnippetContainerCode" dir="ltr" id="CodeSnippetContainerCode_bc869aca-8dd2-4445-92a7-2a2b25a0b375" style="margin: 0px; padding: 10px 21px; width: auto;">
<div style="color: black; margin: 0px; padding: 0px;">
<pre style="font-family: Consolas, Courier, monospace !important; overflow: auto; padding: 5px; word-wrap: normal;">USE msdb ;
GO
EXEC dbo.sp_add_job
@job_name = N'Weekly Sales Data Backup' ;
GO
EXEC sp_add_jobstep
@job_name = N'Weekly Sales Data Backup',
@step_name = N'Set database to read only',
@subsystem = N'TSQL',
@command = N'ALTER DATABASE SALES SET READ_ONLY',
@retry_attempts = 5,
@retry_interval = 5 ;
GO
EXEC dbo.sp_add_schedule
@schedule_name = N'RunOnce',
@freq_type = 1,
@active_start_time = 233000 ;
USE msdb ;
GO
EXEC sp_attach_schedule
@job_name = N'Weekly Sales Data Backup',
@schedule_name = N'RunOnce';
GO
EXEC dbo.sp_add_jobserver
@job_name = N'Weekly Sales Data Backup';
GO
</pre>
</div>
</div>
</div>
</div>
</li>
</ol>
</div>
<div style="font-size: 13px; line-height: 18px; padding-bottom: 15px;">
For more information, see:</div>
</li>
<ul style="font-size: 13px; line-height: 17.549999237060547px;">
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
<a href="http://technet.microsoft.com/en-us/library/ms182079.aspx" style="color: #0066dd; text-decoration: none;">sp_add_job (Transact-SQL)</a></div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
<a href="http://technet.microsoft.com/en-us/library/ms187358.aspx" style="color: #0066dd; text-decoration: none;">sp_add_jobstep (Transact-SQL)</a></div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
<a href="http://technet.microsoft.com/en-us/library/ms187320.aspx" style="color: #0066dd; text-decoration: none;">sp_add_schedule (Transact-SQL)</a></div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
<a href="http://technet.microsoft.com/en-us/library/ms186766.aspx" style="color: #0066dd; text-decoration: none;">sp_attach_schedule (Transact-SQL)</a></div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
<a href="http://technet.microsoft.com/en-us/library/ms178625.aspx" style="color: #0066dd; text-decoration: none;">sp_add_jobserver (Transact-SQL)</a></div>
</li>
</ul>
</ol>
<div>
<span style="line-height: 18px;">.</span></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-89142711134514831332014-05-11T20:45:00.000-07:002014-05-11T20:45:19.005-07:00MS SQL Server: Create SQL Job in SQL Server 2012<span style="color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18px;">This topic describes how to create a SQL Server Agent job in SQL Server 2012 by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects (SMO).</span><br />
<span style="color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px; line-height: 18px;"><br /></span>
<h3 class="subHeading" style="color: #2a2a2a; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 1.386em; font-weight: normal; margin: 0px; padding-bottom: 5px; padding-top: 5px;">
Limitations and Restrictions</h3>
<div class="subsection" style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; font-size: 13px;">
<ul style="color: #2a2a2a; line-height: 17.549999237060547px;">
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
To create a job, a user must be a member of one of the SQL Server Agent fixed database roles or the <strong>sysadmin</strong> fixed server role. A job can be edited only by its owner or members of the <strong>sysadmin</strong> role. </div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
Assigning a job to another login does not guarantee that the new owner has sufficient permission to run the job successfully.</div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
Local jobs are cached by the local SQL Server Agent. Therefore, any modifications implicitly force SQL Server Agent to re-cache the job. Because SQL Server Agent does not cache the job until <strong>sp_add_jobserver </strong>is called, it is more efficient to call <strong>sp_add_jobserver </strong>last.</div>
</li>
</ul>
<div>
<h3 class="subHeading" style="color: #2a2a2a; font-size: 1.386em; margin: 0px; padding-bottom: 5px; padding-top: 5px;">
Security</h3>
<div class="subsection" style="font-size: 13px;">
<ul style="color: #2a2a2a; line-height: 17.549999237060547px;">
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
You must be a system administrator to change the owner of a job.</div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
For security reasons, only the job owner or a member of the <strong>sysadmin</strong> role can change the definition of the job. Only members of the <strong>sysadmin</strong> fixed server role can assign job ownership to other users, and they can run any job, regardless of the job owner.</div>
</li>
<li style="list-style-image: none;"><div style="line-height: 18px; padding-bottom: 15px;">
<span style="font-size: 13px;">If you change job ownership to a user who is not a member of the </span><strong style="font-size: 13px;">sysadmin</strong><span style="font-size: 13px;"> fixed server role, and the job is executing job steps that require proxy accounts (for example, SSIS package execution), make sure that the user has access to that proxy account or else the job will fail.</span></div>
</li>
</ul>
<div>
<h2 class="LW_CollapsibleArea_TitleDiv" style="font-size: 13px; font-weight: normal; line-height: 17.549999237060547px; margin: 9px 0px 19px; padding: 0px;">
<a class="LW_CollapsibleArea_TitleAhref" href="https://www.blogger.com/null" style="outline: none;" title="Click to collapse. Double-click to collapse all."><span class="LW_CollapsibleArea_Title" style="display: block; font-size: 1.692em; overflow: hidden; padding-left: 10px;"><span style="color: #cc0000;">Using SQL Server Management Studio</span></span></a><div class="LW_CollapsibleArea_HrDiv" style="color: #2a2a2a; padding-top: 0px;">
</div>
</h2>
<div class="sectionblock" style="color: #2a2a2a; font-size: 13px; line-height: 17.549999237060547px; padding-bottom: 20px; padding-left: 15px;">
<a href="https://www.blogger.com/null" id="sectionToggle1" style="color: #00749e;"></a><h3 class="procedureSubHeading" style="font-size: 1.386em; font-weight: normal; margin: 0px; padding-bottom: 5px; padding-top: 5px;">
To create a SQL Server Agent job</h3>
<div class="subSection">
<ol>
<li><div style="line-height: 18px; padding-bottom: 15px;">
In the <span class="label" style="font-weight: 700;">Object Explorer</span>, click the plus sign to expand the server where you want to create a SQL Server Agent job.</div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
Click the plus sign to expand <span class="label" style="font-weight: 700;">SQL Server Agent</span>.</div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
Right-click the <span class="label" style="font-weight: 700;">Jobs</span> folder and select <span class="label" style="font-weight: 700;">New Job…</span>.</div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
In the <span class="label" style="font-weight: 700;">New Job</span> dialog box, on the <span class="label" style="font-weight: 700;">General</span> page, modify the general properties of the job. For more information on the available options on this page, see <a href="http://technet.microsoft.com/en-us/library/ms188458.aspx" style="color: #0066dd; text-decoration: none;">Job Properties / New Job (General Page)</a></div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
On the <span class="label" style="font-weight: 700;">Steps</span> page, organize the job steps. For more information on the available options on this page, see <a href="http://technet.microsoft.com/en-us/library/ms178691.aspx" style="color: #0066dd; text-decoration: none;">Job Properties / New Job (Steps Page)</a></div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
On the <span class="label" style="font-weight: 700;">Schedules</span> page, organize schedules for the job. For more information on the available options on this page, see <a href="http://technet.microsoft.com/en-us/library/ms177295.aspx" style="color: #0066dd; text-decoration: none;">Job Properties / New Job (Schedules Page)</a></div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
On the <span class="label" style="font-weight: 700;">Alerts</span> page, organize the alerts for the job. For more information on the available options on this page, see <a href="http://technet.microsoft.com/en-us/library/ms186556.aspx" style="color: #0066dd; text-decoration: none;">Job Properties / New Job (Alerts Page)</a></div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
On the <span class="label" style="font-weight: 700;">Notifications</span> page, set actions for Microsoft SQL Server Agent to perform when the job completes. For more information on the available options on this page, see <a href="http://technet.microsoft.com/en-us/library/ms189685.aspx" style="color: #0066dd; text-decoration: none;">Job Properties / New Job (Notifications Page)</a>.</div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
On the <span class="label" style="font-weight: 700;">Targets</span> page, manage the target servers for the job. For more information on the available options on this page, see <a href="http://technet.microsoft.com/en-us/library/ms186886.aspx" style="color: #0066dd; text-decoration: none;">Job Properties / New Job (Targets Page)</a>.</div>
</li>
<li><div style="line-height: 18px; padding-bottom: 15px;">
When finished, click <span class="label" style="font-weight: 700;">OK</span>.<br /><br /><br />.</div>
</li>
</ol>
</div>
</div>
</div>
</div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-11991465288323393202014-05-11T20:33:00.000-07:002014-05-11T20:34:29.738-07:00MS SQL Server: SQL Script to Push data from 1 server to another ServerTo insert/push data from one to another db, basically using common insert script : INSERT INTO SELECT statement<br />
<span style="background-color: white; font-family: verdana, helvetica, arial, sans-serif; font-size: 17px;"><br />SQL INSERT INTO SELECT Syntax</span><br />
<div style="background-color: white; color: #404040; font-family: verdana, helvetica, arial, sans-serif; font-size: 13px; line-height: 16.899999618530273px;">
We can copy all columns from one table to another, existing table:</div>
<div class="code notranslate" style="background-color: #f1f1f1; border: 1px solid rgb(212, 212, 212); color: #444444; font-family: verdana, helvetica, arial, sans-serif; font-size: 13px; margin: 0px; padding: 5px; width: auto;">
<div style="font-family: 'courier new'; font-size: 14px;">
INSERT INTO <em>table2</em><br />
SELECT * FROM <em>table1;</em></div>
</div>
<div style="background-color: white; color: #404040; font-family: verdana, helvetica, arial, sans-serif; font-size: 13px; line-height: 16.899999618530273px;">
Or we can copy only the columns we want to into another, existing table:</div>
<div class="code notranslate" style="background-color: #f1f1f1; border: 1px solid rgb(212, 212, 212); color: #444444; font-family: verdana, helvetica, arial, sans-serif; font-size: 13px; margin: 0px; padding: 5px; width: auto;">
<div style="font-family: 'courier new'; font-size: 14px;">
INSERT INTO <em>table2</em><br />
<em>(column_name(s))</em><br />
SELECT <em>column_name(s)</em><br />
FROM <em>table1;</em></div>
</div>
<br style="background-color: white; color: #404040; font-family: verdana, helvetica, arial, sans-serif; font-size: 13px;" />
In my case:<br />
I want to push data for integration purpose from <br />
Server A: table <b>dbA:Jdata1</b> and table <b>dbA.Jdata2</b><br />
to Server B: table <b>dbB.Jdata1</b> and table <b>dbB.Jdata2</b><br />
<br />
Let say; server ip like this:<br />
Server A: 10.10.1.20<br />
Server B: 10.10.2.25<br />
<br />
The script must take place in server which you create the Linked Server . It will look like this;<br />
<br />
<span style="background-color: purple; color: white;">INSERT INTO [10.10.2.25].[dbB].[<b>Jdata1</b>]<br />(trx_id, name, amount, recept_no, trx_date)</span><br />
<span style="background-color: purple; color: white;">SELECT (trx_id, name, amount, recept_no, trx_date)<br />FROM [10.10.1.20].[dbA].[<b>Jdata1</b>] where trx_date = cast(dateadd(d, -1, GETDATE()) as DATE)</span><br />
<br />
** cast(dateadd(d, -1, GETDATE()) as DATE) refer to yesterday transaction date<br />
<br />
It same goes to Jdata2;<br />
<br />
<span style="background-color: purple;"><span style="color: white;">INSERT INTO [10.10.2.25].[dbB].[<b>Jdata2</b>]<br />(trx_id, account_no, amount_cr, amount_dr,trx_desc, trx_date)</span></span><br />
<span style="background-color: purple;"><span style="color: white;">SELECT (trx_id, account_no, amount_cr, amount_dr,trx_desc, trx_date)<br />FROM [10.10.1.20].[dbA].[<b>Jdata2</b>] where trx_date = cast(dateadd(d, -1, GETDATE()) as DATE)</span></span><br />
<br />
You can put both script in SQL Job Schedule step to be run daily.<br />
<br />
Read more in: <a href="http://www.w3schools.com/sql/sql_insert_into_select.asp">http://www.w3schools.com/sql/sql_insert_into_select.asp</a><br />
<br />
<br />
.<br />
<br />
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-4008378496057824272014-05-11T20:09:00.001-07:002014-05-11T20:09:47.015-07:00MS SQL Server: How To Add Linked Server*Notes; <span style="background-color: white; color: #333333; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px;">Adding a Linked server can be done by either using the GUI interface or the </span><a href="http://sqlserverplanet.com/dba/using-sp_addlinkedserver/" style="background-color: white; background-image: none; border: 0px; color: #0968b3; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px; margin: 0px; padding: 0px; text-decoration: none;">sp_addlinkedserver</a><span style="background-color: white; color: #333333; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px;"> command.</span><br />
<span style="background-color: white; color: #333333; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px;"><br /></span>
<h5 style="background-color: white; background-image: none; border: 0px; color: #3a3a3a; font-family: vegurregular, 'Droid Sans', sans-serif; font-size: 14px; line-height: 20px; margin: 0px 0px 20px; padding: 0px;">
<u>Adding a linked Server using the GUI</u></h5>
<div>
<a href="http://2.bp.blogspot.com/-4HKcFz41Yq8/U3A4sMPvptI/AAAAAAAAB4A/ttMO9hxJMbU/s1600/newlinkedserver1.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><br /><br /><br /><img border="0" src="http://2.bp.blogspot.com/-4HKcFz41Yq8/U3A4sMPvptI/AAAAAAAAB4A/ttMO9hxJMbU/s1600/newlinkedserver1.jpg" height="268" width="400" /></a><div style="background-color: white; background-image: none; border: 0px; color: #333333; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px; margin-bottom: 17px; padding: 0px;">
<span style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 13.2px; margin: 0px; padding: 0px;">To add a linked server using SSMS (SQL Server Management Studio), open the server you want to create a link from in object explorer.</span></div>
<ol style="background-color: white; background-image: none; border: 0px; color: #333333; counter-reset: section 0; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 14px; padding: 0px 0px 0px 20px;"><a href="http://2.bp.blogspot.com/-VnaG4AXGlBY/U3A5W7IbL7I/AAAAAAAAB4I/qXNsM5fKtFw/s1600/linkedserversettings1.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" src="http://2.bp.blogspot.com/-VnaG4AXGlBY/U3A5W7IbL7I/AAAAAAAAB4I/qXNsM5fKtFw/s1600/linkedserversettings1.jpg" height="200" width="400" /></a>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">In SSMS, Expand Server Objects -> Linked Servers -> (Right click on the Linked Server Folder and select “New Linked Server”) > <span style="font-size: 15px;">Add New Linked Server<br /><br /><br /><br /><br /><br /></span></li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">The “New Linked Server” Dialog appears. (see below).<br /><br /><br /><br /><br /><br /><br /><br /></li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">For “Server Type” make sure “Other Data Source” is selected. (The SQL Server option will force you to specify the literal SQL Server Name)<br /></li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;"><span style="font-size: 15px;">Type in a friendly name that describes your linked server (without spaces). I use AccountingServer.</span></li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">Provider – Select “Microsoft OLE DB Provider for SQL Server”</li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">Product Name – type: SQLSERVER (with no spaces)</li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">Datasource – type the actual server name, and instance name using this convention: SERVERNAMEINSTANCENAME</li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">ProviderString – Blank</li>
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">Catalog – Optional (If entered use the default database you will be using)<br /></li>
</ol>
<div>
<h5 style="background-color: white; background-image: none; border: 0px; color: #3a3a3a; font-family: vegurregular, 'Droid Sans', sans-serif; font-size: 14px; line-height: 20px; margin: 0px 0px 20px; padding: 0px;">
<u>Define the Linked Server Security</u></h5>
</div>
<div>
<span style="background-color: white; color: #333333; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px;">Less Secure. Uses SQL Server Authentication to log in to the linked server. The credentials are used every time a call is made.<br /></span><span style="background-color: white; color: #333333; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px;">Most Secure. Uses integrated authentication, specifically Kerberos delegation to pass the credentials of the current login executing the request to the linked server. The remote server must also have the login defined. This requires establishing Kerberos Constrained Delegation in Active Directory, unless the linked server is another instance on the same Server. If instance is on the same server and the logins have the appropriate permissions, I recommend this one.</span></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-WDl7JrKteEs/U3A6xq6BdAI/AAAAAAAAB4U/vkCNGFJe4_8/s1600/linkedserversecuritysettings1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-WDl7JrKteEs/U3A6xq6BdAI/AAAAAAAAB4U/vkCNGFJe4_8/s1600/linkedserversecuritysettings1.jpg" height="548" width="640" /></a></div>
<div>
<ol style="background-color: white; background-image: none; border: 0px; color: #333333; counter-reset: section 0; font-family: 'Segoe UI', 'PT Sans', sans-serif; font-size: 15px; line-height: 21.170000076293945px; list-style-image: initial; list-style-position: initial; margin: 0px 0px 14px; padding: 0px 0px 0px 20px;">
<li style="background-image: none; background-position: initial initial; background-repeat: initial initial; border: 0px; font-size: 15px; list-style-position: outside; margin: 0px; padding: 0px;">Click OK, and the new linked server is created</li>
</ol>
<div>
<span style="color: #333333; font-family: Segoe UI, PT Sans, sans-serif;"><span style="line-height: 21.170000076293945px;"><br /></span></span></div>
</div>
<div>
<span style="color: #333333; font-family: Segoe UI, PT Sans, sans-serif;"><span style="line-height: 21.170000076293945px;">.</span></span></div>
<div>
</div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-39735745902950738492014-02-03T23:31:00.000-08:002014-02-03T23:31:11.258-08:00MYSQL: GRANT ACCESS to DATABASE<br />
<span style="background-color: white; color: #cc0000; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.790000915527344px;">GRANT ALL PRIVILEGES on db.* to 'username'@'applicationserverhost' IDENTIFIED BY 'password'</span><br />
<span style="background-color: white; color: #cc0000; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.790000915527344px;"><br /></span>
<span style="background-color: white; color: #cc0000; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.790000915527344px;">..</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-50335005975673421142014-02-03T19:39:00.001-08:002014-02-03T19:52:18.595-08:00Install MySQL Server 5 on Ubuntu<h2 style="background-color: white; color: #172232; font-family: arial, helvetica, clean, sans-serif; font-size: 13px; line-height: 15.859999656677246px; margin: 0px 0px 4px; padding: 0px; width: 650px;">
</h2>
<div class="thecontent" style="background-color: white; font-family: arial, helvetica, clean, sans-serif; font-size: 15px; margin: 0px -50px 0px 0px; padding: 0px;">
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 20px; padding: 0px;">
Installing MySQL 5 Server on Ubuntu is a quick and easy process.<br />
It almost feels like it should be more difficult.</div>
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 20px; margin-top: 20px; padding: 0px;">
Open a terminal window, and use the following command:</div>
<blockquote style="background-color: #f9f9f9; border: 1px dashed rgb(47, 111, 171); clear: both; font-family: monospace; line-height: 1.1em; margin: 0px 0px 10px; max-width: 618px; overflow-x: scroll; padding: 10px;">
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 10px; padding: 0px;">
sudo apt-get install mysql-server</div>
</blockquote>
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 20px; margin-top: 20px; padding: 0px;">
If you are running PHP you will also need to install the php module for mysql 5:</div>
<blockquote style="background-color: #f9f9f9; border: 1px dashed rgb(47, 111, 171); clear: both; font-family: monospace; line-height: 1.1em; margin: 0px 0px 10px; max-width: 618px; overflow-x: scroll; padding: 10px;">
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 10px; padding: 0px;">
sudo apt-get install php5-mysql</div>
</blockquote>
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 20px; margin-top: 20px; padding: 0px;">
To create a new database, use the mysqladmin command:</div>
<blockquote style="background-color: #f9f9f9; border: 1px dashed rgb(47, 111, 171); clear: both; font-family: monospace; line-height: 1.1em; margin: 0px 0px 10px; max-width: 618px; overflow-x: scroll; padding: 10px;">
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 10px; padding: 0px;">
mysqladmin create [databasename]<databasename></databasename></div>
</blockquote>
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 20px; margin-top: 20px; padding: 0px;">
See, really easy!</div>
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 20px; margin-top: 20px; padding: 0px;">
Source: <a href="http://www.howtogeek.com/howto/ubuntu/install-mysql-server-5-on-ubuntu/">http://www.howtogeek.com/howto/ubuntu/install-mysql-server-5-on-ubuntu/</a></div>
<div style="color: #333333; font-family: Verdana; font-size: 14px; line-height: 17.4520320892334px; margin-bottom: 20px; margin-top: 20px; padding: 0px;">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-49667217516025045222013-06-17T02:19:00.001-07:002013-06-17T02:19:21.082-07:00MS SQL:Create Index (Transact-SQL)An index can be created before there is data in the table. Relational
indexes can be created on tables or views in another database by
specifying a qualified database name.<br />
<br />
Refer notes from: <a href="http://msdn.microsoft.com/en-us/library/ms188783.aspx">http://msdn.microsoft.com/en-us/library/ms188783.aspx</a><br />
<br />
Sample:<br />
create index PARAMETER on TABLE (COLUMN)<br />
<br />
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:HyphenationZone>21</w:HyphenationZone>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>MS</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><br />
<!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman","serif";}
</style>
<![endif]-->
<br />
<div class="MsoNormal" style="text-autospace: none;">
<span lang="EN-MY" style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;">CREATE</span><span lang="EN-MY" style="font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;"> <span style="color: blue;">INDEX</span>
SHP_ID_CREATE_DATE</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span lang="EN-MY" style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;">ON</span><span lang="EN-MY" style="font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;"> C<span style="color: grey;">.</span>SHOPPER<span style="color: blue;"> </span><span style="color: grey;">(</span>CREATE_DATE<span style="color: grey;">)</span></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="text-autospace: none;">
<span lang="EN-MY" style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;">CREATE</span><span lang="EN-MY" style="font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;"> <span style="color: blue;">INDEX</span> ORDER_CREATE_DATE</span></div>
<div class="MsoNormal" style="text-autospace: none;">
<span lang="EN-MY" style="color: blue; font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;">ON</span><span lang="EN-MY" style="font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;"> E<span style="color: grey;">.<span style="color: black;">ORDERS</span></span><span style="color: grey;">(</span>CREATE_DATE<span style="color: grey;">)</span></span></div>
<div class="MsoNormal" style="text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="text-autospace: none;">
<br /></div>
<div class="MsoNormal" style="text-autospace: none;">
<span lang="EN-MY" style="font-family: "Courier New"; font-size: 10.0pt; mso-ansi-language: EN-MY;"><span style="color: grey;">. </span></span></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-63375309367436963662012-12-24T00:39:00.002-08:002012-12-24T00:43:13.466-08:00Wordpress: Permalinks problem in UBUNTU<strong>How to get WordPress permalinks / pretty links to work in Ubuntu 10.10 with Apache2</strong><br />
<strong></strong><br />
1. Manually create a ".htaccess" file and save it in your main
WordPress directory. (This is the one with the wp-admin, wp-includes,
and wp-content folders.)<br />
<br />
2. Go to the Ubuntu terminal and type:<br />
<code>sudo chown -v :www-data "/enterYourFilePathHere/.htaccess"</code><br />
<br />
You should see a line printed saying that the (group) file ownership has been changed to www-data (Apache2).<br />
<br />
3. Give Apache2 write access to the file:<br />
<code>sudo chmod -v 664 "/enterYourFilePathHere/.htaccess"</code><br />
You should see a line printed saying that the mode of the file has been retained.<br />
<br />
4. Next, we have to allow WordPress to write to the .htaccess file
by enabling mod_write in the Apache2 server. Type the following in the
terminal:<br />
<code>sudo a2enmod rewrite</code><br />
<br />
You should see a line printed saying that it is enabling mod rewrite and reminding you to restart the web server<br />
<br />
5. So let's do that. Restart the web server, Apache2, for the changes to take effect by typing:<br />
<code>sudo /etc/init.d/apache2 restart</code><br />
<br />
We are all done with the command line prompt; you can close the command line window now.<br />
<br />
5. Go into your WordPress admin panel (i.e. <a href="http://yourdomain/wp-admin%29" rel="nofollow">http://yourDomain/wp-admin)</a>. Go to the Settings --> Permalinks and select the permalink format of your choice. Hit the "Save Changes" button.<br />
<br />
6. <strong>DONE!</strong> Go to your site and check any page (other than your homepage) to ascertain that everything is working as expected.<br />
<br />
**<br />
7. The additional step I had to take was to edit /etc/apache2/sites-enabled/000-default.<br />
In that file you'll find an AllowOverride setting for /var/www, saying "None". <br /><br /> Change the setting to say: AllowOverride All
<br />
Restart the web server, Apache2, for the changes to take effect by typing:<br />
<code> sudo /etc/init.d/apache2 restart</code><br />
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-79648237637740634562012-11-01T01:49:00.003-07:002012-11-01T01:49:22.609-07:00XAMPP: Apache cannot start because IISI was in a middle to activate my localhost using xampp, apache web service. But unluckily, my pc already have iis automatically run on startup. So I try to find a way to disable the IIS Service.<br /><br />Finally I found this:<br />
<br /><span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px;">1. Control Panel > Programs and Features > Turn Windows features </span><span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px;">on or off. </span><br />
<span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px;">2. Uncheck the box for Internet Information Services.</span><br />
<span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px;"><br /></span>
<span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px;">3. Ok</span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-55412885716775992012012-10-31T20:51:00.002-07:002012-10-31T20:53:38.302-07:00Data Warehouse: Data Normalization<div class="separator" style="clear: both; text-align: justify;">
Data <a href="http://en.wikipedia.org/wiki/Database_normalization" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Database normalization">Normalization</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> splits up data to avoid redundancy (duplication) by moving commonly repeating groups of data into new tables. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-xI5vYuqmf-U/UJHwD0GRVKI/AAAAAAAABr8/MfEX4g0Xg4U/s1600/normalize_db_sample.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://1.bp.blogspot.com/-xI5vYuqmf-U/UJHwD0GRVKI/AAAAAAAABr8/MfEX4g0Xg4U/s1600/normalize_db_sample.png" /></a></div>
<h4 style="background-color: white; color: #393939; font-family: Arial, Helvetica, sans-serif; font-size: 13px; line-height: 20px; margin: 0px; padding: 20px 0px 0px; text-align: center; text-transform: capitalize;">
Database Normalization Example</h4>
<div>
<br /></div>
<div style="text-align: justify;">
<div style="background-color: white; color: #454545; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 10px 0px 0px; text-align: left;">
The following graphic gives an example of a typical conversion of an un-normalized table to multiple normalized tables.</div>
<div style="background-color: white; color: #454545; font-family: Arial, Helvetica, sans-serif; font-size: 13px; padding: 10px 0px 0px; text-align: left;">
<span class="Apple-style-span" style="font-weight: bold; margin: 0px; padding: 0px;">Advantages of Database Normalization:</span></div>
<div class="lst-case2" style="background-color: white; display: table; font-family: Arial, Helvetica, sans-serif; font-size: 13px; margin: 10px 0px 5px; padding: 0px; text-align: left;">
<ul class="blu" style="margin: 0px; padding: 0px;">
<li style="background-image: url(http://www.sqlsteps.com/assets/templates/sqlsteps-v2/images/bgs1.png); background-position: 0px -177px; background-repeat: no-repeat no-repeat; color: #454545; display: table; height: 15px; list-style-image: initial; list-style-position: initial; list-style-type: none; margin: 0px; padding: 2px 0px 2px 15px; width: 317px;">Data integrity is maintained.</li>
<li style="background-image: url(http://www.sqlsteps.com/assets/templates/sqlsteps-v2/images/bgs1.png); background-position: 0px -177px; background-repeat: no-repeat no-repeat; color: #454545; display: table; height: 15px; list-style-image: initial; list-style-position: initial; list-style-type: none; margin: 0px; padding: 2px 0px 2px 15px; width: 317px;">Results of queries are predictable.</li>
<li style="background-image: url(http://www.sqlsteps.com/assets/templates/sqlsteps-v2/images/bgs1.png); background-position: 0px -177px; background-repeat: no-repeat no-repeat; color: #454545; display: table; height: 15px; list-style-image: initial; list-style-position: initial; list-style-type: none; margin: 0px; padding: 2px 0px 2px 15px; width: 317px;">Changes to data have to be made only once.</li>
<br />Amount of storage required by the database is optimal.
</ul>
</div>
</div>
<br />
<br />
Read more reference:<br />
<a href="http://en.wikipedia.org/wiki/Data_normalization">http://en.wikipedia.org/wiki/Data_normalization</a><br />
<a href="http://en.wikipedia.org/wiki/Database_normalization">http://en.wikipedia.org/wiki/Database_normalization</a><br />
<a href="http://www.sqlsteps.com/what-sql-classes-dont-normally-cover">http://www.sqlsteps.com/what-sql-classes-dont-normally-cover</a><br />
.Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-4999477317987751114.post-6927412364801216702012-10-31T18:22:00.000-07:002012-10-31T18:22:28.565-07:00Data Warehouse: Snowflake Schema<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-8KrstbmoR-w/UJHNVmmp5sI/AAAAAAAABrM/_tI0JidmXM8/s1600/800px-Snowflake-schema.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="193" src="http://4.bp.blogspot.com/-8KrstbmoR-w/UJHNVmmp5sI/AAAAAAAABrM/_tI0JidmXM8/s320/800px-Snowflake-schema.png" width="320" /></a></div>
<b><br />Snowflake Schema</b><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">In data warehouse, a </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">snowflake schema</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is a </span><a href="http://en.wikipedia.org/wiki/Logical_schema" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Logical schema">logical arrangement</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> of tables in a </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Multidimensional_database" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Multidimensional database">multidimensional database</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> such that the </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Entity-relationship_model" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Entity-relationship model">entity relationship</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> diagram resembles a </span><a href="http://en.wikipedia.org/wiki/Snowflake" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Snowflake">snowflake</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> in shape. The snowflake schema is represented by centralized </span><a href="http://en.wikipedia.org/wiki/Fact_table" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Fact table">fact tables</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> which are connected to multiple </span><a href="http://en.wikipedia.org/wiki/Dimension_(data_warehouse)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Dimension (data warehouse)">dimensions</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">It </span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">is similar to the </span><a href="http://en.wikipedia.org/wiki/Star_schema" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Star schema">star schema</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">. However, in the snowflake schema, dimensions are </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Normalization_(database)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Normalization (database)">normalized</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> into multiple related tables, whereas the star schema's dimensions are normalized with each dimension represented by a single table.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><b>Example:</b></span><span style="background-color: #f9f9f9; font-family: sans-serif; font-size: 11px; line-height: 15.833333015441895px;">Snowflake schema used by example query.<br /></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-UIxf_WUBJ1E/UJHOczQmM4I/AAAAAAAABrU/24rujSk07C8/s1600/Snowflake-schema-example.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="347" src="http://4.bp.blogspot.com/-UIxf_WUBJ1E/UJHOczQmM4I/AAAAAAAABrU/24rujSk07C8/s640/Snowflake-schema-example.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: justify;">
</div>
<pre class="de1" style="background-color: #f9f9f9; background-image: none; border: 0px none white; font-size: 13px; line-height: 1.2em; padding: 0px; text-align: start; vertical-align: top;"><span class="kw1" style="color: #993333; font-weight: bold;">SELECT</span>
B<span class="sy0" style="color: #66cc66;">.</span>Brand<span class="sy0" style="color: #66cc66;">,</span>
G<span class="sy0" style="color: #66cc66;">.</span>Country<span class="sy0" style="color: #66cc66;">,</span>
<span class="kw1" style="color: #993333; font-weight: bold;">SUM</span><span class="br0" style="color: #66cc66;">(</span>F<span class="sy0" style="color: #66cc66;">.</span>Units_Sold<span class="br0" style="color: #66cc66;">)</span>
<span class="kw1" style="color: #993333; font-weight: bold;">FROM</span> Fact_Sales F
<span class="kw1" style="color: #993333; font-weight: bold;">INNER</span> <span class="kw1" style="color: #993333; font-weight: bold;">JOIN</span> Dim_Date D <span class="kw1" style="color: #993333; font-weight: bold;">ON</span> F<span class="sy0" style="color: #66cc66;">.</span>Date_Id <span class="sy0" style="color: #66cc66;">=</span> D<span class="sy0" style="color: #66cc66;">.</span>Id
<span class="kw1" style="color: #993333; font-weight: bold;">INNER</span> <span class="kw1" style="color: #993333; font-weight: bold;">JOIN</span> Dim_Store S <span class="kw1" style="color: #993333; font-weight: bold;">ON</span> F<span class="sy0" style="color: #66cc66;">.</span>Store_Id <span class="sy0" style="color: #66cc66;">=</span> S<span class="sy0" style="color: #66cc66;">.</span>Id
<span class="kw1" style="color: #993333; font-weight: bold;">INNER</span> <span class="kw1" style="color: #993333; font-weight: bold;">JOIN</span> Dim_Geography G <span class="kw1" style="color: #993333; font-weight: bold;">ON</span> S<span class="sy0" style="color: #66cc66;">.</span>Geography_Id <span class="sy0" style="color: #66cc66;">=</span> G<span class="sy0" style="color: #66cc66;">.</span>Id
<span class="kw1" style="color: #993333; font-weight: bold;">INNER</span> <span class="kw1" style="color: #993333; font-weight: bold;">JOIN</span> Dim_Product P <span class="kw1" style="color: #993333; font-weight: bold;">ON</span> F<span class="sy0" style="color: #66cc66;">.</span>Product_Id <span class="sy0" style="color: #66cc66;">=</span> P<span class="sy0" style="color: #66cc66;">.</span>Id
<span class="kw1" style="color: #993333; font-weight: bold;">INNER</span> <span class="kw1" style="color: #993333; font-weight: bold;">JOIN</span> Dim_Brand B <span class="kw1" style="color: #993333; font-weight: bold;">ON</span> P<span class="sy0" style="color: #66cc66;">.</span>Brand_Id <span class="sy0" style="color: #66cc66;">=</span> B<span class="sy0" style="color: #66cc66;">.</span>Id
<span class="kw1" style="color: #993333; font-weight: bold;">INNER</span> <span class="kw1" style="color: #993333; font-weight: bold;">JOIN</span> Dim_Product_Category C <span class="kw1" style="color: #993333; font-weight: bold;">ON</span> P<span class="sy0" style="color: #66cc66;">.</span>Product_Category_Id <span class="sy0" style="color: #66cc66;">=</span> C<span class="sy0" style="color: #66cc66;">.</span>Id
<span class="kw1" style="color: #993333; font-weight: bold;">WHERE</span>
D<span class="sy0" style="color: #66cc66;">.</span><span class="kw1" style="color: #993333; font-weight: bold;">YEAR</span> <span class="sy0" style="color: #66cc66;">=</span> <span class="nu0" style="color: #cc66cc;">1997</span> <span class="kw1" style="color: #993333; font-weight: bold;">AND</span>
C<span class="sy0" style="color: #66cc66;">.</span>Product_Category <span class="sy0" style="color: #66cc66;">=</span> <span class="st0" style="color: red;">'tv'</span>
<span class="kw1" style="color: #993333; font-weight: bold;">GROUP</span> <span class="kw1" style="color: #993333; font-weight: bold;">BY</span>
B<span class="sy0" style="color: #66cc66;">.</span>Brand<span class="sy0" style="color: #66cc66;">,</span>
G<span class="sy0" style="color: #66cc66;">.</span>Country</pre>
<br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Read more: </span><a href="http://en.wikipedia.org/wiki/Snowflake_schema">http://en.wikipedia.org/wiki/Snowflake_schema</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-4999477317987751114.post-68912804335567927382012-10-31T18:13:00.000-07:002012-10-31T18:13:07.194-07:00Data Warehouse: Star Schema<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-U5CFpyrOcR4/UJHLY-rqazI/AAAAAAAABrE/u3l5OEEQKc8/s1600/Star-schema-example.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="193" src="http://2.bp.blogspot.com/-U5CFpyrOcR4/UJHLY-rqazI/AAAAAAAABrE/u3l5OEEQKc8/s320/Star-schema-example.png" width="320" /></a></div>
<b>Star Schema</b><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">In Data Warehouse, the combination of facts and dimensions is sometimes called a </span><a href="http://en.wikipedia.org/wiki/Star_schema" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Star schema">star schema</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">The </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">star schema</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> (also called </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">star-join schema</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">data cube</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, or </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">multi-dimensional schema</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">) is the simplest style of </span><a href="http://en.wikipedia.org/wiki/Data_warehouse" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Data warehouse">data warehouse</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> </span><a href="http://en.wikipedia.org/wiki/Logical_schema" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Logical schema">schema</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">. The star schema consists of one or more </span><a href="http://en.wikipedia.org/wiki/Fact_table" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Fact table">fact tables</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> referencing any number of </span><a href="http://en.wikipedia.org/wiki/Dimension_(data_warehouse)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Dimension (data warehouse)">dimension tables</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><b>Model </b>(<i>refer the graphic above</i>)</span><br />
<br />
<ul style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; list-style-image: url(data:image/png; list-style-type: square; margin: 0.3em 0px 0px 1.6em; padding: 0px;">
<li style="margin-bottom: 0.1em;">The <i>fact table</i> holds the metric values recorded for a specific event. Because of the desire to hold atomic level data, there generally are a very large number of records (billions). Special care is taken to minimize the number and size of attributes in order to constrain the overall table size and maintain performance. Fact tables generally come in 3 flavors - transaction (facts about a specific event e.g. Sale), snapshot (facts recorded at a point in time e.g. Account details at month end), and accumulating snapshot tables (e.g. month-to-date sales for a product).<br /></li>
<li style="margin-bottom: 0.1em;"><i>Dimension tables</i> usually have few records compared to fact tables, but may have a very large number of attributes that describe the fact data.<br /><br />Read more: <a href="http://en.wikipedia.org/wiki/Star_schema">http://en.wikipedia.org/wiki/Star_schema</a></li>
</ul>
Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-4999477317987751114.post-13045463910925931052012-10-31T18:06:00.001-07:002012-10-31T18:06:04.981-07:00Data: Data Marts<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Ea1ZAOSsERo/UJHJtykjvEI/AAAAAAAABq8/VS-b8La05GU/s1600/Data_warehouse_overview.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="240" src="http://3.bp.blogspot.com/-Ea1ZAOSsERo/UJHJtykjvEI/AAAAAAAABq8/VS-b8La05GU/s320/Data_warehouse_overview.JPG" width="320" /></a></div>
<br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Data warehouses can be subdivided into </span><a href="http://en.wikipedia.org/wiki/Data_mart" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Data mart">data marts</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">. Data marts store subsets of data from a warehouse.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Data Mart</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is the access layer of the </span><a href="http://en.wikipedia.org/wiki/Data_warehouse" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Data warehouse">data warehouse</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> environment that is used to get data out to the users. The data mart is a subset of the data warehouse that is usually oriented to a specific business line or team.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">In deployments, each department/business unit is considered the </span><i style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">owner</i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> of its data mart including all the </span><i style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">hardware</i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, </span><i style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">software</i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> and </span><i style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">data</i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Each department able to manipulate and develop their data any way they see fit; without altering information inside other data marts or the data warehouse. </span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Read more: </span><a href="http://en.wikipedia.org/wiki/Data_mart">http://en.wikipedia.org/wiki/Data_mart</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-32024683346793964382012-10-31T01:26:00.001-07:002012-10-31T01:26:40.287-07:00Data: Data WarehouseI've been employed by new sub-govern company since last 2 weeks.<br />
And till now I've been assigning different task from the first week to another weeks...<br />
First, I was asked to backup finance system, then last week I was asked to help collection module for new system .. and today I just knowing will be assigned new task.. to handle data warehouse.<br />
What is data warehouse?<br />
<br />
<b style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">Data Warehouse</b><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>(</span><b style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">DW</b><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>or<span class="Apple-converted-space"> </span></span><b style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">DWH</b><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">) is a<span class="Apple-converted-space"> </span></span><a href="http://en.wikipedia.org/wiki/Database" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" title="Database">database</a><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>used for<span class="Apple-converted-space"> </span></span><a href="http://en.wikipedia.org/wiki/Business_reporting" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" title="Business reporting">reporting</a><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>and<span class="Apple-converted-space"> </span></span><a href="http://en.wikipedia.org/wiki/Data_analysis" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" title="Data analysis">data analysis</a><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">. It is a central repository of data which is created by integrating data from multiple disparate sources. Data warehouses store current as well as historical data and are commonly used for creating trending reports for senior management reporting such as annual and quarterly comparisons.</span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">The data may pass through an<span class="Apple-converted-space"> </span></span><a href="http://en.wikipedia.org/wiki/Operational_data_store" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" title="Operational data store">operational data store</a><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>for additional operations before they are used in the DW for reporting.</span></span><br />
<br />
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; margin: 0.4em 0px 0.5em; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<b><b>ETL</b></b><span class="Apple-converted-space"></span>(<b>extract, transform and load</b><span class="Apple-converted-space"> </span>) refers to a process in<span class="Apple-converted-space"> </span><a href="http://en.wikipedia.org/wiki/Database" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Database">database</a><span class="Apple-converted-space"> </span>usage and especially in<span class="Apple-converted-space"> </span><a href="http://en.wikipedia.org/wiki/Data_warehouse" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Data warehouse">data warehousing</a><span class="Apple-converted-space"> </span>that involves:</div>
<ul style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; list-style-image: url(data:image/png; list-style-type: square; margin: 0.3em 0px 0px 1.6em; orphans: 2; padding: 0px; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<li style="margin-bottom: 0.1em;"><a href="http://en.wikipedia.org/wiki/Data_extraction" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Data extraction">Extracting data</a><span class="Apple-converted-space"> </span>from outside sources</li>
<li style="margin-bottom: 0.1em;"><a href="http://en.wikipedia.org/wiki/Data_transformation" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Data transformation">Transforming</a><span class="Apple-converted-space"> </span>it to fit operational needs (which can include quality levels)</li>
<li style="margin-bottom: 0.1em;">Loading it into the end target (database, more specifically,<span class="Apple-converted-space"> </span><a href="http://en.wikipedia.org/wiki/Operational_data_store" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Operational data store">operational data store</a>,<span class="Apple-converted-space"> </span><a href="http://en.wikipedia.org/wiki/Data_mart" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Data mart">data mart</a><span class="Apple-converted-space"> </span>or<span class="Apple-converted-space"> </span><a href="http://en.wikipedia.org/wiki/Data_warehouse" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Data warehouse">data warehouse</a>)</li>
</ul>
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">The staging layer or staging database stores raw data extracted from each of the disparate source data systems. The integration layer integrates the disparate data sets by transforming the data from the staging layer often storing this transformed data in an<span class="Apple-converted-space"> </span></span><a href="http://en.wikipedia.org/wiki/Operational_data_store" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" title="Operational data store">operational data store</a><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>(ODS) database.</span></span></span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">The integrated data are then moved to another database, often called the <b>data warehouse database</b></span>.</span> </span></span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">Read more: </span></span><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><a href="http://en.wikipedia.org/wiki/Data_warehouse">http://en.wikipedia.org/wiki/Data_warehouse</a> </span></span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; background-color: white; color: black; display: inline !important; float: none; font-family: sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.200000762939453px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">. </span> </span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-88189861349884729152012-10-24T21:43:00.001-07:002012-10-24T21:43:27.514-07:00Java: JDK Installation for Microsoft Windows<span style="color: #741b47;"><i><b>Download Installer</b></i></span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">The file<span class="Apple-converted-space"> </span></span><tt style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: #444444; font-family: 'Courier New', Monaco, Courier, monospace; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">jdk-7<version>-windows-i586-i.exe</version></tt><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>is the JDK installer for 32-bit systems. The file<span class="Apple-converted-space"> </span></span><tt style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: #444444; font-family: 'Courier New', Monaco, Courier, monospace; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">jdk-7<version>-windows-x64.exe</version></tt><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span class="Apple-converted-space"> </span>is the JDK installer for 64-bit systems. If you downloaded either file instead of running it directly from the web site, double-click the installer's icon.</span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">Follow the instructions the installer provides. The installer may ask you to reboot your computer. <br />**When finished with the installation, you can delete the downloaded file to recover disk space.</span></span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">Read more; </span></span><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><a href="http://docs.oracle.com/javase/7/docs/webnotes/install/windows/jdk-installation-windows.html">http://docs.oracle.com/javase/7/docs/webnotes/install/windows/jdk-installation-windows.html</a> </span></span><br />
<br />
<span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;"><span style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; display: inline !important; float: none; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">. </span> </span>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-64265320794479949022012-10-23T18:56:00.001-07:002012-10-24T19:40:28.481-07:00Oracle: Java SE Development Kit 7u6I'm planning to study Java programming from online tutorial. The first thing I have to do is download the package first from Oracle official site.. <a href="http://www.oracle.com/technetwork/java/javase/downloads/jdk7u9-downloads-1859576.html">http://www.oracle.com/technetwork/java/javase/downloads/jdk7u9-downloads-1859576.html</a><br />
<br />
<span style="color: red; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 21px; font-weight: bold;"><br /></span>
<span style="color: red; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 21px; font-weight: bold;">JDK 7 and JRE 7 Installation Guide</span><br />
<a href="http://docs.oracle.com/javase/">http://docs.oracle.com/javase/</a><br />
<div class="smallpagetitle" id="sharepage" style="color: red; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 21px; font-weight: bold; margin: 0px; min-height: 23px; padding: 0px 159px 0px 10px; position: relative; z-index: 28;">
<div class="sharepage" style="position: absolute; right: 10px; top: -3px;">
<div class="sharepagew1 share-mailto">
<table cellpadding="0" cellspacing="0" style="background-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/share-page-bgs.gif); background-position: 100% -30px; background-repeat: no-repeat no-repeat;" summary=""><tbody>
<tr><td id="share-mailto" style="background-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/share-page-bgs.gif); background-position: -356px 0px; background-repeat: no-repeat no-repeat;"></td><td id="share-technorati" style="background-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/share-page-bgs.gif); background-position: -3px 0px; background-repeat: no-repeat no-repeat;"></td><td id="share-delicious" style="background-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/share-page-bgs.gif); background-position: -27px 0px; background-repeat: no-repeat no-repeat;"></td><td id="share-digg" style="background-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/share-page-bgs.gif); background-position: -49px 0px; background-repeat: no-repeat no-repeat;"></td><td id="share-slashdot" style="background-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/share-page-bgs.gif); background-position: -71px 0px; background-repeat: no-repeat no-repeat;"></td><td id="share-blank" style="background-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/share-page-bgs.gif); background-position: 100% -30px; background-repeat: no-repeat no-repeat; padding-left: 3px;"></td></tr>
</tbody></table>
</div>
</div>
</div>
<div style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 12px; margin-bottom: 17px; margin-top: 3px;">
Do you want to run Java programs, or do you want to develop Java programs? If you want to run Java programs, but not develop them, download the Java Runtime Environment, or JRE. If you want to develop Java applications, download the Java Development Kit, or JDK. The JDK includes the JRE, so you do not have to download both separately.</div>
<div style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 12px; margin-bottom: 17px; margin-top: 3px;">
</div>
<h1 style="color: red; font-size: 21px; margin: 0px; min-height: 23px; padding: 0px 1px 0px 0px;">
Windows System Requirements for JDK and JRE</h1>
<h3 style="color: black; font-size: 15px; margin: 3px 0px 0px; padding: 0px;">
<a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="processor-32">Processor Requirements</a></h3>
<div style="color: black; font-size: 12px; font-weight: normal; margin-bottom: 17px; margin-top: 2px;">
Both the Java SE Development Kit (JDK) and Java SE Runtime Environment (JRE) require at minimum a Pentium 2 266 MHz processor.</div>
<h3 style="color: black; font-size: 15px; margin: 3px 0px 0px; padding: 0px;">
<a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="disk-space-32">Disk Space Requirements</a></h3>
<div style="color: black; font-size: 12px; font-weight: normal; margin-bottom: 17px; margin-top: 2px;">
For the JDK, you are given the option of installing the following features:</div>
<ul style="color: black; font-size: 12px; font-weight: normal; margin-left: 13px; padding-left: 0px;">
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">Development Tools</li>
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">Source Code</li>
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">Public Java Runtime Environment</li>
</ul>
<div style="color: black; font-size: 12px; font-weight: normal; margin-bottom: 17px; margin-top: 3px;">
<b>Note</b>:</div>
<ul style="color: black; font-size: 12px; font-weight: normal; margin-left: 13px; padding-left: 0px;">
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">For the JDK, the <i>installed image</i> consists of all the files installed under the directory <code style="color: #444444; font-family: 'Courier New', Monaco, Courier, monospace;">jdk1.7.0</code>; for the JRE, it consists of all files installed under the directory <code style="color: #444444; font-family: 'Courier New', Monaco, Courier, monospace;">jre1.7.0</code>.</li>
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">The directory <code style="color: #444444; font-family: 'Courier New', Monaco, Courier, monospace;">Program Files\Common Files\Java\Java Update</code>, or <code style="color: #444444; font-family: 'Courier New', Monaco, Courier, monospace;">Program Files (x86)\Common Files\Java\Java Update</code> on 64-bit operating systems, contains <a href="http://docs.oracle.com/javase/7/docs/technotes/guides/deployment/deployment-guide/java-update.html" style="color: #666666;">Java Update</a>, which enables you to keep your computer up-to-date automatically with the latest JRE releases.</li>
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">The installed image will, by default, be installed on the <i>Windows drive</i> — the drive where the Windows operating system is installed (sometimes called the <i>system drive</i>). Most often this will be the C drive. However, it is possible to install the installed image on any drive. For instance, the installed image for the JDK could be installed to a non-Windows drive with a custom installation.</li>
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">Java SE uses the directory <code style="color: #444444; font-family: 'Courier New', Monaco, Courier, monospace;">%APPDATA%</code> to store temporary files. To determine the location of this directory, go to the Java Control Panel (from the Windows Control Panel). Select the <b>General</b> tab. In the <b>Temporary Internet Files</b> panel, click <b>Settings...</b>. Note that only advanced users should modify the settings for temporary files.</li>
</ul>
<div style="color: black; font-size: 12px; font-weight: normal; margin-bottom: 17px; margin-top: 3px;">
In addition to the disk space required for the installed images, there must be sufficient disk space for Java Update. The table that follow show the various disk space requirements for the JRE and JDK:</div>
<table border="1" cellpadding="3" cellspacing="0" style="color: black; font-size: 12px; text-align: start;" summary="Disk Space Requirements for JRE"><caption style="font-weight: bold; text-align: left;">Disk Space Requirements for JRE</caption><tbody>
<tr><td><b>JRE</b></td><td><b>Installed Image</b></td></tr>
<tr><td>Java Runtime Environment, including JavaFX Runtime</td><td>124 MB</td></tr>
<tr><td>Java Update</td><td>2 MB</td></tr>
</tbody></table>
<table border="1" cellpadding="3" cellspacing="0" style="color: black; font-size: 12px; text-align: start;" summary="Disk Space Requirements for JDK"><caption class="following" style="font-weight: bold; padding-top: 1em; text-align: left;">Disk Space Requirements for JDK</caption><tbody>
<tr><td><b>JDK</b></td><td><b>Installed Image</b></td></tr>
<tr><td>Development Tools, including JavaFX SDK</td><td>245 MB</td></tr>
<tr><td>Source Code</td><td>27 MB</td></tr>
<tr><td>Public Java Runtime Environment</td><td>See the table, "Disk Space Requirements for JRE"</td></tr>
</tbody></table>
<br />
<h3 style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 15px; margin: 3px 0px 0px; padding: 0px;">
<a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="memory-32">Memory Requirements</a></h3>
<div style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 12px; margin-bottom: 17px; margin-top: 2px;">
The following table lists the minimum memory requirements for Windows 32-bit operating systems.</div>
<div style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 12px; margin-bottom: 17px; margin-top: 2px;">
<table border="1" cellpadding="3" cellspacing="0" style="color: black; font-size: 12px; text-align: start;" summary="Memory Requirements for Microsoft Windows 32-Bit"><caption style="font-weight: bold; text-align: left;">Microsoft Windows 32-Bit</caption><tbody>
<tr><th>Version</th><th>Memory</th></tr>
<tr><td>Windows 7</td><td>128 MB</td></tr>
<tr><td>Windows Vista</td><td>128 MB</td></tr>
<tr><td>Windows Server 2008</td><td>128 MB</td></tr>
<tr><td>Windows XP</td><td>64 MB</td></tr>
</tbody></table>
</div>
<h2 style="font-size: 16px; margin: 3px 0px 0px; padding: 0px;">
</h2>
<h2 style="font-family: Arial,Helvetica,FreeSans,Luxi-sans,'Nimbus Sans L',sans-serif; font-size: 16px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; margin: 3px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<u><span style="color: #990000;"><a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="bit-64" style="text-decoration: none;">64-bit Platforms<br /></a></span></u></h2>
<h3 style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 15px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; margin: 3px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="processor-64" style="text-decoration: none;">Processor Requirements</a></h3>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin-bottom: 17px; margin-top: 2px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
Both the JDK and JRE require at minimum a Pentium 2 266 MHz processor.</div>
<h3 style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 15px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; margin: 3px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="disk-space-64" style="text-decoration: none;">Disk Space Requirements</a></h3>
<ul style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin-left: 13px; margin-top: 2px; orphans: 2; padding-left: 0px; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">The JDK features available for 64-bit platforms are the same as those for Windows 32-bit operating systems.</li>
<li style="list-style-image: url(http://docs.oracle.com/javase/webdesign/pubs/im/ul_bullet.gif); margin-left: 13px; padding-left: 0px;">The disk requirement for development tools for 64-bit platforms is 181 MB. The disk space requirements for source code and the public JRE are the same as those for Windows 32-bit operating systems, except for the JavaFX SDK (68 MB) and the JavaFX runtime (32 MB).</li>
</ul>
<h3 style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 15px; font-style: normal; font-variant: normal; letter-spacing: normal; line-height: normal; margin: 3px 0px 0px; orphans: 2; padding: 0px; text-align: start; text-decoration: none; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="memory-64" style="text-decoration: none;">Memory Requirements</a></h3>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin-bottom: 17px; margin-top: 2px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
The following tables list the minimum memory requirements for Windows 64-bit operating systems:</div>
<div style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin-bottom: 17px; margin-top: 3px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<strong>Note</strong>: The minimum physical RAM is required to run graphically based applications. More RAM is recommended for applets running within a browser using the Java Plug-in. Running with less memory may cause disk swapping, which has a severe effect on performance. Very large programs may require more RAM for adequate performance.</div>
<table border="1" cellpadding="3" cellspacing="0" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" summary="Memory Requirements for Microsoft Windows x64, 32-bit mode"><caption style="font-weight: bold; text-align: left;">Microsoft Windows x64, 32-Bit Mode</caption><tbody>
<tr><th>Version</th><th>Memory</th></tr>
<tr><td>Windows 7</td><td>128 MB</td></tr>
<tr><td>Windows Server 2008</td><td>128 MB</td></tr>
<tr><td>Windows Vista</td><td>128 MB</td></tr>
<tr><td>Windows XP</td><td>128 MB</td></tr>
</tbody></table>
<table border="1" cellpadding="3" cellspacing="0" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;" summary="Memory Requirements for Microsoft Windows x64, 64-bit mode"><caption class="following" style="font-weight: bold; padding-top: 1em; text-align: left;">Microsoft Windows x64, 64-Bit Mode</caption><tbody>
<tr><th>Version</th><th>Memory</th></tr>
<tr><td>Windows 7</td><td>128 MB</td></tr>
<tr><td>Windows Server 2008</td><td>128 MB</td></tr>
<tr><td>Windows Server 2008 R2</td><td>128 MB</td></tr>
<tr><td>Windows Vista</td><td>128 MB</td></tr>
<tr><td>Windows XP</td><td>128 MB</td></tr>
</tbody></table>
<div id="javasefooter" style="-webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; color: black; font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 11.818181991577148px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; padding-bottom: 10px; padding-top: 10px; position: relative; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px;">
<br class="Apple-interchange-newline" /></div>
<br />
<div style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 12px; margin-bottom: 17px; margin-top: 2px;">
<br /></div>
<div style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 12px; margin-bottom: 17px; margin-top: 2px;">
<br /></div>
<div style="font-family: Arial, Helvetica, FreeSans, Luxi-sans, 'Nimbus Sans L', sans-serif; font-size: 12px; margin-bottom: 17px; margin-top: 2px;">
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-76973307166604772182012-10-22T19:03:00.001-07:002012-10-22T21:42:21.385-07:00FreeBSD: How to Jails on FreeBsd(Filter access)Thanks Kokteels, the guide refered from you:<br />
<a href="http://shab4b.blogspot.com/2012/03/how-to-jails-on-freebsd-82.html">http://shab4b.blogspot.com/2012/03/how-to-jails-on-freebsd-82.html</a><br />
<span style="background-color: #fafafa; font-family: Georgia, 'Times New Roman', serif; font-size: x-small; text-align: justify;"><br /></span>
<span style="background-color: #fafafa; font-family: Georgia, 'Times New Roman', serif; font-size: x-small; text-align: justify;">1. Need to csup for port & stable supfile. Skip this step if you already compile before.</span><span style="background-color: #fafafa; font-family: Georgia, 'Times New Roman', serif; font-size: x-small; text-align: justify;"> </span><br />
<span style="font-family: Georgia, 'Times New Roman', serif; font-size: x-small; line-height: 19px; text-align: justify;"><br />2. Next step </span><br />
<pre style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-size: x-small;"># setenv D /jail/www
# mkdir -p $D
# cd /usr/src
# make buildworld
# make installworld DESTDIR=$D
# cd etc/
# make distribution DESTDIR=$D
# mount -t devfs devfs $D/dev </span></pre>
<pre style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-size: x-small;">
</span></pre>
<pre style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; text-align: justify;"><span style="font-size: x-small;">3. Edit following patch #ee /etc/rc.conf</span></pre>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;">sshd_enable="YES"<br />ifconfig_em0="DHCP"<br />ifconfig_bge0_alias1="inet 10.0.0.100 netmask 255.255.255.0"<br />jail_set_hostname_allow="NO"<br />jail_enable="YES"<br />jail_list="www"<br />jail_interface="bge0"<br />jail_devfs_enable="YES"<br />jail_procfs_enable="YES"<br />jail_mount_enable="NO"<br />jail_www_rootdir="/jail/www"<br />jail_www_hostname="www.ozel.net"<br />jail_www_ip="10.0.0.100"<br />jail_www_devfs_ruleset="devfsrules_jail"<br />*can be any available IP at you LAN.</span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;">4. Start Jail</span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;">#/etc/rc.d/jail start</span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<br /></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;">5. Testing Jail.</span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;">#jls -v</span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
</div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;"># jls</span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-oMaKpx4-YwE/UIX60Qz_ZVI/AAAAAAAABqs/0fqU_Y1q_74/s1600/jails2.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-oMaKpx4-YwE/UIX60Qz_ZVI/AAAAAAAABqs/0fqU_Y1q_74/s1600/jails2.PNG" /></a></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;"><br /></span></div>
<div style="font-family: Georgia, 'Times New Roman', serif; font-size: 14px; line-height: 19px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-size: x-small;">**</span><span style="background-color: #fafafa; font-size: x-small; line-height: 18px;">*Minimum 6Gb need to deploy jails. Csup will take lot of file.</span></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-10033508237040727432012-10-21T21:48:00.001-07:002012-10-23T18:35:40.344-07:00Finance: Functional & Terms<span style="font-size: x-small;"><span style="color: #073763;">Source Reference:</span></span><br />
<a href="http://en.wikipedia.org/">http://en.wikipedia.org</a><br />
<a href="http://www.investopedia.com/">http://www.investopedia.com</a><br />
<a href="http://www.wikicfo.com/">http://www.wikicfo.com</a><i><b><span style="color: #741b47;"><br /><br />Ledger</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">The ledger is a permanent summary of all amounts entered in supporting </span><a href="http://en.wikipedia.org/wiki/General_journal" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="General journal">journals</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> which list individual transactions by date.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<i><b><span style="color: #741b47;">General Ledger(GL)</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">General Ledger is the final repository of the accounting records and data. In modern accounting softwares or ERP, the general ledger works as a central repository for accounting data transferred from all sub-ledgers or modules like accounts payable, accounts recievable, cash management, fixed assets, purchasing and projects. General ledger is the backbone of any accounting system which holds financial and non-financial data for an oranization.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<i><b><span style="color: #741b47;">Journals</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Is a </span><a href="http://en.wikipedia.org/wiki/Double-entry_bookkeeping_system" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Double-entry bookkeeping system">double entry bookkeeping</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> entries are recorded by </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Debit" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Debit">debiting</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> one or more accounts and </span><a href="http://en.wikipedia.org/wiki/Debits_and_credits" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Debits and credits">crediting</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> another one or more accounts with the same total amount. </span><br />
<i><b><span style="color: #741b47;"><br /></span></b></i>
<i><b><span style="color: #741b47;">Multiple Journal (MJ)</span></b></i><br />
Used to update the project ledger and simultaneously the affected module.<br />
Also used to add expenses or to transfer expenses into Project Costing Ledger.<br />
<br />
<i><b><span style="color: #741b47;">Multi Ledger Journal</span></b></i><br />
Used to update Project Ledger by type of ledger e.g Cash, Actual, Commitment.<br />
<br />
<i><b><span style="color: #741b47;">Account Receivable (AR)</span></b></i><br />
Payment received by company for debtor's invoice issued.<br />
<br />
<i><b><span style="color: #741b47;">Account Payable (AP)</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Also known as Creditors; </span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">is money owed by a business to its suppliers and shown on its Balance Sheet as a liability.</span><br />
<br />
<i><b><span style="color: #741b47;">Invoice</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A </span><a href="http://en.wikipedia.org/wiki/Commerce" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Commerce">commercial</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> document issued by a </span><a href="http://en.wikipedia.org/wiki/Sales" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Sales">seller</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> to the </span><a href="http://en.wikipedia.org/wiki/Buyer" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Buyer">buyer</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, indicating the </span><a href="http://en.wikipedia.org/wiki/Product_(business)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Product (business)">products</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, quantities, and agreed </span><a href="http://en.wikipedia.org/wiki/Price" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Price">prices</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> for products or </span><a href="http://en.wikipedia.org/wiki/Service_(economics)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Service (economics)">services</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> the seller has provided the buyer</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<i><b><span style="color: #741b47;">Account</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A financial statement; </span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">a formal record of the financial activities of a business, person, or other entity.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<i><b><span style="color: #741b47;">Debit</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A financial transaction in which one person withdraws funds from another person's bank account.<br />OR</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Its a f</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">undamental aspects of every </span><a href="http://en.wikipedia.org/wiki/Financial_transaction" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Financial transaction">financial transaction</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> in the </span><a href="http://en.wikipedia.org/wiki/Double-entry_bookkeeping_system" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Double-entry bookkeeping system">double-entry bookkeeping system</a>. <span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Every debit transaction must have a corresponding credit transaction(s).</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">"Dr" (Debit) means left side of a ledger account.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<i><b><span style="color: #741b47;">Credit</span></b></i><br />
<span style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: x-small; line-height: 16px;">A contractual agreement in which a borrower receives something of value now and agrees to repay the lender at some later date.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">OR</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Its a f</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">undamental aspects of every </span><a href="http://en.wikipedia.org/wiki/Financial_transaction" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Financial transaction">financial transaction</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> in the </span><a href="http://en.wikipedia.org/wiki/Double-entry_bookkeeping_system" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Double-entry bookkeeping system">double-entry bookkeeping system</a>. <span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Every credit transaction must have a corresponding debit transaction(s).</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">"Cr" (Debit) means right side of a ledger account.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<br />
<i><b><span style="color: #741b47;">Cash</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Refers to </span><a href="http://en.wikipedia.org/wiki/Money" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Money">money</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> in the physical form of currency.<br />OR</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">In </span><a href="http://en.wikipedia.org/wiki/Bookkeeping" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Bookkeeping">bookkeeping</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> and </span><a href="http://en.wikipedia.org/wiki/Finance" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Finance">finance</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, cash refers to </span><a href="http://en.wikipedia.org/wiki/Current_asset" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Current asset">current assets</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> comprising currency or currency equivalents that can be accessed immediately or near-immediately.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<i><b><span style="color: #741b47;">Cash Book</span></b></i><br />
<span style="color: #111111; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: x-small;">A financial journal that contains all cash receipts and payments, including bank deposits and withdrawals. Entries in the cash book are then posted into the general ledger. The cash book is periodically reconciled with the bank statements as an internal method of auditing. </span></span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;">Budget</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Budget is a financial plan and a list of all planned expenses and revenues. It is a plan for saving, borrowing and spending.</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> </span><a href="http://en.wikipedia.org/wiki/Currency" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Currency"></a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"></span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"></span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"></span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;">Purchase Requisition (PR)</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A purchase requisition is a request sent to the purchasing department to procure goods or services. It is originated and approved by the department requiring the goods or services.</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;">Purchase Order (PO)</span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br />PO </span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">is a </span><a href="http://en.wikipedia.org/wiki/Trade" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Trade">commercial</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> document issued by a </span><a href="http://en.wikipedia.org/wiki/Buyer" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Buyer">buyer</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> to a </span><a href="http://en.wikipedia.org/wiki/Vendor_(supply_chain)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Vendor (supply chain)">seller</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, indicating types, quantities, and agreed prices for products or services the seller will provide to the buyer.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;">Procurement Process(Perolehan)</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Procurement defines as the act of buying goods and services for the government.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Procurement may also involve a </span><a href="http://en.wikipedia.org/wiki/Bidding" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Bidding">bidding</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> process i.e.,Tendering. </span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;"><br /></span></b></i><br />
<i><b><span style="color: #741b47;">Chart Of Accounts(COA)</span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">COA</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is a created list of the </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Nominal_ledger" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Nominal ledger">accounts</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> used by a </span><a href="http://en.wikipedia.org/wiki/Business_entity" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Business entity">business entity</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> to define each class of items for which money or the equivalent is spent or received. It is used to organize the finances of the entity and to segregate expenditures, revenue, assets and liabilities in order to give interested parties a better understanding of the financial health of the entity.</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;"><br /></span></b></i><br />
<i><b><span style="color: #741b47;">Standard Chart Of Accounts</span></b></i><br />
<div style="text-align: justify;">
<span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;">In accounting, a standard </span><a class="pagelink" href="http://www.wikicfo.com/Wiki/Chart-of-Accounts-COA.ashx" style="background-color: white; color: #555555; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px; text-decoration: none;" title="Chart of Accounts (COA)">chart of accounts</a><span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;"> is a numbered list of the accounts that comprise a company’s general ledger. The company chart of accounts is basically a filing system for categorizing all of a company’s accounts and classifying all transactions according to the accounts they affect. The chart of accounts list of categories may include </span><a class="pagelink" href="http://www.wikicfo.com/Wiki/Accounting%20Asset%20Definition.ashx" style="background-color: white; color: #555555; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px; text-decoration: none;" title="Accounting Asset Definition">assets</a><span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;">, liabilities, </span><a class="pagelink" href="http://www.wikicfo.com/Wiki/Owner%e2%80%99s%20Equity.ashx" style="background-color: white; color: #555555; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px; text-decoration: none;" title="Owner’s Equity">owners' equity</a><span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;">, revenues, cost of goods sold, </span><a class="pagelink" href="http://www.wikicfo.com/Wiki/Administration%20Expenses.ashx" style="background-color: white; color: #555555; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px; text-decoration: none;" title="Administration Expenses">operating expenses</a><span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;">, and other relevant accounts. </span></div>
<i><b><span style="color: #741b47;"><br /></span></b></i>
<i><b><span style="color: #741b47;">Assets</span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Assets</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> are economic resources.</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<i><b><span style="color: #741b47;"></span></b></i><br />
<div style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; margin-bottom: 0.5em; margin-top: 0.4em;">
The <a href="http://en.wikipedia.org/wiki/Accounting_equation" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Accounting equation">accounting equation</a> relates assets, liabilities, and <a class="mw-redirect" href="http://en.wikipedia.org/wiki/Ownership_equity" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Ownership equity">owner's equity</a>:</div>
<dl style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; margin-bottom: 0.5em; margin-top: 0.2em;"><dd style="line-height: 1.5em; margin-bottom: 0.1em; margin-left: 1.6em; margin-right: 0px;">Assets = Liabilities + Stockholder's Equity (Owner's Equity)</dd><dd style="line-height: 1.5em; margin-bottom: 0.1em; margin-left: 1.6em; margin-right: 0px;">Assets = liabilities + Capital</dd><dd style="line-height: 1.5em; margin-bottom: 0.1em; margin-left: 1.6em; margin-right: 0px;">liabilities = Assets - Capital</dd><dd style="line-height: 1.5em; margin-bottom: 0.1em; margin-left: 1.6em; margin-right: 0px;">Capital = Assets - liabilities</dd></dl>
<i><b><span style="color: #741b47;"></span></b></i><i><b><span style="color: #741b47;"></span></b></i><i><b><span style="color: #741b47;"></span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;">Current Assets</span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Current assets are cash and other assets expected to be converted to cash or consumed either in a year or in the operating cycle (whichever is longer), without disturbing the normal operations of a business. These assets are continually turned over in the course of a business during normal business activity. There are 5 major items included into current assets:</span><br />
<br />
<ul>
<li><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><a href="http://en.wikipedia.org/wiki/Cash_and_cash_equivalents" style="background-image: none; color: #0b0080;" title="Cash and cash equivalents">Cash and cash equivalents</a></b></li>
<li><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><a href="http://en.wikipedia.org/wiki/Investment" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Investment">Short-term investments</a></b></li>
<li><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Receivable" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Receivable">Receivables</a></b></li>
<li><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><a href="http://en.wikipedia.org/wiki/Inventory" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Inventory">Inventory</a></b></li>
<li><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Prepaid_expense" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Prepaid expense">Prepaid expenses</a></b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> </span></li>
</ul>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">read more:</span><a href="http://en.wikipedia.org/wiki/Asset#Assets_in_accounting">http://en.wikipedia.org/wiki/Asset#Assets_in_accounting</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;"><br />Fixed Assets</span></b></i><br />
<span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;">A fixed asset is a long-term tangible asset. Fixed assets are also called non-current assets, long-term assets, or property, plant and equipment (PP&E). </span><span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;">Fixed assets are often large and illiquid physical </span><a class="pagelink" href="http://www.wikicfo.com/Wiki/Accounting%20Asset%20Definition.ashx" style="background-color: white; color: #555555; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px; text-decoration: none;" title="Accounting Asset Definition">assets</a><span style="background-color: white; font-family: Tahoma, Arial, Helvetica, sans-serif; font-size: 12px;"> that are important to a company’s core business operations. </span><i><b><span style="color: #741b47;"><br /><br /><br />Trial Balance</span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">trial balance</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is a list of all the General ledger accounts (both revenue and capital) contained in the ledger of a business. This list will contain the name of the nominal ledger account and the value of that nominal ledger account. The value of the nominal ledger will hold either a debit balance value or a credit balance value. The debit balance values will be listed in the </span><a href="http://en.wikipedia.org/wiki/Debits_and_credits" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Debits and credits">debit</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> column of the trial balance and the </span><a href="http://en.wikipedia.org/wiki/Debits_and_credits" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Debits and credits">credit</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> value balance will be listed in the credit column.</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<br />
<i><b><span style="color: #741b47;">Balance Sheet</span></b></i><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">In </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Financial_accounting" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Financial accounting">financial accounting</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, a </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">balance sheet</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> or </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">statement of financial position</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is a summary of the financial balances of a </span><a href="http://en.wikipedia.org/wiki/Sole_proprietorship" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Sole proprietorship">sole proprietorship</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, a </span><a href="http://en.wikipedia.org/wiki/Partnership" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Partnership">business partnership</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, a </span><a href="http://en.wikipedia.org/wiki/Corporation" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Corporation">corporation</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> or other business organization, such as an </span><a href="http://en.wikipedia.org/wiki/Limited_liability_company" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Limited liability company">LLC</a>(Limited Liability Company)<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> or an </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/LLP" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="LLP">LLP</a>(Limited Liability Partnership).<br />
<i><b><span style="color: #741b47;"></span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;">Bank Reconciliation</span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Bank reconciliation</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is a process that explains the difference between the bank balance shown in an organization's</span><a href="http://en.wikipedia.org/wiki/Bank_statement" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Bank statement">bank statement</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, as supplied by the bank, and the corresponding amount shown in the organization's own </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Accounting" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Accounting">accounting</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">records at a particular point in time.</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><i><b><span style="color: #741b47;">Financial Transaction</span></b></i><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">financial transaction</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is an </span><a href="http://en.wikipedia.org/wiki/Contract" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Contract">agreement</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, </span><a href="http://en.wikipedia.org/wiki/Communication" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Communication">communication</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, or movement carried out between a </span><a href="http://en.wikipedia.org/wiki/Buyer" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Buyer">buyer</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> and a </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Seller" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Seller">seller</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> to exchange an </span><a href="http://en.wikipedia.org/wiki/Asset" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Asset">asset</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> for </span><a href="http://en.wikipedia.org/wiki/Payment" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Payment">payment</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">.</span><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<br />
<b><i><span style="color: #741b47;">Asset Disposal</span></i></b><br />
Asset disposal is the act of selling an asset usually a long term asset that has been depreciated over its useful life like production equipment.<br />
<br />
<span style="color: #741b47;"><b><i>Investment</i></b></span><br />
<span style="color: #111111; font-family: Verdana, Geneva, sans-serif; font-size: 13px;">An asset or item that is purchased with the hope that it will generate income or appreciate in the future. In an economic sense, an investment is the purchase of goods that are not consumed today but are used in the future to create wealth.</span><br />
<br />
<b style="color: #741b47;"><i>Loan</i></b><br />
<span style="color: #111111; font-family: Verdana, Geneva, sans-serif; font-size: 13px;">The act of giving money, property or other material goods to a another party in exchange for future repayment of the principal amount along with interest or other finance charges. A loan may be for a specific, one-time amount or can be available as open-ended credit up to a specified ceiling amount.</span><br />
<br />
<b style="color: #741b47;"><i>Lease</i></b><br />
<span style="color: #111111; font-family: Verdana, Geneva, sans-serif; font-size: 13px;">An agreement in which one party gains a long-term rental agreement, and the other party receives a form of secured long-term debt.</span><br />
<br />
<b style="color: #741b47;"><i>Sales</i></b><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Sales is the act of </span><a href="http://en.wikipedia.org/wiki/Selling" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Selling">selling</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> a product or service in return for money or other compensation.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span><b style="color: #741b47;"><i>Orders</i></b><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Is an instruction from a customer to buy things.</span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<b style="color: #741b47;"><i>Customer</i></b><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">Is also known as a </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">client</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">buyer</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, or </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">purchaser</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">) is the recipient of a </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Goods_(economics)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Goods (economics)">good</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, </span><a href="http://en.wikipedia.org/wiki/Service_(economics)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Service (economics)">service</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, </span><a href="http://en.wikipedia.org/wiki/Product_(business)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Product (business)">product</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, or idea, obtained from a </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Seller" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Seller">seller</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Vendor" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Vendor">vendor</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">, or </span><a href="http://en.wikipedia.org/wiki/Distribution_(business)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Distribution (business)">supplier</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">for a monetary or other valuable consideration.</span><br />
<b style="color: #741b47;"><i><br /></i></b>
<b style="color: #741b47;"><i>Shareholder</i></b><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">A </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">shareholder</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> or </span><b style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">stockholder</b><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> is an </span><a href="http://en.wikipedia.org/wiki/Individual" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Individual">individual</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> or institution (including a </span><a href="http://en.wikipedia.org/wiki/Corporation" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Corporation">corporation</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">) that legally owns a </span><a href="http://en.wikipedia.org/wiki/Share_(finance)" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Share (finance)">share</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> of </span><a href="http://en.wikipedia.org/wiki/Stock" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Stock">stock</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> in a </span><a href="http://en.wikipedia.org/wiki/Public_company" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Public company">public</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"> or </span><a class="mw-redirect" href="http://en.wikipedia.org/wiki/Private_corporation" style="background-color: white; background-image: none; color: #0b0080; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; text-decoration: none;" title="Private corporation">private corporation</a><span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;">. Stockholders are granted special privileges depending on the class of stock. </span><br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>
<b style="color: #741b47;"><i>Audit Kewangan (Finance Audit)</i></b><br />
<br />
<div style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; margin-bottom: 0.5em; margin-top: 0.4em;">
<b>Audit kewangan</b>, atau lebih tepat dinamakan <b>audit pada penyata kewangan</b>, adalah pemeriksaan penyata kewangan sesebuah syarikat atau organisasi lain oleh parti ketiga yang berpendirian tidak berat sebelah, lalu menghasilkan <i>pendapat bebas</i> mengenai sama ada penyata kewangan adalah relevan, tepat dan lengkap.</div>
<div style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px; margin-bottom: 0.5em; margin-top: 0.4em;">
Audit kewangan biasanya diamalkan oleh firma-firma akauntan, kerana pengetahuan laporan kewangan khusus yang diperlukannya. Audit kewangan merupakan salah satu daripada pelbagai fungsi <i>jaminan </i>atau <i>perbahasan</i> yang disumbangkan oleh firma <a href="http://ms.wikipedia.org/wiki/Perakaunan" style="background-image: none; background-position: initial initial; background-repeat: initial initial; color: #0b0080; text-decoration: none;" title="Perakaunan">perakaunan</a>, yang mana firma tersebut menyumbangkan pendapat bebas mengenai maklumat yang diterbitkan kepada umum.</div>
<br />
<span style="background-color: white; font-family: sans-serif; font-size: 13px; line-height: 19.200000762939453px;"><br /></span>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-4999477317987751114.post-30398815519639475022012-10-18T20:53:00.003-07:002012-10-18T20:53:56.571-07:00MySQL: Grant mssql user in mssql dbCopy from : <a href="http://techovdoom.blogspot.com/2012/06/grant-mssql-user-in-mssql-db.html">http://techovdoom.blogspot.com/2012/06/grant-mssql-user-in-mssql-db.html</a><br />
<br />
Thanks John.<br />
<br />
Configuring user permissions for Microsoft SQL Server
<br />
Microsoft SQL Server defines SQL Server Agent roles that govern accessibility of the job framework. The SQL Server Agent jobs are stored in the SQL Server msdb database.<br />
<br />
<div class="B-Body">
To install Websense Log Server successfully, the user account that owns the Websense database must have membership in one of the following roles in the msdb database: </div>
<div class="B1-Bullet1_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="B1-Bullet1_inner" style="white-space: nowrap; width: 18pt;">
<img alt="*" border="0" height="11" src="http://www.websense.com/content/support/library/web/v75/triton_web_help/b1.jpg" width="11" />
</div>
</td>
<td width="100%"><div class="B1-Bullet1_inner">
SQLAgentUserRole</div>
</td>
</tr>
</tbody></table>
</div>
<div class="B1-Bullet1_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="B1-Bullet1_inner" style="white-space: nowrap; width: 18pt;">
<img alt="*" border="0" height="11" src="http://www.websense.com/content/support/library/web/v75/triton_web_help/b1.jpg" width="11" />
</div>
</td>
<td width="100%"><div class="B1-Bullet1_inner">
SQLAgentReader Role</div>
</td>
</tr>
</tbody></table>
</div>
<div class="B1-Bullet1_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="B1-Bullet1_inner" style="white-space: nowrap; width: 18pt;">
<img alt="*" border="0" height="11" src="http://www.websense.com/content/support/library/web/v75/triton_web_help/b1.jpg" width="11" />
</div>
</td>
<td width="100%"><div class="B1-Bullet1_inner">
SQLAgentOperator Role<br /></div>
<div class="B1-Bullet1_inner">
</div>
<div class="B1-Bullet1_inner">
<a href="http://www.blogger.com/blogger.g?blogID=4999477317987751114" name="more"></a></div>
</td>
</tr>
</tbody></table>
</div>
<div class="B-Body">
The SQL user account must also be a member of the <span class="B-Bold">dbcreator</span> fixed server role.</div>
<div class="B-Body">
Use Microsoft SQL Server Management Studio to grant the database user account the necessary permissions to successfully install Log Server.</div>
<div class="S-Step_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="S-Step_inner" style="white-space: nowrap; width: 18pt;">
<span class="SN-StepNum">1. </span>
</div>
</td>
<td width="100%"><div class="S-Step_inner">
On the SQL Server machine, go to <span class="B-Bold">Start</span><span class="B-Bold"> </span><span class="B-Bold">> Programs</span><span class="B-Bold"> </span><span class="B-Bold">> Microsoft SQL Server </span><span class="B-Bold">2005</span> or <span class="B-Bold">2008</span><span class="B-Bold"> </span><span class="B-Bold">> Microsoft SQL Server Management Studio</span>.</div>
</td>
</tr>
</tbody></table>
</div>
<div class="S-Step_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="S-Step_inner" style="white-space: nowrap; width: 18pt;">
<span class="SN-StepNum">2. </span>
</div>
</td>
<td width="100%"><div class="S-Step_inner">
Select the <span class="B-Bold">Object Explorer</span> tree, and then go to select <span class="B-Bold">Security</span><span class="B-Bold"> </span><span class="B-Bold">> Logins</span>.</div>
</td>
</tr>
</tbody></table>
</div>
<div class="S-Step_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="S-Step_inner" style="white-space: nowrap; width: 18pt;">
<span class="SN-StepNum">3. </span>
</div>
</td>
<td width="100%"><div class="S-Step_inner">
Select the login account to be used during the installation.</div>
</td>
</tr>
</tbody></table>
</div>
<div class="S-Step_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="S-Step_inner" style="white-space: nowrap; width: 18pt;">
<span class="SN-StepNum">4. </span>
</div>
</td>
<td width="100%"><div class="S-Step_inner">
Right-click the login account and select <span class="B-Bold">Properties</span> for this user.</div>
</td>
</tr>
</tbody></table>
</div>
<div class="S-Step_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="S-Step_inner" style="white-space: nowrap; width: 18pt;">
<span class="SN-StepNum">5. </span>
</div>
</td>
<td width="100%"><div class="S-Step_inner">
Select<span class="B-Bold"> User Mapping</span> and do the following:</div>
</td>
</tr>
</tbody></table>
</div>
<div class="SA-StepAlpha_outer" style="margin-left: 18pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="SA-StepAlpha_inner" style="white-space: nowrap; width: 18pt;">
<span class="SA-StepAlpha">a. </span>
</div>
</td>
<td width="100%"><div class="SA-StepAlpha_inner">
Select <span class="B-Bold">msdb</span> in database mapping.</div>
</td>
</tr>
</tbody></table>
</div>
<div class="SA-StepAlpha_outer" style="margin-left: 18pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="SA-StepAlpha_inner" style="white-space: nowrap; width: 18pt;">
<span class="SA-StepAlpha">b. </span>
</div>
</td>
<td width="100%"><div class="SA-StepAlpha_inner">
Grant membership to one of these roles:</div>
</td>
</tr>
</tbody></table>
</div>
<div class="B3-Bullet3_outer" style="margin-left: 36pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="B3-Bullet3_inner" style="white-space: nowrap; width: 18pt;">
<img alt="*" border="0" height="16" src="http://www.websense.com/content/support/library/web/v75/triton_web_help/b3.jpg" width="16" />
</div>
</td>
<td width="100%"><div class="B3-Bullet3_inner">
SQLAgentUserRole</div>
</td>
</tr>
</tbody></table>
</div>
<div class="B3-Bullet3_outer" style="margin-left: 36pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="B3-Bullet3_inner" style="white-space: nowrap; width: 18pt;">
<img alt="*" border="0" height="16" src="http://www.websense.com/content/support/library/web/v75/triton_web_help/b3.jpg" width="16" />
</div>
</td>
<td width="100%"><div class="B3-Bullet3_inner">
SQLAgentReader Role</div>
</td>
</tr>
</tbody></table>
</div>
<div class="B3-Bullet3_outer" style="margin-left: 36pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="B3-Bullet3_inner" style="white-space: nowrap; width: 18pt;">
<img alt="*" border="0" height="16" src="http://www.websense.com/content/support/library/web/v75/triton_web_help/b3.jpg" width="16" />
</div>
</td>
<td width="100%"><div class="B3-Bullet3_inner">
SQLAgentOperator Role</div>
</td>
</tr>
</tbody></table>
</div>
<div class="SA-StepAlpha_outer" style="margin-left: 18pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="SA-StepAlpha_inner" style="white-space: nowrap; width: 18pt;">
<span class="SA-StepAlpha">c. </span>
</div>
</td>
<td width="100%"><div class="SA-StepAlpha_inner">
Click <span class="B-Bold">OK</span> to save your changes.<br /></div>
</td>
</tr>
</tbody></table>
</div>
<div class="S-Step_outer" style="margin-left: 0pt;">
<table border="0" cellpadding="0" cellspacing="0" summary="">
<tbody>
<tr style="vertical-align: baseline;">
<td><div class="S-Step_inner" style="white-space: nowrap; width: 18pt;">
<span class="SN-StepNum">6. </span>
</div>
</td>
<td width="100%"><div class="S-Step_inner">
Select <span class="B-Bold">Server Roles</span>, and then select <span class="B-Bold">dbcreator</span>. The dbcreator role is created.</div>
</td>
</tr>
</tbody></table>
</div>
<table border="0" cellpadding="0" cellspacing="0" summary=""><tbody>
<tr style="vertical-align: baseline;"><td><div class="S-Step_inner" style="white-space: nowrap; width: 18pt;">
<span class="SN-StepNum">7. </span>
</div>
</td>
<td width="100%"><div class="S-Step_inner">
Click <span class="B-Bold">OK</span> to save your changes.</div>
<div class="S-Step_inner">
</div>
<div class="S-Step_inner">
thanks to <a href="http://www.websense.com/">http://www.websense.com</a></div>
</td></tr>
</tbody></table>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-25558308052528706472012-10-16T23:45:00.005-07:002012-10-16T23:46:15.339-07:00What A New World: Financial Management System Solution (FMSS)Back to application world<br />
Explore some of finance terms.... :)<br />
<br />
<ul>
<li>General Ledger - GL</li>
<li>Cash Management/ Cash Book - CB</li>
<li>Accounts Payable - AP</li>
<li>Accounts Receivable - AR</li>
<li>Purchasing - PU</li>
<li>Budgetary Management - BC<br />- Budgetary Control<br />- Budgetary Preparation</li>
<li>Project Costing - PC</li>
<li>Asset Management - FA</li>
<li>Excel Plug-in Reporting Tool<br /><br />Apakah? </li>
</ul>
<br />
<span style="background-color: white; color: #666666; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; line-height: 18px;">.</span>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-4999477317987751114.post-88844179829097332912012-09-25T21:11:00.002-07:002012-09-25T21:11:39.064-07:00Ubuntu: Install & Configure Backuppc** For Backup Data in Ubuntu Server, Need to mount new volume/hd first to locate the backup files.<br />
<br />
<br />
<ol>
<li>Add New Volume or Hard disk to backup server.</li>
<li>SSH to the server using putty.exe</li>
<li>Reboot server<br />#reboot</li>
<li>SSH again and run <br />#fdisk -l<br /></li>
<li>Run command<br /> # mkfs.ext3 /dev/sdh<br /> # df -h<br /> # cd /mnt/<br /> # mkdir backup<br /> # chown -R backuppc:backuppc<br /></li>
<li>Mount new volume/hd to backup<br /> # mount /dev/sdh backup/<br /> # df -h<br />*To check if the volume mount to backup/</li>
</ol>
<div>
<b><u><span style="color: #990000;">BACKUPPC INSTALLATION</span></u></b></div>
<div>
<br /></div>
<div>
<ol></ol>
1. Verifying that your server’s time and date are correct<br /><ol></ol>
# date<br /><ol></ol>
Thu Sep 20 03:48:04 UTC 2012<br /><ol></ol>
<br /><ol></ol>
2. Update & upgrade ubuntu(if needed)<br /><ol></ol>
# sudo apt-get update && sudo apt-get upgrade<br /><ol></ol>
<br /><ol></ol>
3. Install backuppc<br /><ol></ol>
# sudo apt-get install backuppc<br /><ol></ol>
<br /><ol></ol>
4. By default config file located here:<br /><ol></ol>
# nano /etc/backuppc/config.pl<br /><ol></ol>
<br /><ol></ol>
5. Copy backuppc root dir ke /mnt/backup/<br /><ol></ol>
# cd /var/lib/backuppc<br /><ol></ol>
# cp -Rp /var/lib/backuppc /mnt/backup/<br /><ol></ol>
<br /><ol></ol>
6. Backup & Edit config.pl<br /><ol></ol>
# cd /etc/backuppc/<br /><ol></ol>
# cp config.pl config.pl.ORI<br /><ol></ol>
# nano /etc/backuppc/config.pl<br /><ol></ol>
<br /><ol></ol>
7. Change $Conf{TopDir}<br /><ol></ol>
$Conf{TopDir} = '/mnt/backup/backuppc';<br /><ol></ol>
<br /><ol></ol>
8. Restart service backuppc<br /><ol></ol>
# /etc/init.d/backuppc restart<br /><ol></ol>
<br /><ol></ol>
9. Open from browser<br /><ol></ol>
http://yourdomain.com/backuppc<br /> login & start config.</div>
<div>
<br /></div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-34585444482237305262012-09-25T21:00:00.004-07:002012-09-25T21:00:46.484-07:00Hyper V 2012: Can’t delete Virtual MachineIssue: Try to import new CRM2011 machine to Hyper V, some problem occur. But the VM can't be deleted.<br />
<br />
<span style="background-color: white; color: #3b3b3b; font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22.700000762939453px;">There are many reasons why your VM is no longer needed such as you’ve moved to another farm or you simply don’t need the virtual machine. </span><br />
<h3 style="background-color: white; color: #3b3b3b; font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 1.15em; line-height: 18px;">
Delete Fails in MMC & Hyper-V-VMMS Source Errors in Event Viewer</h3>
<div style="background-color: white; color: #3b3b3b; font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
You’ve noticed a “straggler” left behind in your SCVMM console and you attempt to delete it and VMM says no thank you. You can’t repair (which you expected since the files are gone, etc.) nor can you force it to delete. But error message appear.<br /><br /><span style="font-size: 15px; line-height: 22.700000762939453px;">View the Event Viewer (Custom Views –> Roles –> Hyper-V.) You immediately notice a lot of errors similar to the following for the VM you are attempting to delete</span>
</div>
<div style="background-color: white; color: #3b3b3b; font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
</div>
<div style="font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
<b>Clean Up</b><br />To resolve this problem, do the following:</div>
<ol style="font-size: 15px; line-height: 22.700000762939453px;">
<li>Connect to your Hyper-V Server</li>
<li>Open Windows Explorer</li>
<li>Open the path %systemroot%\ProgramData\Microsoft\Windows\Hyper-V\Virtual Machines (<a href="http://support.microsoft.com/kb/309531" style="color: #0066cc; outline: none; text-decoration: none;" target="_blank">NOTE: This is a hidden folder and requires Operating System files to be displayed</a>)</li>
<li>You will notice a set of XML documents, one for each Virtual Machine on this host. locate the one with the same matching GUID from your event viewer message as outlined below -<br /><br /><a href="http://2.bp.blogspot.com/-fdcU0N9fNzc/UGJ83nRAmII/AAAAAAAABo8/fH0VJQkeaiE/s1600/hpv1.png" imageanchor="1" style="font-size: medium; line-height: normal; margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="http://2.bp.blogspot.com/-fdcU0N9fNzc/UGJ83nRAmII/AAAAAAAABo8/fH0VJQkeaiE/s1600/hpv1.png" /></a><br /></li>
<li>Right-click on the XML file with the same GUID, and select delete</li>
<li>Close Windows Explorer</li>
<li>Open Hyper-V MMC console</li>
<li>Notice that the virtual machine is gone…</li>
</ol>
<div>
<h3 style="font-size: 1.15em; line-height: 18px;">
Cleaning up Virtual Machine Manager</h3>
<div style="font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
VMM will almost instantly determine that this virtual machine is now missing and you can do the famous delete and it will succeed.</div>
<div style="font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
<a href="http://4.bp.blogspot.com/-2WF42EKskf8/UGJ85oy8lhI/AAAAAAAABpE/pFn5JL_kpv4/s1600/hpv2.png" imageanchor="1" style="font-size: medium; line-height: normal; margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="http://4.bp.blogspot.com/-2WF42EKskf8/UGJ85oy8lhI/AAAAAAAABpE/pFn5JL_kpv4/s1600/hpv2.png" /></a></div>
<div style="font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
<span style="background-color: white; color: #3b3b3b; font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22.700000762939453px;">Simply right-click and select delete. Finish.</span> </div>
<div style="font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
Thanks to <a href="http://blogs.technet.com/">http://blogs.technet.com</a><span style="font-size: 15px; line-height: 22.700000762939453px;">.</span></div>
<div style="font-size: 15px; line-height: 22.700000762939453px; margin-top: 12px;">
<br /></div>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-49576371879377635122012-09-13T00:30:00.003-07:002012-09-17T19:02:45.183-07:00UBUNTU: OPENLDAP INSTALLATION on UBUNTU SERVER<br />
LDAP INSTALLATION ON UBUNTU SERVER<br />
----------------------------------<br />
<br />
Login to ubuntu server as root<br />
<br />
1. Run update<br />
# apt-get update<br />
<br />
2. Install ldap<br />
# apt-get install slapd ldap-utils<br />
<br />
3. Create Administrator password<br />
Password: XXXXXX<br />
Confirm Password: XXXXXX<br />
<br />
4. Change/Edit ldap.conf<br />
# cd /etc/ldap/<br />
# nano ldap.conf<br />
<br />
5. Add this 2 line:<br />
BASE dc=staff,dc=domain,dc=com,dc=my<br />
URI ldap://localhost<br />
<br />
<br />
6. Copy ldap.sh dari existing ldap server student ke staff server<br />
# cd /root/<br />
# scp name@www.mediu.edu.my:ldap.sh ./<br />
<br />
7. #nano ldap.sh<br />
<br />
Change passwd and first dc for staff<br />
passwd=XXXXXX<br />
dc1=staff<br />
dc2=domain<br />
dc3=com<br />
dc4=my<br />
<br />
Save<br />
<br />
8. Run script<br />
#sh ldap.sh<br />
<br />
**If ldap ON<br />
# ldapadd -x -D cn=admin,dc=staff,dc=domain,dc=com,dc=my -W -f /tmp/database.ldif<br />
<br />
** This script can be found in last line inside ldap.sh file. It will add the new schema to the<br />
<br />
**If ldap STOP/OFF<br />
# slapadd -x -D cn=admin,dc=staff,dc=domain,dc=com,dc=my -W -f /tmp/database.ldif<br />
<br />
9. Check Database<br />
# more /tmp/database.ldif<br />
<br />
10.Run slapcat<br />
# slapcat<br />
<br />
11.If tak jadi, run dpkg-reconfigure slapd<br />
# dpkg-reconfigure slapd<br />
<br />
12. Restart ldap<br />
# /etc/init.d/slapd restart<br />
<br />
13. #slapcat<br />
#more /tmp/database.ldif<br />
<br />
14. Add User in ldap<br />
# pico t<br />
** Copy add user section from ldap.sh paste here:<br />
<br />
#Adding user<br />
dn: uid=ldap1,ou=people,dc=staff,dc=domain,dc=com,dc=my<br />
objectClass: inetOrgPerson<br />
objectClass: posixAccount<br />
objectClass: shadowAccount<br />
uid: ldap1<br />
sn: Asdasd<br />
givenName: ldap1<br />
cn: ldap1 Asdasd<br />
displayName: ldap1 asdasd<br />
uidNumber: 1002<br />
gidNumber: 1000<br />
userPassword: $hash_pw<br />
gecos: ldap1 asdasd<br />
loginShell: /bin/bash<br />
homeDirectory: /home/ldap1<br />
shadowExpire: -1<br />
shadowFlag: 0<br />
shadowWarning: 7<br />
shadowMin: 8<br />
shadowMax: 999999<br />
shadowLastChange: 10877<br />
mail: aw@$dc1.$dc2<br />
postalCode: 31000<br />
l: Mysity<br />
o: $dc1<br />
mobile: +33 (0)6 22 22 22 22 22<br />
homePhone: +33 (0)5 33 22 33 22<br />
title: System Administrator<br />
postalAddress:<br />
initials: LP<br />
<br />
Save<br />
<br />
15. Create $hash password<br />
# slappasswd<br />
New password; ####<br />
Confirm new password: ####<br />
<br />
{SSHA}zQgJa0DFgsUa2Myd3z8Z08SsWOaOgkAS<br />
<br />
Copy SSHA password and copy in pico t<br />
-------------------------------------------------------------<br />
dn: uid=ldap1,ou=people,dc=staff,dc=domain,dc=com,dc=my<br />
objectClass: inetOrgPerson<br />
objectClass: posixAccount<br />
objectClass: shadowAccount<br />
uid: ldap1<br />
sn: Asdasd<br />
givenName: ldap1<br />
cn: ldap1 Asdasd<br />
displayName: ldap1 asdasd<br />
uidNumber: 1002<br />
gidNumber: 1000<br />
userPassword: {SSHA}zQgJa0DFgsUa2Myd3z8Z08SsWOaOgkAS<br />
gecos: ldap1 asdasd<br />
loginShell: /bin/bash<br />
homeDirectory: /home/ldap1<br />
shadowExpire: -1<br />
shadowFlag: 0<br />
shadowWarning: 7<br />
shadowMin: 8<br />
shadowMax: 999999<br />
shadowLastChange: 10877<br />
mail: aw@$dc1.$dc2<br />
postalCode: 31000<br />
l: Mysity<br />
o: $dc1<br />
mobile: +33 (0)6 22 22 22 22 22<br />
homePhone: +33 (0)5 33 22 33 22<br />
title: System Administrator<br />
postalAddress:<br />
initials: LP<br />
---------------------------------------------------------------<br />
<br />
Save<br />
<br />
16.Then run script:<br />
# slapadd -l t<br />
# more /tmp/database.ldif<br />
# slapcat<br />
<br />
17.Command to start & stop ldap<br />
<br />
# /etc/init.d/slapd stop<br />
# /etc/init.d/slapd start<br />
<br />
18.Search ldap info<br />
# ldapsearch -x<br />
<br />
Reference site:<br />
<a href="https://help.ubuntu.com/11.04/serverguide/openldap-server.html">https://help.ubuntu.com/11.04/serverguide/openldap-server.html</a><br />
<a href="http://www.zarafa.com/wiki/index.php/Zarafa_LDAP_cn_config_How_To">http://www.zarafa.com/wiki/index.php/Zarafa_LDAP_cn_config_How_To</a>
<br />
<br />
<div class="MsoNormal">
<span lang="EN-US"><a href="http://ubuntuforums.org/showthread.php?t=1184288">http://ubuntuforums.org/showthread.php?t=1184288</a><o:p></o:p></span></div>
<br />
<br />
*** If you have existing ldap server running, you might be compared the configuration between two server, old and new one. Good luck!<br />
<br />
Additional command:<br />
------------------<br />
<br />
Check current Ubuntu version<br />
<br />
#cat /etc/issue<br />
Ubuntu 12.04 LTS \n \l<br />
<br />
.<br />
<br />
<br />Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-4999477317987751114.post-53814677690296004902012-09-13T00:13:00.000-07:002012-09-13T00:13:36.047-07:00Liferay: Beginner & OverviewReference:<br />
<br />
<span style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px;">In short, Liferay Portal is more than a development platform, more than a content management system, more than a social network, and more than a set of collaboration tools. It’s the best way to build a web site.</span>
<br />
<a href="http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/lp-6-1-ugen01-using-liferay-portal-as-a-content-management-system-1">http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/lp-6-1-ugen01-using-liferay-portal-as-a-content-management-system-1</a>
<br />
<span style="background-color: white;"><br /><span style="color: #444444; font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 1.4em; line-height: 1.125;">How Can Liferay’s WCM Help You?</span></span></span><br />
<br />
<div style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; margin-bottom: 1.3em; margin-top: 1.3em; padding: 0px;">
With Liferay’s WCM you have the ability to create, edit, stage, publish and approve content with easy to learn yet powerful tools. Liferay’s WCM streamlines the content creation process for end users. It’s much faster to use Liferay’s WCM than it would be to create all the content for your site in HTML. Some ways Liferay WCM makes this possible include:</div>
<ul style="background-color: white; clear: both; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; list-style-image: initial; list-style-position: outside; margin: 0.75em 0px; padding: 0px 0px 0px 2.5em;">
<li style="margin: 0px; padding: 0px;">Once set up, non-technical users can manage the site.</li>
<li style="margin: 0px; padding: 0px;">Liferay’s fine-grained permissions system ensures your content gets to the right users.</li>
<li style="margin: 0px; padding: 0px;">To manage the site, no programming is required.</li>
<li style="margin: 0px; padding: 0px;">Content can be staged.</li>
<li style="margin: 0px; padding: 0px;">Content can be passed through a workflow.</li>
<li style="margin: 0px; padding: 0px;">Content can be published on a schedule.</li>
<li style="margin: 0px; padding: 0px;">WCM is integrated with Liferay’s services so advanced template developers can use them to query for data stored elsewhere in Liferay.</li>
</ul>
<div style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 15px; margin-bottom: 1.3em; margin-top: 1.3em; padding: 0px;">
Once you get familiar with Liferay WCM you’ll wonder how you ever got along without it.</div>
<h3 style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; line-height: 1.125; margin: 1.3em 0px; padding: 0px;">
<a href="http://www.liferay.com/documentation/liferay-portal/6.1/user-guide/-/ai/how-can-liferay-s-wcm-help-yo-2" target="_blank"><span style="font-size: x-small;">Read more</span></a></h3>
Unknownnoreply@blogger.com1