SMB Nation Blog

SMB Nation has been serving the Bainbridge Island area since 2001, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Top 5 open source tools for MySQL administrators

Look to these excellent tools to improve CLI and web admin, SQL queries, schema migration, and replication and recovery in your MySQL environment

free neon sign 100719704 large


For database administrators (DBAs), keeping databases running at peak performance can be a little like spinning plates: It takes agility, concentration, quick reactions, a cool head, and an occasional call out from a helpful onlooker. Databases are central to the successful operation of almost every application. As DBAs are responsible for an organization’s data, finding dependable tools that help them to streamline the database management process and ease day-to-day maintenance tasks is essential. DBAs need good tools to keep their systems spinning smoothly.

So what are the tried and trusted tools for MySQL administrators? Here I share my top five open source tools for MySQL administrators and discuss their value in the support of day-to-day MySQL administration tasks. For each of them, I’ve provided a link to the GitHub repository and listed the number of GitHub stars at the time of writing.


The Mycli project provides MySQL command line auto-completion and syntax highlighting. It is one of the most popular MySQL tools for administrators.

Security restrictions such as jump hosts and two-factor authentication leave many MySQL DBAs with command-line only access to their systems. In such circumstances, beloved GUI tools such as MySQL Workbench, Monyog, and others are not an option.

At the command line, much of the time is spent in a light-on-black terminal world. So one of the best things about Mycli is the richness of its syntax highlighting. This allows you, for example, to visually separate functions and operators from query strings in WHERE clauses. For a short, single-line query this may not be such a big deal, but it becomes a game changer when you work with queries that perform JOIN operations over more than a couple of tables. Am I doing the JOIN using indexed columns? Am I filtering using leading wildcards in my WHERE clauses? Mycli supports multi-line queries and syntax highlighting, which means you can home in on the sections that matter most when reviewing or optimizing queries. You can choose from a number of syntax highlighting color schemes or create your own.

The other killer feature of Mycli is smart completion. This allows to you pick out table and column names from a context sensitive list by entering just their first few characters. No more abandoning your current input to run SHOW CREATE TABLE because you forgot the name of the column you want in your WHERE clause!

Read More


Continue reading


Cutting-edge WiFi Distribution Solutions Accommodate Consistent Bandwidth Performance for More Seamless, Flexible, and Collaborative Wireless Small Business Environments —

HARRISBURG, PA – January 22, 2018 – D&H Distributing, a major provider of SMB and consumer technologies to the North American high-tech channel, wants its SMB resellers to take advantage of powerful “mesh” computing solutions. These offerings are making their way from the enterprise to Meshsmall office environments in the form of affordable, easy-to-install and manage solutions.
“Mesh” computing technologies feature a series of access points, or hubs, that distribute and balance a company’s WiFi signal throughout a facility. The systems reduce connectivity “dead spots” so an SMB network can perform more seamlessly, accommodating the roster of wireless and IP-based devices associated with an increasingly more sophisticated small business workplace—even across multiple floors of a single building.
Many regional offices have been forced to locate equipment and workstations within a certain proximity of their WiFi routers to ensure consistent connectivity. Yet today’s modern workplace involves workers who depend on a plethora of wireless devices, ranging from Bluetooth headsets, to tablets and smart phones, to portable speakerphones and high-performance notebook computers. In addition, bandwidth-heavy amenities such as IP surveillance systems or cloud-based storage and printing services create additional demands on bandwidth.
The same office environments often feature open floor plans and ad-hoc conference areas that can be set up on-the-fly, to encourage collaboration between personnel. SMB mesh computing solutions support this trend, allowing workers to take advantage of the collaborative communication these new open-office environments were designed to inspire.

For example, D&H carries the HPE OfficeConnect OC20 802.11ac, which can cluster up to eight access points. It’s a sophisticated yet cost-effective wireless solution that’s easy to set up and administer without significant technical expertise, allowing SMB companies to deploy robust and flexible WiFi of their own accord. The system is installed via a no-cost, straightforward mobile application that can be deployed in minutes, either via cell phone using an Android or iOS app, or through a cloud-based portal. Both the app and the web-based portal also facilitate easy remote network monitoring for the reseller.
The HPE OfficeConnect OC20 allows the business owner to conduct Internet filtering, regulating what sites employees may access and/or restricting adult content. And the solution’s simple remote management capability allows resellers to offer monitoring and troubleshooting via a managed services contract, creating incremental revenue opportunities, and allowing VARs to transition into a basic, hosted services offering.
In addition, D&H offers the popular Cisco Meraki family of wireless access solutions, which incorporates cloud-managed mesh networking into its powerful wireless access points. The Meraki products extend WiFi coverage to hard-to-wire areas and supports resilient, high-performance routing across facilities. These access points “self-configure” to automatically establish a high-performance, robust, and resilient network, without manual intervention or provisioning from the reseller.
The Meraki solutions offer a cloud-based controller interface that can be managed from anyplace with Internet access, and similarly offers an Android or iOS app for administration. This makes the solutions easily accessible, as well being a powerful and versatile mesh networking option.
D&H offers services to support customers in selecting the most appropriate solution for their business models, including assessment services; pre-sales support; and specialized training sessions including live trade show sessions, streaming webcasts, and on-demand presentations. Plus, resellers can take advantage of brandable brochure templates from D&H’s Partner Services Marketing library, including a dedicated piece on the Cisco Meraki products. VARs can use these materials to communicate the benefits of these high-performance WiFi solutions.
“Bandwidth requirements continue to grow as the contemporary SMB workplace incorporates more connected devices and platforms, and as we transition toward the delivery of digital services in almost every facet of business, from email exchange to storage to cloud-based printing and collaboration,” began Peter DiMarco, vice president of VAR sales at D&H. “Manufacturers such as HPE-Aruba and Cisco are now delivering robust, reliable, and cost-effective WLAN WiFi distribution to the small business community. Mesh computing is becoming a necessity in these work environments, to accommodate the increasingly mobile and digital paradigm we all enjoy. In the process, it’s creating ongoing opportunities for VARs and MSPs.”

About D&H Distributing
D&H Distributing believes the most important element of doing business is developing relationships for mutual success. The company continues to build upon its 100-year-old culture by providing its manufacturers, co-owners, and partners with the utmost customer care, consultative guidance, and multi-market expertise. As one of North America’s leading technology distributors, it delivers a wealth of enablement resources and hands-on support services that empower resellers in the IT channel.
The company engages with solution providers, integrators, and VARs to meet current business challenges, as well as forecast their evolving, real-world needs and prospects for lucrative growth opportunities. D&H maintains a special focus on independent VARs expanding their competencies in areas such as hosted and cloud services, the modern mobile workplace, comprehensive SMB server networks, and cross-market expertise across the small business, education, healthcare, and government verticals, to name a few. The company's value proposition includes professional marketing resources, a new transactional service model, dedicated Solutions Specialists, and a highly-lauded webcast training venue; plus reseller engagement events such as technology trade shows, roundtable opportunities, training “track” sessions, and hands-on "lab" sessions.
The distributor is headquartered in Harrisburg, PA, in the US and in Brampton, Ontario, in Canada. Additional warehouses are located in Atlanta, GA; Chicago, IL; Fresno, CA; and Vancouver, BC, Canada. Call D&H toll-free at (800) 340-1001, via, or follow the distributor’s Facebook and Twitter feeds, and @dandh.

Continue reading

IoT security needs a white knight

Jon Gold By Jon Gold
Senior Writer, Network World

wireless network internet of things iot thinkstock 853701554 100739367 large


Thanks to the Mirai botnet attacks, few people in the world of tech need a reminder that IoT devices remain a serious threat to enterprise networks. Still, more than a year after the botnet made headlines worldwide, IoT security remains mostly an idea, rather than a reality.

Such is the scope of the problem that Frost and Sullivan IoT research director Dilip Sarangan argues for governmental intervention. Sarangan says that, because the responsibility for IoT security is diffused across device manufacturers, network providers, software developers and many others, it’s difficult for the industry to make progress on all-encompassing standards.
“The only entity that has the ability to actually dictate what the minimum threshold is, unfortunately, is the U.S. government,” he said.

The difficulty in creating overarching standards mostly has to do with the fact that any given IoT implementation has a large number of moving parts, each of which may be administered by different organizations, or even by third parties. For example, a set of medical devices provided by company A connecting to a network provided by company B, running an application, originally written by company C and residing in company D’s cloud.

“Everyone talks about it like they’re going to provide end-to-end security, and there’s actually no way to do that,” said Sarangan. “You have no control over a lot of parts of an IoT solution.”

Read More

Continue reading

Epson Wins Two 2017 Best in Biz North America Awards

LONG BEACH, Calif. – Jan 16, 2018 – Epson, a leading provider of innovative business solutions, today announced it received two awards in the seventh annual Best in Biz North America Awards, the only independent business awards program judged each year by prominent editors and reporters from top-tier publications in North America. The Epson WorkForce® Enterprise WF-C20590 A3 multifunction printer (MFP) was awarded silver in the “Best New Product of the Year – SMB” category. The WorkForce DS-780N was also awarded bronze in the “Small or Medium Business Product of the Year” category.

Each year, Best in Biz Awards’ entrants span the spectrum, from some of the most innovative local start-ups to the most recognizable global brands. The seventh annual program was particularly hotly contested, with more than 650 entries from an impressive array of Epson Biz America Awards public and private companies of all sizes and from a variety of industries and geographic regions in the U.S. and Canada. Best in Biz Awards 2017 honors were presented in 65 categories, including Company of the Year, Fastest-Growing Company, Most Innovative Company, Best Place to Work, Support Department, Executive of the Year, Most Innovative Product, Best New Product, App, Event and Website of the Year.

“Epson emphasizes the importance of understanding the evolving business market and delivering products that can make our customers more efficient and profitable,” said Larry Trevarthen, director of Business Imaging, Epson America, Inc. “We are honored to be chosen by Best in Biz North America Awards for two solutions across multiple business categories, which underscores our continued commitment to delivering solutions that meet the industry and our customer’s needs.”

About the Epson 2017 Best in Biz North America Awards Winners

  • WorkForce Enterprise WF-C20590: Powered by innovative PrecisionCore Line Head Technology, the WF-C20590 is Epson’s first high-speed multifunction color line head printer delivering brilliant-quality output. With breakthrough speeds up to 100 ISO pages per minute3, this powerful A3 MFP offers business productivity and versatility for large workgroups and departments within SMB and corporate environments.
  • Workforce DS-780N: Designed for greater efficiency in heavy-use environments, the Epson DS-780N delivers high-quality scans with speeds of up to 45 ppm/90 ipm1 plus a 100-page ADF. With a programmable touchscreen, ease-of-use and document management while delivering fast scan speeds, the DS-780N offers enhanced connectivity for versatile scanning.

Since 2011, winners of Best in Biz Awards have been determined based on scoring from independent judging panels composed of prominent editors and reporters from some of the most respected newspapers, TV outlets, and business, consumer, technology and trade publications in North America. Best in Biz Awards’ uniqueness stems, in part, from this distinct composition of its judging panels, allowing it to best leverage the judges’ unparalleled expertise, experience and objectivity to determine award winners. The 2017 judging panel included: Accounting Today, AdWeek, Associated Press, Atlanta Tribune, Business News Daily, Consumer Affairs, Entrepreneur, eWeek, Forbes, Harvard Business Review, Healthcare Innovation News, Inc., Investment Advisor Magazine, Laptop, MediaPost, Pittsburgh Business Times, Security Products Magazine, Wired, WLRN and Yahoo Tech.

For a full list of gold, silver and bronze winners in Best in Biz Awards 2017, visit:

About Best in Biz Awards
Since 2011, Best in Biz Awards, Inc. has made its mark as the only independent business awards program judged each year by a who’s who of prominent reporters and editors from top-tier publications from North America and around the world. Best in Biz Awards honors are conferred in two separate programs: North America and International, and in 65 categories, including company, team, executive, product, and PR and media. For more information, visit:

About Epson
Epson is a global technology leader dedicated to connecting people, things and information with its original efficient, compact and precision technologies. With a lineup that ranges from inkjet printers and digital printing systems to 3LCD projectors, smart glasses, sensing systems and industrial robots, the company is focused on driving innovations and exceeding customer expectations in inkjet, visual communications, wearables and robotics.

Led by the Japan-based Seiko Epson Corporation, the Epson Group comprises more than 80,000 employees in 86 companies around the world, and is proud of its contributions to the communities in which it operates and its ongoing efforts to reduce environmental impacts.

Epson America, Inc., based in Long Beach, Calif., is Epson’s regional headquarters for the U.S., Canada, and Latin America. To learn more about Epson, please visit: You may also connect with Epson America on Facebook (, Twitter (, YouTube (, and Instagram (

Continue reading

10 Best SEO Audit Tools for Websites & Blogs

seo audit tools


SEO Audit Tools make it easy to perform an SEO Audit of Websites & Blogs automatically. Otherwise, doing an SEO Audit can be very time consuming and involve tons of complicated manual checks. Luckily, there are plenty of good website audit tools available online. Here’s a list of Top 10 SEO Audit Tools that you can use for your websites & blogs.

10 Best SEO Audit Tool for Website SEO Audit

It’s important to remember that there is no one-size-fits-all SEO Auditing Tool for Websites. You need to try out each of these good SEO Audit tools to see if they fit your requirements, before picking a website auditing tool to improve your search engine results.

1. SE Ranking Website Audit

SE Ranking is an amazing SEO Audit Software for web developers, content writers & web designer. It identifies all Website Errors in minutes and provides a list of tasks to improve website SEO performance. It performs SEO Audit of your website based on more than 70 parameters such as On-Page SEO, Meta Tags, Content, Domain Checks, Image checks, Link Analysis, Usability, Mobile SEO Optimization and Website Technologies.

Here’s an SEO Audit Report Sample

seranking website audit

It generates a detailed and free SEO Audit Report that provides a website audit checklist of Errors, and Tips to improve SEO performance of your website & blog. After completing the SEO Audit Analysis, you can even export the Audit Report as a PDF or email it.

Read More



Continue reading