QueBIT Value
How Do I Use PostgreSQL’s JSONB Data Type to Store and Search JSON Data?
Forensic Files is a documentary-style, true crime series which reveals how forensic science is used to solve violent crimes, mysterious accidents, and even outbreaks of illness. Being a fan and most likely having watched all of the episodes in the series (more than once!) I was inspired to build a database to be used as…
Read MoreWhat Is MariaDB and How Do I Set It Up and Use It on Microsoft Azure?
MariaDB, created by the original developers of MySQL, is an open source relational database management system that is a compatible, literal “drop-in” replacement for the widely used MySQL database technology. MariaDB offers more and better storage engines which are designed to efficiently manage data files, the data, and the index caches. NoSQL support, provided by Cassandra, allows you to run…
Read MoreHow Do I Build and Run a Simple Data Integration Package Using SQL Server Integration Services (SSIS)?
SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You can use Integration Services to perform a variety of tasks such as maintaining data hubs that serve Planning Analytics or other enterprise applications. The following outlines the process of creating and deploying a working SSIS package that takes…
Read MoreHow Can I Create a Table of Contents in Excel to Easily Navigate Workbooks with Many Tabs?
Have you ever opened an Excel workbook and been surprised by the number of sheets it contains? Perhaps you are looking for something, or don’t know where to begin? This article shares a great trick in Excel if you need to see at-a-glance what all the tabs are in a workbook. You can build your…
Read MoreWhat Is Azure Query Performance Insight and How Can It Help Me Analyze and Optimize Database Queries?
Query Performance Insight proposes to provide “intelligent” query analysis for single and pooled (databases in a pool are on a single server and share a set number of resources ) databases. It identifies those queries that consume the most resources as well as the longer-running queries. This helps find which queries to optimize to improve…
Read MoreWhat Is Azure Data Factory and How Do I Use It to Build and Run Simple ETL Pipelines in Azure?
Since I’ve worked with SQL Server Integration Services (SSIS) off and on for a while, I have been anxious to explore Azure Data Factory (or ADF) to see what the differences are and how it stacks up. While SSIS may be a familiar ETL tool for on-premises work, Azure Data Factory (defined as a “platform…
Read MoreGather data from an API using the Script source node
The following article outlines how Euclid Studio can be used to request data from an API and process it so it can be used in the system. This requires some knowledge of Python coding that is used within the Script source node and how APIs function. APIs usually have associated documentation that describes how to…
Read MoreHow Can I Create and Use Custom Shape Maps in Power BI Desktop to Visualize Regional Data?
The objective of this exercise is to explore the use of Microsoft Power BI Desktop (version 2.98.1) to create a map visualization, so, let’s start by answering the question: what is a map visualization? Map visualizations are used to analyze and display geographically related data and present it in the form of a map. This…
Read MoreUsing Azure Data Studio Notebooks to investigate variable correlations
The objective of this exercise is to demonstrate creating an Azure Data Studio (ADS) Notebook using Python to query SQL Server and investigate correlations between variables. Variable correlation can be key to increasing the accuracy of a forecast or predicting potential outcome scenarios. What is an Azure Data Studio Notebook? Azure Notebooks is a Microsoft…
Read MoreHow Do I Use Symmetric Encryption in SQL Server to Encrypt and Decrypt Data?
There is a very helpful article describing how to encrypt a column of data in a relational database by using symmetric encryption (sometimes known as column-level encryption, or cell-level encryption) using Transact-SQL found here: https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-ver15. After reading the article, I felt like working-through the provided examples myself in order to dig a bit deeper into…
Read More