Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Ad for State of Database Landscape survey
The Voice of the DBA
 

Internal Staff Growth

Imagine that you are about to tackle a new project that will take more than a year. This might be a new system, perhaps a cloud migration, or maybe it's rewriting something that doesn't work well. You don't have enough employees to undertake the project without overloading everyone. Your team needs to grow.

Would you rather hire a more senior person from outside the organization or pick a junior person that's already inside your company and teach them what they need to know? Think about this as if you were the one making the decision about the future direction of your software team. Philosophically, do you want to buy experienced people or train/build new ones from your internal staff.

It's an interesting idea and for a lot of companies, I see them looking outside the company first, rather than investing in, and training, their internal staffers to grow. It takes time to train and grow people, for sure, and it's a constant investment that never goes away. At the same time, bringing people in from the outside also requires some level of training on how the current systems and org work, even if the new hire has a lot of experience.

I think there are good reasons to look at both of these, but my view is that I want to have people on a team that know how to work together. The tech skills (or design, modeling, etc.) can be taught, and I would rather have a good cultural fit, already knowing how a person fits with others. That assumes I've got good employees who fit together and believe in our culture. That's hard enough to do, which is why I want to hire people who can work as a team and keep them. Part of the "keeping" them is investing in them.

This also means that if people don't fit in, I want to help them move on to a better fit.

This doesn't mean I want everyone to think the same. It is important to have a variety of views on how to design and build applications. A variety of people is important, but we have to be a team.

I prefer to train and invest in the people I have over bringing in more experienced staffers. A big part of why I feel this way is that hiring is always a gamble, and it seems we make no shortage of mistakes. If I do get it right, then I want to grow and keep those people around for the long term.

Steve Jones - SSC Editor

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

Ad for State of Database Landscape survey
 
 Featured Contents
SQLServerCentral Article

Implementing PostgreSQL with Python for Real-Time Logging and Monitoring

sabyda from SQLServerCentral

Learn how you can create a logging module in Python that can be used to insert real-time records in a PostgreSQL database and display them on a dashboard.

External Article

JSON_CONTAINS Function in SQL Server 2025

Additional Articles from MSSQLTips.com

I have data coming into my SQL Server database as JSON. Before I start parsing it which is quite intensive, I need to check if some values are present in the JSON. Is there a function I can use to do this? Let’s see what the new JSON_CONTAINS function in SQL Server 2025 can do.

Blog Post

From the SQL Server Central Blogs - Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition

aen from Anthony Nocentino Blog

In my previous post, I showed you how to build a snapshot backup catalog using SQL Server 2025’s new native REST API integration. But what if you’re still running...

From the SQL Server Central Blogs - Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation

Chris Yates from The SQL Professor

Change is inevitable. What separates thriving organizations from those that falter is not the scale of disruption but how leaders respond to it. In times of shifting technologies, evolving...

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

Site Owners from SQLServerCentral

This practical book provides a comprehensive overview of troubleshooting and performance tuning best practices for Microsoft SQL Server. Database engineers, including database developers and administrators, will learn how to identify performance issues, troubleshoot the system in a holistic fashion, and properly prioritize tuning efforts to attain the best system performance possible.

 

 Question of the Day

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

 

Identify a Slipstream Installation

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?

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)

The New Database CheckDB

I run this code:

create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')

What is returned?

Answer: 1900-01-01 00:00:00.000

Explanation: This returns 1900-01-01 00:00:00.000. Ref: DatabasePropertyEX() - https://learn.microsoft.com/en-us/sql/t-sql/functions/databasepropertyex-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 - Administration
SSIS packages failing with a status "ended unexpectedly" (SSL/TLS timeout ?) - We have an issue where SSIS packages are failing with a status of "ended unexpectedly" within 30 - 60 seconds after scheduled start. This issue is transient and not specific to any SSIS package. After rebooting the server, packages will run normally for a couple of weeks but then start to fail a few at […]
SQL Server 2019 - Development
count the number of NULLs in a row - Hi everyone I have a SP that finds the average based on 3 tables.  I need to know how many NULLs are in a row, not column.  The only way I know how to do this is to first find all combinations of outcome and then second use a CASE statement.  This is fine for […]
SQL Azure - Administration
SQL MI Next-gen general purpose tier - Has anyone used Azure SQL MI on the next-gen general purpose tier, Microsoft documentation says it offers better IOPS compared to the regular tier. If the IOPS limit is stated as 10k, is this limit applied per database or is it the upper limit for the entire SQL Managed Instance? Does the IOPS we get […]
General
Can Flyway work with GitHub Self-Hosted Runners? - I work on the CI/CD team. We're considering different applications for helping us with database migrations and, if necessary, rollbacks. Red-Gate's Flyway is one of the solutions we are considering. I've got experience writing SQL Scripts to create tables, views, stored procedures, etc., but I am not a DBA. I've started watching some of Red-Gate's […]
SSDT
ETL Framework In Production - Hello, I am leveraging Python within SQL Server Integration Services (SSIS) packages, primarily through the Execute Process Task.   I am extracting Data from E2 SQL to Azure SQL Server. The connection has already been established. I am building complete ETL using Function Extraction of Data (Full load/Incremental Load) Transformation Logging Audit Table Loading The […]
Editorials
The Selfish Case for Learning AI - Comments posted to this topic are about the item The Selfish Case for Learning AI
SQLServerCentral.com Website Issues
Are topic notifications working? - This is a topic to test whether reply notifications are working or not.
Article Discussions by Author
The Last Good DBCC Run - Comments posted to this topic are about the item The Last Good DBCC Run
SQL Server Ghosts - Comments posted to this topic are about the item SQL Server Ghosts
Regular Expressions in SQL Server 2025 - Comments posted to this topic are about the item Regular Expressions in SQL Server 2025
Slip Streaming Installs - Comments posted to this topic are about the item Slip Streaming Installs
SQL Server 2022 - Development
Varchar(max) to lines - I have an issue with a varchar(max) field with up to 7000 characters needing to be put in to lines of 85 characters long and keep formatting with char(13) in it and not to break words. Basically it is to take a memo field from a software to import into Business Central Extended Text lines. […]
Deleting data in large table - I have a large table with 17M+ rows for our package record audits.  I've decided to clear out anything older than 3 months which would clear all but 1.2M records.  The table doesn't currently have any indexes.  What's the recommended way to clear the records from the table?  Should i consider adding an index to […]
SQL Newbie HELP: The query references an object that is not supported in distr.. - Hi everyone! I'm new to SQL and am trying to query a view (dbo.) made from a D365 table. My goal is to do a recursive joins on 4 different views but to start with I tried something basic and received the following error: The query references an object that is not supported in distributed processing […]
Connecting ERP system E2 and Extract Data , perform Transformation - Hello, May someone please help me how can I pull data from ERP named as E2. E2 is using SQL Server. Looking for detailed steps of connecting to E2 System. I am planning to use python scripting. Do I need to Install any driver. what all configuration details we have to paas in the scripting. […]
 

 

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

 

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