Forem: Jeff Zuerlein

Using T-SQL To Generate Large Amounts Of Test Data

Jeff Zuerlein — Tue, 16 Apr 2024 04:10:02 +0000

Being able to generate millions of rows of data in your SQL database, in a few seconds, opens up a world of options.

It means you can validate your data access strategy, and UI design early in the development process. The goal is to fail fast, to minimize risk. Having a set of data that mirrors the size you expect in production means you’ll quickly see what works, and what doesn’t.

In cases where you need to have data that matches real world data, you could leverage open source datasets of names and locations to provide information that conforms to your software’s business rules.

ChatGPT can also provide sets of information that may not be accurate, but close enough for load testing.

I’ve created a video to discuss the benefits of testing an application with large sets of data, and provide a demonstration of T-SQL code that you can use in your own projects.

What’s the difference between Span and Memory?

Jeff Zuerlein — Mon, 12 Feb 2024 05:51:13 +0000

The first time I used Span of T and Memory of T, I struggled to understand what the difference was. Don’t struggle, watch my video instead.

My goal is not to tell you how awesome these features are, but to get you over the hump of understanding how they work. I cover what Span and Memory of T do and why, along with some description of their internals. Finally, I discuss what the owner consumer model is, and why it's relevant to Memory of T.

Supercharged Dapper Repositories: Boost Performance With Sorted Span

Jeff Zuerlein — Thu, 18 Jan 2024 05:39:05 +0000

Dapper handles the mapping of object properties, but if your aggregate has child collections, you have to manually do that. When those collections get large, there is an opportunity to improve performance! See what the benchmarks prove about using Linq where extensions, dictionaries, and sorted spans.