Manage SQL Server Services from the Command Line

To manage the default database server instance, use these commands:

NET START MSSQLSERVER Starts SQL Server as a service.

NET STOP MSSQLSERVER Stops SQL Server when running as a service.

To manage named instances of SQL Server, use the following commands:

NET START MSSQL$instancename Starts SQL Server as a service, where instancename is the actual name of the database server instance.

NET STOP MSSQL$instancename Stops SQL Server when running as a service, where instancename is the actual name of the database server instance.

Read more at https://technet.microsoft.com/en-us/library/dd421654.aspx

Notes on Sample Azure Application Fix It

Here are some experience I got when learn to Developing Apps with Windows Azure by working on The Fix It Sample Application (Building Real-World Cloud Apps with Azure)



After unzip the zip file "Fix It app for Scott Guthrie%27s Building Real World Cloud Apps with Windows Azure.zip", rename the folder name to get rid of the special character "%". It is better to use the short name such as "Fix It". Otherwise, we get an error when compile the project.



When make a web app on Azure, don't make it to long in such as "fixitdemoapponazure20160916235959" (When you make a new MVC web application project using Visual Studio 2015 template, it could be long as webapplication120160917124045). You may get an error when the PowerScript attempt to add a new storage. After I named my Azure web app 12 characters, it worked.

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?

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

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

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

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