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

The Balanced Technical Manager

I find there to be a lot of value in actively managing your career. This is part of a series of editorials based on advice I've read from Raylene Yung (Facebook and Stripe) on your engineering career.

In the last few years I've started to see a number of organizations find ways to build technical career growth paths that don't require someone to become a manager. A lot of technical people don't want to manage others, and I'd argue that making the best technical person the lead or manager isn't often the best decision. Those are two different skill sets and success in one doesn't predict success in the other.

There are technical people who would like to move into management. If you are one of those people, then you ought to tackle building skills in that area just as you might tackle learning Power BI, SQL window functions, or any other skill.

Management requires a few different skills. Project management is important, as you will often be balancing a variety of work tasks for your direct reports. Another set of skills is people skills: leadership, listening, evaluating, and having hard conversations, none of which are easy.

Part of the advice for technical people wanting to be managers is that you have to work on your emotional equilibrium, as the way your job works as a manager is different from that of an engineer. Your view of success, happiness, and your emotional takeaway from daily work is different. You also have to view the workings of your team at a higher level, understanding that your focus and goals can be slightly different than those of your engineers.

I think you also have to learn to make hard decisions on what to prioritize or how to distribute your staff among the competing demands you face. Learning to make decisions and move forward, as well as apologize and change course when you realize you've made a mistake is something relatively few people do well.

It's also important to recognize that as your team grows, something will always be wrong. In any size organization, you'll have a birthday every month and likely some sort of illness or other negative action. Have a large enough organization and someone will die on a regular basis. Keeping yourself balanced when something is always wrong (and something is always right) can be a challenge.

Having done these jobs, I do think that one way to test the waters is to ask to lead a team on a small project. Getting a feel for balancing work, and learning that management is work that needs to be counted, can help you decide if you want to go down this path. It's not for everyone, but becoming a manager can be a good career path, though not necessarily easier than writing code or managing infrastructure.

If you want to consider this path, ask others for advice, read books, and learn like you would if someone assigned you a new technology. I've enjoyed my time in some companies as a manager, and if I hadn't been looking to move earlier in my career, I might still be running the technology organization at a previous company. It was one job I really enjoyed.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Getting Started with DDL statements of Cassandra Query Language

Shivayan Mukherjee from SQLServerCentral

Learn the basics of how to work with objects in Cassandra, a NoSQL database.

External Article

Why Haven’t You Disabled SA? Wrong Answers Only.

Additional Articles from Brent Ozar Unlimited Blog

On social media, I asked folks, “Why haven’t you disabled the SA account in your SQL Servers? Wrong answers only.” The results were pretty funny:

Technical Article

Accelerated Database Recovery enhancements in SQL Server 2022

Additional Articles from SQLServerCentral

We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.

Blog Post

From the SQL Server Central Blogs - Changing the Data Type of a Primary Key–#SQLNewBlogger

Steve Jones - SSC Editor from The Voice of the DBA

A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....

Blog Post

From the SQL Server Central Blogs - Building Upon Your Productivity Momentum: Staying Productive For Life

MarlonRibunal from Marlon Ribunal - SQL, Code, Coffee, etc.

Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...

Pro T-SQL 2022: Toward Speed, Scalability, and Standardization for SQL Server Developers

Site Owners from SQLServerCentral

Learn how to write and design simple and efficient T-SQL code. This is a hands-on book that teaches you how to write better T-SQL with examples and straightforward explanations.

 

 Question of the Day

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

 

Creating Aggregates

What types of code can I include in the CREATE AGGREGATE statement?

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)

An Incomplete Window Definition

I have defined code as follows in SQL Server 2022:

SELECT 
SUM(sod.OrderQty) OVER(ob_OrderID_ProductID partition BY sod.SalesOrderID) AS Total
 FROM Sales.SalesOrderDetail AS sod
 WHERE sod.ProductID IN (710, 711, 712)
 WINDOW ob_OrderID_ProductID AS (ORDER BY sod.SalesOrderID, sod.ProductID)

What is the default framing for a window definition such as this?

Answer: RANGE UNBOUNDED PRECEDING AND CURRENT ROW if an ORDER BY is specified

Explanation: The default framing is the same as if the OVER() clause were not in window definition. This is RANGE UNBOUNDED PRECEDING AND CURRENT ROW when an ORDER BY is included. Without an ORDER BY, then the entire partition is used. Ref:

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 2017 - Administration
Semaphore Timeout Expired Issue When Communicating with Web Server - I've been encountering a persistent issue while attempting to read/write to a web server. The error message I'm receiving is A transport-level error has occurred (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) I've already ensured that the firewall is enabled and properly configured, and there don't seem to be any […]
IMPLICIT TRANSACTIONS - Hi All, In our environment we have bunch of vendor specific db's where it is using SET IMPLICIT_TRANSACTIONS ON setting and it is causing a lot of BLOCKING. especially for long running adhoc batches with multiple statements and transactions,keeping the transactions open and holding locks for longer duration. So, the issue started when one of […]
Elevated permissions to developers? - Hi All, Is it a good idea to give any elevated permissions to developers? In one of the sub-prod environments, Dev team is running some newly developed stored procedures from SSMS and Frontend UI. When they see the blocking they are reaching out to us and we are providing where it is getting blocked and […]
Unsupported OS to update the driver - Hello, I have a client machine, which doesn't connect SQL Server. The driver seems unsupported but the operating system doesn't support to install the latest driver. Is there any workaround to connect to SQL using old version of driver?
SQL Server 2017 - Development
Commit transaction inside loops - Hello, our users are complaining about blocking during a delete loop so I'm thinking that adding begin tran; and commit tran; inside the loops would allow the other queries to squeeze through in between delete loops.  Is this how people would achieve a reduction in impact while deleting data and is the below query pretty […]
SQL Server 2016 - Development and T-SQL
SQL runs slow in a union all statement - Could you please help? My Union all sql query consist of three individual queries that runs quickly on its own. However when they are in a union all statement it runs up to a point then kind of hangs and then resume after a while. It runs for a long time. The first two queries […]
Reporting Services
The subscription contains parameter values that are not valid - Hi, I've got an issue on SSRS where I have a daily subscription that works most of the time but sometimes the subscription fails with the message "The subscription contains parameter values that are not valid".  This is without any changes to the subscription and when you manually run it, it goes through successfully.  Checking […]
Analysis Services
Invalid location of measures when opening tabular model in excel - Hello, I built my first Analysis Services Tabular project, however the icon of measures and dimensions were not as expected. Also location of measures is under the dimension. (images attached) Any idea what could be wrong with the project setup ? Thank you.
Working with Oracle
Sequentially update a column with a decrementing value - I want to update the "QTY_REQ" column in the PLSQL table in the screen cap below sequentially row by row by dividing out a number (e.g. 7) among the rows. I want to start with the row with the highest value in QTY (QTY 4, LOC 10800B41) and enter 4 for QTY_REQ. Then go to […]
Sequentially update a column with a decrementing value - I want to update the "QTY_REQ" column in the PLSQL table (in the screen cap attached) sequentially row by row by dividing out a number (e.g. 7) among the rows. I want to start with the row with the highest value in QTY (QTY 4, LOC 10800B41) and enter 4 for QTY_REQ. Then go to […]
SQL Server 2022 - Development
SQL Server Developer Edition on Windows VM - I'm currently facing a peculiar issue with SQL Server Developer Edition on my Windows VM, and I'm seeking your expertise to help me troubleshoot this problem. Has anyone faced this issue?
Can you reference 'Inserted' or 'Deleted' Trigger Table in SQL Mail Query - Hello, I am trying to reference the results from the Inserted or Deleted tables from a SQL Trigger in teh @query param of sp_sendmail but doesn't seem to work.  Getting the dreaded: Msg 22050, Level 16, State 1, Line 54 Failed to initialize sqlcmd library with error number -2147467259. This usually happens when you are […]
Primary key column question - Hi, I'm new to sql server and successfully created a table of columns, however after creating the table I realised I forgot to add the primary key column. I used the ALTER command for and used a query to create a new  column for the primary key. This was successful but it added the column […]
Newby - Stuck with a trigger. - Hello Forum, Apologies for this post, I'm stuck with an update trigger that i need to amend.  I need to capture the Date, OrderID and CustID, Surname and Firstname from a trigger which prevents an update on table. The Date, OrderID and CustID , Surname and Firstname need to go into a table. I can't […]
Check Code Correction Current Period Prior Period Movement - Please assist me?I am trying to calculate Current Period Prior Period Movement from my data, the date columns are:   Please check my code for any errors, code runs, i just want to make sure it does what it's supposed to do. Small data set is attached. -- Use IF EXISTS to check for the […]
 

 

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

 

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