Open Database Connectivity (ODBC) is designed to expose database capabilities via SQL. It improves the analytics process by giving users real-time access to data from multiple sources. Data can be transformed, within applications such as Excel and PowerBI, into reports and dashboards. Excel macros and scripting languages like PowerShell can automate the creation and distribution of reports via email, web page, or as saved files.

Connecting data to applications that are familiar to users, such as Excel, saves time and the expense of developing interfaces in proprietary database-driven platforms. Modern web-based platforms also have performance and interface limitations that can be removed by accessing data directly in desktop applications. In this example, you can see the web interface is limited compared to the Excel sheet, which has additional formatting and filters applied.

Web Interface

Excel Sheet

Upon opening the linked excel , sheet is populated with current data almost instantly.

Bluebeam Drawings optimizes and distributes the latest plans for mobile viewing in the field. Drawings can be viewed for free on any device. Uploading files requires Bluebeam Revu with maintenance. Download

Boolean search

Utilizes special words or symbols to limit, widen, or define the scope of your search.

These include: AND, OR, NOT, and NEAR, as well as the symbols + (add) – (subtract) ” ” (quote).

A document can be easily converted to a fillable PDF form using either Adobe Acrobat Pro DC or Bluebeam Revu eXtreme (this feature is not available with Revu CAD or Revu Standard). If you are starting with a Word or Excel file, first convert that to a PDF, then follow these instructions:
(more…)

When collaborating on a document in the cloud, it is advisable to use common fonts. A custom font loaded on your local computer, will be replaced when the recipient either does not have the font installed, or opens the file in their browser-based 365 Apps. This can lead to substantial changes in the content of the document. (more…)

Using keyboard shortcuts will greatly enhance your productivity.

After updating your iOS you may experience issues such as:

• Attachments not downloading.
• Calendar invites showing up as .ics files.
• Contact searches running very slow.
• Unread items showing incorrect count.
• Email downloading only the first few lines. (more…)

For Verizon customers, this app does a good job of blocking unsolicited calls. It provides real-time alerts and automatically blocks known offenders. The$3 subscription is not necessary for the basic level of protection.

Download

Wireless headsets can be a great enhancement to your daily productivity. The Jabra Engage 75 connects to your PC, Mobile and desk phone. For those that travel the Jabra Evolve2 85 is a great over the ear solution.
(more…)

Teams is a great tool for real-time collaboration.  It allows your office to call, chat and meet one place. Chats are persistent and can be secured to limit access. (more…)

Workstation class laptops usually have two GPUs. The onboard Intel integrated GPU and a dedicated NVIDIA  graphics card. When this is the case you need to make sure that your high-performance applications use the NVidia GPU, rather than the low-performance Intel integrated GPU.

To ensure optimal application performance make the following adjustment: (more…)

Beginning with iOS 13 you can connect a Bluetooth mouse or Bluetooth keyboard & mouse combo to your iPad. Here are the steps:

1. Go to settings > Accessibility > AssistiveTouch > Devices > Bluetooth Devices
2. Place your device in pairing mode and select it from the iPad menu.
3. Go back to AssistiveTouch and turn it on.

(more…)

In order to protect yourself on the Internet, you need to be proficient at locating and identifying domain names. This is because, emails and attachments can be used to redirect you to sites that are loaded with bad content. Make sure you can:

1. Verify the email sender.
2. Verify any link contained in the message or within an attachment before clicking on it. (more…)

The “Grandparent Scam” is a particularly disturbing scam perpetrated on the elderly. The criminal contacts the Grandparent, pretending to be a grandchild in trouble with the law or in desperate need of cash for a medical bill. They then claim that the matter cannot be discussed with other family members (red flag). Victims report receiving calls late at night, adding confusion and a sense of urgency. The preferred mechanism of money movement is wire transfer (red flag), and now via courier, sent to the victims home. (more…)

Applications like InDesign and AutoCAD interlink files as you create content. This allows teams to share workloads, provides more efficient file storage and adds greater stability to the software platforms. These linked files can create an issue when multiple entities work on the same file or when content is moved to a new location. The solution to this problem is to use relative paths. (more…)

This is the mobile version of Keepass, our recommended desktop password management tool. You can use iTunes on your PC or Mac to transfer your password database to your iOS device periodically. This will give you mobile access to your passwords without ever placing them at risk in the cloud. This can also serve as a backup location for your Keepass database. (more…)

Grammarly is a writing assistant that can spell-check your web-based content as you write. It can be loaded as a firefox browser plugin for free. It offers advanced functionality, with a monthly subscription, to evaluate your writing in the areas of tone, engagement, clarity, and grammar.

When creating an e-mail signature in Outlook or sharing a word or excel file, it is important to remember that fonts are not common across all platforms. If you use a font that does not exist on the recipient’s device, your signature or file appearance will change as the font you selected is replaced with a default font. This is mitigated on web-based platforms (e.g., a web site or blog) by using fonts that load to the user’s device in real-time from the cloud (1000 to choose from). (more…)

When you have a weak wireless signal, you can try and boost it in a couple of ways:

1. Make sure the wireless access point (WAP) closest to you is not obstructed. Clear away any dense objects within a foot of the device. You might also reposition it to boost the signal.
2. Make sure your device in not in power save mode (yellow battery icon on iOS). It can be disabled in Settings > Battery > Low Power Mode: set to off. (more…)

Ever want to watch a movie with your kids without them getting too scared or without the profanity and sexual scenes? This subscription based app works with your existing streaming apps. It can filter out content with very granular options. (more…)

A business may be held liable for all or a substantial portion of any loss when checks are stolen or altered. Positive Pay is an automated check fraud detection service offered by most banks. It matches the payee, check number, and dollar amount of each check presented for payment against a list of checks issued from your accounting system. All three components of the check must match exactly or the check will not be paid. (more…)

Tips, from the FBI, to avoid becoming a victim of cyber fraud:

Do Not

• Do not give unknown, unverified persons remote access to devices or accounts.
• Do not communicate with unsolicited email senders.
• Do not act in haste. Criminals create a sense of urgency to produce fear and lure the victim into immediate action. (more…)

There is a great deal involved in maximizing the performance of your laptop or phone battery. GPS, Temperature and screen brightness all play a role. This Page from Apple details how to optimize each device.

Whether you are in a hotel, airport, or coffee shop, WiFi can be spotty. The most common cause is the requirement for you to agree to an acceptable use policy on each device. This must be done before you can connect to your email or VPN. To do this, launch your browser and go to a new page. At this point, you will be redirected to accept an agreement, or in some cases pay for access. Once you have joined one of these restricted networks, your device will always automatically reconnect in the future; (more…)

Apple announced the new features of iOS 13 More here… Do not be the first to upgrade. Turn off Automatic Updates: Settings > General > Software Update > Automatic Updates > Off

Your current Illinois driver’s license will not be accepted at airports, military bases and secure federal facilities after Oct. 1, 2020. You can obtain a REAL ID card or use a passport after that time. To see what documents you need to apply for a REAL ID, visit the REAL ID Interactive Checklist. All Driver Services facilities are issuing REAL IDs, with the exception of mobile units and express facilities. To check your license look for a gold star at the top right. (more…)

Hackers are using the familiar Apple settings icon to trick users into hacking their own iOS devices. As I discussed in a previous post, this can permanently destroy your device. If you ever see the settings icon and a request to install, confirm or cancel, do not click any response presented. Rather, you should immediately close your app. If the message returns upon reopening the app, contact IT support. (more…)

The U.S. Postal Service just fixed a security weakness that allowed anyone who has an account at usps.com to view account details for some 60 million other users, and in some cases to modify account details on their behalf. This would have been less of an issue before they released their latest service called Informed Delivery, which allows users to see the exterior of their mail. With this information, criminals can access private details and target you for fraud.

Office has a new look if you are on Office 365. One advantage that Office 365 offers is real-time access to the ever growing list of features that the product receives on an ongoing basis. Microsoft has also released its on-premise version of Office 2019

Attackers exploited a vulnerability in Facebook’s code that impacted “View As” a feature that lets people see what their own profile looks like to someone else. This allowed them to steal Facebook access tokens which they could then use to take over people’s accounts.

The next generation of cellular known as 5G is being rolled out on October 1. Verizon is first in the world to provide a commercial 5G service, with plans for rapid broadband internet, and 5G mobility service More Here …

Remote administration tools, such as Remote Desktop Protocol (RDP), as an attack vector has been on the rise since mid-late 2016 with the rise of dark markets selling RDP Access. Malicious cyber actors have developed methods of identifying and exploiting vulnerable RDP sessions over the Internet to compromise identities, steal login credentials, and ransom other sensitive information. (more…)

Your iPhone is capable of making higher quality voice calls with VoLTE. The quality improvement comes from increasing the bandwidth used to carry your voice, relative to a traditional cellular call. To enable this go to Settings > Cellular > Cellular Data Options > Enable LTE > Select Voice & Data

OneNote is a virtual notebook, with incredible search capabilities, that synchronizes across all your devices and between multiple users in real time. A universal platform, it works on Windows, Mac, iOS, Android, and Online. Everything is stored as a separate element so markups can be removed, files or images can be saved or moved. Pages are a limitless whiteboard that can accept markups, tags, MS Office and 3rd party files, tables, images, video, audio,  web elements and screen clippings. Here are our detailed instructions..

Did you know you can use your iPhone, or iPad with cellular service, as a backup internet connection. You need to set it up before you loose Internet service. (more…)

Capturing a unique perspective of a project is easier than ever with the use of a drone. Services such as Droners.io connect you with pilots from around the country, making capturing those images very easy and affordable. Costs range from $40-$150 depending on the scope of your project. (more…)

Today the greatest threat to company security is the email vector. KnowBe4 provides security awareness training and simulated phishing attacks to test employee response to manage the continuing problem of social engineering.

Did you know that prices on Amazon change hourly. CamelCamelCamel.com tracks prices and can send alerts when they are at their lowest. Browser Plug-ins help simplify the service.

There are a multitude of services that are built specifically for storing your passwords. I’d like to briefly delve into why it is foolish to use any of them.

First of all, there are specific instances of these sites being hacked, for obvious reasons. If you store all the gold in one bank, that’s where the robbers are going to go. (more…)

Should you get a pop-up like this one. Do not follow the advice in the window, and in particular, do not call the number in the window. Just close the browser immediately. DO NOT click on any part of the window, as this can trigger a virus installation. If the pop-up is preventing you from closing the browser, then reboot your computer. Also, make a mental note of the site you were visiting when the alert popped up. Very often it will be a news site or a content aggregation site; the type of site with lots of ads in the borders or strewn throughout the articles. (more…)

Sketchup Make is a free version of SketchUp, however, the license is not for commercial use. Employees of our clients will often unknowingly request that we install software that has similar limitations. These requests are not intended to do harm, but they can be costly. (more…)

When specifying storage for a server-class machine, it’s important to understand that the drives within the system will be running 24/7 for the next 4-5 years. Because of this, the equipment used must be highly reliable. In order to enhance this reliability and fault tolerance, as well as the performance, various RAID (Redundant Array of Independent Disks) configurations are used.

• RAID 1 is a mirrored set of drives, should one fail, the second drive has a full copy of your data. In a normal operating state, the mirror also provides faster access when data is being read, as the data can be read from both drives simultaneously. RAID 1 is typically used for the operating system partition of the server.
• RAID 5: in this configuration,  data is spread across (striping) 3-?? drives (depending on the chassis drive capacity) and a checksum is created on one additional drive. Should one drive fail, the data on the missing drive is calculated from the checksum and remaining drives. This is typically used for large capacity storage. It is not recommended to place more than 8 drives in a RAID 5 array.
• RAID 10: in this configuration,  data is spread across 4-?? drives (depending on the chassis drive capacity) and a checksum is created on one additional drive. Should one drive fail, the data on the missing drive is calculated from the checksum and remaining drives. This is typically used for large capacity storage. It is not recommended to place more than 8 drives in a RAID 5 array.
• Global hot spare: an unused drive designated to rebuild the array in real time in the event of a failure. When one of the drives is predicted to fail, or it fails, this drive takes its place, ensuring the integrity of the data and continued operation in the event of failure.

Calculate Capacity

To calculate capacity for RAID 1 configurations, multiply the size of one of the drives by 0.8. This will gie you the usable data storage capacity for that drive.

To calculate capacity for RAID 5 configurations, subtract one from the number of drives in the RAID 5 array, then multiply that number times the capacity of each drive, then multiply that result by 0.8.

The global hot spare capacity is not included in either calculation, as it is unavailable for data storage.

Keeping your family safe on the Internet is a moving target. The Internet brings technology into our lives, but like the Gutenberg Press, its original purpose has been corrupted. If left unchecked, it will influence the very character of your children. To this end, I have a number of technologies and insights that can aid you in protecting your loved ones. In addition, scammers are aggressively targeting the elderly. (more…)

Passwords should never be stored in clear text, Excel or in the cloud. These are easy targets for viruses and hackers. KeePass is an open-source program that will store your passwords in an encrypted file on your Mac or PC. A pin or password is used to access your data. You can also load this directly to a mobile version of the program without the data ever touching the cloud. KeePass will actually speed your access to web-based accounts (more…)

A great website that walks you through complicated repairs. They have detailed manuals and sell tools and parts to fix may items including iOS devices.

Doceri allows you to mirror and control any PC or Mac from a wirelessly connected iPad.  It is also an interactive whiteboard that can be used to create a presentation, insert images, save and edit and record a screencast video that can be saved and shared. It works with any software as the makeups are actually being done in a separate space in front of your computers software. (more…)

If you need to retrieve voicemail from your cell phone, when you do not have access to your phone. Begin by calling your mobile number from another phone. When you hear your voicemail greeting, press the # key. This will interrupt the greeting and prompt you for your voicemail password. It is important that you know the voicemail password as you will need your cell phone to reset it. (more…)

4K monitors are taking over, but there are a number of pitfalls when implementing them.

Video cards: Even a lightweight card a NVidia Quadro NVS 295 (Passmark 103) will let you run at 4K resolution, but the PC is unusable. A more typical production card used by our architecture clients is the NVidia Quadro K2000 (Passmark 1672). The K2000 had no problem running a Samsung 75″ TV, and produces a fantastic picture. (more…)

Did you know you can enable your Out of office message from your iPhone (more…)