AUTO_DROP Statistics

When Companies Fail

The challenge of software pervading all aspects of our lives and inside many products is going to be create an interesting world when companies fail.

Are We Dinosaurs?

Let's talk about the elephant in the room right up front. Yes, I'm old. I remember when Buck Woody was a little tyke on the day the last of the Tyranosaurs died (I'm older than Buck). So, I'm not asking if I'm old. Yes. I'm old. No, I'm asking if that massive meteor strike over […]

The Vast Expansions of Hardware

Today Steve looks back at hardware changes over time.

The PASS Data Community Summit Session Schedule is LIVE!

Join over 170 global data experts offering more than 150 sessions designed for all skill levels. Explore the schedule to plan your days on-site, secure your ticket, and book your travel before prices increase.

EsProc SPL and SQL, Complimentary , But Different Technologies

Have you ever surfed the internet and felt overwhelmed by personalized advertisements that appear to know your every desire? Have you ever been amazed at how accurate some weather forecasts can be? These actions are based on data processing. EsProc SPL and SQL (note, SPL stands for Structured Processing Language and SQL stands for Structured Query Language). SQL is a major language widely encountered and used for data manipulation within relational databases. While EsProc SPL is another effective tool for data processing, especially suited for complex computations and in-memory operations, it is less commonly encountered.

Setup Excel as Front End Application for SQL Server

In this article, we walk through how to set up a simple Excel interface to work with SQL Server data to insert, update, delete, and select data.

Concat Addition

Level 3 of the Stairway to Synapse Analytics: Analyze Data Using a Spark Pool

Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creation of the Synapse Workspace. In Level 2, data analysis was done on Data Lake files using Serverless SQL Pool. In Level 3, I will analyze data from the files uploaded in Data Lake container using a Spark Pool. I will […]

LIKE Constraints

In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.