Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
 
The Voice of the DBA
 

Forward Deployed Engineers

I recently recorded a session with Ken Muse and a Redgate Flyway Solution Engineer. It was a fun session using GitHub and AI, and better managing the code in an automated fashion to bring some determinism to AI coding. I'm hoping it will be released soon, and you can see a vision of how you can better wrangle your AI agents and reduce risk and increase reliability.

When we started our discussion, Ken noted that he is an AI forward deployed engineer for GitHub. His job is to work with teams in how to use agentic coding. When we were first prepping, I had never heard the Forward Deployed Engineer title, which is apparently getting popular. It was in an issue of the Pragmatic Engineer Deep Dives last year, and I must have missed that issue. Apparently, this is a role that works part of the time with customer teams and part of the time with product teams.

In other words, a software engineer with a new title who gets paid more than a software engineer.

Titles are always a funny thing to me. I've seen people who write computer code go from programmers to developers to software engineers to forward deployed engineers. The job is the same. I work with a team of others who write code, or I work with a customer who wants code and might need help writing it. Or, if I'm working at a company that works with outside customers, this is really a consultant role renamed.

DBAs have had a similar change. I started as a DBA because they made a lot of money at the time. I moved from programmer to DBA, without much change in skill, but with a nice pay rise at a new company. I left that role before we got Data Engineers, Site Reliability Engineers, Database Reliability Engineers, and who knows what else. However, if I had stayed in a company, I'm sure I would have been changing my title periodically to earn more money.

Certainly, I'd still have been adding skills that give me a reason to change my title, but I'm not sure the job would have changed. Instead, I'd be trying to grow my career not only with seniority and time, but with new skills and title changes.

Maybe there's a good reason to keep learning new skills. New skills let you claim you need a new title. Hopefully, you pick a title that HR doesn't have any data about, so they have to set a new range for the position that's above your current range.

Viola! Instant raise.

Not a bad career plan. Just make sure you're adding some skills that are asked for in job descriptions, including soft skills. After all, a forward deployed engineer is going to be working with others, so communication is going to be key.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
 
 Featured Contents
SQLServerCentral Article

TRY_PARSE vs TRY_CONVERT in SQL Server: From Basics to Practical Usage

john.martin from SQLServerCentral

This article shows how the TRY_PARSE() and TRY_CONVERT() functions can be used to handle data quality issues and ensure that your software continues to function without throwing errors.

Technical Article

It’s 2026. Why are databases still failing GDPR compliance audits?

Additional Articles from SQLServerCentral

This article examines three recurring database-layer failures documented in the EDPB’s 2026 enforcement findings: the complexity of executing erasure across relational schemas, the backup paradox that can silently undo compliant deletions, and the audit log contradiction that traps organizations between two competing obligations.

Blog Post

From the SQL Server Central Blogs - WITH clause gets a 26ai boost!

administrator from Connor McDonald

By way of background, a while back I did video called “My New Favourite Join” on the LATERAL clause. The reason I like it is that it lets you...

Blog Post

From the SQL Server Central Blogs - Monday Monitor Tips: Virtual Machine Usage and Cost

Steve Jones - SSC Editor from The Voice of the DBA

One of the things I’ve been requesting for a number of years is cost information. I could see this coming in 2015 with the move to the cloud and...

Technical Article

Databricks Data Intelligence Platform: Unlocking the GenAI Revolution

Site Owners from SQLServerCentral

This book is your comprehensive guide to building robust Generative AI solutions using the Databricks Data Intelligence Platform. Databricks is the fastest-growing data platform offering unified analytics and AI capabilities within a single governance framework, enabling organizations to streamline their data processing workflows, from ingestion to visualization. Additionally, Databricks provides features to train a high-quality large language model (LLM), whether you are looking for Retrieval-Augmented Generation (RAG) or fine-tuning.

 

 Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

DBCC CHECKDB Limits II

I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?

Think you know the answer? Click here, and find out if you are right.

 

 

 Yesterday's Question of the Day (by Steve Jones - SSC Editor)

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;

Answer: NULL

Explanation: When a NULL is sent into BIT_COUNT(), it returns a NULL. Ref: BIT_COUNT() - https://learn.microsoft.com/en-us/sql/t-sql/functions/bit-count-transact-sql?view=sql-server-ver17

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2019 - Development
cons for a dev machine in a different version of sql from our prod server - hi, im not a dba. For a couple of years our dev sql server has been a 2022 vm std instance with varying levels of horsepower depending on how loudly we objected.   For many years our prod , 2019 on prem std.  both have ssas, ssis, ssrs and of course the engine. We are looking […]
Editorials
SSRS Reminded Me of the Time Microsoft Retired TMG - Comments posted to this topic are about the item SSRS Reminded Me of the Time Microsoft Retired TMG
I Can't Make You Learn - Comments posted to this topic are about the item I Can't Make You Learn
A Quick Second Opinion - Comments posted to this topic are about the item A Quick Second Opinion
Article Discussions by Author
BIT_COUNT II - Comments posted to this topic are about the item BIT_COUNT II
Why Your SQL Permissions Disappeared - Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Why Your SQL Permissions Disappeared - Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload - Comments posted to this topic are about the item Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Checking the Error Log I - Comments posted to this topic are about the item Checking the Error Log I
Calculating Geometric Mean in Power BI - Comments posted to this topic are about the item Calculating Geometric Mean in Power BI
SQL Server 2022 - Administration
Alamat Kantor Bank BCA KCP Lomanis Telp:08218154393 - WA:08218154393 Jl. Gatot Subroto No.080A, RT.001, Cigobang, Gunungsimping, Kec. Cilacap Tengah, Kabupaten Cilacap, Jawa Tengah 53224
Upgrade 2016 Standard to 2022 Express - Title pretty much says it all - can this be done? I've tried several paths and always come up against some failure in the installation process. I can install a new version of 2022 Express, but that means also porting all my logins and roles, as well as restoring every database. I would much prefer […]
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO - Hello, I would like to ask whether it is technically possible to redirect a specific list of client machines by forcing their SSMS to automatically use the ApplicationIntent=ReadOnly option when connecting to SQL Server. The goal is to apply this behavior through an Active Directory Group Policy (GPO), ensuring that all SQL connections initiated from […]
SQL Server 2022 - Development
Alamat Kantor Bank BCA KCU CILACAP Telp:08218154393 - WA:08218154393 Jl. Jend. Ahmad Yani No.118, Sidakaya Dua, Sidakaya, Kec. Cilacap Sel., Kabupaten Cilacap, Jawa Tengah 53212
Getting results from a Procedure to join to a query - I have a need to execute a stored procedure and return the results to something I can join to in a query. I am trying to execute a Trial balance from our ERP and get those balances and account numbers to correlate to another table with new account numbers. So my stored procedure execution looks […]
 

 

RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -