| A community of more than 1,600,000 database professionals and growing |
| | | Your Job Description In every job I've ever held, there's been some scope creep in my duties. No matter what I think my job is, I end up handling tasks in very different areas. While bartending, I've had to cook food a few times. While managing a network, I ended up performing some software development. As a DBA, I've assembled network cables. As a manager, I've had to arrange and setup dinner banquets for late working employees. Even at SQLServerCentral, I used to have to make sales calls when I expected to be more of a technical worker. That's the sign of a good employee. Someone that pitches in and gets the work done as needed, doing their best if the task is out of their skill area. It's what I'd expect from most employees, though I've never worked with a union. Rules might be different for union employees, though I'd hope most would pitch in in a crisis. I also think this is something I look for when I interview people. I hope to get the feeling from a candidate that they'd be willing to learn to handle tasks outside of their primary position. I was thinking about this as I read a post about job descriptions. It talks about the mess that many job postings contain, with a wide variety of requirements and duties. I think many of these descriptions, especially in technology are the result of too many chefs working on the final product. From what I've seen, most of the descriptions need a mythical candidate in order to meet all requirements. Companies will never find this person and instead compromise their choice based on who applies. So, always apply if you meet 50% of the requirements. This made me wonder about the descriptions that are out there. Some of them are really crazy, but I think some of the issue is there are people that want to make their jobs sound more important than they really are, just as they may do with their job title. Keeping this in mind, what would you say is your job description? Is that what you'd list in a job posting or would you add more or take away some of the items? I used to want a more important title, and a more complex job description as I was growing my career. These days I'm less concerned with pumping up my job, but I think that's part of the cycle of a career. I'm curious where you are in your career and how you might describe what you actually do to others. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.8MB) podcast or subscribe to the feed at iTunes and Libsyn. The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | | | | How to track every change to your SQL Server database See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more |
| | | | We’re making SQL Server audits easier – can you help? The Redgate Foundry team have just finished researching the problems caused by SQL Server audit and compliance. This blog post shares what they've learnt, and explains how you can get involved with their early access program. Find out more |
|
|
|
| | | | | Additional Articles from MSSQLTips.com Your SQL Server drives are running out of disk space and you want a way to quickly tell which sub-directories are taking the most space - here's how to do it with T-SQL. More » |
| | With ten programmers working on the same project, how do you agree on a standard style for formatting SQL code, and then implement it consistently? One way is through draconian rules, meeting after meeting, and the occasional sacrifice of a programmer to put the fear in those who remain. Another way is using SQL Prompt, Louis Davidson shows how. More » |
| | Daniel Janik from SQLServerCentral Blogs Recently my wife and I were comparing Cortana with Siri. It’s sometimes fun to compare virtual assistants to see how... More » |
|
|
| | | Today's Question (by Steve Jones): I've got a sales table that contains price amounts for products. The data is similar to this: 21, 18, 11, 25. I want to mask this data for users, but I want the data to be close to the original values. What masking function do I use? |
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: Dynamic Data Masking. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): When I run this query, I get an error. DECLARE @json NVARCHAR(MAX) = ' { "City" : "Denver", "Team" : "Broncos", "Offense" : { "QB" : "Siemian", "RB" : "Anderson", "WR" : "Thomas" } } ' SELECT JSON_VALUE(@json, 'strict $.team') The error is: Msg 13609, Level 16, State 2, Line 14 JSON text is not properly formatted. Unexpected character '"' is found at position 130. Why?
Answer: The case of "team" is incorrect Explanation: JSON is case sensitive, and therefore the query must be $.Team. Ref: JSON_VALUE - 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. Distribution Cleanup job Issue - My Distribution DB is keep on growing and the Distribution clean job fails with the below error. I have added the... need counts of unique patients - Friends, i am counting unique patients that were referred by a doctor.i simply used distinct count by referring doctor to get... sql logic issue, using OUTER APPLY, causing loss of data. - I have a source that contains rows for applications that have experienced issues aka 'Alerts', their issuestarttimes, and resolutiontimes. I... Need counts of orders by month and year - Hello Everyone, I'm hoping someone could help me out, so here's my scenario: I have a table that tracks orders from... Parent-Child records - Goodmorning, Ihave a table that stores par Schema design , many-to-many M:N - Basically trying to get my head around how to enforce primary / foreign key constraints on what is essentially a many-to-many... SQL server 2014 is very slow - Based on this report(performance monitor) can any one tell why the Sql server is running slow. many application have slow... Updating multiple columns in a single statement for a table according to non-matching column names - I need to populate a table containing customers’ ageing with the remaining amounts in each of four columns. The customer’s... Not able to pass Parameters in Stored Procedure through SSRS - Hello Sir I have created a stored procedure (fetching data from wonderware Historian).I want to pass parameter @Para from SSRS.But its... Permission denied error on object - Executing the query "PROC_ACTION_INSERT ?,?" failed with the following error: "Cannot find the object 'PROC_ACTION_INSERT ', because it does not exist or... Nested loops estimated rows equal 1 - Why do I have one estimated row in the nested loop node 2 while correlated seek and scan each has... Rolling 6 Months - I have a table: Date Value 05/09/2017 88,688 12/28/2016 66,777 10/14/2016 55,444 . . . I need to subtract the value for a date (05/09/2017) which is... How to update column type ? - How to update column type VARCHAR to NVARCHAR ? I have data in VARCHAR column. I need a script which would update... Batches and Transactions - I have a stored procedure that has multiple commands: Inserts, deletes, creates temp tables. I put Begin Transactions .... Commit in... Schema name, Schema Owner and Login - Hi guys, I have two logins abc_prod and abc_dev in my prod environment. All our objects are created with schema... grant execute overrides user permissions - Hi. It looks like granting a user permission to execute a proc overrides that user's insert/update/delete permissions they'd otherwise have... Database Mail Queue stuck in INACTIVE State - can't get Database Mail to work on Server - Please post to the following: http://www.sqlservercentral.com/Forums/Topic1276632-1550-4.aspx#bm1276973 I execute the following statement to check the status of Database Mail: EXEC msdb.dbo.sysmail_help_queue_sp @queue_type = 'mail'; The mail... SQL Server Agent jobs not running as scheduled - Hi all, has anyone encountered sql server agent not actually running the jobs it is schdeduled to run?! It was recently... SQL behaving strangely on different servers - Hi All, I have a sql statement working on static tables (no Insert,Update,Delete) on our testing server it's running very fast... SSIS precedence constraint, check my logic please - All, I'm an SSIS newbie, putting together an SSIS package to push data from a source server to several destination servers. ... |
|
| 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.
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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
