Do As I Say, Not As I Do

Yesterday morning I sat down to start a new project. Before I got started, I knew I needed to put this in source control. Now, the project was going to be in AWS, but, AWS has shut down their flavor of Git, CodeCommit. I decided to use GitHub instead, no big deal.

Well, until I looked at my GitHub repositories.

See, I use GitHub all the time. I put my presentation code there. I have examples there. I published the code for my book there. I'm shoving stuff in to source control pretty willy nilly all the time. I've been pretty tactical, adding stuff on the fly and working way more remotely and not centrally.

Yeah.

My GitHub was a mess.

There were repositories there I didn't recognize. I found duplicate repositories with no idea why. Failed experiments. Just a jumbled up pile of, probably, junk. What's worse, because it's just me and my own code, no team, I hadn't bothered using good code commit messages. Further, I wasn't in the habit of putting in good, oh heck, any, ReadMe files to show what the heck the project was for. I realized that before I could get going on yet another repo with bad documentation, poor naming standards, and all the rest, that I would need to clean up.

The irony wasn't lost on me. I fly around the world teaching people how to get their database code into source control. I go off on rants about how important proper naming standards are. I crack jokes about bad commit messages. In short, every single silly thing I had done to turn my GitHub repositories into a hot mess, I tell all of you not to do.

I spent a chunk of yesterday, and will probably be spending some more time today, cleaning up a mess I knew better than to create.

I see you out there. There's a whole bunch of you saying, "Hoo, Grant, why'd you do that? I'd never intentionally violate good practices myself." And, sure, for a few of you, that's probably true. The rest of you, well, come on, look around, you're with me. We just don't always practice what we preach. It's a humbling, but useful, reminder.

I want to say, it doesn't hurt to slow down for a minute and be sure you're doing what you know you should. However, yesterday hurt. Regardless, through inattention, I built up a technical debt. Sooner or later, one way or another, you're going to pay for that debt. So, do as I say, not as I do, and be sure you are indeed following the best practices you know you should.

Now, I've got to go write some ReadMe files.

Grant Fritchey

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

Find your personal ROI in under 1 minute. And see how many working days you and your team could save in coding time with SQL Prompt!

As AI and ML drive IT innovation, organizations fa...

Can an AI help me with some database API work? Let...

Italian scientists designed a neural network to an...

Investigate why a staggering 69% of job seekers th...

Parents' lawsuit over AI homework cheating fails a...

Discover the latest research uncovering critical barriers to AI adoption for enterprises of all sizes. The post New Study Identifies Major Roadblocks to AI Adoption for Businesses — Are You...

Discover how Google leveraged AI to uncover a hidden software bug that has been lurking for two decades. The post Google Uncovers 20-Year-Old Software Bug Using AI appeared first on...

Domain registrar failed to respond after offending content was taken down.

"Reddit Answers" will answer questions with AI-generated summaries of user content.

Parents suing want Character.AI to delete its models trained on kids' data.

In this article, we look at how to create an SQL S...

I saw a post where a developer was trying to read ...

Deadlocks in SQL Server can be frustrating and can...

Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since that time, we have observed an intriguing phenomenon when encountering a login failure. To demonstrate... The...

THE VIDEO THE SYNOPSIS In this video, I show how to back up and restore SQL Server databases in piecemeal form, using filegroups to manage read-only versus read-write data,...

We released more content in SQLBI+ with two new se...

When building products that interact with multiple...

In this Microsoft Azure AI series: Speech studio (available at URL: https://speech.microsoft.com/portal)  is a set of UI-based tools for building and integrating features from Azure AI Speech service (available...

A bored IT team is also an unproductive IT team. Here's how to keep your staff motivated and energetic.

Accelerate genomics, multimedia, big data, network...

In this Microsoft Azure AI series: Vision and Docu...

Like many others, I recently fled the social media...

Since 2012, the SAS Health Center Center and VETS ...

Results from a recent survey have prompted questions.

In Part 1 of this article series, we will begin to build a PowerShell tool that visualizes disk space.

Have you accomplished something amazing with SAS s...

  ...

As someone who works at storytelling with data, I'...

While researching the topic of Latin hypercube sampling (LHS), I read an article by Emily Gao (2019) that shows how to use PROC IML in SAS to perform the...

SoDA를 이용해 쉽게 배우는 데이터 과학 #4 지난 포스팅에서는 SoDA 인터페이스 구성과 그 기능에 대해 알아보았습니다. 오늘은 SoDA 인터페이스 중 ‘작업 모드’와 ‘프로세스 플로우’ 두 가지 요소에 대해 알아보겠습니다....

Leaked form shows how Fog Data helps cops find whe...

Yes, you read it right. Most security implementati...

As unstructured data creation rates have soared, t...

In today’s fast-paced digital landscape, we all ...

Some of the most difficult and tedious issues in a...

In 2012, Harvard Business Review declared the data scientist the sexiest job of the 21st century. Here’s what we knew at the time: big data was (and still is...

Reading Time: 8 minutesIn this post I cover two ...

Explore emerging trends alongside enduring strategies, while understanding which practices may fade as DevOps evolves in 2025.

The post How to Build Data Management for Unstructured Data appeared first on Joyful Craftsmen.

The post How to Build Data Management for Unstructured Data appeared first on Joyful Craftsmen. The post How to Build Data Management for Unstructured Data appeared first on SQLServerCentral.

Embodied says it will try to refund recent purchas...

No pricing or availability, but there's new compet...

Intel has solved the biggest problems with its Arc...

Explore the latest Nvidia earnings report, AI grow...

New Pi 5-powered PC also launches with optional portable 1080p monitor.

Learn how to conduct a goal-driven infrastructure assessment to uncover vulnerabilities, ensure compliance, and strengthen your IT environment.

Over the past year, cyberattacks on cyber-physical...

Overview of the techniques and the tools (free and...

In Tabular Editor 3, you can analyze models with DAX Optimizer and track fixed/ignored issues without leaving the integrated development environment.

We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses in Fabric. We only go to the workspace level and add the user as a viewer or member. However, this is far from a good idea. The solution is on the old and good SQL security practices.

The Basics If you’ve dealt with Power BI licensi...

When Function Rewrites Need Query Rewrites In SQL Server Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love...

Next month, I'l be hosting 2 or 3 discussions of A...

If you have worked with PostgreSQL for a while, yo...

PGConf.EU 2024 in Athens is over, time for a revie...

At last week’s local Postgres user group meetup here in Estonia, one of the topics was HA and recent Patroni (the most popular cluster manager for Postgres) improvements in...

First things first, a couple of definitions to clear up: ETL: Extract, Transform, Load. Transforms data before loading it into the target system extract raw data from various sources...

"Retrieval Augmented Generation" (RAG) is a useful technique in working with large language models (LLM) to improve accuracy when dealing with facts in a restricted domain of interest. ...

Let’s stipulate that PostgreSQL has grown significantly in popularity over the last 20 years. I don’t know by how much, but certainly at least one order of magnitude, probably...

Time Travel PostgreSQL History Until PostgreSQL 6.2 had time travel implemented in its core. It has been removed in PostgreSQL 6.3. How To Implement It In...

As databases grow in size and complexity, performance issues inevitably arise. Whether it is slow query execution, lock contention, or disk I/O bottlenecks, identifying the root cause of these...

This session introduces the Visual Calculations fe...

  Field parameters are another tool for Power BI ...

Maybe you are moving from Dev to Production, or yo...

Is your Power BI report taking too long? Are you c...

Video by: Reid HavensLearn how to build a dynamic vertical waterfall chart using Power BI's native stacked column visual and visual calculations. This step-by-step tutorial covers setting up the...

Unlocking the value of data is a key focus for bus...

An IT professional is anxious about giving a prese...

From widespread developer layoffs to the mainstreaming of AI-assisted coding and the rise of platform engineering, 2024 reshaped software development in unexpected ways.

Besides Python Speech SKD there are multiple langu...

PySpark DataFrame PySpark – apply() PySpark – ...

In this Microsoft Azure AI series: Using SDK optio...

Learn how to use multi-dimensional arrays when wor...

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's... The...

Vulnerability with severity rating of 9.8 out of p...

Redgate's Inside Perspectives offer a selection of insights from industry experts on the most compelling topics for the data community. Hear from Mri Pandit, Senior Manager at Navy Federal Credit Union, about how the data security and compliance landscape has evolved.

This is going to be interesting. It’s a video of someone trying on a variety of printed full-face masks. They won’t fool anyone for long, but will survive casual scrutiny....

A Chinese threat actor infiltrated several IT and security companies in a bring-your-own VS code, with an eye to carrying out a supply-chain-based espionage attack.

Insider risk prevention strategies should emphasize unified visibility, context-aware monitoring, access management, and a cyber-aware culture fostered through training and motivation-aware policies.

Many people are confused about monolithic and micr...

For the final T-SQL Tuesday of 2024, Kevin Chant i...

First off, thank you to Kevin Chant for hosting TS...

Query Store. This is my choice in relation to “W...

Rounding out T-SQL Tuesday for 2024, Kevin’s invitation brings it together with the Festive Tech Calendar (more on that at the end), and asks us to write about a Microsoft Data Platform announcement...

Reading Time: 3 minutesFor this months T-SQL Tuesday contribution I cover why I believe in the premise of Microsoft Fabric and why it made me go “wow”...

It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve gotten to #181. That’s over 15 years of monthly blog parties. This month we have... The...

It’s December. The last month of the year, and hence also the last T-SQL Tuesday of the year. Edition 181 is hosted by Kevin Chant. His chosen topic for...

A textbook example of shifting the standards of ev...

Engineers are already beginning to plan for possib...

Device could be integrated into clothing, harvest ...

We may owe our tiny sliver of Neanderthal DNA to j...

These latest findings further support the Hubble Space Telescope's prior expansion rate measurements.

It's predictions season. Find out what the coming year won't have in store in Forrester's 2025 anti-predictions.

Blue Origin needs to fly the New Glenn rocket to identify where the vehicle has margin.

Phil's company hired a contractor. It was the typi...

Alice has the dubious pleasure of working with SalesForce. Management wants to make sure that any code is well tested, so they've set a requirement that all deployed code...

Help yourself to prizes by helping us raise money for good causes.

Tesla's limited-edition action figure, modeled after its Optimus humanoid robot, flew off the virtual shelves at $40 each. The collectible sold out within a day of its release, and...

Rob's co-worker needed to write a loop that iterated across every element in an array. This very common problem, and you'd imagine that a developer would use one of...

Understanding the gravity of the situation: Driving Lucid's serious new SUV.

I saw a post from Erin that Preview 2 is available...

Kubernetes 1.32 boasts 44 enhancements, including ...

A boulder engraved with a turtle, good acoustics, and torch lighting—what more do you need for a good time?