QuBay: Information Technology

Rollback IE 10 to IE 9 on windows 7

2013-09-29T14:02:00.001-07:00

Rollback IE 10 to IE 9 on windows 7

Symptom: IE 10 would freeze frequently, especially when using Yahoo Mail.

Here is a reference web page talking about the solution:
http://answers.microsoft.com/en-us/ie/forum/ie10-windows_7/help-my-internet-explorer-disappeared/90a1b55c-87c1-48b0-b3e7-edaeabb5b7aa

Basically you can open a command window, and type the following command:

FORFILES /P %WINDIR%\servicing\Packages /M Microsoft-Windows-InternetExplorer-*10.*.mum /c "cmd /c echo Uninstalling package @fname && start /w pkgmgr /up:@fname /norestart"

Afterwards you need to restart your computer. You will have IE 10 removed and you are back to IE 9.

why does the mouse cursor spins continuously in Word 2013?

2013-08-25T20:30:00.004-07:00

I have word 2013 installed on my windows 7 computer, frequently I found that the mouse cursor would spin contibuously.

It turns out this has to do with my printer.

I have a Canon MP495 as default printer. In word 2007 it is ok. So I believe this is a bug related to word 2013.

Please also refer to this web site for more information.

http://answers.microsoft.com/en-us/office/forum/office_2013_release-word/why-does-the-mouse-cursor-spins-continuously-in/a2aa2a93-eb8b-4754-8fdf-4bd87c7730f5?lc=1033&auth=1&rtAction=1377366721361

edit a template column of datagrid control

2013-08-10T20:57:00.002-07:00

To edit a template column of datagrid control:
1. In the designer, right-click the DataGrid control, point to Edit Template, and choose the template column you created.
2. You can edit four templates ?Header, Footer, Item, and EditItem. Add controls to the template as needed.
3. To exit edit mode, right-click the DataGrid control and select End Template Editing from the menu.

Note: since it's not convenient to edit the controls inside a template column directly, we can always create a control in other place, and then copy it into the template column, this include generating for the control

asp.net Treeview

2013-08-10T20:55:00.004-07:00

Treeview

To disable action when a node of the treeview is selected, set this for the node: SelectAction="None"

Ajax Control Toolkit

2013-08-10T20:53:00.003-07:00

http://www.asp.net/ajaxlibrary/act.ashx

The next step is to add the Ajax Control Toolkit to the Visual Studio Toolbox. Follow these steps:

1.Launch Visual Studio and create a new ASP.NET Web Forms project or website. Open Default.aspx in the Visual Studio editor.

2.Create a new Toolbox tab by right-clicking the Toolbox and selecting Add Tab. Name the new tab Ajax Control Toolkit.

3.Right-click beneath the new tab and select the menu option Choose Items... Click the Browse button and browse to the folder where you extracted the Ajax Control Toolkit. Pick the AjaxControlToolkit.dll and click the OK button to close the Choose Toolbox Items dialog.

File compare tool

2013-08-10T20:47:00.001-07:00

File compare tool:

It doesn't compare Unicode text file. Especially for sql file, when renaming them to .txt file, it's in unicode format. Need to save it as ANSI text format, then File compare tool will work.

SQL 2008: Generate change script

2013-06-23T13:16:00.003-07:00

SQL 2008: Generate change script

1. Tools->Options->Designers->uncheck [prevent saving changes that require table re-creation]

2. right click on target table->desgin->make changes->Table designer->generate change script

N prefix before string in Transact-SQL query

2013-06-23T13:15:00.001-07:00

N prefix before string in Transact-SQL query

This denotes that the subsequent string is in Unicode (the N actually stands for National language character set). Which means that you are passing an NCHAR, NVARCHAR or NTEXT value, as opposed to CHAR, VARCHAR or TEXT

http://dba.stackexchange.com/questions/12475/n-prefix-before-string-in-transact-sql-query

http://support.microsoft.com/kb/239530/en-us

SQL 2008 database mail

2013-06-23T13:13:00.001-07:00

SQL 2008 database mail:

reference:
http://www.sqlservercentral.com/Forums/Topic690626-146-1.aspx

SSMS-->Management-->Database mail-->Configure Database Mail-->
Account name: [Your account name]
Description: [Your description]
Outgoing mail server (SMTP):
Email address: your gmail address
Display name: Your display name
Reply email: Your reply email
Server name: smtp.gmail.com
Port number: 587
This Server requires a secure connectin (SSL)
SMTP authentication:
Basic authentication:
User name: Your gmail address
Password: Your password
Email Profile:
Profile name: Your profile name
Description: Your description
SMTP account: Your gmail address
Public
Default Profile: Yes

To create sql server job

2013-06-23T13:09:00.001-07:00

To create sql server job:

Sql server agent-->Jobs-->right click-->new job

To start sql server agent

2013-06-23T13:08:00.002-07:00

To start sql server agent:

Sql server configuration manager-->Sql server services-->Start mode: automatic, and then start it

SQL 2008

2013-06-23T13:06:00.002-07:00

SQL 2008:

After installing SQL Server 2008, it turns out we can not install SP1 of it, because SP1 is already installed, even though it doesn't show on [About] Page, [select @@VERSION] will show it.

Clean installation of SQL Server 2008

2013-06-23T13:00:00.004-07:00

Clean installation of SQL Server 2008:

1. uninstall all SQL server related features/Programs
2. Command line-->RegEdit:
   HKEY_LOCAL_MACHINE-->Software-->Microsoft-->delete any SQL related entries, including [MSSQLServer]
3. delete folder: ..\Program Files\Microsoft SQL Server
4. Run SQL 2008 installation:
   Account Name: NT AUTHORITY\NETWORK SERVICE
5. SQL Server 2008 Express seems to be not very compatible with VS2008, when it comes to create the connection string;
   Try SQL Server 2008 Full Version
6. admin account: xxx

SharePoint 2010 Product key (for trial version)

2013-06-23T12:45:00.002-07:00

SharePoint 2010 Product key (for trial version)

http://jaydeep-patil.blogspot.com/2010/11/sharepoint-2010-product-key.html

SharePoint Server 2010 Enterprise Client Access License Features: GGDG8-JCMXH-8KG8C-RJYYX-3Y33H
SharePoint Server 2010 for Internet Sites, Enterprise: 9FPGB-W6QTT-G68T4-TBX7M-R624H
SharePoint Server 2010 Standard Client Access License Features: KB443-F7CJV-J2RP4-QYQJ7-6PBB3
SharePoint Server 2010 for Internet Sites, Standard: H4P2T-CYKM7-9FKKD-DTQ7X-W69GG

Getting started with PowerShell and SharePoint

2013-06-23T12:41:00.001-07:00

Getting started with PowerShell and SharePoint, here is a good reference:

https://www.nothingbutsharepoint.com/sites/devwiki/SP2007Dev/Pages/Getting%20started%20with%20PowerShell%20and%20SharePoint.aspx

Sharepoint: two important namespaces

2013-06-23T12:13:00.002-07:00

two important namespaces:

1. Microsoft.SharePoint namespace - This is the root namespace for all WSS objects. A developer would always use Micorsoft.SharePoint.dll namespace for creating WSS compatible components like webparts,features and solution packages.

2. Microsoft.Office.Server namespace - This is the root namespace of all Office Server 2007 (i.e. MOSS) objects. A developer will use the Microsoft.Office.Server namespace while accessing SharePoint 2007 server (or MOSS) specific components like BDC,Enterprise search etc.

Sharepoint Feature

2013-06-23T06:53:00.002-07:00

Feature is a functional component that can be activated and deactivated at various scopes throughout a SharePoint instances.

Sharepoint Solution Package

2013-06-23T06:52:00.003-07:00

These packages are nothing but a .cab files which contain other files that needed to be deployed on the SharePoint server.

These Solutions packages represented in SharePoint as .wsp files

Sharepoint file system folder (12 hive)

2013-06-23T06:50:00.001-07:00

Here is the sharepoint file system folder (12 hive):

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12

Good sharepoint 2007 tutorials

2013-06-23T06:48:00.000-07:00

http://mysharepointwork.blogspot.com/2010/05/sharepoint-2007-tutorial-for-beginners.html

Above is a good web site teaching developers how to do sharepoint programming. A very good starting point.

Sharepoint 2007 and SQL 2008

2013-06-23T06:44:00.005-07:00

When we chose [basic] installation for Sharepoint 2007, it actually use SQL 2005 as backend. In this case, we have to uninstall it ans install again using [advanced] in order to use SQL 2008 as backend.

Basic Line Editing Tricks and Shortcuts for Windows PowerShell

2013-03-17T16:54:00.001-07:00

Basic Line Editing Tricks and Shortcuts for Windows PowerShell:

http://technet.microsoft.com/en-us/magazine/ff678293.aspx

"Dot Sourcing" a Script

2013-03-17T16:53:00.001-07:00

"Dot Sourcing" a Script:

. 'E:\User\myAccount\program\PowerShell\sum.ps1'

powershell command

2013-03-17T16:52:00.006-07:00

scenario: I have a script file [C:\Users\myAccount\test.ps1], and try to execute [test] or [test.ps1] in powershell

Error:
The command test was not found, but does exist in the current location.

Windows PowerShell doesn't load commands from the current location by default. If you trust this command, instead type ".\test". See
"get-help about_Command_Precedence" for more details.

a command that retrieves your Windows PATH environment variable

2013-03-17T16:51:00.002-07:00

Here’s a command that retrieves your Windows PATH environment variable and displays it in a readable fashion:

$a = $env:path; $a.Split(";")

http://technet.microsoft.com/en-us/library/ee176949.aspx