.NETAgileAngularArchitectureASP.NETAzureBIBig DataBusinessC#Cloud ServiceDebuggingEncryptionFYIGoogleHardwareInternetInterviewsjQueryLeadershipManagementMicrosoftMobileMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSTeamTestingTSQLVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
Hexadecimal Numbers
Decimal Hexadecimal 0 0 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 A 11 B 12 C 13 D 14 E 15 F
Binary Numbers
Decimal Binary 0 0000 1 0001 2 0010 3 0011 4 0100 5 0101 6 0110 7 0111 8 1000 9 1001 10 1010 11 1011 12 1100 13 1101 14 1110 15 1111
Row Count using @@ROWCOUNT
Record the number of rows affects in the last transaction.
SQL Bitwise Operators
Bitwise Operators X Y X&Y X|Y X^Y ~X 0 0 0 0 0 1 0 1 0 1 1 1 1 0 0 1 1 0 1 1 1 1 0 0 See the following topics: & (Bitwise AND) &= (Bitwise AND Assignment) | (Bitwise OR) |= (Bitwise OR Assignment) ^ (Bitwise Exclusive OR) ^=... » read more
Make Field Not Null with a Default Constraint of 0
Alter Table Script Create Table Script
Restart IIS
Go to command prompt in Admin mode. C:\WINDOWS\system32>iisreset
Computer Name and Info on Windows
In Windows search, type in “Computer Name” and then click on “View your PC name”. An app should open with all the information about your PC.
Creating new IIS web application from IIS Manager.
Open up the “Internet Information Services (IIS) Manager” application. Server -> Sites -> Add Website Input “Site name”. Leave application pool to DefaultAppPool. Input “Physical path” to point to your web application root folder. Input “Port” number.
Install and Uninstall Service Host
Scripts for installing and uninstalling service host on Windows machine. Need to reinstall every time the service is modified and recompiled. InstallService.bat May need to modify the app.config to point the database connection to your database. UninstallService.bat