Learning NoSQL

NoSQL is an option for a database platform and Steve wonders if you can discuss and debate the use of NoSQL for your business partners? Or are you going to learn more? He is.

Kickstart the year with our free Livestream! Navigating the database landscape in 2024

The key finding from our annual ‘State Of’ survey is that there’s a need for skill diversification to keep up with the pace of technological advances in IT world.

How will this skills gap affect you?

Whether you’re just starting out in your career, you’re a seasoned data professional or you’re a senior IT leader wanting to stay ahead of business growth, join our free livestream on January 23rd.

Redgaters Steve Jones, Ryan Booz and Beca Parker will introduce key findings from the survey and offer their thoughts on the big changes coming in 2024 and what you can do to thrive in this changing landscape.

Two-Dimensional Interval Packing Challenge

Packing intervals is a classic SQL task that involves packing groups of intersecting intervals to their respective continuous intervals. In mathematics, an interval is the subset of all values of a given type, e.g., integer numbers, between some low value and some high value.

A Simple Method to Load Excel Data

Learn how a C# script can easily load data from Excel into SQL Server.

Portable Data Storage

Today Steve wonders if the technology for storage and data transfers has superseded the need for portable drives.

Eager Aggregation in SQL queries

Aggregation is a widely used way to summarize the content of a database. It is usually expressed with GROUP BY clause or just using aggregate functions (like COUNT or SUM). When the database engine executes a query with aggregations, it produces individual rows need to compute the required output and then performs the aggregation as (almost) last step. We discuss in this article how to re-write a query manually so that the order of operations will be different and when it can be beneficial.

Play To Your Strengths

I really enjoy playing with radios [ed: we know, you won't shut up about it]. Something as simple as checking in to a local net (basically saying hi to a bunch of people on the radio) is fun. However, there's so much more to it. In the last few weeks I've been testing a new […]

Continuity Across Restarts

A cloud version of Aurora MySQL has added support for the buffer pool to survive restarts of the database engine. Steve thinks that's an interesting technology, which could be helpful.

Dimensional Modelling Case Study Part 1 - Age Group

Learn how you can handle dimensional modeling in a data warehouse when your data uses different categorization for ages.

Counting more efficiently

Nearly a decade ago, I wrote a post called “Bad habits : Counting rows the hard way.” In that post, I talked about how we can use SQL Server’s metadata to instantly retrieve the row count for a table.