| The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com | Hand-picked content to sharpen your professional edge |
| 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 |
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. |
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 |
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 |
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... |
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 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 |
Optimize your Snowflake data warehouse for speed, cost, and scale with practical tips on query tuning, resource management, and efficient data practices. |
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’... |
Career, Employment, and Certifications |
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... |
After two years of increased responsibilities with... |
This month’s T-SQL Tuesday invite comes from Joe... |
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... |
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) |
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 |
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... |
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... |
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... |
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 |
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 |
See Cole transform a table into an informative vis... |
Database Design, Theory and Development |
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) |
The previous article in this series discussed usin... |
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 |
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) |
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... |
You must have heard the buzzword “Medallion arch... |
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... |
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. |
As an Oracle DBA stepping into the PostgreSQL world, one of the first surprises you’ll encounter is during installation. If |
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! |
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 |
Now that we’ve all learned to love rounded corners, let’s talk about another quiet champion of good design: padding. |
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... |
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 |
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... |
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... |
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. |
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... |
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 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 Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m... |
In your most recent Query Exercise challenge, I ga... |
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 Going Further If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering... |
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 –... |
It was a good idea that arrived too late to matter. |
IBM announced detailed plans today to build an err... |
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... |
Agency seeks contractors to modernize decades-old systems within four years. |
Canada is the only G7 nation without a launch program. Quebec wants to do something about that. |
Time Lord Jason H. has lost control of his calend... |
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... |
To make this plan a reality, Interlune needs larger lunar landers to come online. |
Tools for Dev (SSMS, ADS, VS, etc.) |
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... | 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. 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. |
|
|