Learning a New Language

This week, there are two interesting articles in the newsletter. The first is a markdown getting started article, which helps you learn how to format your documents. At first, I wasn't sure I liked markdown, but I've come to prefer it for a lot of documents. It's easy to use, and it makes using Git for docs very easy. Plus, I can mix in markdown and HTML as needed, which I really appreciate. I think most people who collaborate and update any documents in a team should learn to use markdown instead of Word, Notepad, etc.

The second one that caught me eye is one on Power Query. I don't know Power Query, but there was a piece on the 13 things John Kerski wishes he knew when he started. I didn't really do more than skim this since I am not writing any Power Query right now. What was interesting to me is that I'm not sure I'd bookmark this if I were actually writing Power Query in Power BI as part of my job.

Maybe I would, but as I start to use a GenAI more and more to get me started with different projects or requirements, I'm finding it as a way to kickstart me in learning something new. It's not perfect, and I have to test the results I get. Learning to judge the quality is part of my job, but that's different than trying to learn something new from scratch. That's a similar view to what I've heard from a few people. This podcast with Kent Beck showcases this view (starts at 6:12).

In the real world, when I wanted to learn something new, I often looked for a book or a few magazine articles that might get me some basics in a new area. In the digital world, I used to do the same thing, but in the last 20 years, I've been looking for an article or a "start in 30 days" book that might give me some basic skills. Then I could experiment and extend what I learned to get work done, likely asking friends or someone in a forum how to do the thing I need.

Now I ask a GenAI and go from there. I no longer worry about learning the specifics of a language, as I have a good idea in general of the things I need to do. What I'm using the GenAI to do is implement some details, and then I go back and check things. It's like having an intern who can do a first draft while I work on something else.

Except it's way faster.

GenAI models aren't perfect, and they make mistakes. However, the more I use them, the more I enjoy them, and I find enough small time savings that I want to use them more.

Steve Jones - SSC Editor

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

Redgate Monitor now supports Oracle Data Guard environments, giving DBAs instant visibility into replication health, lag and role transitions, so Standbys stay in sync and are ready to protect availability and data when needed.

Redgate Monitor now gives you full visibility into activity across Oracle Multitenant environments. With metrics and alerts at both the Container Database (CDB) and Pluggable Database (PDB) level, you can quickly pinpoint performance issues and ensure compliance.

Redgate Flyway is renowned for its low-friction, SQL-first approach. If you’re considering adopting Redgate Flyway or making a switch, here’s what you need to know about its simplicity and scalability.

This article aims to help make things clearer and easier to work with when dealing with Infor’s CloudSuite when you need to pull data out for your data & AI initiatives.

Interesting experiment: To design their experiment...

Everywhere I look, I see AI clones. On X and LinkedIn, “thought leaders” and influencers offer their followers a chance to ask questions of their digital replicas. OnlyFans creators...

At SAS Innovate in Orlando, our partners shared how they’re driving meaningful change with SAS®. From strengthening financial services with AI-powered AML solutions, to helping marketers build privacy-conscious personalization,...

This is the first in a series of articles meant to provide practical solutions to common SQL Server issues. In this post, we’ll talk about one of the most pervasive error messages out there.

How could different unrelated tables fail with a latch timeout on the exact same page? And aren't latches supposed to be, like, super-quick? The post Error 845 Time-out occurred while waiting...

Hello, reader! Today, I’m going to walk you through a scenario that many DBAs encounter: accessing a SQL Server instance when you don’t have the SA password, and no... The...

AWS has launched its first New Zealand Region with three Availability Zones, marking its 16th Region in Asia Pacific and enabling local data residency for New Zealand organizations.

Whether you’re building your very first website, starting a blog, or looking to improve your site’s visibility, WordPress.com offers a growing library of free courses to help you every...

Atlanta BI fans, please join us in person for our next meeting on Monday, September 8th at 18:30 ET. Jeff Levy (Data Architect @ Protiviti) will show us how to...

This month, I’m teaching two of my classes live, online, completely free! These are the two fundamentals classes that I think everybody should start with, regardless of their experience...

The fundamental difference between traditional regression, which uses single fixed values for its parameters, and Bayesian regression, which models them as probability distributions.

Dashboards evolve as user needs change, so revisions happen in the real world. This month, the teams behind the upcoming books Dashboards That Deliver and storytelling with data: before...

The Apache Kafka community is proud to announce the release of Apache Kafka® 4.1.0. This blog post highlights the many new features and improvements included in this release. For a full list of changes, be sure to check the release notes.

Reading Time: 3 minutesIn this post I cover the mystery of the fabric-cicd authentication that never was. To help others who experience similar issues with fabric-cicd. Allow...

Learn T-SQL With Erik: Optimistic Isolation Levels Don’t Allow Dirty Reads Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my...

In part 1 of this series, I laid the foundation to...

SQL Server Performance Office Hours Episode 27 To ask your questions, head over here. What are stupid things to monitor in SQL Server? INTERVIEW QUESTION: what’s your sql weakness?...

Take a look at this. Pay attention to the estimated rows. See the problem? Even at a full cartesian join, 49 by 49 rows does not produce 27670. Usually,...

I recently completed a training session for one of...

Here are the top lessons I give Power Query newcomers to help them avoid the mistakes of my past.

DATE/TIME September 5th at 1:30 PM (Pacific Time)DESCRIPTION Ready to transform your workforce data from basic hour tracking into strategic business intelligence? This deep dive takes you through real-world...

Redgate Monitor now supports Oracle Data Guard environments, giving DBAs instant visibility into replication health, lag and role transitions, so Standbys stay in sync and are ready to protect...

The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital estate – a castle of data, with towers of insight and vaults of sensitive information.... The...

Cyberattackers target local and state agencies, a problem as the Trump administration cuts cybersecurity funds and culls workers at federal security agencies.

Everything to know about the mishap that threatene...

Google refutes claims that all 2.5 billion Gmail users are at risk.

Markdown is the standard for writing technical documentation at Microsoft and many other organizations. Its simplicity, readability, and compatibility with other tools make it an ideal choice for blogging, documenting software, procedures, APIs, and more.

Let's test out the Data API Builder (dab) to create API endpoints for a local SQL Server database running in a container.

Learn T-SQL With Erik: Lock Compatibility Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75%...

Historic interpreter taught millions to program on...

As models like DeepSeek-R1 rival proprietary systems at a fraction of the cost, the AI landscape is shifting toward transparency and governance — making the database the new control...

For better or for worse, AI has colonized this list so thoroughly that AI itself is little more than a list of announcements about new or upgraded models. But...

You don't have to track down pricey retro hardware to play the Pioneer LaserActive anymore.

It’s time for another video! This time, join me as I walk through Creating a SQL Server docker container using VS Code. As a bonus, I’ll also show you...