MS SQL Server 

How to Auto Restart SQL SERVER when its crashed?

The possible reasons for SQL server crash are listed below 1 . What to do if the operating system crashed? For this, the solution is very simple. i. In PC start -> open Run,  type “services.msc“.       ii. In this find the SQL Services name (ex: SQL Server (MSSQLSERVER)) of the instance and then click Properties. iii. In properties window, select start type to Automatic as shown below 2. There could be situations where SQLServer is shutting down automatically due to a crash or an unexpected behaviour with SQL…

Read More
MS SQL Server MS SQL Server 

How to Fix SQL Server Error – Restore Operation Failed for Database Due to Insufficient Memory in the Resource Pool ‘Default’

one fine day when working with SQL server we faced this error. the error states like below ************************************************************************************************* Msg 41379, Level 16, State 0, Line 0 Restore operation failed for database ‘InMemoryDB’ due to insufficient memory in the resource pool ‘default’. Close other applications to increase the available memory, ensure that both SQL Server memory configuration and resource pool memory limits are correct and try again. See ‘http://go.microsoft.com/fwlink/?LinkID=507574’ for more information. Msg 3167, Level 16, State 1, Line 2 RESTORE could not start database ‘InMemoryDB’. Msg 3013, Level 16, State…

Read More
Ajax ASP.net C#(cSharp) Javascript 

How to upload file to ftp using C#(C-Sharp) – aspx,ashx and ajax

In this article, we are going to explain how to upload the file to FTP using C# Generic handler(.ashx), HTML and Ajax. Please follow the steps below In visual studio create a solution with empty web app with aspx project solution. Create a file called index.aspx by adding a new item to the solution, in aspx page add the below code Add jquery plugin to <head> tag section Add HTML form fields to upload a file At bottom add the ajax file upload ajax script. After this create a File…

Read More
News Tech News 

Kaspersky store that only accepts personal data as currency

Kaspersky Lab has setup an unusual pop-up shop in London, called  The Data Dollar Store. Tech companies try to track your every move. Your Google searches. The videos you watch on YouTube. They’re all monitored by algorithms that want to serve you highly targeted ads. We don’t realise it, but the breadcrumb trail we leave online has value. Real, monetary value. To emphasise that point, cybersecurity firm Kaspersky Lab is running a pop-up shop in London called The Data Dollar Store this week. Inside, you’ll find exclusive t-shirts, mugs and screen prints by…

Read More
News Tech News 

New Device Which Turns Your Smartphone Into a Medical Lab

“SWISS ARMY” TECH The advent of the smart phone was a key development in the technological evolution of our species. What used to be relegated to entire rooms and even buildings can now fit snugly in our pockets giving each person the potential to access massive amounts of information from the palm of their hand. This evolution has not reached its apex, however, as continuing innovations are allowing for more and more capabilities for the technology. With the help of some researchers at the University of Illinois at Urbana-Champaign, we can…

Read More
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
News Tech News 

Difference between NFC and MST-samsung pay

Near Field Communication (NFC) It allows two devices placed within a few inches of each other to exchange information by tapping one device to other. If merchants want to use NFC for communication they have to upgrade their current Magnetic Secure Transmission (MST) It sends a magnetic signal from a compatible device to the payment terminal’s card reader. MST payments do not require the merchant to upgrade the payment terminal, making Samsung Pay available for use at nearly all payment terminals with a card reader. Some payment terminals may require…

Read More
Tech News 

Top Technology Myth’s Debunked

There was a time when development in technology happened at snail’s pace. You blink, and you miss it is the pace at which current development takes place. As someone said, Yesterday’s standard operating procedure is tomorrow’s mistake. And what used to be good advice for avoiding danger might not be relevant anymore. In our daily life, we have heard many technology myths and blindly follow them too, but here are some of them which we would like to debunk. Top Technology Myths: Charging Phones, laptops after 100% charge will reduce battery…

Read More
Ajax C#(cSharp) Javascript PHP 

How to create server side session using javascript

It is possible to create a server-side session using javascript for any server-side programming language like PHP, C#, Python etc. by just calling server side function using ajax calls as shown below. To do that, first create a server side application file and write the session variables which you want to set, then in client side javascript just pass the data which you need to set as a session to the server side application function using Ajax call as shown in below examples First, we will take an Example of C#/Asp.net. Javascript…

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