Asp.Net Tips & Tricks

Wednesday, November 28, 2018

Amazon Ec2 Linux Launch Connect SSH

Amazon EC2 Linux Launch Connect SSH

In this tutorial I have shown, How to launch a Linux EC2 Instance and connect using SSH tunnel with Putty. Amazon Ec2 Linux Launch Connect SSH.

Please subscribe our channel(click: https://goo.gl/GE4g8v), like the video and share with your friends and social network.

Instructions:
Go to http://aws.amazon.com/ and create a new account if you don't have an account already.

You will require a credit card or debit for creating an account and you have to verify your card validity.

Follow instructions in video.

Please write your feedback in comments section and subscribe to get more useful videos, click on like button to inspire me for next video also share the video with your friends on facebook, twitter, linkedin etc.

Thank you for watching.

You can also visit our other videos:
Get Unlimited Google Drive Space completely Free: https://youtu.be/p6oeAc9bCUk
How to create a new gmail account :Gmail Tutorial Part-1: https://youtu.be/Iz7msqC7LSE
Create and Manage Users in Linux hosting CPanel: https://youtu.be/iP9Ci0eWi9M
Stop windows 10 spying on your activities: https://youtu.be/mcgRcPusjcg

-~-~~-~~~-~~-~-
Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v
Channel URL: https://goo.gl/VYi58K
Most Recent Videos: https://goo.gl/hXFN4w
Most Popular Video: https://goo.gl/7u7B1x

Social:
Facebook: https://www.facebook.com/triksbuddy/
Linked in: https://www.linkedin.com/company/trik...
Blog: https://triksbuddy.blogspot.com/
Tumblr: https://www.tumblr.com/blog/imrulquaes89
RSS Feed: https://www.youtube.com/feeds/videos....
-~-~~-~~~-~~-~-

How to Launch Google Virtual Machine Instance

How to Launch Google Virtual Machine Instance

In this video I have discussed How to Launch Google Virtual Machine Instance

An instance is a virtual machine (VM) hosted on Google's infrastructure. You can create an instance by using the Google Cloud Platform Console or the gcloud command-line tool.

Compute Engine instances can run the public images for Linux and Windows Server that Google provides as well as private custom images that you can create or import from your existing systems.

You can choose the machine properties of your instances, such as the number of virtual CPUs and the amount of memory, by using a set of predefined machine types or by creating your own custom machine types.

-~-~~-~~~-~~-~-
Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v
Channel URL: https://goo.gl/VYi58K
Most Recent Videos: https://goo.gl/hXFN4w
Most Popular Video: https://goo.gl/7u7B1x

Social:
Facebook: https://www.facebook.com/triksbuddy/
Linked in: https://www.linkedin.com/company/trik...
Blog: https://triksbuddy.blogspot.com/
Tumblr: https://www.tumblr.com/blog/imrulquaes89
RSS Feed: https://www.youtube.com/feeds/videos....
-~-~~-~~~-~~-~-

AWS EC2 - How to Launch Amazon Web Service EC2 instance

AWS EC2 - How to Launch Amazon Web Service EC2 instance

Please subscribe our channel, like the video and share with your friends and social network.

How to Launch and Terminate an Amazon Web Service EC2 instance - AWS EC2 Tutorial for Beginner by triksbuddy

An instance is a virtual server in the AWS cloud. With Amazon EC2, you can set up and configure the operating system and applications that run on your instance.

The instance is an Amazon EBS-backed instance (meaning that the root volume is an EBS volume). You can either specify the Availability Zone in which your instance runs, or let Amazon EC2 select an Availability Zone for you. When you launch your instance, you secure it by specifying a key pair and security group. When you connect to your instance, you must specify the private key of the key pair that you specified when launching your instance.

Instructions:
Go to http://aws.amazon.com/ and create a new account if you don't have an account already.

You will require a credit card or debit for creating an account and you have to verify your card validity.

Follow instructions in video.

Please write your feedback in comments section and subscribe to get more useful videos, click on like button to inspire me for next video also share the video with your friends on facebook, twitter, linkedin etc.

Thank you for watching.

/*ignore*/

These video related to following queries:
- amazon ec2 launch - instance initialization
- amazon ec2 launch date
- amazon ec2 launch instance
- amazon ec2 launch instance command line
- amazon ec2 launch instance from ami
- amazon ec2 launch instance from snapshot
- amazon ec2 launch more like this
- amazon ec2 launch reserved instance
- amazon ec2 launch templates
- amazon ec2 launch wizard
- aws ec2 launch configuration
- aws ec2 launch date
- aws ec2 launch failed
- aws ec2 launch instance
- aws ec2 launch instance
- aws ec2 launch instance cli
- aws ec2 launch instance from snapshot
- aws ec2 launch logs
- aws ec2 launch more like this
- aws ec2 launch template
- aws ec2 launch time
- aws ec2 linux launch connect ssh
- how to launch amazon ec2 instance
- how to launch aws ec2 instance
- how to launch ec2 instance command line
- how to launch ec2 instance from snapshot
- how to launch ec2 instance in aws
- how to launch ec2 instance in putty
- how to launch ec2 instance using ansible
- how to launch ec2 instance using aws cli
- how to launch ec2 instance using jenkins
- how to launch ec2 instance using putty
- how to launch ec2 instance using python
- how to launch reserved instance ec2
- how to launch windows ec2 instance
- launch a linux virtual machine with amazon ec2
- launch a windows virtual machine with amazon ec2
- launch a wordpress website with amazon ec2
- launch amazon ec2 instance
- launch ec2 instance aws cli
- launch ec2 instance boto3
- launch ec2 instance cloudformation
- launch ec2 instance from ami
- launch ec2 instance from cli
- launch ec2 instance from python
- launch ec2 instance from snapshot
- launch ec2 instance in vpc
- launch ec2 instance using ansible
- launch ec2 instance using cloudformation
- launch ec2 instance using terraform
- launch ec2 instance with iam role
- launch ec2 instance without key pair
- launch more like this amazon ec2
- you launch an amazon ec2 instance without an assigned

/*ignore*/

-~-~~-~~~-~~-~-
Please subscribe in below link and like our video.

Subscription URL: https://goo.gl/GE4g8v
Channel URL: https://goo.gl/VYi58K
Most Recent Videos: https://goo.gl/hXFN4w
Most Popular Video: https://goo.gl/7u7B1x

Social:
Facebook: https://www.facebook.com/triksbuddy/
Linked in: https://www.linkedin.com/company/trik...
Blog: https://triksbuddy.blogspot.com/
Tumblr: https://www.tumblr.com/blog/imrulquaes89
RSS Feed: https://www.youtube.com/feeds/videos....
-~-~~-~~~-~~-~-

Thursday, August 29, 2013

Extent (Error_ID) in database ID (DB_ID) is marked allocated in the GAM, but no SGAM or IAM has allocated it

Problem: I am getting a database error while checking database with DBCC CHECKDB command. The error message:
Extent (Error_ID) in database ID (DB_ID) is marked allocated in the GAM, but no SGAM or IAM has allocated it.

Solution: To resolve this error first try these sql commands:

    sp_dboption AMMS, single, true
    DBCC CHECKDB (AMMS, REPAIR_REBUILD)
    sp_dboption AMMS, single, false

This will repair the error with no data loss.

In case of failure of above statements please try with following commands:

    exec sp_dboption AMMS, single, true
    begin try
    DBCC CHECKDB (AMMS, repair_allow_data_loss)
    end try
    begin catch
    DBCC CHECKDB (AMMS, repair_allow_data_loss)
    end catch
    exec sp_dboption AMMS, single, false

There may occur data loss with this statement.

This problem generally occurs when there is some hardware errors. Run hardware diagnostics and correct any problems. Fix any hardware related problems. It might find it beneficial to switch to a completely new hardware system.

How to find out database error?

Problem: How can I find out errors in SQL Server database?

Solution: While running database for a long time on live, it may occur some error in database. To find out database error DBCC CHECKDB command is commonly used. DBCC CHECKDB find out database memory allocation and structural integrity of all object in the specified database. DBCC CHECKDB performs a physical consistency check. DBCC CHECKDB is the safest repair statement because it identifies and repairs the most of the possible errors.

Lets See the syntax of DBCC CHECKDB command:
DBCC CHECKDB
    ( 'database_name'
         [ , NOINDEX | { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]
    )    [ WITH { [ ALL_ERRORMSGS ]
                    [ , [ NO_INFOMSGS ] ]
                    [ , [ TABLOCK ] ]
                    [ , [ ESTIMATEONLY ] ]
                    [ , [ PHYSICAL_ONLY ] ]
                    }
        ]

Lets see some important arguments:

'database_name': Name of the database you want to check for memory allocation and structural integrity errors.
NOINDEX: Specifies that non-clustered indexes should not be checked.

REPAIR_FAST: Performs minor, quick repair actions. No risk of data loss.
REPAIR_REBUILD: Performs all repairs done by REPAIR_FAST and repair actions like rebuilding indexes. No risk of data loss.
REPAIR_ALLOW_DATA_LOSS: This performs all repair actions done by REPAIR_REBUILD and includes allocation and reallocation of rows and pages for correcting allocation errors, structural row or page errors, and deletion of corrupted text objects.

Note: Database requires to be in single user mode while specified these arguments.

Example of commands:
1. Check current database errors
    DBCC CHECKDB

2. Check specified database without non-clustered indexes:
    DBCC CHECKDB ('myDb', NOINDEX)

3. Check database errors with REPAIR_REBUILD specified:
    sp_dboption AMMS, single, true
    DBCC CHECKDB (AMMS, REPAIR_REBUILD)
    sp_dboption AMMS, single, false

4. Check database errors with REPAIR_ALLOW_DATA_LOSS specified:
    exec sp_dboption AMMS, single, true
    begin try
    DBCC CHECKDB (AMMS, repair_allow_data_loss)
    end try
    begin catch
    DBCC CHECKDB (AMMS, repair_allow_data_loss)
    end catch
    exec sp_dboption AMMS, single, false

Tuesday, January 22, 2013

How to filter special characters from user input?

Problem:
I am using a textbox to capture user entry to create a custom SQL select statement. I have everything working fine but I get an exception thrown when I wanted to search by city name and I entered, "Cox's Bazar" in the textbox.
Solution:
In this case you need to filter special characters from user input values that produce this error. You can filter user inputs using following method in your string helper class:

        /// <summary>

        /// Replace UnWanted Character from string

        /// </summary>

        /// <param name="input">Input string</param>

        /// <returns></returns>

        [DebuggerStepThrough()]

        public static string ReplaceUnWantedCharacter(string input)

        {

            input = input.Replace('+', ',');

            input = input.Replace("--", "++");

            input = input.Replace('&', ',');

            input = input.Replace("%", "[%]");

            input = input.Replace("_", "[_]");

            input = input.Replace("[", "[[]");

            input = input.Replace("]", "[]]");

            input = input.Replace("'", "''");

return input;
}

the use of this method may be like:


string cityName = StringHelper.ReplaceUnWantedCharacter(txtCityName.Text.Trim());

Sunday, January 20, 2013

Crystal Report Performance Improvement Tips

Problem:
How can I improve performance of crystal report in my web application?

Solution: Here is some important tips for improvement of crystal report performance in a web application:
1. Avoid using Linked OLE object if not extremely necessary. Locating OLE object is potentially time consuming.
2. Avoid using Sub-report if you can do same without sub-report. Incorrect use of sub report may have huge impact on performance.
3. Avoid special functions: Page N of M, Total Page Count. This cause the report more time to display first page.
4. Avoid unnecessary use of graphics. This may cause disk I/O which will impact on performance.
5. Remove un-used objects from report.
6. Remove or suppress unnecessary report section.
7. If summaries are used in the report, use conditional formulas instead of running totals when ever possible.
8. Whenever possible, limit records through Record selection Formula, not suppression. Return only necessary data from your data source.
9. Perform grouping on database server.
10.Disable report option Verify of First Refresh and Verify Stored Procedure on First Refresh.

Hope this will help.

Please feel free to add your valuable comments.

Wednesday, January 16, 2013

Important points that programmers should remember while developing web application software

I have tried to find out some points that every programmer should remember while coding in web application:

1. Do R&D about business logic and make a plan how you will implement it before you start writing code.
2. Should write code easy, understandable and maintainable way.
3. Make sure you are developing application wide consistent look and feel.
4. Should think in OOP way.
5. Try best practices that are established in the industry.
6. Maintain Naming convention
7. Transaction should be used properly and where necessary.
8. Remember concurrency issue while coding.
9. Validation should be checked properly. Validation should be done at client side so far possible.
10. User or role based permission should be implemented properly so that user can’t do anything if not permitted.
11. Should do comments where necessary.
12. Should be aware about security of application and database.
13. Write less code to do more jobs. Do re-factor where possible.
14. Think about performance of your code.
15. Make use of client side Ajax.
16. Be aware of hacking options like Sql Injection, Cross Site Scripting etc.
17. Should do paging on database end where data is more than 20 in grid.
18. Do less use of Session and ViewState.
19. Do caching where possible.
20. Always check existence of an object before accessing it.
21. Be careful about exception handling.
22. Write error log to identify errors.
23. Make sure you dispose large objects.
24. Grid should have a SL column.
25. Dropdown or combo values should be in a specific order.
26. Remove unnecessary code and comments from your page.
27. Set a title in each page. Don’t keep it like Untitled Page.
28. Include search option when data is more than 100 records in a page.
29. Use Namespace properly for pages and code files.
30. Show short and friendly error message to user but log error details.
31. Do not have more than one class in a single class.
32. Please write copy right and author information at the top of each file.
33. Avoid unnecessary round trip to database server. Use batch SQL statement to reduce round trip.
34. Use light weight controls. Choose controls carefully for your page.
35. Make your database normalized.
36. Make sure optimization of your queries.
37. Always deploy release build of your application.
38. Use release build and minimized version of any third party controls used.
39. Deploy your application on staging first and do all testing in staging.
40. Before deployment in production make sure necessary configuration and changes are done properly if needed. For example setting up new encryption key, encrypting sensitive information and setup application settings information etc.
41. Develop a way to notify users with friendly message while doing some changes or maintenance task after deployment.
42. Make sure to check all major functionality is working properly after deployment.

Monday, December 17, 2012

How to get list of sql server database objects?

Problem: How to get list of database objects?

Solution: You can get list of objects in two ways.

1. Getting the list from sys.objects table. Ex:

List of tables:

SELECT *
FROM sys.objects where type='U'

List of stored procedures:

SELECT *
FROM sys.objects where type='P'

List of views:

SELECT *
FROM sys.objects where type='V'

2. Getting the list query from object related tables. Ex:

List of tables:

SELECT *
FROM sys.Tables

List of stored procedures:

SELECT *
FROM sys.procedures

List of views:

SELECT *
FROM sys.views

How to remove all data from table and reseed identity column to initial value?

Problem: How to remove all data from table and reseed identity column to initial value?

Solution: For this purpose best solution is to use truncate sql command when you want to delete all data and reset identity column value to initial value.
Ex. TRUNCATE TABLE tableName

Somebody uses the following command which results same output:

DELETE FROM tableName
DBCC CHECKIDENT (tableName,RESEED, 0)

Tuesday, November 6, 2012

New blog on Ext.Net

I have started writing on Ext.Net in a new blog(http://practicalextnet.blogspot.com/) that will be dedicated to Ext.Net technologies. Now a day I am working on Ext.Net and developing all my web application with highly used Ext.Net. I have faced many problems while started working. So I would like to share my knowledge and finding with ext.net developers on the community so that they get help in their work. Hope this will be helpful.

Thanks

Saturday, November 3, 2012

Display Gridpanel cell tooltip in Ext.Net

You often want to display tooltip using cell data when data length overflows column width in your gridpanel. You will get an example to show tooltip with gridpanel cell data here: http://examples1.ext.net/#/Miscellaneous/ToolTips/GridPanel_Cell_Tooltip/

But this is not working properly when it is included in some project especially if you have master page based design. I have tried this in my project and it worked properly with little bit changes. Here I want to share the codes with you guys:

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">

<ext:XScript ID="XScript1" runat="server">

var showTip = function () {

var rowIndex = #{gpList}.view.findRowIndex(this.triggerElement),

cellIndex = #{gpList}.view.findCellIndex(this.triggerElement),

record = #{gpListStore}.getAt(rowIndex),

fieldName = #{gpList}.getColumnModel().getDataIndex(cellIndex),

data = record.get(fieldName);

if (data ==null){

this.body.dom.innerHTML = "";

}

else{

this.body.dom.innerHTML = data;

};

</script>

</ext:XScript>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

<ext:ResourceManager ID="rcm" runat="server">

</ext:ResourceManager>

<ext:Hidden ID="hfPK" runat="server">

</ext:Hidden>

<ext:TabPanel ID="tPnlMain" runat="server" ActiveTabIndex="0" AnchorHorizontal="100%"

Height="500" Plain="true" Visible="true" Width="1024">

<Items>

<ext:Panel ID="Tab2" runat="server" Title="Employee Search" Padding="1" AutoScroll="true">

<Items>

<ext:RowLayout runat="server">

<Rows>

<ext:LayoutRow RowHeight=".25">

<ext:Panel ID="Panel1" runat="server" Header="false" Padding="1" AutoScroll="true">

<Items>

</Items>

</ext:Panel>

</ext:LayoutRow>

<ext:LayoutRow RowHeight=".75">

<ext:Panel ID="Panel3" runat="server" Title="Employee List" Padding="1" AutoScroll="true">

<Items>

<ext:GridPanel ID="gpList" runat="server" StripeRows="true" AutoExpandColumn="EmployeeName"

Collapsible="true" AnchorHorizontal="100%" Height="322" TrackMouseOver="true">

<Store>

<ext:Store ID="gpListStore" runat="server">

<ext:JsonReader IDProperty="EmployeeId">

<ext:RecordField Name="EmployeeId" />

<ext:RecordField Name="EmployeeName" />

<ext:RecordField Name="EnrollId" />

<ext:RecordField Name="FirstName" />

<ext:RecordField Name="MiddleName" />

<ext:RecordField Name="LastName" />

<ext:RecordField Name="AddressLine1" />

<ext:RecordField Name="DepartmentId" />

<ext:RecordField Name="DesignationId" />

<ext:RecordField Name="PolicyId" />

<ext:RecordField Name="CardNumber" />

<ext:RecordField Name="DesignationName" />

<ext:RecordField Name="DeptName" />

<ext:RecordField Name="SbuName" />

</Fields>

</ext:JsonReader>

</Reader>

</ext:Store>

</Store>

<ext:RowNumbererColumn />

<ext:CommandColumn Header="Action" Width="65">

<ext:GridCommand Icon="ApplicationEdit" CommandName="Edit">

</ext:GridCommand>

</Commands>

</ext:CommandColumn>

<ext:Column ColumnID="cEnrollId" Header="Enroll Id" DataIndex="EnrollId" Width="50" />

<ext:Column ColumnID="cStaffCode" Header="Employee Code" DataIndex="StaffCode" Width="70" />

<ext:Column ColumnID="cEmployeeName" Header="EmployeeName" DataIndex="EmployeeName"

Width="130" />

<ext:Column ColumnID="cDesignationName" Header="Designation" DataIndex="DesignationName"

Width="150" />

<ext:Column ColumnID="cDepartmentName" Header="Department" DataIndex="DeptName" Width="100" />

<ext:Column ColumnID="cSbuId" Header="Branch" DataIndex="SbuName" />

<ext:Column ColumnID="cAddressLine1" Header="Address" DataIndex="AddressLine1" Width="180" />

</Columns>

</ColumnModel>

<ext:RowSelectionModel ID="RowSelectionModel1" runat="server" SingleSelect="true" />

</SelectionModel>

<ext:PagingToolbar ID="gpListPager" runat="server" PageSize="20" />

</BottomBar>

</Listeners>

<ext:ToolTip ID="RowTip" runat="server" Target="#{gpList}.getView().mainBody" Delegate=".x-grid3-cell" ShowDelay="0"

TrackMouse="true">

</Listeners>

</ext:ToolTip>

</ToolTips>

</ext:GridPanel>

</Items>

</ext:Panel>

</ext:LayoutRow>

</Rows>

</ext:RowLayout>

</Items>

</ext:Panel>

</Items>

</ext:TabPanel>

</asp:Content>

Hope this will help my friends.