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

Adding the Right Value

I caught this post about a career presentation from Kendra Little and it resonated a bit with me. The summary of the post (it's a bit long) is that there is valuable work that supports and benefits a team of people, called glue work. However, glue work isn't necessarily technical and it isn't necessarily recognized as valuable by management. In fact, it might unintentionally lead you from a career in engineering to one in project management.

I haven't been someone who has been marginalized in positions, who has been taken for granted or expected to do certain tasks. I think some people get taken advantage of, and this is especially true for women, who both volunteer more and are volunteered by others more for these tasks. While I have been quick to document decisions or actions, and sometimes help out with project work, I do that in addition to any technical work. I've felt that as a developer, my job is to produce code. If I can help with other things, then I'm a Developer+, but I ultimately know that code my clients can use is what matters.

I think that people sometimes mistake valuable work for the team with valuable work for the people looking at the team. They know teams fall apart because someone doesn't do the glue work. Or they have a s*** project manager who isn't managing the project. I think that is very common, and because many of us have an "I need to succeed" mentality, we sometimes stop coding to pick up other tasks, essentially volunteering to be the pseudo-project manager or team manager. That's fine, but if you fill your days with non-coding tasks, you are not moving toward senior engineer status.

At the same time, I know that many of you don't want to work long hours, nor do you want to let tasks drop that need to be handled. There's tension there, as either the employee feels overworked and taken advantage of, or they work themselves into burnout.

Sometimes there isn't a choice and your boss might expect you to work extra hours on tasks adjacent to or related to your work. I have seen a few people work for one of the big-name tech companies where employees had tasks outside of their normal work that they were expected to complete outside of their core 40 hours. If you have a boss like that, I'd look for a new position. That's my advice. I'm happy to work extra hours in limited doses, but not on a regular basis.

I'd say the same thing if your fellow employees don't step in and do their share of the load of glue work. If we're a team, we all do those things. If we don't, we're not a team, and I don't like working in places where we aren't a team.

Whatever you decide to do, make sure that you are clear on what is expected of you to get that raise/bonus/promotion and focus most of your efforts there. It doesn't matter what you think is important; it matters what those who make decisions about your career think is important.

Steve Jones - SSC Editor

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

 
 
 Featured Contents
SQLServerCentral Article

How to Load a Fabric Warehouse: Data Engineering with Fabric

John Miner from SQLServerCentral

In this next level, learn how you can load data from Amazon S3 in Fabric.

External Article

SQL Server OPTION RECOMPILE for Simple Queries

Additional Articles from MSSQLTips.com

Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.

Blog Post

From the SQL Server Central Blogs - Replacing Images in PBIR Format Reports

Meagan Longoria from Data Savvy

With the PBIR format of Power BI reports, it’s much easier to make report updates outside of Power BI Desktop. One thing you may want to do is to...

Blog Post

From the SQL Server Central Blogs - Learning Database Design and Power BI Performance

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

I spend my days working on and managing SQL Server instances—working days at least, and sometimes even on non-working days. I’ve been working with SQL Server for years now,...

Refactoring Databases cover

Refactoring Databases: Evolutionary Database Design

Site Owners from SQLServerCentral

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance.

 

 Question of the Day

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

 

Hash Joins IV

What is a hash bailout?

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)

Data API Builder APIs

What formats of API endpoints can the Data API Builder present to clients when exposing the database?

Answer: REST and GraphQL only

Explanation: The Data API Builder will expose REST and/or GraphQL endpoints for clients as queryable APIs. Ref: Data API Key Features - https://learn.microsoft.com/en-us/azure/data-api-builder/overview#key-features

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 - Development
Send results of a SQL query in Outlook email body - Hello SSC! I hope everyone had a great holiday! Happy New Year to all! Issue: I am currently using SQL Agent to send emails when a job succeeds or fails. The process is basically a bunch of SSIS packages. I also have an attachment that is the results of an SQL query, which UNIONS 2 […]
Database Archive missing FK - Bonjour à tous, je vais bientôt démarrer un projet d'archivage de données pour alléger la base de production. Dans la configuration spécifique de la base d'archivage, il a été décidé qu'elle ne contiendrait pas de clés étrangères (FK), ce qui fragilise davantage la base. En effet, un TRUNCATE TABLE pourrait être effectué sur toutes les […]
SQL Server 2012 - T-SQL
convert to date - I have a field called DueDates in table where they stored a Date value as Char(10) . mm/dd/yy How can I get it to true date so I can perform logic like to find all DueDates > 10/01/2022 I tried cast and convert but when I apply logic DueDates > 10/01/2022 it doesn't find correct […]
SQL Server 2019 - Development
Join 2 tables - Table A ServerName ColB ServerA C ServerA I ServerA L ServerA M ServerA N ServerA T ServerB D ServerB E ServerC C ServerC D ServerC E Table B ServerName ColB ColC ColD ColE Date ServerA Z 100 200 ABC date1 ServerB D 1000 10 DEF date2 ServerB X 1000 10 DEF date2 ServerC C 11 […]
Impact of Not Including Foreign Keys in an SQL Archive Database - Hello everyone, I am about to start a data archiving project that will affect almost all tables in my SQL database. To facilitate this process, I have created an archive database with the same schema as the main database but without including foreign keys to ease the insertion order. My question is: What are the […]
how to fix this error? - hi I am creating a stored procedure to reduce log size when needed.  I want to explicitly state which db to use but I am getting an error.  How can I fix my sp so it knows which db to use? Code: ALTER procedure [dbo].[ToolReduceLogFileSize] as USE myDB CHECKPOINT DBCC SHRINKFILE (2,1024) Error: Msg 154, […]
what if my last resort on extracting excel is at the cell level? - Hi, after i copy in ssis my excel file to a secured folder, its looking more and more like i'll need to get data out of the destination spreadsheet at the cell level. i'm looking at posts like the one at https://stackoverflow.com/questions/41702840/i-need-to-pull-specific-cells-from-a-single-excel-file-to-create-a-single-row-in but dont believe power query is the answer because  1) its an add […]
dont see a file system task approach to copying excel - Hi , rather than the approach at https://stackoverflow.com/questions/68314594/copy-an-excel-sheet-and-move-to-a-new-location-using-ssis where content rather than file level copying is done, i'd like to use the file system task to simply copy an entire excel file from one folder to another. i may be missing something but i dont see that option in what the file system task would […]
need community help on 1 final cdata odbc driver product eval question - Hi, for whatever reason,  CDATA is conflicted about answering 1 remaining disclosure type question before we conclude our eval of their netsuite odbc product.   Their product is installed on our sql server.     together with its related objects (dsn's etc as describe in paragraph 5) that are also installed on our sql server,  their purpose […]
how to calculate an average only if a minimum number of records exist? - Hi I am working on a rolling average calculation that is not working quite right.  Here is the code: AVG(T1.PRICE) OVER (PARTITION BY T1.UNIT ORDER BY T1.DATE ROWS BETWEEN 19 PRECEDING AND CURRENT ROW) This will calculate a rolling average using the last 20 rows including the current row.  This works great if there are […]
dont want pkg to abort if someone is in excel source document - Hi, is there a way when using excel as a flat file source in ssis to forgive the fact that someone has it open?   in my mind analogous to a dirty read in sql?   maybe read what it had at last save?  i'd hate to have an error handler alerting the file owner for hours […]
Reporting Services
Page break in multi column paginated report - Hi, I have created a multicolumn paginated report, which includes a subreport that I want to break at the group level (based on the "Date" field). Currently, the report is breaking at the column level instead of a page break at the group level. Steps I've taken so far: In the subreport, I created a […]
Powershell
create multiple output files based on query - I have this script that puts all of the output from query to a single file. Could it be changed to create multiple files based on query results? The query will find like a months worth of information like this in the table based on the Like condition. 20240501 20240502 20240503 Instead of creating 1 […]
SQL Server 2022 - Development
Using a RETURN - How does this capture multiple values from a cursor, and put them into an email message? DECLARE @SINGLE_RETURN char(2) = ISNULL(char(13), '') + ISNULL(char(10), '') (here are statements of a cursor that finds unencrypted databases) (then, EACH database name is put into a single message, (before I was sending an email with each cursor/database by […]
Problem installing SQL Server 2022 - Hello, I currently have an instance of SQL Server 2019 Developer installed on my computer. I'm trying to uninstall it so that I can then install SQL Server 2022 Developer. I don't want two instances of SQL Server on my PC and since it's just a local development instance for my C# projects, I don't […]
 

 

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

 

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