Sunday, November 1, 2015

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:



Sunday, March 8, 2015

Essential Software Developer Tools


  1. Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages. 

  2. WinMerge is an Open Source differencing and merging tool for Windows. 

  3. 7-Zip is a file archiver with a high compression ratio. 

  4. Visual Studio Community. A fully-featured, extensible, free IDE for creating modern applications for Android, iOS, Windows, as well as web applications and cloud services. 

  5. Visual Studio Code is a lightweight but powerful source code editor which runs on your desktop and is available for Windows, OS X and Linux.


Sunday, February 8, 2015

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.

How to recognize a fake Geek Squad renewal scam | Consumer Advice

Except from  https://consumer.ftc.gov/consumer-alerts/2022/10/how-recognize-fake-geek-squad-renewal-scam Scammers are at it ag...