SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

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.com

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

ADVERTISEMENT
SQL Change Automation

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

Database DevOps

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

Featured Contents

 

Building RESTful APIs using Node JS, Express JS, and MS SQL Server

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 »


 

Getting Started with Database Development Using SQL Provision

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 »


 

Power BI Introduction: Working with SQL Server data in Power BI Desktop — Part 5

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 Tables

SQL_Girl from SQLServerCentral Blogs

Let’s start off with what is a temporal table? SQL Server 2016 introduced support for system-versioned temporal tables as a... More »


 

From the SQLServerCentral Blogs - Forcing Execution Plan

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 »

Question of the Day

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.

ADVERTISEMENT

Microsoft SQL Server 2017 on Linux

This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. Get your copy from Amazon today.

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.

SQL Server 2017 : SQL Server 2017 - Development

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 : SQL Server 2016 - Administration

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


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

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...


SQL Server 2014 : Administration - SQL Server 2014

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...


SQL Server 2012 : SQL 2012 - General

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...


SQL Server 2012 : SQL Server 2012 - T-SQL

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...


SQL Server 2008 : SQL Server 2008 - General

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...


Reporting Services : Reporting Services

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