SQL naming conventions This article is for standards for the SQL naming convention. I listed all basic which I found useful. May this will benefit you too. Databases and Files The database name should accurately reflect the database content and function. Use the Pascal case structure for database names. E.g., Northwind Use both upper and lower …
How to detect CAPS lock is ON using JavaScript? If you have a secure page which requires the credentials which obvious is a case-sensitive. So in case if user is typing password without aware of if CAPS LOCK is ON, which will cause invalid credentials error .To avoid its better to show message to the …
C# Coding Standards General Naming Conventions Following a consistent set of naming conventions can be a major contribution to readability. Beyond consistency of form, names of application and framework elements must be easily understood and must convey the functions of each element. Word Choice It is important that the names of identifiers make sense on …
How to Format SQL query? While working on SQL queries especially when one is dealing is large lines of SQL code , in that case formatted and refracted query is a live savior. In this blog I’II provide you with the solution which I found quite useful. #Formatting SQL query using SSMS This is for the guys who regularly …
How to turn windows 8 PC into Wifi Hotspot In this article I’II explain you “How you turn your PC into Wifi hotspot through command prompt”. If you find yourself with a modem but no router, you can share one computer’s connection to other devices with a few commands. The wireless connection can be shared …
IIS Application Pools Pros and Cons In this article we are going to see the IIS Application Pools Pros and Cons, before we start lets start what is Application pool identity, it is the name of the service or user account under which the application pool’s worker process runs. It denotes the system level privileges with …
How to Edit IIS ApplicationHost file? What is Application Host file? ApplicationHost.config is the root file of the configuration system when you are using IIS 7 and above. It includes definitions of all sites, applications, virtual directories and application pools, as well as global defaults for the web server settings.
Avoid Multiple ASP .NET Deployment server Annoying Right ? I used to work on different projects and during debugging I found a bit of an annoying behavior within Visual Studio. When debugging a solution that contains multiple project/application. Visual Studio starts up a very new development web server for each project/application within your solution. After spending …
How to attach EXE file in Gmail ? Most email providers, like G mail, don’t allow you to send executable or “.exe” files as G-Mail is most widely used mailing service hence security is a prime concern for Google because it contains the important confidential content/ data that yours . But this security sometime prevents us from doing something like sending …
