Skip to main content

Posts

Showing posts from March, 2017

How to delete many rows from a large table in MySQL

If you want to delete many rows from a large table, you may exceed the lock table size for an InnoDB table. To avoid this problem, or simply to minimize the time that the table remains locked, the following strategy (which does not use DELETE at all) might be helpful: Select the rows not to be deleted into an empty table that has the same structure as the original table: create table t_copy like t; insert into t_copy SELECT * FROM t WHERE ... ;
See also:

How to Copy Table in MySQL
Use RENAME TABLE to atomically move the original table out of the way and rename the copy to the original name: RENAME TABLE t TO t_old, t_copy TO t; Drop the original table:
DROP TABLE t_old; Note that Foreign keys that point to the renamed table are not automatically updated. In such cases, you must drop and re-create the foreign keys in order for them to function properly.
See also:
How to get all foreign keys to a table or column in MySQL No other sessions can access the tables involved while RENAME TABLE executes,…

[HDGEM] Google’s Safe Browsing technology examines billions of URLs per day looking for unsafe websites.

Google's Safe Browsing technology examines billions of URLs per day looking for unsafe websites.

Google announced that they updated the site status tool with a "cleaner UI, easier-to-interpret language, and more precise results." This tool is used to help site owners or site visitors to see the safety status of a web page without actually having to go visit the page.



--
Posted By Blogger to HDGEM at 3/31/2017 03:43:00 AM

[HDGEM] How to fix scroll bar missing problem on Mac

Click the Apple menu at the top-left of the screen, then select System Preferences.Next, select the General preferences pane; it's the very first one, up at the top.Under the "Show scroll bars" heading, you'll find three options: "Automatically based on input device," "When scrolling," and "Always."Go ahead and select that last "Always" option. You're done!

--
Posted By Blogger to HDGEM at 3/30/2017 10:13:00 AM

[HDGEM] Microsoft’s latest upgrade to Windows 10 - intimidating

The new "Creators Update" for Windows 10 – its third major upgrade since the system launched in 2015 – adds a function that lets users turn their smartphones into 3D scanners, then import those 3D images into their computers.

It also adds support for virtual reality and mixed reality headsets.

--
Posted By Blogger to HDGEM at 3/29/2017 08:48:00 PM

[HDGEM] What Is Data Serialization

Serialization is: the process of translating data structures or object state into a format that can be stored (for example, in a file or memory buffer, or transmitted across a network connection link) and reconstructed later in the same or another computer environment.

--
Posted By Blogger to HDGEM at 3/29/2017 07:21:00 PM

[HDGEM] PivotTables are a great way to summarize, analyze, explore, and present your data

You can create PivotTables with just a few clicks in Excel.  PivotTables are highly flexible and can be quickly adjusted depending on how you need to display your results.
You can also create PivotCharts based on PivotTables that will automatically update when your PivotTables do. 

--
Posted By Blogger to HDGEM at 3/29/2017 02:06:00 PM

[HDGEM] Types of Marketing campaigns

Regular CampaignsPlain-Text CampaignsRSS CampaignsA/B Testing Campaigns
    RSS campaigns allow you to automate your marketing campaigns by combining content from an RSS feed with user-friendly templates. 

--
Posted By Blogger to HDGEM at 3/29/2017 12:38:00 PM

[HDGEM] Chatbots are programs pretending to be people that you can interact with through text or even voice.

You can talk to these chatbots in your messaging apps, much like you would any other contact in your list, to get the day's news or even get something done.
In the context of conversational commerce, where messaging apps become a bridge between consumers and businesses, chatbots seem to be the best answer for ecommerce business owners to manage thousands of one-to-one conversations with customers.

--
Posted By Blogger to HDGEM at 3/29/2017 12:31:00 PM

[HDGEM] Different types of learning styles

Intrapersonal: Can understand one's own emotions, wants, and desires and control them as needed.Interpersonal: Can recognize, understand, and influence other people's emotions, wants, and desires.Kinesthetic: Can use their body to convey information and ideas.Linguistic: Can use words (both written and verbal) to express their ideas and learn new concepts.Musical: Can appreciate, create, and reproduce music.Logical-mathematical: Can solve abstract problems, analyze complex information, recognize patterns, and develop calculations.Visual-spatial: Can understand the relationship between images and meanings and objects and space.


--
Posted By Blogger to HDGEM at 3/29/2017 12:23:00 PM

[HDGEM] How to draw a line or shape on Google Maps

On your computer, sign in to My Maps.Open or create a map. A map can have up to 10,000 lines, shapes, or places.Click Draw a line Add line or shape.Select a layer and click where to start drawing. A layer can have 2,000 lines, shapes or places.Click each corner or bend of your line or shape. To move the map, click and hold the mouse.When you're finished drawing, double-click or complete the shape.Give your line or shape a name.When you're done, click Save.

--
Posted By Blogger to HDGEM at 3/29/2017 12:12:00 PM

How To Set Up an OpenVPN Server on Ubuntu

Install OpenVPN sudo apt -y update

sudo apt -y install openvpn easy-rsa

Set Up the CA Directory  OpenVPN is an TLS/SSL VPN. This means that it utilizes certificates in order to encrypt traffic between the server and clients. In order to issue trusted certificates, we will need to set up our own simple certificate authority (CA).

To begin, we can copy the easy-rsa template directory into our home directory with the make-cadir command:

make-cadir ~/openvpn-ca

Move into the newly created directory to begin configuring the CA:

cd ~/openvpn-ca

Configure the CA Variables To configure the values our CA will use, we need to edit the vars file within the directory. Open that file now in your text editor:

vim vars

Towards the bottom of the file, find the settings that set field defaults for new certificates. It should look something like this:

~/openvpn-ca/vars
. . .

export KEY_COUNTRY="US"
export KEY_PROVINCE="CA"
export KEY_CITY="SanFrancisco"
export KEY_ORG=&quo…

How to set up VPN user accounts

The VPN users are configured in the /etc/ipsec.secrets file. vim /etc/ipsec.secrets Example content: # This file holds shared secrets or RSA private keys for authentication. # RSA private key for this host, authenticating it to any other host # which knows the public part. Suitable public keys, for ipsec.conf, DNS, # or configuration of other implementations, can be extracted conveniently # with "ipsec showhostkey". : RSA vpnHostKey.der : PSK 8cv+NkxY9LLZvwj4qCC2o/gGrWDF8d21jL i88ca: EAP "qCC2o/gGL4qCC2o/gG" spiderman: XAUTH "xauth_ikev1_example_password" In the example above the RSA private key file vpnHostKey.der stored in the /etc/openswan.d/private/ directory is not protected by symmetric encryption (a password). The PSK for IKEv1 connections is also defined. The format of the EAP MSCHAPv2 user credentials is: [<domain>\]<username> : EAP "<plaintext password>" Add as many users as you like there. The first line allows a…

VPN client traffic settings

Should client traffic be routed by default through the VPN?Explanation: If you only have a small network you would like your remote users to connect over the VPN, select no. Otherwise, if you would like everything to go through the VPN while the user is connected (especially useful if you want to secure data communications over an insecure link), select yes for this option.
Should client DNS traffic be routed by default through the VPN?Explanation: If you would like your VPN clients to able to resolve local domain names using an on-site DNS server, select yes for this option. Otherwise, select no.

Do note that if you selected yes for the previous option, all traffic will be routed over the VPN regardless what you set for this setting here.

Advantages of a Private VPN Server on the cloud

Private: Dedicated VPN server for your use only.Secure: Encrypted & password enabled VPN server with no logs.On demand: You can start / stop the VPN server as required.Global: One or more VPN servers in worldwide regions.Device support: Supports PPTP and L2TP with IPSEC which means you can use the VPN server on your Android, iPhone, iPad, PC, MAC, and even most routers.

Bridged VPN

A bridged VPN allows the clients to appear as though they are on the same local area network (LAN) as the server system.  The VPN accomplishes this by using a combination of virtual devices -- one called a "bridge" and the other called a "tap device". A tap device acts as a virtual Ethernet adapter and the bridge device acts as a virtual hub. When you bridge a physical Ethernet device and a tap device, you are essentially creating a hub between the physical network and the remote clients. Therefore, all LAN services are visible to the remote clients.

--
Posted By Blogger to HDGEM at 10/20/2016 12:31:00 PM

How to Setup and Configure an OpenVPN Server on CentOS 6

Enabled Extra Packages for Enterprise Linux (EPEL) Repository:

$ sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm

Install

$ sudo yum install openvpn -y

copy the configuration file to its destination:

$ sudo cp /usr/share/doc/openvpn-2.3.2/sample/sample-config-files/server.conf /etc/openvpn

uncomment the "push" parameter so traffic on our client systems to be routed through OpenVPN.

# If enabled, this directive will configure
# all clients to redirect their default
# network gateway through the VPN, causing
# all IP traffic such as web browsing and
# and DNS lookups to go through the VPN
# (The OpenVPN server machine may need to NAT
# or bridge the TUN/TAP interface to the internet
# in order for this to work properly).
push "redirect-gateway def1 bypass-dhcp"

route DNS queries to opendns.com and Google's Public DNS servers.

push "dhcp-option DNS 208.67.222.222"
push "dhcp-option DNS 208.67.220.220"
push &qu…

Enhanced privacy online with Opera’s free VPN

Opera is the first major browser maker to integrate an unlimited and free VPN or virtual private network. Now, you don’t have to download VPN extensions or pay for VPN subscriptions to access blocked websites and to shield your browsing when on public Wi-Fi.
Opera’s built-in free VPN feature is easy to use. To activate it, Mac users just need to click the Opera menu, select “Preferences” and toggle the feature VPN on, while Windows and Linux users need to go to the “Privacy and Security” section in “Settings” and enable VPN there. A button will appear in the browser address field, from which the user can see and change location (more locations will appear later), check whether their IP is exposed and review statistics for their data used. It’s free and unlimited to use, yet it offers several must-have options available in paid VPNs, such as: Hide your IP address – Opera will replace your IP address with a virtual IP address, so it’s harder for sites to track your location and identify …

[HDGEM] What ISP can possibly do to your data

Sell your browsing history to basically any corporation or government that wants to buy it    Hijack your searches and share them with third parties    Monitor all your traffic by injecting their own malware-filled ads into the websites you visit    Stuff undetectable, un-deletable tracking cookies into all of your non-encrypted traffic    Pre-install software on phones that will monitor all traffic — even HTTPS traffic — before it gets encrypted. AT&T, Sprint, and T-Mobile have already done this with some Android phones.

--
Posted By Blogger to HDGEM at 3/29/2017 08:44:00 AM

[HDGEM] Faster Deploy Times for Large Serverless Services - The Serverless Framework relies on CloudFormation to deploy the service with its infrastructure in a consistent and reliable way.

V1.10 of the Serverless Framework includes an improvement where resources are defined in a way which helps CloudFormation to deploy them in parallel rather than sequentially. Making the deployment process faster.

--
Posted By Blogger to HDGEM at 3/29/2017 08:26:00 AM

[HDGEM] Full Android Support for Jetpack Sites

Significant improvements for Jetpack users in the official WordPress App for Android, available now in the Google Play Store.
This update brings to Jetpack users the same features and functionality that WordPress.com site owners have come to expect on Android including, amongst others, People Management, Site Settings, and Site Icons.

--
Posted By Blogger to HDGEM at 3/29/2017 08:12:00 AM

[HDGEM] Get all the benefits of running your application on the JVM - Spark won't be deprecated tomorrow

Lately, a lot of server-side web development has been taken over by NodeJS, but a growing number of NodeJS developers are using TypeScript and other statically typed languages that compile to JavaScript. Why not go all the way and use a language that was actually designed with types, and intended to run on the server-side? You also get all the benefits of running your application on the JVM, where libraries aren't deprecated every day. If you're coming from ExpressJS, then Spark's syntax will feel very familiar, and unlike a lot of JavaScript web frameworks, Spark won't be deprecated tomorrow.

--
Posted By Blogger to HDGEM at 3/29/2017 08:04:00 AM

[HDGEM] Serverless computing lets you build scalable and cost-effective applications that scale up or down automatically without the need for provisioning, scaling, and managing servers.

You use AWS Lambda to run your application's code and Lambda triggers your code in response to events, such as HTTP requests or changes to data in an Amazon S3 bucket or Amazon DynamoDB table.  You are charged for the duration it takes for your code to execute and the number of times your code is triggered. Since Lambda scales precisely with the size of your workload, you never pay for idle compute.

AWS also provides a set of fully managed services that you can use with Lambda to build serverless applications.  These services let you add database and storage tiers for your application or manage connections and messages from mobile and IoT devices. You can use these services together with Lambda to build applications that don't require provisioning and maintaining servers or administering databases. You also no longer need to worry about application fault tolerance and availability. Instead, AWS provides all of these capabilities for you, allowing you to focus on product i…

[HDGEM] AWS Lambda automatically runs your code without requiring you to provision or manage servers.

No Servers to Manage, Just write the code and upload it to Lambda. Continuous Scaling AWS Lambda automatically scales your application by running code in response to each trigger. Your code runs in parallel and processes each trigger individually, scaling precisely with the size of the workload.

Subsecond Metering With AWS Lambda, you are charged for every 100ms your code executes and the number of times your code is triggered. You don't pay anything when your code isn't running.

--
Posted By Blogger to HDGEM at 3/29/2017 07:59:00 AM

[HDGEM] Serverless computing allows you to build and run applications and services without thinking about servers.

With serverless computing, your application still runs on servers, but all the server management is done by AWS.  At the core of serverless computing is AWS Lambda, which lets you run your code without provisioning or managing servers. With Lambda, you can run code for virtually any type of application or backend service, and it takes care of everything required to run and scale your code with high availability.

--
Posted By Blogger to HDGEM at 3/29/2017 07:57:00 AM

[HDGEM] Spark - A micro framework for creating web applications in Java 8 with minimal effort

Built for Productivity Spark Framework is a simple and lightweight Java web framework built for rapid development. Spark was originally inspired by the web framework Sinatra, but it's intention isn't to compete with Sinatra, or other similar web frameworks in different languages. Sparks intention is to provide a pure Java alternative for developers that want to (or are required to), develop their web application in Java. Spark is built around Java 8's lambda philosophy, which makes a typical Spark application a lot less verbose than most application written in other Java web frameworks.

Spark focuses on being as simple and straight-forward as possible, without the need for cumbersome (XML) configuration, to enable very fast web application development in pure Java with minimal effort. It's a totally different paradigm when compared to the overuse of annotations for accomplishing pretty trivial stuff seen in other web frameworks.

--
Posted By Blogger to HDGEM at…

[HDGEM] AWS Serverless Application Model (AWS SAM) allows you to easily create and manage resources used in your serverless application using AWS CloudFormation.

You can define your serverless application as a SAM template - a JSON or YAML configuration file that describes Lambda function, API endpoints and other resources in your application. 
Using nifty commands, you upload this template to CloudFormation which creates all the individual resources and groups them into a CloudFormation Stack for ease of management. When you update your SAM template, you will re-deploy the changes to this stack. AWS CloudFormation will take care of updating the individual resources for you.

--
Posted By Blogger to HDGEM at 3/29/2017 07:46:00 AM

[HDGEM] You can now develop your AWS Lambda functions using Node.js v6.10.

You simply upload your Node code as a ZIP using the AWS CLI or Lambda console and select the Node.js v6.10 runtime. You can also use the AWS Serverless Application Model to package and deploy Lambda functions. Lambda takes care of everything required to run and scale your code with high availability.

--
Posted By Blogger to HDGEM at 3/29/2017 07:44:00 AM

[HDGEM] Emma is a Lightweight Database management tool

Emma is a very basic GUI database manager with all the CRUD(Create, Read, Update, Delete) functionality. One will find it useful for doing simple tasks, such as managing database for learning purposes, performing day to day tasks using a very lightweight GUI and also performing CRUD actions using MySQL queries from the command field. 

--
Posted By Blogger to HDGEM at 3/29/2017 07:00:00 AM

[HDGEM] Shopify Wholesale for Plus merchants

The Shopify Wholesale channel syncs with online stores and creates a password-protected wholesale store where merchants can invite buyers to purchase products at assigned wholesale prices. All Plus merchants can access the Wholesale channel from the channel addition window in their admin.

https://help.shopify.com/manual/sell-online/wholesale

--
Posted By Blogger to HDGEM at 3/29/2017 06:32:00 AM

[HDGEM] Ansible is a very flexible and extensible automation tool

Ansible can be used in a lot of different environments that may not fit your preconceived notions of Ansible as an SSH-based tool to configure Linux and Unix systems.  There are many other things you can do with Ansible, and a few ways to further customize and configure how your automation works.

Ansible can help you:

    Manage more than just servers
    Mix on-premise and cloud inventories easily
    Write playbooks in JSON
    Manage Windows machines
    and more...



--
Posted By Blogger to HDGEM at 3/29/2017 06:29:00 AM

[HDGEM] HelpSocial Open API

HelpSocial, a social media and messaging integration platform provider, has announced the launch of an updated version of the HelpSocial Open API.  The new HelpSocial Open API is modularly built and has been enhanced for improved performance, scalability, and security. The API provides access to all capabilities of the platform. The company has also updated its Connect Dashboard, a standalone Social CRM and command center, that is often considered "a visual menu of the Open API capabilities."

--
Posted By Blogger to HDGEM at 3/29/2017 06:27:00 AM

[HDGEM] Amazon Connect is a simple to use, cloud-based contact center service that makes it easy for you to deliver better customer service at lower cost.

This new service from Amazon Web Services is based on the same contact center technology used by Amazon customer service associates around the world to power millions of customer conversations. Setting up a cloud-based contact center with Amazon Connect is as easy as a few clicks in the AWS Management Console, and agents can begin taking calls within minutes.

Amazon Connect's self-service graphical interface makes it easy for non-technical users to design contact flows, manage agents, and track performance metrics – no specialized skills required. The service also makes it possible to design contact flows that adapt the caller experience, changing based on information retrieved by Amazon Connect from AWS services, like Amazon Redshift, or third-party systems, like CRM or analytics solutions. You can also build natural language contact flows using Amazon Lex, an AI service that has the same automatic speech recognition (ASR) technology and natural language understanding (NLU) th…

[HDGEM] How to Use Night Shift in Mac OS

Go to the  Apple menu and choose "System Preferences"Select "Displays" and choose the "Night Shift" tabPull down the "Schedule" tab and select either "Sunset to Sunrise" or "Custom" Next adjust the "Color Temperature" to suit your preferences, as you slide the dial you will notice a the screen warmth will change to preview the setting 

--
Posted By Blogger to HDGEM at 3/29/2017 02:48:00 AM

[HDGEM] There are three types of authentication

Something you know: a password, PIN, zip code or answer to a question (mother's maiden name, name of pet, and so on)Something you have: a phone, credit card or fobSomething you are: a biometric such as a fingerprint, retina, face or voice

--
Posted By Blogger to HDGEM at 3/28/2017 07:54:00 PM

[HDGEM] VisualVM includes a profiler that enables you to profile applications running on a local JVM.

Profiling an Application You access the profiling controls in the Profiler tab of the application tab. The profiler enables you to analyze memory usage and CPU performance of local applications.

Launch a local Java application. (Start the application with the -Xshare:off argument.)Under the Local node in the Applications window, right-click the application node and choose Open to open the application tab.Click the Profiler tab in the application tab.Click Memory or CPU in the Profiler tab. When you choose a profiling task, VisualVM displays the profiling data in the Profiler tab.

--
Posted By Blogger to HDGEM at 3/28/2017 01:59:00 PM

[HDGEM] Google disclosed their intent to deprecate and remove trust in Symantec-issued certificates

Google's notice says Symantec allowed at least four parties access to their infrastructure in order to issue certificates, but didn't oversee the granted access sufficiently as required and expected. "These issues, and the corresponding failure of appropriate oversight, spanned a period of several years, and were trivially identifiable from the information publicly available or that Symantec shared," Google's notice states.

--
Posted By Blogger to HDGEM at 3/27/2017 09:42:00 AM

[HDGEM] Cloud native applications are being developed and deployed following DevOps principles

IT organizations are changing the way modern applications are being built and deployed. Cloud native applications are being developed and deployed following DevOps principles, which mandate agile development, rapid-fire and continuous deployment, continuous integration, and much more. 

--
Posted By Blogger to HDGEM at 3/27/2017 09:27:00 AM

[HDGEM] Security researchers from Cybellum have discovered another technique cyber criminals can use to take over your computer.

The zero-day attack called DoubleAgent exploits Microsoft's Application Verifier tool, which developers use to detect and fix bugs in their apps. Developers have to load a DLL into their applications to check them, and Cybellum's researchers found that hackers can use the tool to inject their own DLLs instead of the one Microsoft provides. In fact, the team proved that the technique can be used to hijack anti-virus applications and turn them into malware. The corrupted app can then be used to take control of computers running any version of Windows from XP to the latest release of Windows 10.

--
Posted By Blogger to HDGEM at 3/27/2017 06:40:00 AM

[HDGEM] Mobile email messages

Every year the adoption of mobile devices continues to fly even higher than the year before. And when it comes to email marketing, more than half of messages are opened on mobile devices before they're ever seen on a desktop. In 2016, open rates reached 68 percent.

--
Posted By Blogger to HDGEM at 3/27/2017 04:23:00 AM

[HDGEM] Financial topics at home

While all parents thought that financial education was important to the well being of their children, few actively taught financial topics at home, or felt empowered or sufficiently skilled to do so.

--
Posted By Blogger to HDGEM at 3/26/2017 06:43:00 PM

[HDGEM] Got SHA-1 collision

Git stores all data in "objects." Each object is named after the SHA-1 hash of its contents, and objects refer to each other by their SHA-1 hashes. If two distinct objects have the same hash, this is known as a collision. Git can only store one half of the colliding pair, and when following a link from one object to the colliding hash name, it can't know which object the name was meant to point to.

Two objects colliding accidentally is exceedingly unlikely. If you had five million programmers each generating one commit per second, your chances of generating a single accidental collision before the Sun turns into a red giant and engulfs the Earth is about 50%.

--
Posted By Blogger to HDGEM at 3/26/2017 06:10:00 PM

[HDGEM] AdWords offers four different ad rotation settings

Optimize for clicks, optimize for conversions, rotate evenly, and rotate indefinitely.

While there are use cases for each of the four options, the recommended approach is either optimize for clicks or optimize for conversions.

If you're tracking conversions, you should optimize toward them. This option takes both clickthrough rate (CTR) and conversion rate into consideration to give preference to ads that are expected to provide more conversions.

--
Posted By Blogger to HDGEM at 3/26/2017 05:56:00 PM

[HDGEM] IntelliJ IDEA 2017.1 is available for download!

In addition to many important bug fixes, this massive update brings lots of improvements to supported languages, frameworks, and built-in tools.

Java 9: The latest builds of JDK 9 are fully supported, with assisted project import and coding assistance for editing module declarations. Built-in inspections validate module declarations and provide quick-fixes for adjusting project dependencies.
Java 8: Quick-fixes that help migrate for loops to Stream API calls have been improved and now support more sophisticated scenarios. We've also added a quick-fix that turns Stream API calls back into for loops, which is handy for debugging or exploring code.
Async-aware debugger: Async stacktraces is a new feature that substitutes parts of a stack trace related to asynchronous code execution with data captured from where that code is invoked. This helps you focus on what you're debugging. An improved Smart Step Into also supports asynchronous code and lambda expressions running on other…

[HDGEM] A London-based hacker group, calling itself the Turkish Crime Family, has claimed to have access to 250 million Apple accounts

A London-based hacker group, calling itself the Turkish Crime Family, has claimed to have access to 250 million Apple accounts
The hackers are threatening to reset the passwords on those iCloud accounts and remotely wipe iPhones if Apple doesn't pay a ransom by April 7. Those…
https://www.hqgem.com/a-london-based-hacker-group-calling-itself-the-turkish-crime-family-has-claimed-to-have-access-to-250-million-apple-accounts/

--
Posted By Blogger to HDGEM at 3/26/2017 01:43:00 PM