Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

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. 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 others that are in similar situations?

Maybe most importantly, do you trust your manager?

Asking for a raise is something I'd be very careful of, at least in the US in 2025, as it seems the hope of executives to use more AI and the large number of people looking for jobs might cause a reasonable request to be denied or could create lingering ill will.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

 
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.
Vendors/3rd Party Products

Tracking Down Object Changes in Flyway Migration Files

The goal of this article is to help Flyway developers search their migration files to pinpoint exactly where a specific database object, like a table, view, or procedure, was created or changed. It introduces a PowerShell script that scans files in version order and returns the relevant DDL statements with surrounding context.

Redgate Flyway’s latest major release: more flexibility, more control

The latest major release of Redgate Flyway brings flexibility and control to the way teams develop and deploy database changes. Flexibility, meaning Flyway can meet teams where they are and grow with them as their needs change. Control, meaning that teams can easily access Flyway’s capabilities, bringing repeatability and reliability to database change management.

AI/Machine Learning/Cognitive Services

LLM Technical Editor Test – ChatGPT with a VERY wrong article

I have set out to test an LLMs ability to technical edit. For my first set of tests, I am using a pair of articles I created, filled with very bad advice. The advice is the same for both articles, but what differs is the intro and the conclusion. One says the advice is good, the other said it is bad.

Administration of SQL Server

SQL Server Agent Jobs: Set It and Forget It?

From SQLServerCentral Blogs

Useful tips to make your jobs more stable Too many IT teams treat SQL Server Agent jobs like a coffee timer “Set it and forget it!” Unfortunately, that mindset... The...

SQL Server 2025 : ZSTD Compression

From SQLBlog.org

As the SQL Server 2025 public preview hit the streets, I had to test the new backup compression algorithn, ZSTD, on a decently-sized database.

TempDB Resource Governor Space Controls in SQL Server 2025

From Simple Talk

TempDB is a system database in SQL Server that manages temporary objects for all databases on a server. Because it is a shared resource, it can easily become a...

Azure Databricks, Spark and Snowflake

Guide to Optimizing Your Snowflake Data Warehouse for Performance, Cost Efficiency, and Scalability

From Daily WTF

Optimize your Snowflake data warehouse for speed, cost, and scale with practical tips on query tuning, resource management, and efficient data practices.

Load Data into Snowflake Using Native Snowflake Connector for Python: From Small to Large Datasets

From Simple Talk

In our ongoing exploration of Snowflake data loading strategies, we’ve previously examined how to use pandas with SQLAlchemy to efficiently move data into Snowflake tables. That approach leverages pandas’...

Azure DevOps

How to update an Azure DevOps PAT in GitHub

From DCAC

 

Career, Employment, and Certifications

Advice I Like: Focus on what’s important

From SQLServerCentral Blogs

Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by the urgent of any sort. Focus on the important. The urgent is a tyrant. –... The...

Underpaid and Overlooked? How to Ask for the Raise You've Earned

From IT Pro - Microsoft Windows Information, Solutions, Tools

After two years of increased responsibilities with...

T-SQL Tuesday #187 – Troubleshooting Weird Problems

From Callihan Data

This month’s T-SQL Tuesday invite comes from Joe...

T-SQL Tuesday #187–Solving Problems

From SQLServerCentral Blogs

 

My Name is Andy, and I Vibe Code

From AndyLeonard.blog()

Originally published at Engineer Of Data as a newsletter. Subscribe to my newsletter here. 50 Years Last month, I Celebrated 50 Years in Software. That link will take you to...

Cloud - AWS

New Azure VMs that perform close to on-prem servers?!

From Jeff Taylor

Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...

Computing in the Cloud (Azure, Google, AWS)

Cloud Provider Outage!

From Jeff Taylor

Your Cloud Provider is experiencing an outage! Your websites and databases are all down! When local data centers were the primary source...

Conferences, Classes, Events, and Webinars

Free Webinar – Build a data warehouse on Azure Data Platform for $150

From SQLServerCentral Blogs

I’m presenting a free webinar at MSSQLTips.com at Thursday, July 10, 2025 at 6PM UTC (8PM CET or 2PM EDT). The abstract: As you might learn from the abstract,... The...

Redgate at SQLBits 2025 – join us for a keynote that shines!

From Blog – Redgate Software

  We’re thrilled to announce that Redgate will be front and centre at SQLBits 2025, the premiere event for data professionals, happening June 18–21 at the iconic ExCel London. This...

SQLBits Added More Capacity to My Workshop! Move Quick.

From Brent Ozar Unlimited

I’m coming to London this month for SQLBits, and my Thursday workshop “Faster, Cheaper Cloud Databases” workshop sold out right away when it was announced. There’s been a waitlist...

DMO/SMO/Powershell

Verifying SQL Server Backups with PowerShell and SMO

In this post you will see how to run that command from PowerShell by invoking SQL Server Management Objects (SMO), turning a one-off verification into a repeatable step you can schedule across all your servers.

Data Privacy, Compliance, and Governance

Airlines Secretly Selling Passenger Data to the Government

From Schneier on Security

This is news: A data broker owned by the country’s major airlines, including Delta, American Airlines, and United, collected U.S. travellers’ domestic flight records, sold access to them to Customs...

Data Storytelling and Visualisation

trust the process

From Storytelling with Data

See Cole transform a table into an informative vis...

Database Design, Theory and Development

Data Elements on a Nominal Scale

The simplest possible type of scale is called a “nominal” scale and all it does is give a name to an entity or data element. It’s really more important for what properties it does not have. In fact, the nominal scale is so weak that originally people did not like to even include as a scale. After all, all you’ve done is name something. Its most important property is that it’s elements are unique. That is, we can use a name to identify an element in the set. But it establishes a logical principle called “The Law of Identity”.

DevOps and Continuous Delivery (CI/CD)

Introduction to GitHub Actions Part 3: Self-hosted runners

From Simple Talk

The previous article in this series discussed usin...

How to Integrate Quality Throughout the Software Development Process

From IT Pro - Microsoft Windows Information, Solutions, Tools

In this Q&A, Capital One's VP of Software Engineering Leena Kallakuri shares how to implement an effective automation strategy for software quality.

ETL/SSIS/Azure Data Factory/Biml

Getting Started with the SSIS Catalog in SSMS v21

From AndyLeonard.blog()

SQL Server Integration Services (SSIS) is available in preview in SQL Server Management Studio v21.2.5. Here’s how to configure SSMS get started using the SSIS Catalog! Install or Update,...

Microsoft Fabric ( Azure Synapse Analytics, OneLake, ADLS, Data Science)

Variable Libraries In Microsoft Fabric, In Preview!

From Purple Frog Systems

In Preview: Variable Libraries in Microsoft Fabric Microsoft Fabric’s variable libraries offer a powerful way to streamline your CI/CD processes, especially when you’re working in a shared workspace. In...

Medallion Architecture in Fabric: Why? What? and How?

From RADACAD

You must have heard the buzzword “Medallion arch...

Live Monitoring of Fabric Mirroring

From Prologika (Teo Lachev's Weblog)

A current project called for mirroring a Google BigQuery dataset to Fabric. This feature is currently in private preview so don’t try to find it. However, the tips I...

Oracle/MySQL/other RDBMS

Working with MongoDB Shell

Throughout this series, I’ve provided a number of examples of how to run commands in MongoDB Shell (mongosh). However, the examples were limited to the version of mongosh that’s embedded in MongoDB Compass. Although mongosh can be a handy tool to use in conjunction with Compass, MongoDB also offers a freestanding version of mongosh that provides greater flexibility and gives you more control over the command environment.

Oracle DBA to PostgreSQL: Install and Architecture, Part I

From DBAKevlar

As an Oracle DBA stepping into the PostgreSQL world, one of the first surprises you’ll encounter is during installation. If

PostgreSQL

Per-backend IO stats in PostgreSQL 18

One of my favorite new PostgreSQL 18 features which hasn’t had much attention yet is tracking session-level IO stats. It’s going to be really helpful for more quickly finding problematic queries in real-time – kudos in particular to Bertrand Drouvot for the work on it!

From SQL Server to PostgreSQL: A Story of 5 Key SQL Differences

From SQLServerCentral Blogs

After spending decades working in SQL Server, getting familiar with PostgreSQL felt like traveling to a country where everyone speaks a language I mostly understand – but with a different accent... The...

PowerPivot/PowerQuery/PowerBI

Power BI Padding Tips: The Sacred Space Between Chaos and Clarity

Now that we’ve all learned to love rounded corners, let’s talk about another quiet champion of good design: padding.

Power BI Model Analysis using DAX INFO Functions

From RADACAD

There are many DAX functions for covering day-to-day business-related calculations using measures and calculated columns. However, there is also a set of functions that can be helpful to the...

Thoughts about two ways to check that Power BI reports are using the right template with Azure DevOps

From Kevin Chant

Reading Time: 3 minutesIn this post I want to share my thoughts about two ways to check that Power BI reports are using the right template with...

Product Reviews and Articles

What’s new in SQL Prompt Version 11.0

From Blog – Redgate Software

We’re excited to announce the release of SQL Prompt Version 11.0. SQL Prompt Version 11.0 adds support for SQL Server Management Studio 21 (SSMS 21) and includes compatibility with...

Monday Monitor Tips: Customizing Data Retention

From SQLServerCentral Blogs

One of the biggest challenges with monitoring data is managing the volume over time. Lots of bespoke/home-grown solutions don’t do this well, and some commercial products have a gross... The...

Python

Navigating Imbalanced Datasets with Pandas and Scikit-learn

Imbalanced datasets, where a majority of the data samples belong to one class and the remaining minority belong to others, are not that rare. In fact, imbalanced data can stem from diverse real-world situations, such as fraud detection systems in banking and finance, where fraudulent transactions are much less frequent than legitimate ones, and medical diagnostics, where rare diseases arise far less often than common health conditions.

SQL Server News

The Requested Feature of SQL Server 2025

From The SQL Herald (Joey D'Antoni)

No, it’s not dark mode for SQL Server Management Studio, though the votes are probably close. (Note: I feel like I’m the only IT pro who doesn’t use dark...

Security News and Issues

Coming to Apple OSes: A seamless, secure way to import and export passkeys

From Ars Technica

Apple OSes will soon transfer passkeys seamlessly and securely across platforms.

T-SQL and Query Languages

Learn T-SQL With Erik: EXISTS, NOT EXISTS, and Row Goals

From Erik Darling Data

Learn T-SQL With Erik: EXISTS, NOT EXISTS, and Row Goals Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training....

Learn T-SQL With Erik: Getting Defensive with CASE Expressions

From Erik Darling Data

Learn T-SQL With Erik: Getting Defensive with CASE Expressions Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m...

Query Exercise Answers: Returning Routes in the Right Order

From Brent Ozar Unlimited

In your most recent Query Exercise challenge, I ga...

Modifying a Trigger to Capture More Info: #SQLNewBlogger

From SQLServerCentral Blogs

I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to... The...

Learn T-SQL With Erik: Subqueries With NOT IN

From Erik Darling Data

Learn T-SQL With Erik: Subqueries With NOT IN Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering...

Video: Reshaping Data with APPLY

From 36 Chambers – The Legendary Journeys

 

Guide to Decoding SQL Server Bulk Insert Error Files

From IT Pro - Microsoft Windows Information, Solutions, Tools

 

Station Coding Exercise from Brent Ozar

From Greg's Ramblings SQL, Programming and IT Life

 

Tech News

700 Engineers – Not AI – Developed Code at $1.5B Disruptor Filing Bankruptcy

From Past News - RSS Feeds

Builder.ai, once a $1.5B AI startup backed by Microsoft, files for bankruptcy after revelations it used about 700 engineers instead of AI to build apps. The post 700 Engineers –...

Another one for the graveyard: Google to kill Instant Apps in December

From Ars Technica

It was a good idea that arrived too late to matter.

IBM aims to build the world’s first large-scale, error-corrected quantum computer by 2028

From Technology Review Feed - Tech Review Top Stories

IBM announced detailed plans today to build an err...

Starting Points for Quantum Computing Learning

From SQLServerCentral Blogs

I didn't have these in my slides for the Techno Security & Digital Forensics Conference, but brought them up the web browser during the presentation. If you're looking at... The...

US air traffic control still runs on Windows 95 and floppy disks

From Ars Technica

Agency seeks contractors to modernize decades-old systems within four years.

The Lighter Side

Rocket Report: New delay for Europe’s reusable rocket; SpaceX moves in at SLC-37

From Ars Technica

Canada is the only G7 nation without a launch program. Quebec wants to do something about that.

Error'd: Squaring the Circle

From Daily WTF

Time Lord Jason H. has lost control of his calend...

CodeSOD: A Real POS Report

From Daily WTF

Eddie's company hired a Highly Paid Consultant to help them retool their systems for a major upgrade. Of course, the HPC needed more and more time, and the project...

A long-shot plan to mine the Moon comes a little closer to reality

From Ars Technica

To make this plan a reality, Interlune needs larger lunar landers to come online.

Tools for Dev (SSMS, ADS, VS, etc.)

SSMS 21 Fixes Irritating Problem

From Scary DBA (Grant Fritchey)

I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today, celebrate with me that SSMS 21 finally, at long last, fixes the irritating fact that...

 
RSS FeedTwitter
This email has been sent to [email protected]. To be removed from this list, please click here. If you have any problems leaving the list, please contact the [email protected]. This newsletter was sent to you because you signed up at SQLServerCentral.com. Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
[email protected]

 

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