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

Where Your Value Separates You from Others

I ran across a post that discusses what makes you a senior engineer (via Brent Ozar). The main point of the post is that there is a core skill that separates senior engineers from others, which is reducing ambiguity. When a senior engineer gets an ill-defined (or ill-communicated) request, they can deliver a solid, or even great, result.

When someone says "performance is poor," what do you do with that? Can you build a plan to identify the issues and solve them? Or do you expect the customer to explain what is slow and why it's slow? Do you ask what metrics they have showing things are slow? A senior engineer can ask questions to find the problem and then determine how to move forward.

The post also discusses the way many companies hire senior people, often basing decisions on years of experience and answering specific questions in an interview or on a test. It's hard to interview and test a person who is given a vague requirement and develops a solution. Most interviewers don't want to have to wprl that hard and compare what might be very disparate answers to ambiguous questions. How can you judge two people who give very disparate answers to questions with no clear answer?

It's hard, and I know this because when I've run interviews that lightly describe a situation and let the candidate lead me to the next question, so that I can see how they work and think. It's very hard to judge the end result and rate the candidate as effective. Often, I find myself deciding if I like the person more and if they fit in our company. That's if I think they can probe to find information and make decisions when that information is incomplete. If they can't probe and find a way to solve the problem without direction, that's an issue.

And that really is the senior skill. In all fields, not just engineers or DBAs. Managers, customer service, analysts, and more. Can someone handle an unstable atmosphere and clarify, identify, simplify, and present a way forward? If they can, then they are likely someone to consider for a senior role. They still need expertise in their area, but can they get things done when they aren't being directed?

Are they self-starters?

That might be the main thing I consider for senior people. Can they drive themselves and get things done, things we need done, but without a lot of direction and hand-holding? If a senior person struggles to move forward without more direction or supervision, then maybe they aren't really a senior-level employee.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

T-SQL in SQL Server 2025: Encoding Functions

Steve Jones - SSC Editor from SQLServerCentral

Learn about these new binary encoding and decoding functions in SQL Server 2025.

External Article

Generating Shape Bound Random Points in SQL Server

Additional Articles from MSSQLTips.com

Random number generation is vital in computer science, supporting fields like optimization, simulation, robotics, and gaming. The quality, speed, and sometimes security of the generator can directly affect an algorithm’s correctness, performance, and competitiveness. In Python, random number generation is well-supported and widely used. In this article, we will look how to we can use SQL to do this.

Blog Post

From the SQL Server Central Blogs - Self-Hosting a Photo Server the Whole Family Can Use

Bert Wagner from Bert Wagner

Until recently, my family's 90,000+ photos have been hidden away in the depths of my gaming PC's hard drives. Many of the more recent photos were also scattered across...

Blog Post

From the SQL Server Central Blogs - Keeping MS Docs Up to Date

Steve Jones - SSC Editor from The Voice of the DBA

One of the things that I like about the SQL Server docs (MS Learn Docs) is that I can fix things I find wrong. For years we had downloaded...

T-SQL Fundamentals

Site Owners from SQLServerCentral

For anyone else who needs to write queries or develop T-SQL code for SQL Server, Azure SQL Database, or Azure SQL Managed Instance

 

 Question of the Day

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

 

Fixing the Error

On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error: Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function. What is the easiest way to fix this error?

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)

Which Table I

I have this code in SQL Server 2022:

CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
    ProductID INT,
    ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
    SELECT  ProductName
    FROM product;
END;
GO

When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned?

Answer: Bee AI Wearable

Explanation: The result is: Bee AI Wearable. This showcases the ownership chaining, and the result is that the un-specified Product table is etl.Product as the owner of the proc is the etl schema. I don't have a great reference, but if you find one, let me know.

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
Database file shrink issue. - Hi experts, I have a 3+ TB database on a 2019 sql server which has more than 50% free space. I know database or data file shrink is not a good practice so please not go there, I tried with 100 mb in a loop which is taking much longer time so it's not feasible. […]
SQL Server 2019 - Agent job PowerShell step issue - I have a couple of SQL Agent job steps which run PowerShell commands of the form: Invoke-Command -ComputerName REMOTE -ScriptBlock {& "E:\Scripts\PowerShellScript.ps1" -ServerName "REMOTE\INSTANCE"} In each case, these steps have started failing with errors of the form: The job script encountered the following errors. These errors did not stop the script: Unhandled Exception: System.FormatException: Index […]
Analysis Services
Database backup job steps - I have a SQL Agent job for backing up a set of Analysis Services databases with each database covered by a different "SQL Server Analysis Services Command" job step of the form: { "backup": { "database": "CUBE NAME", "file": "CUBE NAME.abf", "allowOverwrite": false, "applyCompression": true } } However, if a database is added, deleted or […]
Editorials
The North Star for the Year - Comments posted to this topic are about the item The North Star for the Year
Finding Motivation - Comments posted to this topic are about the item Finding Motivation
The Side Job - Comments posted to this topic are about the item The Side Job
Happy Holidays, Let's Do Nerdy Stuff - Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy Stuff
Article Discussions by Author
Multiple Escape Characters - Comments posted to this topic are about the item Multiple Escape Characters
The Last Binary Value of the Year - Comments posted to this topic are about the item The Last Binary Value of the Year
SQL Art, Part 2: New Year Fireworks in SSMS - Comments posted to this topic are about the item SQL Art, Part 2: New Year Fireworks in SSMS, which is is not currently available on the site.
Database security permissions save script - Comments posted to this topic are about the item Database security permissions save script
SQL Server 2025 Backup Compression Algorithm - Comments posted to this topic are about the item SQL Server 2025 Backup Compression Algorithm
The Large Encoded Value - Comments posted to this topic are about the item The Large Encoded Value
UNISTR Escape - Comments posted to this topic are about the item UNISTR Escape
SQL Server 2022 - Development
reaching ftp thru winscp but erroring in ssis ftp task connection - Hi, below i show various results trying to reach our ftp site (a globalscape product) from both winscp and ssis's ftp task as a certain user on a certain port.   as far as i know, in winscp i choose FTP as the protocol even though its more appropriately FTPS (not sftp).  in ssis i tried […]
 

 

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

 

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