April 5, 2017
- Making Asynchronous Calls
- Improve the speed, performance and usability of a web application
- using Update Panel and,
- using jQuery
Demonstration: Implementation of Ajax using jQuery:
we can simply use the bootstrap class and call jQuery functions in ASP.NET MVC because during the project creation it will by default added to project and also
February 12, 2017
Threat Detection is an awesome feature, which helps to detect anomalous activities in the databases which indicates potential Security threats to the databases.
This feature “Threat Detection” is in preview and supported for Azure SQL Database.
This feature helps to provide new security layer enables the database Users to detect and respond to the potential threats by providing security alerts on anomalous actions. Users can easily suspicious events using Azure SQL Database Auditing to determine if they result from an attempt to access, exploit data in the database. That’s why Threat Detection makes it very simpler to address potential threats to database without the need to be a security expert or an Advanced security monitoring systems.
SQL injection is one of the most common Web application security issues on the Internet, used to attack data-driven applications. Attackers take advantage of application vulnerabilities to inject malicious SQL statements into application entry fields, for modifying data in the database.
Therefore, the “Threat Detection” feature helps to detect certain anomalous database activities indicating potential SQL injection attempts.
Get started with SQL Database Threat Detection:
Step 1: Login to Azure portal, using the credential of your Subscription.
Step 2: Go to the configuration blade of the SQL Database that you want to monitor. In the Settings blade, select Auditing & Threat Detection.
Step 3: In the Auditing & Threat Detection configuration blade turn ON auditing, which will display the Threat detection settings. Also turn on Threat Detection(preview). Enter the email address in which you want to receive notifications and check the email service & co-administration box. Finally save it.
Step 4: Explore anomalous database activities upon detection of a suspicious event like SQL Injection etc. You will receive an email notification upon detection of anomalous database activities.
The email will provide information on the suspicious security event including the nature of the anomalous activities, database name, server name and the event time.
In addition, it will provide information on possible causes and recommended actions to investigate and mitigate the potential threat to the database.
Step 5: In the email, click on the Azure SQL Auditing Log link,
which will launch the Azure portal and show the relevant Auditing records around the time of the suspicious event.
Step 6: Click on the audit records to view more details on the suspicious database activities such as SQL statement, failure reason and client IP.
Also, You can click Open in Excel to open a pre-configured excel template to import and run deeper analysis of the audit log around the time of the suspicious event. in Recent Excel, Power Query and the Fast Combine setting is required.
That’s all f0r today keep on rocking.
#SQL #SQLdatabase #Azure
January 27, 2017
- Id primary key
- Name nvarchar,
- Address nvarchar.
- Enter the database server name.
- Choose SQL Server Authentication.
- Enter the Username and password of the database server.
- Enter the Database name That you created, in my case it is “data-to-azure-sql”.
November 13, 2016
We all know that without creating the database we cannot connect. So lets, create the SQL database first.
First of all, Login to Azure portal using the credential of your Subscription.
Now, to create SQL Database got to New > Databases > SQL Databases as shown in figure below:
Then, In the SQL Database blade, Provide the Informations as shown below:
Database Name: The name of database you want to create.
Subscription: Choose your available Subscription.
Resource Group: Either use existing resource group or create new one.
Select Source: Choose the database you want, Here I choose Blank Database.
Server: You can choose existing database server if available, else create new one, I am creating new. To create New server do similar as shown in the New Server Blade.
Pricing tier: Choose the size and price of database that is suitable for you.
Collation: Which one you want.
Then, Pin it to dashboard for easy access and click on create, It will take some time to deploy Database.
After database is successfully deployed, its wizard will open automatically as shown below:
Now, SQL Database has been successfully created in Azure.
Then to connect it through SQL Server Management Studio follow the steps:
We need to add client machine IP to the fire wall so, go to Tools as shown below:
Click on open in Visual Studio, go to configure your Firewall. Firewall Setting blade will appears. Click on Add Client IP and then Save, as shown below:
Open SQL Server Management Studio:
Server Type: Database Engine
Server Name: Enter the name that you created earlier in Azure.
Authentication: SQL Server Authentication
Login: Username that you set earlier while creating database in Azure.
Password: Password that you set earlier while creating database in Azure.
Then, Click on connect.
You will be redirected to another preview, which seems as shown below:
HAPPY CODING!! HAPPY ROCKING!!
June 13, 2016
Step 2: Then add an empty model as shown below:Step 3: Then,add the Model and entity as shown below:Step 4: Add the properties that you want in the model by right clicking on the properties field as shown below:Step 5: After completion of adding the required properties you must generate the database from model as shown below:Step 6: A dialog box will appear where you have to choose the database name, You can use the already made database or you can create from there as well. I am making the new database “CollegeStudent”.Step 7: Other box will appears do as shown below. That automatically setups the necessary Connection strings for the connection with the database.Step 8: Dialog box will automatically close and will be redirected to the visual studio to execute the connections for .edmx as below:Step 9: Now add the controller inside the controller folder as shown below:Step 9: Choose MVC 5 Controller with views, using Entity Frame Work as below:Step 10: Choose the Model name that you made when making the entity, also choose the context name that you made earlier and enter the content name that you want. In my case, I have as shown below:Step 11: Go to RouteConfig inside App_Start and change the controller name to the one that you made earlier and enter the action method name that you want to call when the page loads. In my case, I have shown as below:Step 12: Finally, run it in the browser. then you will get the view as shown below now you can create, add, delete menu there and go through it for proper operation as you need.Thank you for you time! Keep visiting my website for more other blogs.
February 4, 2016
When you create a web app, Azure assigns it to a sub-domain of azurewebsites.net. For example, if your web app is named exploreitnepal, the URL is exploreitnepal.azurewebsites.net. Azure also assigns a virtual IP address. For a production web app, you probably want users to see a custom domain name. And We can use Azure credits to buy Custom Domains and host it as well. This feature is not possible from the Dreamspark pass of Azure. This Blog explains how to buy and configure a custom domain with Web Apps.
- For instructions on using Traffic Manager to load balance traffic to a web app, use the selector at the top of this article to select the Traffic Manager specific steps.
- Custom domain names cannot be used with Free web app. You must configure your web app for Shared, Basic, or Standard mode, which may change how much you are billed for your subscription.
If you don’t have a domain name for your web app, you can easily buy one on Azure Portal. During the purchase process you can choose to have WWW and root domain’s DNS records be mapped to your web app automatically. You also can manage your domain right inside Azure Portal.
Steps to Buy Domain Names:
- In your browser, open the Azure Portal.
- In the Web Apps tab, click the name of your web app. In my case, I am using “exploreitnepal” as shown below:
- Click on Setting there, a new blade will appears as shown below:
- Scroll down the blade and then select Custom domains and SSL as shown below:
- Then click on the Buy Domain in “Custom domains and SSL” blade as shown below:
- In the Buy Domains blade, use the text box to type the domain name you want to buy and hit Enter. The suggested available domains will be shown just below the text box. Select what domain you want to buy. You can also purchase multiple domains at once. Then, Click the Contact Information as shown below:
- Fill the domain’s Contact Information form and Click on OK.
- Now you can choose to,
- “Auto renew” your domain every year
- Opt-in for “Privacy protection” which is included in the purchase price for FREE
- “Assign default host names” for WWW and root domain to the current Web App.
- Click the Select on Buy Domains blade, then you will see the purchase information on Purchase confirmation blade. If you accept the legal terms and click Buy, your order will be submitted and you can monitor the purchasing process on Notification.
- Domain purchase can take few minutes to complete. After getting the similar view as shown below, be sure that your domain has been bought.
Stay tuned for my next blog, where I will be talking about the Domain Name Configuration.
Happy Using Azure #Happy Coding!!!