 | A community of more than 1,600,000 database professionals and growing |
| | When it comes to salaries, I'm not average Today we have a guest editorial as Steve is out of the office. Negotiating salaries is usually hard and often a bit awkward. The employee wants to maximize their earnings and feel like they are being fairly compensated based on experience, tenure, and ability. The employer generally wants to pay fairly, but not give away the store and are often constrained by HR, so they can’t give away the store. Both sides are looking for benchmarks to use to support their case. Which benchmark to use though? Payscale is a commonly used one as is Salary.com. Glassdoor is worth checking. Those may be supplemented or replaced by others though. For example, here in Orlando, there is the annual salary survey of developers. Those of us in the data space might point people to the 2018 Data Professional Survey. I always supplement those by checking in with a couple of local recruiters. Any of them can be useful if you like the numbers they show! As you look at the benchmarks be mindful that the job title matters. If your title doesn’t match the benchmark (or matches one that isn’t really the same), it hurts your ability (and that of your manager) to pay you more. Sometimes you have to work on getting your job title or description changed to better reflect the work you do before you can finish negotiations. Sometimes it’s as easy as getting them to put “Senior” in front of your current title. You also have to make sure the numbers are regionally adjusted. Wages and costs in Orlando are different than Austin and San Jose. Sometimes you’ll get an employer that will pay big market wages regardless of where you live, but that’s the exception. Most will want to be inline with the local market. You do the research, your boss or hiring manager does the research, and then you sit down for the talk. I’d urge you to keep in mind that neither you or your boss is an experienced negotiator, so it may not go smoothly. Eventually the cards are on the table and it’s at that point you’ll hear something like “the market average for your position is …” as a reason they cannot pay you what you hoped to earn. I get it. I’ve been on both sides of the table and I know that the benchmarks come in to play. But that doesn’t have to be the end of the discussion. It’s at this point I calmly say “I’m not average”. It’s a little funny how that disrupts things in a good way. It usually sets them back a step. They have to process that, then think about whether they see you as above average. If they agree you are above average, the same benchmark will support paying you more and they will see that. If they don’t see you as above average they have to have that conversation and while it may be uncomfortable for a few minutes, you’ll either convince them to reassess or you’ll get the definition of what you need to do to be above average when you next meet. Using “I’m not average” is not a strategy for a beginner or someone without a good measure of self-confidence. The latter is important because most of us tend to overestimate our value, if not our skills, and it’s not going to be a great day if we find out we’re not as above average as we thought we were. Think on it some and if you take nothing else away from this I hope you’ll look at every relevant benchmark you can find before you go into the next negotiation. An hour of research is time well spent. Andy Warren from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT |  | Benchmark your Database DevOps maturity level Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment |
|  | What’s the top challenge faced by SQL Server professionals in 2018? Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report |
|
|
|
| |
 | Additional Articles from Microsoft MSDN In-Memory OLTP (project “Hekaton”) is a new database engine component, fully integrated into SQL Server. It is optimized for OLTP workloads accessing memory resident data. In-Memory OLTP allows OLTP workloads to achieve significant improvements in performance, and reduction in processing time. Tables can be declared as ‘memory optimized’ to enable In-Memory OLTP’s capabilities. Memory-optimized tables are fully transactional and can be accessed using Transact-SQL. Transact-SQL stored procedures can be compiled to machine code for further performance improvements on memory-optimized tables. The engine is designed for high concurrency and blocking is minimal. More » |
 | Louis Davidson explores the hidden treasures within SQL Prompt right-click context menu when working in the SSMS grid format results pane. More » |
 | Steve Jones from SQLServerCentral Blogs I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None... More » |
 | Bert Wagner from SQLServerCentral Blogs I love continuing my education in SQL Server. Recently I was fortunate enough to take Brent Ozar’s 3-day live online... More » |
|
|
| | Today's Question (by Henrico Bekker): When executing a SSIS package in Azure Data Factory, the package requires conversion or execution in 64bit. |
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: SSIS. We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): Which of these are true about lists, tuples, and dictionaries? (choose 3) Answer: - lists are denoted by brackets, i.e. ["Broncos", 18, "2016-02-07"]
- tuples are denoted by parenthesis, i.e. ("Broncos", 18, "2016-02-07")
- dictionaries are denoted by braces, i.e. {"Broncos", 18, "2016-02-07"}
Explanation: Python lists are denoted by brackets, dictionaries by braces, and tuples by parenthesis. Ref: Python Data Structures - click here
» 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. How to find the all table list in the order of reference - Hi, How to find the entire table list in the order of Foreign key reference in a database ie. Parent table first,... Lock on SQL data rows - Hi, Can some one please help how can I acquire lock on rows while it is being worked by some one. My... Looking for some thoughts on design for db table renaming. - Basically, we have a 2 tables. One is being used by the app for querying (active), and one is used... Converting MTVF to In-Line TVF. - I am trying to convert a MTVF into an In-Line TVF. I already went through and changed a whole lot... query performance - Hi, I have this execution plan and a query which run more than 10 h.Please help me with some performance tuning recommendations. UPDATE h SQL 511 error on a SELECT statement - I am receiving the message while doing a SELECT statement. Msg 511, Level 16, State 1, Line 1 Cannot create a row... Linked servers on an instance all pointing to the local instance. - We have around 4 linked servers on an instance, each one of them pointing to a remote instance. These were... The transaction log for database 'database_name' is full due to 'XTP_CHECKPOINT' - Hi Gurus, I'm new to SQL Server. We got an issue on our Production Server at this moment and i'm having... SARGability of query - We have inherited the following (obfuscated) code, and are looking to improve performance. MyAudit has over 35 million rows, and... Logging options while running stored procedure - Hi I am tasked with building a stored procedure which performs inserts, merges, etc. What i have now is as follows. create... SQL Transactional Replication - Hi, We have a 2008 based replication system up and running. We have a table, which is currently replicated and full of... Clustered PK perf - - Hi Experts, I have a doubt reg. the creation of a clustered PK for one of our DWH tables. Background - There's a... Top 2 records with range - Hi, Below the test daa Declare @Score table(IdScore int, score int, Name varchar(100)) insert into @Score(IdScore,score, name) select 1,0, 'poor' union all select... get starting to last specific string valuesin sql server - Hi I have one doubt in sql server . how to get first position to right side specific character position. table : empfiles filename: ab_re_uk_u_20101001 ax_by_us_19991001 abc_20181002 I... Programmatically trigger an event on a WinForms object in Powershell - Hi all, Let's say I've got a label ($ObjLabel) and a checkbox ($ObjCheckBox), that is created not checked, and added to... Measure Calculation - Here some background: I am using vs2010 multidimensional cube solution. My fact table, FactProductionClaims, consists of contract keys and the claims keys... Computed columns best practices. - Hi all. I'm having a helluva time deciding whether or not to use a bunch of computed columns. I seem... Restore with different name on same server - Hello All... I have a database XYZ (Full Recovery Model,300 users in it size aroung 134800 MB,) on Server 1(dev) I need... Taking backup with option "Disk = nul" - hi , can anybody tell me what exactly below backup query does ? and where it keep the backup file after taking... Each GROUP BY expression must contain at least one column that is not an outer reference. - Hi, i'm raising the summary tables by using the following query, INSERT INTO ClientTbl_SummarySalesMonthTY ( , , , , , , , ... |
|
| 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. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it here.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com |
|
|