MS SQL Server MS SQL Server SQL 

How Start/Stop MS SQL Server Using .bat file in windows

If you are a stack developer who works on multiple platform for coding, might face this proble of starting and stoping the Sql Server, because if you want work in default port 80 for apache in php of any other, you have to stop the iis and SQL server to run apache in port 80 only, so while doing this to start/stop we use eather SQL Configuration manager/ windows services. so here we will tell you how to create a .bat file to start and stop all the sql services…

Read More
BackEnd Programming MS SQL Server 

Automatic Blocking of a particular IP Address

Web application security is a branch of Information Security that deals specifically with the security of websites, web applications and web services. At a high level, Web application security draws on the principles of application security but applies them specifically to Internet and Web systems. Websites and any network to which web servers are connected are prone to security risks . With the emergence of the web and app based applications on such a large scale, there arises an issue of security. To overcome such a situation, every application has a role…

Read More
MS SQL Server BackEnd Programming MS SQL Server 

Violation Of 1NF and how to deal with it

What is 1 NF? The first normal form (1NF) is one of the most violated rules while designing and developing a database.The First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if and only if the domain of each attribute contains only atomic (indivisible) values, and the value of each attribute contains only a single value from that domain. The benefits of Normalization are: Greater overall database organization Reduction of redundant data Data consistency within the database A much…

Read More
MS SQL Server MS SQL Server SQL Windows Server 

How to configure SQL server to access it remotely

How to configure SQL server to access it remotely?, Actually this is not a big issue there are some straightforward steps to configure, but there might be a possibility of giving problem after configure using the same steps also. So go through the below steps carefully. To establish a successful remote connection is to set up ports through the Window Firewall. In SQL Server there are two types of instances. First is a default instance and the second is a named instance. To connect to the default instance of Database…

Read More
MS SQL Server BackEnd Programming MS SQL Server SQL 

Stored Procedure Vs Function in MS SQL Server

Stored Procedure: A set of SQL Queries which are used to perform a specific task. A stored procedure can improve the performance of a database. Function: A  set of SQL Queries which can be used to pass parameters into and return values from it. Difference: Sl.No Stored Procedure Function 1 Compiled only once Complies every time the function is invoked 2 Input and Output Parameters are permitted Only input parameters are permitted 3 Need not necessarily return a value A return value is necessary 4  A Function can be invoked…

Read More