 | A community of more than 1,600,000 database professionals and growing |
| | When someone asks you what you do for work, how do you answer? A common thing to ask someone when you first meet is: what do you do for work? It is an interesting question that can often dictate where the conversation goes from there. Sometimes I think we should come up with creative job titles just to surprise people when they ask us what we do for a living. What if we said our job title was: Senior Department Lead IV Technical Architect? Sounds pretty good, but it doesn’t exactly say what we do at work. I supposed we could call ourselves a Senior Boffin (you will have to look it up). It can be difficult to properly describe what we do at work in a job title. I would guess a number of us play multiple roles and have a lot of different responsibilities at our jobs. We might manage servers, write code, create reports, manage ETL or datamarts, etc. How do we even begin to try to describe these things to someone we just met, let alone have a job title that describes them? I would guess some of us just answer with: I work with computers, or I work with databases. Then if someone shows some interest, we dive into more detail and hope we don’t bore them to pieces. Personally, I do find it intriguing when I meet someone and they say they work with computers. It really could mean anything. They could be help desk, or tech support. They might work with networks. Or they could work with databases, write code, etc. So I guess for me a more general answer, causes me to want to know more. I suppose it is not very impressive to say you work with computers, but honestly actual job titles probably don’t impress anyone either. I know mine doesn’t. I know a number of you have DBA in your title. So do you use that when someone asks what you do for work? I can see how someone who isn’t technical could get confused. “Did they say MBA? I was asking what they did for work not what degree they have.” Or perhaps if you are from the U.S. they would ask themselves, “NBA, they seem a little short for that type of work.” I guess in the end we are sharing a little bit of ourselves when we tell someone what we do for work. So what best describes what you do for work? What job title would you give if someone asked you what your profession was today? Ben Kubicek from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| ADVERTISEMENT |  | CI/CD for your SQL Server database Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control. Try it free |
| |
|
|
| |  | Manjunath Matathamana from SQLServerCentral.com This post covers the basic details that you need to know while developing a RESTful API using Node, Express and SQL Server. More » |
 | Steve Jones shows how a developer, who is a sysadmin on their own SQL Server instance, can migrate their existing development databases to clones, using SQL Provision. Using a simple PowerShell function, we have seen a repeatable process that is quick and consistent. More » |
 | Additional Articles from SimpleTalk Data for Power BI can come from many sources, but often the data is hosted in SQL Server. In this article, the fifth of the series, Robert Sheldon demonstrates how to work with SQL Server data in Power BI Desktop, including relationships between tables. More » |
 | From the SQLServerCentral Blogs - Temporal TablesSQL_Girl from SQLServerCentral BlogsLet’s start off with what is a temporal table? SQL Server 2016 introduced support for system-versioned temporal tables as a... More » |
 | Harsh Mishra from SQLServerCentral Blogs Very rarely there is a need to force an execution plan and even more rarely we should be doing it.... More » |
|
|
| | Today's Question (by Steve Jones): I create and populate this table in SQL Server 2016. CREATE TABLE NULLTest ( myint INT, myvalue VARCHAR(20)) GO INSERT dbo.NULLTest ( myint, myvalue ) VALUES (1, 'Steve' ), (2, NULL), (3, 'Andy') GO Now I want to run this query: SELECT nt.myint , nt.myvalue FROM dbo.NULLTest AS nt WHERE nt.myvalue = NULL; What should I SET to get this to return 1 row. I have the default settings for a US English installation already. These are: - ANSI_NULLS - ON
- ANSI_NULL_DFLT_OFF - ON
- ANSI_NULL_DFLT_ON - OFF
|
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. 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): In SQL Server 2016, I want to create a trigger that prevents the altering of any table in only one database, not on the whole instance. How should I write this? Answer: CREATE TRIGGER StopAlter ON DATABASE FOR ALTER_TABLE AS ROLLBACK; Explanation: We can create a DDL trigger with a database scope by using the ON DATABASE phrase after the trigger name. This trigger will prevent any table alters in the database in which it is created. CREATE TRIGGER StopAlter ON DATABASE FOR ALTER_TABLE AS ROLLBACK; Ref: DDL Triggers - 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. Insert in the Insert statement the previous value from the before value - CREATE TABLE .( NOT NULL, NOT NULL, PRIMARY KEY CLUSTERED ( ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,... sql server 2016 distributed availability groups - Hello This new feature "sql server 2016 distributed availability groups" is awesome. But can you please explain the few key pros... how to restore an encrypted database - Hello, can anyone let me know how to restore an encrypted databases. I already have the necessary keys. Regards Atulyan Padmanabhan How to pass and use Variable on CTE - Hello comunity, I want to use my variable on my CTE but my CTE query don´t return result. Here is my script... How to implement the threading in storeprocedures without duplicate - Hi All, My table have 10000 records and i create the 5 store procedures and my 5 applications exec the... Difference in performance restore database - Hi, everyone. Is there difference in performance, if I restore database from full backup in existing database. And if I delete... Comparing Tables with Union against another Table with conditions - Hello, I have this query, select * from (select from . union select from . where like '%abc%' or like '%def%') as C where not... Self join to get desired result - I have a table where i have column (ItemNo,Year,Month(Jan,Feb,Mar...Dec) But i need in this format as one item no and all... Left padding a FLOAT type with zeroes - Dear Friends, I'm in a situation where in I've to Left Pad a column of type Float with zeroesto a length... SA user unable to access a database - Dear All, I have scenario where in I have to create a user who has no access to a database D2... How to restore SQL server database from damaged MDF file? - Hello everyone, My SQL server data file has been corrupted and I do not have a database backup. But it... ssrs 2012 report written mailing labels - In a new ssrs 2012 report, I need to write a report that is written like mailing labels. Basically I... |
|
| 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 |
|
|