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

Engineer Lessons

Many of you reading this have a number of years working with technology. You might have 1 year or 20 years, but you've likely grown and learned along the way. Some of you may also know someone who has several years of seniority in a position but not that many years of experience. In this case, a person might have been working at this job for 5 years, but they really have one year of experience that's been repeated 5 times.

That's been a common complaint over quite a few years from people who interview others. They find candidates often have very limited experience, yet are applying for senior roles. These candidates are ones who have just a few years of experience, but have ended up repeating those few years over and over.

I ran across an interesting piece that contains 21 lessons from the author's 14 years at Google. You might not think Google is the place where great software engineering takes place, or where great careers are made, but Google has been a place where it is challenging to get a job, they work on truly large-scale problems, and Google has had many engineers who have gone on to success elsewhere.

The first few lessons in here are things that I've learned in my career. Quite a few of them point to the value of being a team player, and remembering that being effective and efficient matter. It's easy to be smart, or depend on one's code to speak for our ability, but in many cases, we are working in teams. Our code is a team game, and others need to understand our code. It's easy to forget that someone responding to a problem at 2 am might not understand the code. It's also easy to forget that person might be you, and you might get confused.

Others also need to understand and believe in us. Lessons 2, 14, and 16 talk about the value of working with others and not creating resentment or ill will in others. Even with AI help, most software will require multiple people working together, so building those skills and habits is important.

I found this to be an interesting list, and there are other topics I want to discuss in the future, but the main thing I see here is that these are lessons from someone who has had to work as a technical engineer with others, while having success both at his job and outside of it. That resonates with me, as do these lessons. Individuals and teams that work in similar ways to those described in the piece have tended to have more success than those that don't, at least in my experience.

Learn to be a team player as an engineer, developer. DBA, or any other job, and you will have more success than if you expect to only be judged on what code you write.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Fun with JSON

ateraa from SQLServerCentral

Last year, I used a lot of JSON to exchange data between systems. There are several ways to extract data from a JSON file, but there is one specific, probably less-used possibility that I’d like to highlight. For one project, I received JSON files containing a variable number of parameters and their values. If I […]

External Article

Azure Functions: The Serverless Powerhouse

Additional Articles from MSSQLTips.com

Today’s organization are faced with multiple conflicts for their current cloud infrastructures and which approach to go with either opting for a microservice or monolith applications. However, there are numerous difficulties with standard hosting methods.

Blog Post

From the SQL Server Central Blogs - Claude AI Convinced Me Not to Build an iPad App

Steve Jones - SSC Editor from The Voice of the DBA

I coach volleyball and I do a lot of stat stuff on paper. I decided recently to see if I could find a way to more easily automate things....

Blog Post

From the SQL Server Central Blogs - SQL Server Upgrades: In-Place or New Server?

Kevin3NF from Dallas DBAs

This isn’t a religious debate.   I have a client right now debating how to handle SQL Server upgrades across all of their dev and test environments. And it’s...

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Site Owners from SQLServerCentral

A new era of SQL Server is here, and this latest edition of Grant Fritchey’s best-selling dive into SQL Server query performance can ensure your queries keep up.

 

 Question of the Day

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

 

Creating JSON II

On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO

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)

Backup to Immutable Storage

In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?

Answer: The backup file is not created with zeros and instead is created in one step.

Explanation: Previously, SQL Server backups were created in two steps: 1 create a file with zeros and 2 file updated with data. This first step is skipped in SQL Server 2025 when backing up to immutable storage. Ref: Azure immutable storage support - https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver17#azure-immutable-storage-support

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 Azure - Administration
Transactional Replication setup issue - Hi! I've been banging my head against the wall for 2 days now trying to setup Transactional Replication between an Managed Instance and Azure SQL Database. Documentation: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/replication-two-instances-and-sql-server-configure-tutorial?view=azuresql That's the documentation I'm working with although I'm using the same instance for distribution and publishing. I've double checked the config on Azure and replication multiple times […]
Editorials
The Power of Data and Privacy - Comments posted to this topic are about the item The Power of Data and Privacy
The DBA is Dead; Long Live the DBA - Comments posted to this topic are about the item The DBA is Dead; Long Live the DBA
Optimism Without Illusion or Why AI Needs Blunt Technologists - Comments posted to this topic are about the item Optimism Without Illusion or Why AI Needs Blunt Technologists
When SQL Server Central Went Down - Comments posted to this topic are about the item When SQL Server Central Went Down
Discussions about Books
Data Warehouse Toolkit meets Star Schema: The Complete Reference - Is there a good syllabus for reading these two together? (Yes, it's called the table of contents!) Just wondering because Kimball's book is super high level, and Adamson's book is much more detailed. Maybe I'll just have to put it all in my book report. LOL
Article Discussions by Author
What's the Date? - Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform - Comments posted to this topic are about the item Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
GPX distance and time analysis in SQL Server - Comments posted to this topic are about the item GPX distance and time analysis in SQL Server
Changing the AG Listener - Comments posted to this topic are about the item Changing the AG Listener
The String Distance I - Comments posted to this topic are about the item The String Distance I
SQL Server 2022 - Administration
SSMS 22 Latest Update Crashing - Hi all, I've just had to roll back my SSMS 22 version from 22.3.0, because this version seems to crash as soon as I open it (just after selecting an instance to connect to). Anyone else having any issues with 22.3.0?
SQL Server 2022 - Development
SSIS with VS2022 64/32 issue with Excel files - Hi all, I'm trying to do classic scenario for loading multiple Excel files into db working in VS2022. I have reliable template which worked OK for csv files. But now after switching to xlsx I have problem when file name defined on Variable tab let say FileA.xlsx is not present in directory. If […]
Case part is sloooooow - Hi So the case statement is slowing this down - but for the life of me I cant think/find a more efficient way to get the results:   select * FROM pec.tBRClaimLinePreCalc WITH (NOLOCK) JOIN dbo.tclaim_procedure WITH (NOLOCK) ON tclaim_procedure.claim_procedure_id = tBClaimLinePreCalc.claim_procedure_id JOIN dbo.TPEC_RGV_ProcedureType WITH (NOLOCK) ON TPEC_RGV_ProcedureType.claim_procedure_id = tClaimLinePreCalc.claim_procedure_id WHERE claimProc_ServiceType IS NULL OR […]
Why the following cmds in sequence do not work - I need to delete rows from both the temporal main and history tables. The temporal main table can get deleted without issues. For the temporal history tables, I code to turn system versioning off, issue the Delete, then turn system versioning back on. If I execute manually each of the below cmds one at a […]
 

 

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

 

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