Love

Love is many a splendored thing. It is also a much-abused word with many different (and twisted) meanings. The type of love I wish to speak about today is not friendship, nor the kind of thing that makes your heart go pitter patter in the springtime, but rather the type of love known as storge, or familial love in the data community. It is not the same as friendship either. I do have many people I consider friends in the community, but far more that are like family.

I have been a member of the data community (previously the SQL Server community!) for over 20 years. Over these years, it has been wonderful to see our family grow into something extraordinary, like a Norman Rockwell family painting that everyone always wants their extended families to be like, but rarely actually are. I spend less time each year with my extended family than with my SQL family. From conferences (PASS, SQL Saturday, etc.), forums, and especially X (or Twitter if you aren't into that whole brevity thing), I typically know more about SQL'ers lives than my actual aunts and uncles.

It is a phenomenon that, every so often I pause to ponder. This SQL family comprises people from tremendously different employers with very different viewpoints. Still, we share one subject rather deeply: data. Like a typical family, we rarely talk politics or religion at holiday gatherings (PASS Summit, or the lesser holidays, like SQL Saturdays), just the topic of our common bond over food and drink, occasionally stretching into topics like Lego and science fiction movies (though one must be careful, as some of these topics do border on a type of religion for many of us).

I can't quite figure it out because, for the most part, our gathering around such a business-oriented topic as data shows little financial gain at its center. Keeping our names in the public does help the digital resume, and I helped hire quite a few of my compatriots when my previous company needed training or a second (or third) opinion about technology. But not nearly enough to merit 100s of hours spent preparing training materials to go out and present for free (or nearly so, compared to consulting income.)

I am still impressed with how many people stick around the community to help others, even when they have made their name. Some fade away, thinking they will make a million dollars from the community. Still, our core community has been around for many years, adding more and more great people every year.

Louis Davidson (@drsql)

Join the debate, and respond to the editorial on the forums

As data grows and databases become larger and more complicated, data subsetting provides a method of working with a smaller, lighter copy of a database to make development and testing faster and easier. In this article, James Hemson poses the questions; what exactly is data subsetting, how and why are developers using it – or not using it, and what’s prompting conversations about it?

Database models have all sorts of useful applications during Flyway development to help us automate those repetitive development tasks that otherwise slow down delivery. This article shows how models can help us automate mundane tasks such as generating a build script for any version of a database or deleting the data from every table.

SQL Monitor provides detail-level diagnostic data that will allow an expert to drill down to establish the cause of, and a fix for, any database problem. However, with support for webhooks, it can also contribute alerts to the sort of "Tier 1" alerting and paging system that an operations team might use to get an immediate notification of an urgent problem, anywhere on the network, and then coordinate a timely response.

A database model is a standard document that represents the logical design and structure of a database. If we save a model each time Flyway creates a new version of the database, then we can find out what's in each version, and get an overview of how that structure changed between any two versions. This has all sorts of uses in team-based database development work.

Introduction These are my SQL Server Diagnostic In...

It’s me again with my apparently semi-annual blo...

I used to believe this option was something almost...

There are times when a SQL Server database change ...

I saw an article on this and realized I had no ide...

Harnessing the computational capabilities of artificial neural networks, deep learning algorithms have the ability to model complex patterns and make accurate predictions based on these patterns. This makes them particularly valuable in big data mining, a field that deals with extracting meaningful information from substantial datasets.

Learn how Microsoft Azure Data Factory (ADF) stand...

Reading Time: 2 minutes In this post I want to co...

In this article, I will demonstrate how to create ...

Reading Time: 7 minutes In this post I want to co...

We’re on quite a roll with window functions thes...

This is part twenty-five of the plansplaining series, and the third part that covers window functions. I have already explained how basic window functions work, with or without a...

This article explores check constraints in SQL Ser...

The 2020s have been tough: a pandemic, a recession...

For Your Eyes Only I’ve been keeping a mental li...

Top Down I start off all of my stored procedures w...

Attn Pls. Most code I look at has been a disaster ...

How can you PIVOT or UNPIVOT data in SQL Server? W...

Spaces First, a list of things that are horrible: Tabs Leading commas All lowercase All uppercase Not putting new things on new lines (from join on where and or...

Learn about SQL Server CROSS APPLY and OUTER APPLY...

If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, you’ve come to the right place. And while using Docker on its own to manage a single MySQL instance or multiple instances has certain drawbacks, such as lacking the ability to orchestrate multiple instances, scale, and provide services for external clients, in this blog we’ll explore how Kubernetes addresses these limitations and what to do when you’re facing problems.