Oct 18, 2019 | Data Encryption, Data Security, Data Warehousing, healthcare, Tech Tips
By: Ken Adams Data security is a vital part of successful data warehousing and business intelligence today, and a critical step in successfully securing a data warehouse is implementing proper data security levels. From a legal perspective, related...
May 20, 2019 | Tech Tips, Web design, Web Development
By: Phillip Sharpless Website Deployment Back in the Day Deploying a website was once upon a time a rather straightforward process. You simply copied or uploaded all your site’s various core files (HTML, JavaScript, etc.) and any assets they might...
Apr 30, 2019 | Big Data, Business Intelligence, Data Warehousing, Tech Tips, Technical Information
By: Jeff Levy Hadoop Distributed File System Overview This step-by-step tutorial will walk you through how to install Hadoop on a Linux Virtual Machine on Windows 10. Even though you can install Hadoop directly on Windows, I am opting to install Hadoop...
Apr 10, 2019 | Business Intelligence, Data Visualization, PowerShell, Tech Tips, Technical Information
By: Mason Prewett Introduction As an admin of many server types, I often encounter the issue of a machine running out of disk space. Tracking the culprit folder that was hogging up disk space used to be a troublesome, manual effort. However, I recently coded a...
Mar 22, 2019 | Consulting, Microsoft, SQL Server, Tech Tips, Technical Information
By: Jason E. Bacani Introduction When working with SQL Server Agent, one of the many useful features is the ability to schedule SQL Agent Jobs. The frequency and scheduling of such jobs can be as fancy and as specific as needed, and can be coordinated with...
Mar 15, 2019 | Business Intelligence, Data Visualization, SQL Server, Tech Tips, Technical Information
By: Andy Kim Introduction If you ask a SQL professional to name some data types, you might hear: varchar, int, datetime, decimal, or something to that effect. Rarely do people mention the spatial data types of: geography and geometry. This is because most SQL...
