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

Rising Pay for Certifications

Certifications can pay off, at least in some areas. There's a piece that talks about pay rising for some tech professionals when they have some credentials. Networking, architecture, and project management are mentioned in the report, as are database and data management.

I haven't seen the source report, and I'm not sure which certifications are getting higher pay rises, but I'd guess that newer data technologies, things related to cloud databases, and even anything related to AI is likely to get you a raise.

Note, that I would guess that if you want a raise, you likely need to change employers, as those companies who have skills gaps in their teams are likely to overpay in the short term. There are certainly pockets of change in many organizations that are looking to move faster and adopt new technologies and might need training for existing staff as well as hiring new people to handle the workload.

There are two interesting quotes in the article related to AI. The first is that companies are learning that the quality of their data impacts their use of AI, and I suspect they might want more people managing data, checking quality, cataloging it, and more to ensure they can use it to train a GenAI LLM.

The other quote was that "...technologies like AI are forcing organizations to move with lightning speed to fill specific gaps in their job architectures — and too often, they are stumbling." I read this as AI gives people code they don't understand, so there is a need to hire someone experienced enough to review AI code. That's good for experienced people as it creates opportunities, but I wonder if these are short term or this will be a lasting trend.

This is a tough time in technology, in May 2025 as many companies are being cautious about hiring tech professionals. This might be the time to get a few certifications as companies start to put more weight on them along with experience. The cert doesn't prove you can do the job, but with experience, it might give hiring managers a little more confidence you are a good choice.

Steve Jones - SSC Editor

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

 
 Featured Contents
SQLServerCentral Article

Understanding MERGE to Insert, Update, and Delete Data Simultaneously

Noman072 from SQLServerCentral

Learn how to use the SQL Server MERGE statement to efficiently synchronize data by inserting, updating, and deleting records in a single operation.

External Article

Building AI Calls into the First Responder Kit

Additional Articles from Brent Ozar Blog

No, that isn’t an April 1st joke, heh. I know a lot of vendors are shoving AI down your throat, but I can think of a few ways I actually want to get quick, easy advice from large language models (LLM) when I’m calling the sp_Blitz scripts:

Blog Post

From the SQL Server Central Blogs - Monday Monitor Tips: Finding the Hostname for Queries

Steve Jones - SSC Editor from The Voice of the DBA

I was chatting with a customer recently and they wanted to know which host was sending in queries that were causing problems in real time. This post looks at...

From the SQL Server Central Blogs - Streamline Dependency Management in Databases

Chris Yates from The SQL Professor

In the intricate world of business, where precision and efficiency are paramount, managing database dependencies can often feel like navigating a labyrinth. Imagine having a tool that not only...

Deciphering Data Architectures

Deciphering Data Architectures

Additional Articles from SQLServerCentral

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

 

 Question of the Day

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

 

Secondary Query Store

If I enable the Query Store for secondary replicas, what does this do?

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)

Decoding the Collation I

In a collation setting, like Latin1_General_100_CI_AS_KS_WS_SC_UTF8, what does the KS mean?

Answer: This is for kana sensitivity

Explanation: The KS is for kana sensitivity. Japanese has two kana sets, hiragana and katakana. If insensitive, then these two are treated equally. Ref: Collation Terms - https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver16#collation-terms

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
Size of DB on physical disk doesn't match Disk Usage by Table report - Hi everyone I am looking at the size of my db on disk (ie c-drive) and comparing it against SS report Disk Usage by Table.  The size of the mdf file on my storage drive is close to 37 GB.  The sum of all tables and indexes (columns Data (KB) + Indexes (KB)) on the […]
SSIS Won't Create Log Entries - Hi everyone My SSIS package will not log to sysssislog.  I am not sure what to do to troubleshoot.  Can someone please provide some guidance on what I can do to help fix this? Setup configuration: The configuration manager I use is the same one I use in SSIS when I have tasks that read […]
SQL Server is terminating in response to a 'stop' request from Service error - Dear All, In one of the server its repeatedly restarting sqlserver services and not found any thing in logs except this Message SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required. please help to find some solution to fix […]
Somebody realized to configure Cluster-Aware updating on VMWare nodes - Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File server. All servers are VMWare Virtual Servers (with Windows server 2025) Having some problems with configuring the Cluster-Aware Updating. While troubleshooting i was just wondering if this is possible to install. Is there anyone on this forum that was able to […]
SQL Server - Log file not getting smaller on Log backup - I have a database that is in full backup recovery model. When the log file is backed up the usage size is not getting smaller [ dbcc sqlperf(logspace) ] . For example, if the log file is 1000 MB, and 800MB is used, the expectation is when a log backup occurs, the usage will then […]
SQL Server 2019 - Development
Update particular record in a table - I need to update greatherthan8 (category) record to Missing (status) if the same member is in different (category) but having same (status) and that also only when they are  compliant. for example 123 PID i have both lessthan8 and greaterthan8 (category) but having same (status) that is compliant so for this member 123 for greaterthan8 […]
SSIS giving "Error converting data type varchar to float" error - issue resolved.
mysql query timeout upped but job still fails about same number of minutes in - hi, i changed my mysql based linked server's timeout to N'600' instead of N'0' but my job (sqlagent->ssis) goes down at about  the same number of minutes in as when i have it at n'0'.  the error i get is shown below. i'm using an odbc driver (mysql) installed on my sql server to contact […]
is it cache or something else - hi a few days ago i narrowed down the cause of a new problem in ssrs to 2 columns (of maybe 50) in a view.   nobody is claiming responsibility.  the calcs for both are hard to look at.  when i eliminated the 2 columns, the view ran in ssrs fine. if you haven't seen this […]
Reporting Services
Report Server Configuration Manager - The target principal name is incorrect SSL - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. Report Server Configuration Manager - Database - Change Database - Choose an existing report server database. - Test Connection I am able to log into the SQL Server in SSMS without checking […]
Report Server Configuration Manager - Change Database - SSL Error - SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target principal name is incorrect.' in the Change Database setting. I'm trying to set the database in the configuration manager and when I click on 'Test Connection' or 'Next' in the 'Change Database' popup box, I get that error. Report Server Configuration […]
SQL Server 2022 - Administration
How do you keep track of the purpose for SQL Logins? - Wondering how others keep track of the purpose for SQL Logins?  I'm not talking about Windows Logins since you can put notes in Active Directory. We have different systems that use SQL logins and I have a hard time remembering what they are used for, such as just upgrades or regular use by the system. […]
Just a rant about the SQL Server 2022 upgrade - Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am so glad we're doing this in our test environment. During the install, got a popup about a missing file C:\Windows\ProPatches\msoledbsql_18.7.4_x64.msi Try again fails, obviously - I have no idea why they even have "try again" as an option, the file is […]
Edition features - SELECT * FROM sys.dm_db_persisted_sku_features If the result set has no records is it conclusive to state that the enterprise features are not being used and we can downgrade to standard? This is across all sql versions...2008R2,2012,2014...2022 Are there more checks which need to be performed before we make an informed decision ? Thanks
SQL Server 2022 - Development
Internationalisation - Quick one I hope in case I'm heading off in entirely the wrong direction! I've been working on a product for some time now that had an entirely UK-only customer base. The powers that be now want to flog it to Australia and the ROI. For one reason or another, there are a few places […]
 

 

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

 

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