Nice try..
> net start p2psvr
>netsh
>p2p pnrp clould
Wednesday, May 30, 2007
Friday, May 25, 2007
String Concatenation in SQL Server
When using '+' to concatenate two string field in SQL server (e.g. a+b), if one of them is NULL, then the whole string will become NULL. There is one solution to solve it:
So if any of the field is NULL, it will evaluate as an empty string. That's it!
COALESCE(a,'') + COALESCE(b,'')
So if any of the field is NULL, it will evaluate as an empty string. That's it!
Monday, May 7, 2007
Just played around with Greasemonkey
I'm not a javascript expert, but just played around using js in greasemonkey, quite funny.
// ==UserScript==
// @name FilterGuruEntry
// @description Filter Guru Entry
// @include http://www.guru.com/pro/search_results.cfm*
// ==/UserScript==
var allTRs, thisTR;
allTRs = document.getElementsByTagName('SPAN');
for (var i = 0; i < allTRs.length; i++) {
thisTR = allTRs[i];
if (thisTR.getAttribute("class") == "btblue") {myTR = thisTR.parentNode.parentNode.parentNode.parentNode.parentNode.parentNode.parentNode;
myTD = thisTR.parentNode.parentNode.parentNode.parentNode.parentNode.parentNode;
if (myTR.nodeName == "TR") {
myTR.removeChild(myTD);
}
}
}
Thursday, May 3, 2007
SQL Express installation messages
In case you just skip the post-installation messages... that may helps :P
Configuring and Managing SQL Server Express
· For improved manageability and security, SQL Server 2005 provides more control over the SQL Server surface area on your system. To minimize the surface area, the following default configurations have been applied to your instance of SQL server:
o TCP/IP connections are disabled
o Named Pipes is disabled
o SQL Browser must be started manually
o OPENROWSET and OPENDATASOURCE have been disabled
o CLR integration is disabled
o OLE automation is disabled
o xp_cmdshell is disabled
To enable or disable features and services, run the SQL Server Surface Area Configuration tool from the Start menu.
· To install SQL Server Management Studio Express Edition, download it from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
Documentation and Samples
To install SQL Server 2005 Books Online, download them from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
To install the .NET Framework SDK, see "Installing the .NET Framework SDK" in SQL Server Books Online.
To install sample databases and code samples, download the SQL Server Samples from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
Configuring and Managing SQL Server Express
· For improved manageability and security, SQL Server 2005 provides more control over the SQL Server surface area on your system. To minimize the surface area, the following default configurations have been applied to your instance of SQL server:
o TCP/IP connections are disabled
o Named Pipes is disabled
o SQL Browser must be started manually
o OPENROWSET and OPENDATASOURCE have been disabled
o CLR integration is disabled
o OLE automation is disabled
o xp_cmdshell is disabled
To enable or disable features and services, run the SQL Server Surface Area Configuration tool from the Start menu.
· To install SQL Server Management Studio Express Edition, download it from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
Documentation and Samples
To install SQL Server 2005 Books Online, download them from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
To install the .NET Framework SDK, see "Installing the .NET Framework SDK" in SQL Server Books Online.
To install sample databases and code samples, download the SQL Server Samples from the SQL Server Developer Center on MSDN (http://go.microsoft.com/fwlink/?linkid=51793).
Subscribe to:
Posts (Atom)
Sync multiple git repo at once
Use the following command in Linux will do the job: ls -d RepoNames* | xargs -I{} git -C {} pull
-
When Office2003 couldn't find file SKU011.CAB: regedit -> [HKEY_LOCAL_MACHINE] -> [SOFTWARE] -> [Microsoft] -> [Office] -&...
-
The resolution can be changed by editing the BlueStack's registry: HKLM\SOFTWARE\BlueStacks\Guests\Android\FrameBuffer\0\Height and ...
-
To count the number lines of files / stdout in Linux, we uses "wc -l" to achieve. In Windows, we use the following instead: find...