Sunday, September 4, 2016

Cloud Computing

Cloud Computing today is a trend. Popular cloud computing are Amazon Web Services (AWS), Microsoft Azure, IBM Cloud, ... 

Cloud Computing like a private Local Area Network (LAN) on the internet. For most business, Cloud Computing is a cost effective. Instead of spend thousand dollars or more per month, they spend less. Instead of maintain a group of Information Technology (IT) professional, they may need only one. They don't need much of network engineer, network administrator.

So, first they are outsource software development. Then, outsource IT help desk. Now, companies outsource the IT infrastructure. 

The questions is:

  1. In which scenarios, moving to Cloud Computing is cost saving?
  2. How about security, privacy?

Sunday, August 28, 2016

PHP: require() vs include()

You can insert the content of one PHP file into another PHP file before the server executes it, with the include() or require() function.

The two functions are identical in every way, except how they handle errors:


include() generates a warning, but the script will continue execution


require() generates a fatal error, and the script will stop

Sunday, November 1, 2015

How to determine the version and edition of SQL Server and its components

Using query command:
Select @@version

for more info read https://support.microsoft.com/en-us/kb/321185

Saturday, October 31, 2015

Debugging in Visual Studio

Sometime to debug an web application in Visual Studio, you need to run as Administrator user or for other user.
For more info read: http://stackoverflow.com/questions/1287099/runas-a-different-user-when-debugging-in-visual-studio

Saturday, September 26, 2015

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

Sunday, August 16, 2015

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

Saturday, May 16, 2015

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: