Information

AMAZON - Create SSL Certificate for a Load Balancer This section describes the process of generating a server certificate and preparing it to use with AWS products through IAM. To create a certificate, you perform a series of tasks as described by the following topics. Note: If you want to create user signing certificate that you can use to sign SOAP requests in EC2, see Creating and Uploading a User Signing Certificate Topics Install and Configure OpenSSL Create a Private Key Create a Certificate Signing Request Submit the CSR to a Certificate Authority Install and Configure OpenSSL Creating and uploading a certificate requires a tool that supports the SSL and TLS protocols. OpenSSL is an open-source tool that provides the basic cryptographic functions necessary to create an RSA token and sign it with your private key. If you don't already have OpenSSL installed, follow the instructions in this section. To install OpenSSL on Wi...

Sign in to the AWS Management Console and open the Amazon EC2 console at https://console.aws.amazon.com/ec2/. On the Amazon EC2 Getting Started page, in the EC2 Dashboard pane, under NETWORK & SECURITY, click Load Balancers. On the Load Balancers page, select your load balancer. The bottom pane displays the details of your load balancer. Click the Listeners tab. Click Change in the SSL Certificate column of the certificate you want to update. On the Configure SSL Certificate page, select Choose from your existing SSL Certificates to use previously uploaded SSL certificate and select the certificate from the drop-down box. Or, select Upload a new SSL Certificate if you have a SSL certificate and want to uploaded it. Before you upload, ensure that your certificate meets the following citeria: Certificates must follow the X.509 PEM format. The current date...

his section describes the process of generating a server certificate and preparing it to use with AWS products through IAM. To create a certificate, you perform a series of tasks as described by the following topics. Note: If you want to create user signing certificate that you can use to sign SOAP requests in EC2, see Creating and Uploading a User Signing Certificate Topics Install and Configure OpenSSL Create a Private Key Create a Certificate Signing Request Submit the CSR to a Certificate Authority To update an SSL certificate for an HTTPS load balancer Sample server certificate Install and Configure OpenSSL Creating and uploading a certificate requires a tool that supports the SSL and TLS protocols. OpenSSL is an open-source tool that provides the basic cryptographic functions necessary to create an RSA token and sign it with your private key. If you don't already have OpenSSL installed, follow the instructions in this section. ...

Set up the VPC, subnet, and Internet gateway: Open the Amazon VPC console at https://console.aws.amazon.com/vpc/ . Click VPC Dashboard in the navigation pane. Locate the Your Virtual Private Cloud area of the dashboard and clicks get started creating a VPC, if you have no VPC resources, or click Start VPC Wizard. Select the first option, VPC with a Single Public Subnet Only, and then click Continue. The confirmation page shows the CIDR ranges and settings that you've chosen. Make any changes that you need, and then click Create VPC to create your VPC, subnet, Internet gateway, and route table. Create WebServerSG and Adding Rules to the Security Group The WebServerSG security group is the security group that you'll specify when you launch your web servers into your public subnet. The following table describes the recommended rules for th...

First Declare a temp table DECLARE @table Table(column1 INT, Column2 INT, total int) insert duplicate data to temp table insert INTO @table SELECT column1, Column2,count(*) FROM Catalogue.MailingListCategoryContacts GROUP BY column1, Column2 HAVING count(*) > 1 Delete from all the data from original table DELETE FROM Catalogue.MailingListCategoryContacts WHERE column1 IN (SELECT column1 FROM @table) again insert into the original table INSERT INTO Catalogue.MailingListCategoryContacts(column1, Column2) SELECT column1, Column2 FROM @table

<a href="mailto:test@example.com?subject=testing%20out%20mailto&body=Just%20testing">Second Example</a> Example : click here to view the demo

DATEADD ( type , value , date ) date is the date you want to manipulate value is the integere value you want to add (or subtract if you provide a negative number) type is one of: yy, yyyy: year qq, q: quarter mm, m: month dy, y: day of year dd, d: day wk, ww: week dw, w: weekday hh: hour mi, n: minute ss or s: second ms: millisecond mcs: microsecond ns: nanosecond SELECT DATEADD(dd, 1, GETDATE()) will return a current date + 1 day