How many clustered indexes can be in one table?

One clustered indexes per table. 

For more info: https://msdn.microsoft.com/en-us/library/ms143432.aspx

Start SQL Service from Command Line

Sometime open Microsoft SQL Server Studio on local machine, it cannot open the local databases instance, instead of using the GUI, using the command line must more quicker.

net start SQLSERVERAGENT

For more info, see
https://msdn.microsoft.com/en-us/library/hh403394(v=sql.110).aspx#CommandPrompt

Northwind Sample DB Script is not work on SQL 2014

Comment out the line #24-25 in file "SQL Server 2000 Sample Databases\instnwnd.sql"

sp_dboption removed after SQL 2012

-- exec sp_dboption 'Northwind','trunc. log on chkpt.','true'

=> ALTER DATABASE Northwind SET RECOVERY SIMPLE

-- exec sp_dboption 'Northwind','select into/bulkcopy','true'

=> ALTER DATABASE Northwind SET RECOVERY BULK_LOGGED

Referenece:

https://gist.github.com/idevacc/4527115

Free Windows 10 Upgrade

As I guessed in my post last year, the next version of Windows is a free upgrade to consumer of Windows 7, 8, and 8.1. I love it.

OPEN OFFICE DOCUMENTS ON ANDROID SMARTPHONES AND TABLETS

To open office documents on Android smartphones and tablet, I would like to use the QuickOffice. It’s a free application from Google lets you create and edit Microsoft® Office documents, spreadsheets and presentations.

It also open the Adobe PDF files. So why we need another app to open PDF only?

Type Vietnamese on Mobile Devices

I like iOS one thing: I can type Vietnamese in iPhone, iPod Touch, iPad quickly without install additional app. Android is not.

For Android version before 4.0, you must install a third party app to type Vietnamese. It's scary. Some apps ask for unnecessary permissions like reading your contact, your account info, your SMS message,... When I installed some trusted apps to type Vietnamese, as a precaution Android warning me for possible security breach like keys log. So I uninstalled them and used the built in Google Keyboard. Since it do not support any popular input method used by Vietnamese like Telex, VNI or VIQR, it's hard to use and slow. For example: To type letter 'ê', I can type ee (Telex type) as in iOS but for Android Google Keyboard, I must hold a letter e to see it displays other characters, select and drag letter 'ê' to an input text box.

I hope Google should catch up with Apple in support Vietnamese input. There are a lot of Vietnamese in the world using Android-based phones and tablets.

Should Microsoft Windows Free?

Few days ago, I read this article "Microsoft should get used to giving Windows away for free" written by  Tony Bradley on TechRepublic. I like that idea. If Microsoft can not make Windows free as Ubuntu Linux, at least it should be free upgrade or low cost like Mac OS/X 10.7