SQL Endpoint Secrets you need to know (DBW 2024 -02-08)

No End to Programmers

There's an interesting piece at O'Reilly this week titled The End of Programming as We Know It. That's actually a good title, but it doesn't mean the end to programmers, developers, software engineers, of whatever people call themselves.

The piece looks back at history, starting with physically connecting circuits to program and moving to switch flippers, cards, compiled languages, and on to the web and mobile systems. Each of this brought more and more programmers into the industry because there's no end to the software needs of the world and it's hard to write good code.

I like that the web was seen as the end of programming as anyone could easily build a minimal application to share things. Even frameworks like WordPress let novices create applications that do all sorts of useful things. However, we still need programmers. Look around at how many WordPress consultants are willing to help you.

That's because there's a difference between configuring something off a shelf (or from a digital store) and actually having a working application for your situation. There's no end to what people want to build, and really, they need someone to build it for them. Or at least modify, improve, or re-implement the proof of concept they created.

The world of AI LLMs, and chat-oriented programming, is no different. Anyone can ask for an app and get a reasonable prototype. However, I don't think this means less programmers. While more people will build more PoCs or prototypes, that also means more people will need a professional to clean up their system and make it work, scale, and perform well. And probably help secure it better.

Programmers (developers, software engineers, etc.) will scale themselves with AI tech, as they'll get the AI to do some scaffolding and initial work that they clean up. I'm sure the very best will build RAG AI systems that generate the type of code they want with a little training and input. I could see millions of AI assistants that help write basis code outlines, write tests, check for standards and code smells, and help the human shift left, catching small, simple, silly mistakes.

I think we'll have more people producing software in the future, but I also think that those who know their industry well will be in more demand. They'll recognize issues in AI-generated code, they'll guide AIs better, and they'll communicate more clearly with AIs. They'll get their pick of the best jobs, and they might be better compensated.

Things they likely do today with their fellow humans.

Steve Jones - SSC Editor

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

This article explains how to compare databases and generate schema models using Flyway Enterprise CLI with PowerShell. It allows developers and DBAs to identify schema differences between environments and create schema models that capture the current state of a database, making it easier to track and review changes over time.

We’re pleased to announce the planned opening of our new office located in central Amsterdam, marking the first phase of our ambitious plan to expand and grow in the Northern Europe market.

Jeff Foster, Director of Technology & Innovation at Redgate, explains how Redgate is approaching the AI revolution.

The meteoric rise of DeepSeek—the Chinese AI startup now challenging global giants—has stunned observers and put the spotlight on China’s AI sector. Since ChatGPT’s debut in 2022, the country’s...

Recently I had a severe problem with SQL endpoints and I was required to build a quick workaround for this. The problem brought to light details we don’t know about SQL Endpoints and the care we need to have.

Database Administrators (including Microsoft SQL S...

This post demos a script I put together to help move SQL Server database files to another drive and folder by generating PowerShell and T-SQL commands.

It’s easy to focus on user databases and overlook the system databases at the core of every SQL Server instance. However, the master, msdb, and model databases form the backbone of your environment. Understanding each database’s specific responsibilities, how to safely customize them, and how to protect them from data loss or corruption is important for maintaining a stable server.

Have you ever made a change in your system and immediately regretted it? A few weeks ago, I did just that while working with a customer on their Databricks platform. His IT guys made some changes, moving a user to another domain. In Databrick, this is considered a new user, so I added the new user and gave him the same permissions as the old user.

In this post, the fourth in our series, I want to ...

“Publishing a book is an amazing experience. Writing a book is very, very hard.” Louis Davidson, Simple Talk Editor (@drsql) At the risk of burying the lede… “Introduction to...

An IT pro seeks guidance on whether it’s ever ac...

Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest in flip-flops. But guess what? You absolutely can become an SQL whiz without sacrificing your... The...

We are often looking for attributes, but what about the empty attributes? How can I find out if an attribute is empty? That is the focus of this article....

Learn how to build and customize grid-based GUIs in PowerShell using Windows Presentation Foundation.

Data doesn't always tell a happy story. For example, when a marketing campaign doesn't reach its desired performance or when a new product your company is launching receives negative...

So many data visualization and design-related questions are context-dependent. For example, if someone asks if one chart type is better or worse than another, the answer is, “It depends.” Who's the audience? What's the data? How's it being shared? It’s impossible to say one way or another in every case. We all crave simple, binary solutions, but unfortunately, real life is messy like that.

THE VIDEO THE SYNOPSIS In this video, I provide a primer on the concept of key performance indicators. Along the way, we’ll talk about common warehousing terminology such as...

Some decisions in life are easy, like whether to drink that second cup of coffee. But when it comes to databases, things get complicated fast. Developers often seek my input on adding tables and columns. A common question arises: Should they create a new table or expand an existing one by adding columns?

In this article, Robert Sheldon introduces you to the time series collection and demonstrates different ways you can create them in MongoDB Shell.

If you process SSAS cubes via SSIS packages you might notice a weird message like "Full Processing:Warning: Server: Operation completed with XXX problems logged."

SQL Server migrations are a headache, ask anyone who’s been through the pain of moving a reasonably large server and I’m sure they will agree. There are all sorts...

With soldered RAM and eMMC storage, this is not "a...

Since SQL database is a native item in Fabric, it utilizes Fabric capacity units like other Fabric workloads. Compute charges apply only when the database is actively used, so you only consume what you need. Storage is billed separately on a monthly basis, as are automatic backups, which are retained for seven days.

If you’ve ever used a database, you’ve probabl...

In this blog post I am going to show you how to get all the Power BI licenses in your tenant. This can be very useful to understand how...

In Microsoft Fabric, the Data Factory is the workload for ETL and data integration, and the Data Pipeline is a component in that workload for orchestrating the execution flow....

Indexing SQL Server Queries For Performance: Compu...

Indexing SQL Server Queries For Performance: Windowing Functions Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my...

Indexing SQL Server Queries For Performance: Indexed Views And Non-SARGable Predicates Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about,...

Indexing SQL Server Queries For Performance: Index Sorting Thanks for watching! Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my...

With the postgis_raster extension, it is possible ...

Materialized views are widely used in Postgres today. Many of us are working with using connected systems through foreign data wrappers, separate analytics systems like data warehouses, and merging data from different locations with Postgres queries. Materialized views let you precompile a query or partial table, for both local and remote data. Materialized views are static and have to be refreshed.

Backups are crucial for any mission-critical appli...

Straight from Microsoft’s documentation “Micro...

I have been watching the codification of spatial d...

Cover photo by Mayukh Karmakar An issue I often see folks missing when reviewing query plans, is that all of their scans involve indexes, so they think that...

Lately, I’ve been getting a lot of questions about the canvas size in Power BI. Or maybe I’ve just been seeing too many reports that look... off. Some are stretched across massive screens like a Hollywood blockbuster, while others are crammed into tiny spaces where insights have to fight for air.

This article covers splatting, explaining the advantages of using it with Flyway. We create reusable parameter sets and combine them as needed, using PowerShell. This simplifies multi-parameter Flyway commands,...

The Solutions Engineers at Redgate recently releas...

This article explains how to compare databases and...

I wrote about getting the Redgate Test Data Manager set up in 10 minutes before, and a follow up post on using your own backup. One of the things... The...

Introduction These are my SQL Server Diagnostic In...

Every quarter, we publish adoption rate data showi...

This entire blog post is driven by the #1 feature in this list. I think about the #1 feature a lot, like at least once a week. I think about...

It’s time for T-SQL Tuesday again and this month I’m hosting. I realized that I didn’t host in 2024 and since I run the thing, I ought to be... The...

Explore common Linux malware types, how to detect ...

Amount paid by victims to hackers declined by hundreds of millions of dollars.

Home Affairs Minister Tony Burke said the Chinese AI app posed unacceptable risk.

Organizations and development teams need to evolve from "being prepared" to "managing the risk" of security breaches.

Microsoft’s AI Red Team just published “Lessons from Red Teaming 100 Generative AI Products.” Their blog post lists “three takeaways,” but the eight lessons in the report itself are more...

To save money and protect privacy, the successful service won't bug you.

I’ve been working in technology for entirely too long—but one of the first, and most important lessons I learned was try to identify the correct error message, in the...

NULL is a special marker that indicates a missing or undefined value in a column. It is different from zero or an empty string. Handling NULL values is essential for accurate data analysis, data integrity, and error avoidance. This tip explores how to handle NULL values in SQL Server using the COALESCE() function using various queries and reviewing the results.

I was talking to a friend of mine and they are learning some SQL and they said something that I have seen come up multiple times in learning SQL.

Recently I was talking with someone who had not na...

This is a post in the SQL Interview series. These ...

This is a post in the SQL Interview series. These aren't trick or gotcha questions, they're just questions designed to scope out a candidate's knowledge around SQL Server and...

One thing you might not have considered is that a table can also be joined to itself. Imagine that I want a list of employees, but I also want...

In a recent Reddit AMA, the OpenAI CEO also called DeepSeek’s R1 model “impressive.” The post Sam Altman Says OpenAI Has Been on “The Wrong Side of History” Regarding Open...

Salesforce plans to eliminate 1,000 jobs and hire workers for new AI products, according to Bloomberg. The post Salesforce Reportedly Laying Off 1K Workers While Adding AI-Focused Sales Roles appeared...

Supply chain attack targets developers using the Go programming language.

Enterprises are shifting from chasing trends to strategically modernizing legacy systems, leveraging existing infrastructure with modern enhancements to maximize business value and future-proof operations.

Google revises its AI ethics guidelines, ending its ban on weapons and surveillance. The policy shift ignites debate over national security and tech responsibility. The post Google’s Updated AI Ethics...

redesis – n. a feeling of queasiness while offer...

Giant presses and 3D stir welding make the battery...

Bike design seems like a solved problem, but there...

Interesting news dropped – Microsoft announced t...

Let me cut to the chase. If you are like me, you m...

The latest and greatest preview of the new SSMS 21...

For enterprise SQL Server DBAs, high availability is essential for maintaining seamless database operations—particularly in scenarios involving Change Data Capture (CDC) or other mission-critical functionalities. Docker containers can streamline the setup and management of development or testing environments for Always On Availability Groups (AOAG). By bundling configuration files, scripts, and dependencies into containers, teams gain a reproducible, portable, and efficient deployment mechanism.

The other day I came across an interesting repo on github, KubeDiagrams. What this repo does is generate Kubernetes architecture diagrams from Kubernetes manifest files…nice! Deploying applications to Kubernetes...