Using query command:
Select @@version
for more info read https://support.microsoft.com/en-us/kb/321185
Application Development. Business Solutions. Computers. Consulting. Cybersecurity. Information Technology. Software. Technology
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
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
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
- Notepad++ is a free (as in "free speech" and also as in "free beer") source code editor and Notepad replacement that supports several languages.
- WinMerge is an Open Source differencing and merging tool for Windows.
- 7-Zip is a file archiver with a high compression ratio.
- 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.
- 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.
Subscribe to:
Posts (Atom)
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...
-
https://dupeguru.voltaicideas.net/ https://github.com/arsenetar/dupeguru/releases/tag/4.3.1 $ gpg --verify dupeguru_macOS_Qt_4.3.1.zip.siggp...
-
These keyboard shortcuts are helpful. Some of them are not document in Visual Studio 2010 Express, for example: <Ctrl> F5 to run the ...
-
Except from https://consumer.ftc.gov/consumer-alerts/2022/10/how-recognize-fake-geek-squad-renewal-scam Scammers are at it ag...