tag:blogger.com,1999:blog-52777762395539631212024-03-14T18:47:23.997+11:00ThinkingDavidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.comBlogger286125tag:blogger.com,1999:blog-5277776239553963121.post-9269385158221697362015-05-21T13:19:00.000+10:002015-05-21T13:19:10.805+10:00Making a round lable//width and height are twice of layer.cornerRadius<br />
<br />
label.frame = CGRectMake(0, 0, 100, 100);<br />
label.center = CGPointMake(160, 240);<br />
label.alpha = 0.0;<br />
<br />
label.layer.cornerRadius = 50;<br />
label.clipsToBounds = YES;Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-13195671217609624472015-04-07T13:00:00.001+10:002015-04-07T13:00:46.956+10:00Composite patternA design pattern that solves this kind of structural problem is<br />
called the Composite patternWith the Composite pattern, we can compose our strokes and dots into a tree structure<br />
so that we can treat each of the nodes uniformly.Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-54954301606850081212015-04-03T15:35:00.003+11:002015-04-03T15:35:49.285+11:00Observation Pattern in Objective-C<div class="p1">
<span style="font-size: large;">There are three steps to using key-value observation:</span></div>
<div class="p1">
<span style="font-size: large;"><br /></span></div>
<div class="p1">
<span style="font-size: large;"><span class="s1">• </span>Send the addObserver:forKeyPath:options:context: message</span></div>
<div class="p1">
<span style="font-size: large;">to each object that is being observed.</span></div>
<div class="p1">
<span style="font-size: large;"><br /></span></div>
<div class="p1">
<span style="font-size: large;"><span class="s1">• </span>Override the method observeValueForKeyPath:ofObject:chan</span></div>
<div class="p1">
<span style="font-size: large;">ge:content: in the class definition of the object that is doing the</span></div>
<div class="p1">
<span style="font-size: large;">observing.</span></div>
<div class="p1">
<span style="font-size: large;"><br /></span></div>
<div class="p1">
<span style="font-size: large;"><span class="s1">• </span>Override the dealloc method and remove the observer reference</span></div>
<br />
<div class="p1">
<span style="font-size: large;">in the class definition of the object that is observing.</span></div>
Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-434040737831921792015-02-12T14:51:00.002+11:002015-02-12T14:53:51.793+11:00The following are some high-level, conceptual questions to develop of Axure• How is information organized and accessed on each screen in the case of Information Architecture?<br />
• Where and how are key task flows initiated and ended?<br />
• What are the main navigation systems?<br />
• What common elements are shared across screens?<br />
• How are common elements affected by a device size?Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-72385023919478046282014-11-04T10:22:00.000+11:002014-11-04T10:26:09.784+11:00 Xampp version on Windows<br /><br /><b>Add this line to xampp\phpmyadmin\config.inc.php</b><br /><br />$cfg['ExecTimeLimit'] = 6000;<br /><br /><b>And Change xampp\php\php.ini to</b><br /><br />post_max_size = 750M <br /><br />upload_max_filesize = 750M <br /><br />max_execution_time = 5000<br /><br />max_input_time = 5000<br /><br />memory_limit = 1000M<br /><br /><b>And change xampp\mysql\bin\my.ini</b><br /><br />max_allowed_packet = 200MDavidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-75755286473044855462014-09-02T11:15:00.000+10:002014-09-02T11:17:36.457+10:00Choosing a data format for Javascript<div>
HTML snippets require very little work to implement. The external data can be loaded</div>
<div>
and inserted into the page with one simple method that does not even require a</div>
<div>
callback function. No traversal of the data is necessary for the straightforward task</div>
<div>
of adding the new HTML into the existing page. On the other hand, the data is not</div>
<div>
necessarily structured in a way that makes it reusable for other applications. The</div>
<div>
external file is tightly coupled with its intended container.</div>
<div>
<br /></div>
<div>
JSON files are structured for simple reuse. They are compact and easy to read. The</div>
<div>
data structure must be traversed to pull out the information and present it on the</div>
<div>
page, but this can be done with standard JavaScript techniques. Since modern</div>
<div>
browsers parse the files natively with a single call to JSON.parse(), reading in a</div>
<div>
JSON file is extremely fast. Errors in the JSON file can cause silent failure or even</div>
<div>
side effects on the page, so the data must be crafted carefully by a trusted party.</div>
<div>
<br /></div>
<div>
JavaScript files offer the ultimate in flexibility, but are not really a data storage</div>
<div>
mechanism. Since the files are language-specific, they cannot be used to provide</div>
<div>
the same information to disparate systems. Instead, the ability to load a JavaScript</div>
<div>
file means that behaviors that are rarely needed can be factored out into external</div>
<div>
files, reducing code size unless and until it is needed.</div>
<div>
<br /></div>
<div>
While XML has fallen out of favor in the JavaScript community, with most developers</div>
<div>
preferring JSON, it is still so common that providing data in this format makes it very</div>
<div>
likely that the data can be reused elsewhere. Indeed, many web services, such as Yahoo</div>
<div>
Weather (http://developer.yahoo.com/weather/), export XML representations</div>
<div>
of their data, which has allowed many interesting mashups of their data to arise. The</div>
<div>
XML format is somewhat bulky, and can be a bit slower to parse and manipulate than</div>
<div>
other options.</div>
Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-4022992039253480362014-08-26T14:12:00.003+10:002014-08-26T14:12:26.125+10:00fadeIn() VS slideDownThe fading animations are very useful for items that are outside the flow of the<br />
document. For example, these are typical effects to apply to "lightbox" elements<br />
that are overlaid on the page. However, when an element is part of the document<br />
flow, calling .fadeIn() on it causes the document to jump to provide the real estate<br />
needed for the new element, which is not always aesthetically pleasing.Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-83829658776897643312014-08-15T15:42:00.001+10:002014-08-26T14:14:18.026+10:00Convert DMG to CDR or ISO with Disk Utilityhdiutil convert /path/imagefile.dmg -format UDTO -o /path/convertedimage.iso<br /><br />hdiutil convert /path/imagefile.cdr -format UDTO -o /path/convertedimage.isoDavidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-31912485995173399902014-08-01T09:55:00.003+10:002014-08-01T09:58:42.374+10:00JavaScript TipsIn JavaScript, functions are objects.<br /><br />Function arguments are the real values received by the function when it is invoked.Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-17623097106851528512013-10-25T11:56:00.002+11:002013-10-25T11:59:05.976+11:00Using a self-signed ssl certificate for SSRS 2008 R2<span style="font-family: Arial, sans-serif;"><span style="line-height: 18px;">1. Open IIS 7, click on the computer you wish to create the certificate for. In the Content View double click on Server Certificates.</span></span><br />
<span style="font-family: Arial, sans-serif;"><span style="line-height: 18px;">2. The top right has an “Actions” menu. Click on “Create self-signed Certificate Request”</span></span><br />
<span style="font-family: Arial, sans-serif;"><span style="line-height: 18px;">3. Type in a name for your certificate .</span></span><br />
<span style="font-family: Arial, sans-serif;"><span style="line-height: 18px;">4. Launch Reporting Services Configuration Manager, go to “Web Service URL”, select your newly created SSL certificate from the list and click apply.</span></span>Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-61721125385417597532013-10-02T15:42:00.001+10:002013-10-02T15:42:44.447+10:00Check the enforced password expiration setting of all users on SQL Server<br />
select name,is_expiration_checked<br />
from sys.sql_logins<br />
where is_expiration_checked=1Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-45180525096444693082013-09-16T10:06:00.006+10:002013-09-16T10:06:50.304+10:00SQL Server Trace Files (Database Schema Chang History)EXEC master.dbo.sp_configure 'allow updates', 1;<br />
GO<br />
EXEC master.dbo.sp_configure 'show advanced options', 1;<br />
GO<br />
EXEC master.dbo.sp_configure 'default trace enabled', 1;<br />
GO<br />
RECONFIGURE WITH OVERRIDE;<br />
GO<br />
<br />
SELECT * FROM sys.configurations WHERE configuration_id = 1568<br />
<br />
SELECT * FROM ::fn_trace_getinfo(0)<br />
<br />
SELECT * FROM sys.traces<br />
WHERE id = 1;Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-14269859839252101812013-06-26T15:01:00.003+10:002013-06-26T15:01:08.686+10:00How to Find the Original Install Date and Time of Windows OS<span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px; text-align: justify;"> </span><b style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px; text-align: justify;">cmd /k systeminfo | find "Original Install Date"</b><span style="background-color: #f6fafb; color: #323232; font-family: verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 13px; text-align: justify;"> </span>Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-18690498939750605892013-06-19T11:02:00.005+10:002013-06-19T11:02:47.357+10:00Checking SET Options for the Current Session in SQL ServerDECLARE @options INT<br />
<br />
SELECT @options = @@OPTIONS<br />
<br />
PRINT @options<br />
IF ( (1 & @options) = 1 ) PRINT 'DISABLE_DEF_CNST_CHK'<br />
IF ( (2 & @options) = 2 ) PRINT 'IMPLICIT_TRANSACTIONS'<br />
IF ( (4 & @options) = 4 ) PRINT 'CURSOR_CLOSE_ON_COMMIT'<br />
IF ( (8 & @options) = 8 ) PRINT 'ANSI_WARNINGS'<br />
IF ( (16 & @options) = 16 ) PRINT 'ANSI_PADDING'<br />
IF ( (32 & @options) = 32 ) PRINT 'ANSI_NULLS'<br />
IF ( (64 & @options) = 64 ) PRINT 'ARITHABORT'<br />
IF ( (128 & @options) = 128 ) PRINT 'ARITHIGNORE'<br />
IF ( (256 & @options) = 256 ) PRINT 'QUOTED_IDENTIFIER'<br />
IF ( (512 & @options) = 512 ) PRINT 'NOCOUNT'<br />
IF ( (1024 & @options) = 1024 ) PRINT 'ANSI_NULL_DFLT_ON'<br />
IF ( (2048 & @options) = 2048 ) PRINT 'ANSI_NULL_DFLT_OFF'<br />
IF ( (4096 & @options) = 4096 ) PRINT 'CONCAT_NULL_YIELDS_NULL'<br />
IF ( (8192 & @options) = 8192 ) PRINT 'NUMERIC_ROUNDABORT'<br />
IF ( (16384 & @options) = 16384 ) PRINT 'XACT_ABORT'<br />
<br />
<a href="http://www.mssqltips.com/sqlservertip/1415/determining-set-options-for-a-current-session-in-sql-server/">http://www.mssqltips.com/sqlservertip/1415/determining-set-options-for-a-current-session-in-sql-server/</a>Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-5533693877727268572013-06-17T15:39:00.000+10:002013-06-17T15:50:03.368+10:00Plan cache and optimizing for adhoc workloads (fixing plan cache bloat problem)SELECT objtype AS [CacheType]<br />
, count_big(*) AS [Total Plans]<br />
, sum(cast(size_in_bytes as decimal(18,2)))/1024/1024 AS [Total MBs]<br />
, avg(usecounts) AS [Avg Use Count]<br />
, sum(cast((CASE WHEN usecounts = 1 THEN size_in_bytes ELSE 0 END) as decimal(18,2)))/1024/1024 AS [Total MBs - USE Count 1]<br />
, sum(CASE WHEN usecounts = 1 THEN 1 ELSE 0 END) AS [Total Plans - USE Count 1]<br />
FROM sys.dm_exec_cached_plans<br />
GROUP BY objtype<br />
ORDER BY [Total MBs - USE Count 1] DESC<br />
go<br />
<br />
<h2 id="post-2137" style="font-family: Arial, Helvetica, sans-serif; font-size: x-large; font-weight: normal; margin: 0px; padding: 0.4em 0em;">
Turn "<a href="http://www.bradmcgehee.com/2011/04/do-you-enable-optimize-for-ad-hoc-workloads/" rel="bookmark" style="margin: 0px; padding: 0.4em 0px; text-decoration: none;" title="Permanent Link: Do You Enable “Optimize for Ad Hoc Workloads”?">Optimize for Ad Hoc Workloads</a>" on</h2>
<a href="http://www.sqlskills.com/blogs/kimberly/plan-cache-and-optimizing-for-adhoc-workloads/">http://www.sqlskills.com/blogs/kimberly/plan-cache-and-optimizing-for-adhoc-workloads/</a>Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-91823810786296564692013-05-23T11:18:00.000+10:002013-05-23T11:24:41.717+10:00enables the SQL Server Agent extended stored procedures in SQL Server 2012<br />
The possible values are:<br />
<br />
0, indicating that SQL Server Agent extended stored procedures are not available (the default).<br />
<br />
1, indicating that SQL Server Agent extended stored procedures are available.<br />
<br />
<br />
The following example enables the SQL Server Agent extended stored procedures.<br />
<br />
sp_configure 'show advanced options', 1;<br />
GO<br />
RECONFIGURE;<br />
GO<br />
sp_configure 'Agent XPs', 1;<br />
GO<br />
RECONFIGURE<br />
GO<br />
Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-31586654507327334672013-04-04T16:04:00.003+11:002013-04-04T16:07:00.514+11:00Installing Web Front End Only requires install from command line<br />
<h3 style="margin: 0px; padding-bottom: 5px; padding-top: 5px;">
<span style="font-family: Segoe UI Light, Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif; font-size: small;"><span style="font-weight: normal;">If you want to install just a web front end, you have to run the install from the command line. </span></span></h3>
<h3 style="margin: 0px; padding-bottom: 5px; padding-top: 5px;">
<span style="font-family: Segoe UI Light, Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif; font-size: small;"><span style="font-weight: normal;">Follow the instructions at http://technet.microsoft.com/en-us/library/cc262897.aspx and create a config file for server type="WFE"</span></span></h3>
Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-38861929032093356852013-03-28T11:33:00.000+11:002013-03-28T11:33:29.146+11:00Allowing other machines to use filesharing via the DNS Alias in Windows OS<br />
<div class="MsoNormal">
Allowing other machines to use filesharing via the DNS Alias
(DisableStrictNameChecking)</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
This change alone will allow other machines on the network
to connect to the machine using any arbitrary hostname. (However this change
will not allow a machine to connect to itself via a hostname, see
BackConnectionHostNames below).</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Edit the registry key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters
and add a value DisableStrictNameChecking of type DWORD set to 1.</div>
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
Edit the registry key (on 2008 R2)
HKLM\SYSTEM\CurrentControlSet\Control\Print and add a value DnsOnWire of type
DWORD set to 1</div>
Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-56462765981617734992013-03-20T11:25:00.001+11:002013-03-20T11:25:47.007+11:00SSIS Services 32 and 64 bit with Oracle ClientsWin2003+ SQL2005SSIS + two Oracle Homes (32,64bit)<br />
<br />
Win2008+SQL2005SSIS + two Oracle Homes (32,64bit)<br />
<br />
Win2008+SQL2008SSIS +One Oracle Home (32,64bit)Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-36352520263342501942013-03-19T14:48:00.002+11:002013-03-19T15:25:21.570+11:00Rebuild System databases on SQL 2005start /wait "T:\Installation\SQL 2005 64Ent\Disk1\setup.exe" /qn INSTANCENAME=PROD REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=1.uwsw0542Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-83520594029015105882013-02-28T14:33:00.000+11:002013-02-28T14:33:54.731+11:00Error 1053: The service did not respond to the start or control request in a timely fashion ---- Fixed<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">1.Click Start, click Run, type regedit, and then click OK.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">2.Locate and then click the following registry subkey:</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">3.In the right pane, locate the ServicesPipeTimeout entry.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">a.On the Edit menu, point to New, and then click DWORD Value.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">b.Type ServicesPipeTimeout, and then press ENTER.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">4.Right-click ServicesPipeTimeout, and then click Modify.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">5.Click Decimal, type 60000, and then click OK.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">This value represents the time in milliseconds before a service times out.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;"><br /></span></span>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
<span style="font-family: Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif;"><span style="font-size: 20px; line-height: 25px;">6.Restart the computer.</span></span><br />
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse; border-spacing: 0px; border: none; list-style-type: none; margin: auto auto auto 3.75pt; outline: 0px; padding: 0px;"></table>
Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-13405407091215035952013-02-20T13:58:00.003+11:002013-02-20T13:58:59.967+11:00Github Vs Bitbuckethttp://www.pocoo.org/~blackbird/github-vs-bitbucket/bitbucket.html<br />
<br />
<a href="http://getcomparisons.com/github-vs-bitbucket" id="internal-source-marker_0.7004496969245461"><span style="background-color: transparent; color: #1155cc; font-family: Arial; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; text-decoration: underline; vertical-align: baseline;">http://getcomparisons.com/github-vs-bitbucket</span></a>Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-4077554663027977922013-01-03T10:11:00.002+11:002013-01-03T10:15:46.580+11:00VMware for MAC OS X Mount Lion<code>mainMem.useNamedFile = "FALSE"</code><br />
<br />
<code style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img alt="VMware Mac OS X Mountain Lion " height="224" src="http://www.ychong.com/wp-content/uploads/2012/10/20121007-maclion-vmware-09.png" title="" width="400" /> </code>Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-73841741140604113302012-12-06T14:41:00.000+11:002012-12-06T14:44:11.921+11:00Search special colum name in all databases on SQL Serversp_msforeachdb <br />'select "?" AS db, object_name(object_id,db_id("?")) , * from [?].sys.columns <br />where name=''user_login_name'''Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0tag:blogger.com,1999:blog-5277776239553963121.post-74770776479454750142012-10-25T15:11:00.002+11:002012-10-25T15:11:33.974+11:00SET TRANSACTION ISOLATION LEVEL (Transact-SQL)<br />
<code>ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;</database></code> <br />
<br />
<br />
SELECT name ,is_read_committed_snapshot_on FROM<br />sys.databases WHERE is_read_committed_snapshot_on=1Davidhttp://www.blogger.com/profile/04327501950131792986noreply@blogger.com0