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

The Job Outlook for Database Professionals

This is a strange time for many technology professionals and their employment. It seems many organizations have open positions and are struggling to fill those slots with qualified candidates (one look at this). At the same time, many other organizations have followed the large technology firms (FAANG, MSFT) and laid off large numbers of their staff in the last year.

At the same time, with the hype and rapid growth of GenAI systems, we have companies that are looking to machines to fill some of their labor needs. Salesforce noted that they did not expect to hire more software engineers in 2025 as their plan was to use AI tech to help them write enough code. They've seen productivity gains with AI tech, so they aren't adding more developers. They still need human developers, just not more of them.

While thinking about the labor market, I ran across this report from the Bureau of Labor Statistics in the US, which tries to project jobs across many different industries in the future. They typically are careful and conservative, and while they show growth in the need for database administrators and database architects (and software developers) they also admit they can't quite tell what impact GenAI tech will have on the labor market. They do think there will be an impact, but for now they have the need for data professionals growing faster than average.

Why is it hard to get an IT job? I know plenty of people looking for work that have struggled to find a position that suits them. I think there are a few things at work here. First, many companies have been burned in the past with unqualified candidates. We know hiring is hard, and we will make mistakes with some hires. With the focus on cloud, new technologies, DevOps, and more, companies want to hire skilled people who can hit the ground running.  I also think the supply of workers is high and companies are more choosy about who they hire.

Lots of companies are also investing in their own workforces, upskilling and re-skilling them in new technology. It's often easier to train someone whose work ethic, soft skills, and other factors are known than hire someone new who might or might not be a good cultural fit. I know that I often see budgets for conferences and classes are low, but there are plenty of companies still sending people to classes, conferences, or providing opportunities to learn.

If you want a new job, or you're struggling to find one, I can't stress enough the importance of working on your own skills and showing prospective employers that you are investing in yourself. Take stock of your skills and work on projects, experiments, build things, blog about them, and show companies that you have the skills they need.

Don't forget your soft skills as well if you're investing in yourself. Learn to communicate well, both written and verbal, as that can often set you apart from other candidates. As someone that has interviewed others, those skills sometimes are more impactful than your technical ones.

Invest in yourself now, and you'll be ready for the challenges you face in the future.

Steve Jones - SSC Editor

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

 
  Featured Contents
SQLServerCentral Article

Understanding the Logical Functions IIF and Choose in SQL Server 2022

Noman072 from SQLServerCentral

Learn how to simplify conditional logic in SQL Server 2022 using the IIF and CHOOSE functions.

Technical Article

The Power of Generate_series

Additional Articles from SQLServerCentral

SQL 2022 introduced the function generate_series which permits us to solve problems for which we previously had to use a table of numbers (also known as a "tally table"). generate_series is a great addition, because when using a table of numbers there was always a risk that you could run out of numbers. Or some joker could have deleted rows from the table. All these worries are gone with generate_series.

Blog Post

From the SQL Server Central Blogs - Join me at the Microsoft Fabric Community Conference with a discount code

Meagan Longoria from Data Savvy

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which takes place March 31 through April 2 in Las Vegas, Nevada. I will be co-presenting...

Blog Post

From the SQL Server Central Blogs - Data Governance: The Invisible AI Accelerator

Joyful Craftsmen from Joyful Craftsmen Blog

Introduction Do you remember the effort of tidying up your BI and reporting systems, only to find yourself facing a labyrinth of inconsistent data, missing values, and unclear ownership?...

Practical Database Auditing for Microsoft SQL Server and Azure SQL

Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance

Site Owners from SQLServerCentral

Know how to track changes and key events in your SQL Server databases in support of application troubleshooting, regulatory compliance, and governance. This book shows how to use key features in SQL Server ,such as SQL Server Audit and Extended Events, to track schema changes, permission changes, and changes to your data. You’ll even learn how to track queries run against specific tables in a database. ss

 

  Question of the Day

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

 

The Character choice

What happens when I run this code in SQL Server 2022?
create table Names ( namestring varchar(20)) go insert Names select 'Steve' go select choose(namestring, 'steve', 'andy', 'brian') from Names

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by MMartin1)

Dateadd with a numeric value

What is returned from the following query ?

declare @currentDateTime DATETIME = '2025-01-01 00:00:00.000' select dateadd(hour, 3.0/2, @currentDateTime); 

Answer: 2025-01-01 01:00:00.000

Explanation: From the DATEADD Docs at: https://learn.microsoft.com/en-us/sql/t-sql/functions/dateadd-transact-sql?view=sql-server-ver16DATEADD truncates a specified number value that has a decimal fraction. It doesn't round the number value in this situation."

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.


Development - SQL Server 2014
Different number of records returned from SSMS and C# ExecuteReader - I am using the EXACT same query in SQL Server Management Studio (2014) as I am in my C# program, but I get different results. How is this possible? SELECT tblWTHistory.Date, tblWTHistory.EstCompDate, tblOperator.BadgeID, tblOperator.OperatorName, tblWTHistory.WONum, tblWTHistory.WOType, tblWTHistory.PartNum, tblWTHistory.CellReceivedQty, tblWTHistory.OpNum, tblWorkCenter.WorkCenterName, tblWorkType.WorkTypeName, tblWTHistory.WorkQty, tblWTStatus.StatusName, tblWTHistory.ReasonID, tblWTReasons.ReasonName, tblWTHistory.Rework, tblWTHistory.OpComment FROM tblWTHistory INNER JOIN tblWTReasons ON tblWTHistory.ReasonID = […]
SQL Server 2019 - Administration
Column Encryption/Exporting Windows Certificate - So random question about Windows Certificates -- I administer and develop a SQL Server DB App -- Back End is on an Azure Server/Front End is MS Access, about 35 End Users. We employ column encryption on a handful of fields, and re encrypt every 3 months or so.  When this encryption is done by […]
Sync SQL Server and Kafka in real time - Hello, Let say, my .NET API has been inserted successfully into SQL Server Database. It is possible, this data also inserted in Kafka in real time ? This transaction should be done in .NET API or should be done in SQL Server by configuration ? Please help me to understand more and better
SQL Server 2019 - Development
Unable to delete records from table - Hi, Im unable to delete records from a table.Im a little surprised as have not witnessed this. The SQL server runs on MSSQL 2019 RTM. I use the below queries. select top (5) * from Journal where createddatetime<'2006-01-01' -- To figure out the records below year 2006 Fetched the 5 top queries Delete from Journal […]
Is anybody using Windows 2022 clustered SQL Failover cluster ( 2019 CU30 ) - How do you configure the cluster resources to be able to use Distributed Transactions ? Documentation ( 01/15/2014 ) is unclear and doesn't show a working solution. Begin Distributed Transaction fails ! Msg 8501, Level 16, State 3, Line 12 MSDTC on server 'VirtSQLServer\MyInstanceName' is unavailable.
Query Help to show record in single row - Hi All, need help with an SQL query. We have an existing table that's already formatted this way, and I am having trouble extracting the data in single record. Current Output: EXPECTED OUTPUT: The EndDate and EndTime I want it displayed in the same row where BName like '% Start' I tried to do this through […]
MSDTC not available on Windows 2022 clustered SQL 2019 CU30 - I connect to this clustered instance and run : begin distributed transaction Msg 8501, Level 16, State 3, Line 2 MSDTC on server 'ClusteredTargetServer\Instance' is unavailable. I have configured the clustered msdtc of this instance:   Test-Dtc -LocalComputerName $env:COMPUTERNAME -Verbose VERBOSE: ": Firewall rule for "RPC Endpoint Mapper" is enabled." VERBOSE: ": Firewall rule for […]
General
What Version MS SQL Server and SSMS Am I Running? and Git with MSSSQL - Information I've run across searching other topics led me to want to find out what version I'm running.  This was motivated by trying to learn if git/github would be good tools for version control on my database which led to the question of version. I found an article that told me to run SELECT @@version.  […]
Several Questions: Relationships and SSMS and Data Diagrams - I'm struggling setting relationships among tables.  I understand the one-to-many, many-to-one, many-to-many, and self-referential concepts.  It's implementing them that I find a bit vexing. I've used queries like this successfully: ALTER TABLE clan.parents ADD CONSTRAINT FK_FatherID_PeopleID FOREIGN KEY (parentsFatherId) REFERENCES clan.people (peopleID); How can I view relationships after I've completed queries like the above?  After […]
SQL Server 2022 - Administration
Backup taking too much time - Hi Experts, One of my Large database having about 4TB in size is taking almost 3 days to complete the backup . To reduce the backup I stripped the same to 4 different cluster drives and still its taking the same time. The data stored is all documents and it uses filestream. Below are the […]
Keeping QUERIES for Using Again and Adding DB to Git/Github and VS Code - While I know that it will speed my learning to type queries as I need them, sometimes I have put other people's queries to good use, queries that I lack the skills to create but will likely use in the future.  Alas, I find no way to store and retrieve queries making them very accessable.  No […]
Found a Tool Very Helpful for Beginner - I struggled with remembering the conventions I'd chosen when creating column names and data types.  Likewise I struggle - continually - with relationships and keeping track of Foreign Key assignments.  While I have not fully resolved the last issue, I stumbled upon a query that will list all the data elements in a database along […]
SQL Server 2022 - Development
After an Oracle migration, write out a function into a View SELECT statement - This is the function oracle.xxxfloat BEGIN IF @first IS NULL OR @second IS NULL RETURN NULL IF @first < @second RETURN @first RETURN @second END Here is the select statement getting column2, where I need to write the function 'oracle.xxxfloat' inline as part of the select so I can phaze out the above function. In […]
Convert stored procedure into a Table-valued function - <sorry, duplicate> =(  
Convert stored procedure into a Table-valued function - Feel like I'm missing something blatantly obvious. I am trying to return the cost of each of a set of ingredients as of a specific date (so I can sum them in the next step, for example). It works fine if I create it as a stored procedure, but when I try to create a […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. 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

 

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