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

Can You Ask for a Raise?

I mean, you can ask for a raise. It's always an option, but is now the time to ask for a raise in this economic climate, where businesses can be unsettled and there are a lot of tech workers looking for jobs. I even saw a piece that noted many computer science graduates are struggling to get hired at the top tech firms. While that's not where most people work, it seems that often other CIOs/CTOs look to the big tech firms for guidance, and they may choose to hire fewer new staffers as well.

This is on my mind at work after reading an article on asking for a raise that I added to the newsletter. It's a response in the advice column where a reader asks how to go about asking for a raise when they think they deserve one. It is unclear in which industry or level this person works, so I am not sure if I think the advice is good.

The gist of the response is that anyone wanting a raise needs to make a business case about why they deserve more money. I agree with that, but the piece goes on to talk about cost of replacement and loss of knowledge. To me, those start to delve into the area of a stick over a carrot approach to asking for a raise. I have used those techniques, but only when I am truly ready to look for another job if they don't agree. While you might think you know your manager, you never know when they (or their boss/HR) might take offense to you bringing up the losses from you leaving.

I'd also say that if you are successful with this, it might be a one-time thing, and it might affect future bonus/raise amounts as the company thinks you've already gotten extra compensation.

That's not to say that you can't ask for a raise. I've been successful making a business case that's based on my salary compared to peers doing similar work. Experience matters a bit, but the job I do and my responsibilities matter more. Of course, if I'm near the top of a range, then I'm really asking for a promotion and a raise. That might make sense, or it might not. Ask yourself as you build a case if you'd respond well if you owned the company and this was presented to you.

Maybe the most important thing to evaluate is the situation in which your business finds itself right now. Is it doing well? Sales/revenue/profits increasing? Are they lean on staff and need to hire more? Or is that not the case? Does your management seem to value experience and the work you do or are most of the staff pressed to do more work over time, with your coworkers in similar situations?

Maybe most importantly, do you trust your manager?

If you don't feel confident in positive answers to these questions, proceed cautiously. Asking for a raise is something I'd be very careful of, at least in the US in mid-2025, as it seems to be the hope of executives to use more AI to replace people. Couple that with the large number of people looking for jobs and this environment might cause a reasonable request to be denied or could create lingering ill will. That might not be worth a short-term raise.

Steve Jones - SSC Editor

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

 
 Featured Contents

Contained Availability Groups in SQL Server 2022

Deepam Ghosh from SQLServerCentral

SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively manage the Server Level objects, such as Logins, SQL Agent jobs, etc. in an HA environment. In today's article, we will learn about this new feature of SQL Server. The Challenge of Managing Server Objects in Availability […]

External Article

13 Things I wish I knew about Power Query (when I first started)

Additional Articles from SimpleTalk

When I first started with Power Query, it was in Excel, through the Power Pivot feature. I was amazed at how I could transform data with just a few clicks and quickly create PivotTables. Then, when Power Query appeared in Power BI, I began working with larger data sources and more complex projects.

Blog Post

From the SQL Server Central Blogs - Accessing the Kubernetes API from SQL Server 2025

dbafromthecold@gmail.com from The DBA Who Came In From The Cold

The sp_invoke_external_rest_endpoint stored procedure that’s available in 2025 allows for SQL Server to hit external rest endpoints…which opens up quite a few interesting options. I was thinking about this...

Blog Post

From the SQL Server Central Blogs - Azure DMS Tutorial: Migrate Databases to Azure with Minimal Downtime

Rohit Garg from MSSQLFUN

Migrating databases to the cloud can be complex, but Azure Database Migration Service (DMS) simplifies the process with a robust, fully managed solution. Whether you’re transitioning from SQL Server, MySQL, PostgreSQL,...

Admin Azure SQL Solutions

Exam Ref DP-300 Administering Microsoft Azure SQL Solutions

Site Owners from SQLServerCentral

Directfrom Microsoft, this Exam Ref is the official study guide for the new MicrosoftDP-300 Administering Microsoft Azure SQL Solutions certification exam.

 

 Question of the Day

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

 

A Big Updated Columns List

I have this table in SQL Server 2022:
CREATE TABLE CustomerLarge
  (CustomerID               INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName             VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName  VARCHAR(40)
 , Address                  VARCHAR(20)
 , Address2                 VARCHAR(20)
 , City                     VARCHAR(20)
 , CountryCode              CHAR(3)
 , Postal                   VARCHAR(20)
 , creditlimit              INT
 , discount                 NUMERIC(4, 2)
 , lastorderdate            DATETIME
 , lastorderamount          NUMERIC(10, 2)
 , lastordercontact         VARCHAR(20)
 , created                  DATETIME
 , modified                 DATETIME
 , modifiedby               VARCHAR(20)
 , statusid                 INT
 , active                   BIT
 , customersize             INT
 , primarysalesid           INT);
GO
If I check the columns_updated() function return in a trigger, what is the data returned?

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)

Enabling Change Tracking

If I want to set up Change Tracking in a database, what should I do first in SQL Server 2022?

Answer: Run ALTER DATABASE mydb SET CHANGE_TRACKING=ON

Explanation: An ALTER DATABASE with a SET option turns this on. Ref: Enable and Disable Change Tracking - https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-tracking-sql-server?view=sql-server-ver16

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 - Development
Replace with like join - I am trying to create and Update query based on a like join.  Is that possible?  This is what I have: UPDATE claim SET incident_desc = CASE WHEN incident_desc like '%' + NAC.Glyph + '%' THEN REPLACE(claim.incident_desc, NAC.Glyph, NAC.Replacement) ELSE incident_desc END FROM claim INNER JOIN NonASCIICharacters  NAC ON claim.incident_desc LIKE '%' + NAC.Glyph + […]
built in deadlock information capture - Hi, i cannot recall the object or even if it comes off the shelf but i once saw a tool in sql server where the competing tables etc involved in a deadlock are recorded.   I think you had to know a bit about the complicated looking test it provided but it was sweet.   my recollection […]
why do my advanced i/o column lengths on city keep changing - hi , every time i go back to an ssis pkg that is under construction, at least one column in a tsv needs to be reset in the advanced properties of the oledb source from 50 bytes to 256.  Even though last time i edited it,  i saved the pkg. why is that happening?   Today […]
Anything that is NOT about SQL!
NKTg Law on Varying Inertia – A Different Way to Think About Motion - Hi everyone, I’d like to share something from the science side of life rather than the SQL side. It’s called the NKTg Law on Varying Inertia. In classical mechanics, Newton’s laws describe how objects move under the influence of forces. But the NKTg Law takes a different angle: instead of focusing only on forces, it […]
Editorials
Carrots and Sticks - Comments posted to this topic are about the item Carrots and Sticks
Storage Enhancements - Comments posted to this topic are about the item Storage Enhancements
Everyone Wants a Piece of the AI Pie - Comments posted to this topic are about the item Everyone Wants a Piece of the AI Pie
Article Discussions by Author
How to create your custom GPT SQL Expert - Comments posted to this topic are about the item How to create your custom GPT SQL Expert
MongoDB and NodeJS in action - Comments posted to this topic are about the item MongoDB and NodeJS in action
SQL Server 2022 - Administration
Index Consolidation - I am trying consolidate indexes in the production environment and whilst I have a good idea of what or how to about the actual index consolidation, my challenge is how to test this process to ensure that stored procedures or processes calling on tables are using the indexes they would normally have used so for […]
CDC job running for 17 days? - Good morning, I've noticed my CDC job running for 17 days.  I've noticed it before, but wasn't sure it was an issue.  I've checked sys.databases to check the log_reuse_wait_desc to see if it said "replication". It says nothing. The Database is 8 TB and the log file is 23 GB. I queried :  SELECT job_id, […]
Database growth events for unidentified databases - We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly reports have started showing regular growth events for the following database files (see attached). model_replicatedmaster (both the replicatedmaster and replicatedmasterlog files) model_msdb (both the MSDBData and MSDBLog files) Firstly, what databases are these? I'm familiar with model, master, msdb and tempdb […]
distributed availability group query - Not sure if this is my misunderstanding or an error in my process: Create AG1 on server 1 & 2.  (2019).  Add DB1.  Replica are joined, DB1 is synchronised. Create AG2 on server 3 & 4.  (2022). Add DB2.  Replica are joined, DB2 is synchronised. Remove DB2 from AG & drop on both. Create DAG […]
SQL Server 2022 - Development
ODCB error from Linux client - Hi Folks, When connecting to one of SQL Server 2022 servers , from a linux machine, there is this ODBC error . Strangely the same isql test is successful when I test against another SQL server 2022 server on a different server and also in the same VLAN. I can connect to both these servers […]
azure vm has to be rebooted more often than we'd like - Hi we're noticing this 2022 server gets into a funk now and then.   Specifically, i notice when i script existing tables to the clipboard etc it just hangs with that circle continuing to spin.    i notice that if i reboot, the problem goes away for a while.  does the community have a similar experience?  […]
 

 

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

 

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