Showing: 1 - 10 of 212 RESULTS
Cooking And Homemaking - Hearty Fall Pasta Casseroles

Hearty Fall Pasta Casseroles

As temperatures cool off, we turn our thoughts towards warming pasta casseroles that provide nourishment while being easy and quick to make. These autumn-inspired meals can provide both nourishment and tasty nourishment all in one satisfying package! This delicious sausage pasta casserole comes together quickly in just 35 minutes! Try using smoked mozzarella for extra umami flavor and to add an smoky, savory flair. Perfect as a weeknight dinner option for health-conscious eaters! Chicken Alfredo Pasta Casserole If you’re craving comforting food, few dishes top creamy pasta and chicken as the ideal comfort dish. This cheesy chicken Alfredo pasta casserole …

Technology - Data Catalog Vs. Data Dictionary Vs. Business Glossary

Data Catalog Vs. Data Dictionary Vs. Business Glossary

The differences between a data catalog and a data dictionary are vast, and the choices of a single database can be overwhelming. The data dictionary depends on the data that is stored in the database. As a result, changes in data are likely to affect the dictionary as well. However, a data catalog will always be the most accessible reference point when the business glossary is not available. These differences are crucial in determining whether or not a business glossary is appropriate for a specific situation. Alation An Alation Data Catalog is a powerful metadata organization tool that scours the …

Technology - Netezza / PureData - Casting Numbers to Character Data Type

Netezza: Casting Numbers to Character Data Type

I noticed that someone has been searching for this example on my site, so, here is a quick example of how to cast number data to a character data type.  I ran this SQL example in Netezza and it worked fine. Basic Casting Conversion Format cast(<<FieldName>> as <<IntegerType_or_Alias>>) as <<FieldName>> Example Casting Number to Character Data Type SQL SELECT—-Casting Integer to Character Data Type ————— SUBMITDATE_SRKY as  SUBMITDATE_SRKY_INTEGER, cast(SUBMITDATE_SRKY as  char(10)) as Integer_to_CHAR, cast(SUBMITDATE_SRKY as Varchar(10)) as Integer_to_VARCHAR, cast(SUBMITDATE_SRKY as Varchar(10)) as Integer_to_VARCHAR, cast(SUBMITDATE_SRKY as Nchar(10)) as Integer_to_NCHAR, cast(SUBMITDATE_SRKY as NVarchar(10)) as Integer_to_NVARCHAR —-Casting Double Precision Number to Character Data …

Technology - The Best Programming Text Editor

The Best Programming Text Editor

Whether you are a rookie programmer or a seasoned developer, you need a reliable text editor to increase your performance, productivity, and efficiency. The truth is, text editors are the lifeblood for many development teams, programmers, and coders across the world. But these editors are not created equal! A good text editor should help you write neat and accurate code that is devoid of formatting issues. It should also have a fast, flexible, and functional interface that allows you to examine and edit your code on the go. Additionally, the programming text editors should offer robust interoperability between different OS …

Technology - Denodo Data Virtualization Project Roles

Denodo Data Virtualization Project Roles

A Denodo virtualization project typically classifies the project duties of the primary implementation team into four Primary roles. Denodo Data Virtualization Project Roles Data Virtualization Architect Denodo Platform Administrator Data Virtualization Developer Denodo Platform Java Programmer Data Virtualization Internal Support Team Role To Project Team Member Alignment While the denodo project is grouped into security permissions and a set of duties, it is import to note that the assignment of the roles can be very dynamic as to their assignment among project team members.  Which team member who performs a given role can change the lifecycle of a denodo project.  …

Navigating Netezza Table Distribution Key Practices: A Guide for Beginners

Navigating Netezza Table Distribution Key Practices: A Guide for Beginners

Transitioning from traditional database systems to Netezza can be a bit like learning to drive on the opposite side of the road. What you knew about indexes and data organization may suddenly seem upside down. In Netezza’s world, the focus isn’t on grouping data through indexes but on spreading it out. This spread, facilitated by an effective distribution key, leverages Netezza’s zone map functionality to boost performance. If you’re new to this concept and coming from a background in other database systems, you might find the optimization of distribution keys somewhat counterintuitive. Fear not, as we delve into some of …

Technology - An Introduction to SQL Server Express

An Introduction to SQL Server Express

If you use SQL, several options are open to you, from the Enterprise editions down to SQL Server Express, a free version of Microsoft’s main RDBMS (Relational Database Management System), SQL Server. SQL Server is used to store information and access other information from multiple other databases. Server Express Edition is packed with features, such as reporting tools, business intelligence, advanced analytics, and so on. SQL Server Express 2019 is the basic version of SQL Server, a database engine that can be deployed to a server, or you can embed it into an application. It is free and ideal for …

Technology - Why Use DuckDuckGo Instead of Google?

Why Use DuckDuckGo Instead of Google?

Despite being the top search engine, Google is not a great place to go for privacy. It is well known that the company tracks its users and knows their faces and their names. The site also has a lot of advertisements, and it has been found that 75% of the top million websites on the internet have at least one Google tracker installed. While not all of these ads are malicious, it is important to be careful when clicking on pop up ads. DuckDuckGo is a privacy-focused search engine Privacy-focused search engines don’t track keywords and collect no personal data …

Column Data Classification

Column Data Classification

When analyzing individual column data, at its most foundational level, column data can be classified by their fundamental use/characteristics.  Granted, when you start rolling up the structure into multiple columns, table structure and table relationship, then other classifications/behaviors, such as keys (primary and foreign), indexes, and distribution come into play.  However, many times when working with existing data sets it is essential to understand the nature the existing data to begin the modeling and information governance process. Column Data Classification Generally, individual columns can be classified into the classifications: