12 April 2024
12 April 2024

Snake draft sorting in SQL Server, part 1

I recently had a restore job where I needed to split the work up into multiple parallel processes (which I’ll refer to here as “threads”). I wanted to balance the work so that the duration was something significantly less than the sum of the restore times. Imagine a job that loops through and restores each … Read more
11 April 2024
11 April 2024

How to Use Any SQL Database With Rust

0
0
Rust is emerging as a frontrunner for ensuring memory safety without sacrificing performance. Its growing popularity isn’t solely based on the “fearless concurrency” mantra but also on its expanding ecosystem that fosters integration with various technologies. A domain Rust proves to be formidable is database interaction, and a pivotal player in this realm is the … Read more
0
0
08 April 2024
08 April 2024

Using Common Table Expressions: Transforming and Analyzing Data in PostgreSQL, Part 2

In the first article in this transforming data series, I discussed how powerful PostgreSQL can be in ingesting and transforming data for analysis. Over the last few decades, this was traditionally done with a methodology called Extract-Transform-Load (ETL) which usually requires external tools. The goal of ETL is to do the transformation work outside of … Read more
04 April 2024
04 April 2024

Building a Culture of Data

One of the major trends in enterprise computing, and really in enterprises themselves is an increased emphasis on data. My career has always revolved around data, but this is a new focus for many parts of the organization. Even business units that traditionally don’t care about data realize that access to more, and better, data … Read more
29 March 2024
29 March 2024

SQL Logic

In this article, I will discuss the history and thinking behind several types of logic that are typically associated with writing relational database code. Because of how relational databases implement NULLs, it definitely can make some processes more complex than expected by may programmers (inexperienced and experienced alike!) Three Valued Logic Missing or UNKNOWN values … Read more

Cloudfare Turnstile, A New Way To Prove You Are Real

0
1
    This article describes the recommended way to integrate Cloudflare Turnstile into a React application. When I first heard about Cloudflare Turnstile, I remembered the New York City subway entrances. After all, I have been commuting with the subway for over ten years and can’t even count how many turnstiles there would ever be. … Read more
0
1
14 March 2024
14 March 2024

Kubernetes For Complete Beginners

Container orchestration has become a cornerstone of modern application deployment. For beginners stepping into the world of modern application deployment and orchestration, understanding the essence and significance of Kubernetes is essential. A container is a compact and self-contained package comprising essential components like code, runtime, libraries, and system tools necessary for running an application. Container … Read more
12 March 2024
12 March 2024

Transforming and Analyzing Data in PostgreSQL

In our data hungry world, knowing how to effectively load and transform data from various sources is a highly valued skill. Over the last couple of years, I’ve learned how useful many of the data manipulation functions in PostgreSQL can supercharge your data transformation and analysis process, using just PostgreSQL and SQL. For the last … Read more
11 March 2024
11 March 2024

Get the most out of SQL Server Agent logs

If you haven’t migrated your workloads to a managed database platform yet, you’re probably still relying on SQL Server Agent for various maintenance and other scheduled tasks. Most of the time, these processes just work. But when it’s time to troubleshoot, it can be cumbersome to get to the root of some problems. In this … Read more
05 March 2024
05 March 2024

Serverless Authentication methods in web apps.

0
2
Serverless authentication methods refer to approaches for managing user identity and access without the need for traditional server-based authentication systems. Instead of relying on a dedicated server, authentication tasks are outsourced to cloud-based services or specialized third-party providers. This allows developers to focus on application logic while leveraging secure, scalable, and often managed authentication solutions. … Read more
0
2
04 March 2024
04 March 2024

The Value of Conference Speaking

0
1
Editor note: The call for speakers is open at on the Pass Data Community Summit 2024 Site, so join Jason in throwing your hat into the ring for this year’s Summit coming up in Seattle November 4-8! My Power BI Speaking Tour: This is the Way Over the past year, I decided I was going … Read more
0
1
01 March 2024
01 March 2024

Building MongoDB Aggregations

0
0
In the previous article in this series, I discussed how to use a find statement to retrieve data from a MongoDB collection. However, the find method is not the only option for retrieving document data. Another important method is aggregate, which lets you group documents, perform calculations on those groups, and in other ways extract … Read more
0
0
29 February 2024
29 February 2024

Find and Replace Text in Strings in T-SQL

String manipulation is an inevitable task for developers and data professionals alike. Despite all the best efforts to normalize databases, eventually we are faced with some sort of text-based data stored within a relational database and need to extract detailed information from it. Those of us who have tackled these challenges fully understand how code … Read more
22 February 2024
22 February 2024

Making Accessibility Part of the Design Process – Part 3

0
1
Naviagation, flow, and testing it all In this last segment of the series, we’ll delve into the crucial elements of navigation and flow, exploring further the part of web accessibility that ensures users can effortlessly navigate online content. Additionally, we’ll shine a spotlight on the indispensable practice of regular testing, an ongoing commitment that goes … Read more
0
1