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

The Voice of the DBA

Mercenary

This editorial was originally published on Oct 14, 2014. It is being re-published as Steve is out of the office.

I was listening to a few people talk at an event about the software they were working on. For some of them, there was a true passion in solving the problems they faced. However these weren't applications that eased poverty with cleaner water, or more efficient transportation. These weren't applications that dealt with medical issues impacting human health. In many cases these were simple, consumer applications that entertained people, but these developers were quite proud of the applications they worked on.

The challenge of practicing their craft on these projects elicited quite a bit of passion from these developers. They not only took a lot of pride in building an efficient set of methods in Java or C# quickly, they really enjoyed the process of taking a development task, writing code and tests, and delivering software that worked. They would even find pleasure in receiving a bug report, finding the issue, and delivering a corrected version of code. Most of all, however, they believed their software was making the world better in some way.

There were also plenty of developers that didn't really care what they worked on. They didn't find anything special about software development, and were happy to get assigned a task, write some code, and deliver it. They weren't looking to produce shoddy applications quickly, and many of them were talented developers. They just didn't much care where they worked or what the function the software performed.

Is this you? Are you willing to work on whatever application comes your way? Or do you have a passion to build something in particular, to work on projects that have some meaning to you? I think I've usually been one of the former, willing to work on any application. I've always been more concerned about the coworkers I have than the project we work on, but there are times I've felt our applications were a little special, and made a difference in some way.

Without a doubt I think most of us would prefer to work in an area that means something to us, an area that elicits some passion. I just wonder how many of us actively seek out such positions or projects.

Steve Jones from SQLServerCentral.com

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

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

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

Featured Contents

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

Joshua Feierman from SQLServerCentral.com

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion. More »

Transaction Locking and Row Versioning Guide

Steve Jones from Microsoft MSDN

This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently. More »

From the SQLServerCentral Blogs - Randomizing Names with Data Masker

Steve Jones from SQLServerCentral Blogs

Data Masker for SQL Server is pretty cool. It can reduce your attack surface area and exposure under the GDPR... More »

From the SQLServerCentral Blogs - Why I blog: TSQL Tuesday #102

Kenneth Fisher from SQLServerCentral Blogs

It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given... More »

Question of the Day

Today's Question (by Steve Jones):

What happens with this code?

 SELECT COALESCE(5, CAST('A' AS INT), (SELECT (1/0)))

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: Coalesce().

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

This comprehensive and authoritative guide will teach you the DAX language for business intelligence, data modeling, and analytics. Leading Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization

Pick up your copy of this great book today at Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I decide that the 20 workers that are added when I installed SQL Server Machine Learning services are not enough. How many can I have in total? What's the limit?

Answer: 100

Explanation:

You can increase this up to 100.

Ref: Modify the user account pool for SQL Server machine learning - 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

SSIS Package Execution issue using ODBC Oracle Source - Hi, I'm having an issue running a package when I have an ODBC Oracle Source. When I manually execute the package...

Error Processing Cube from SSIS package run as a SQL Job - Hi, I am trying to upgrade a SQL server with Analysis Services to SQL 2017 cu5, 14.0.3023.8, (I tried CU4 before...

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

Is there a maximum number of joins allowed in SQL 2016? - I have reports that are between 6 and 100 User DefinedFunctions joined together. When I have the compatibility level set...

Getting free periods from booked periods - I have this issue. I have a table with booked items, simplified here: declare @t table(dBookedFrom smalldatetime, dBookedTill smalldatetime) insert into...

Return rows where value doesnt exist - Hello Everyone, I have a slight problem so I hope you can help. I have a table with orders joined to...

Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an...

Export data in XML to import into Word - Hi Folks, I am building a one-click application to export information from SQL Server 2016 in XML format that will be...

SQL Server 2012 : SQL 2012 - General

Log shipping and database backups - Hi all We've got a few databases that we want to start log-shipping from. Normally, we'd use replication but the 3rd-party software...

The SQL Server Network Interface library could not register the Service Principal Name (SPN) but KERBEROS connections are possible - After rebooting the server running Windows Server 2012 and SQL Server 2012 there was are an entry in the error...

FileStream Encryption - I am evaluating encryption methods for filestream as I am currently using TDE for non file data but filestream data...

SQL Server 2012 : SQL Server 2012 - T-SQL

Why is this query so slow? - I have one "big" table with 300 million rows... CREATE TABLE rstore.OutputDataset(OutputDatasetId INT NOT NULL IDENTITY(1,1) ,OutputDatasetHeaderKey INT NOT NULL

SQL Server 2008 : SQL Server 2008 - General

Send Mail to Particular Mail id if Any employer of the organisation has Birthday on daily basis - Hello, techies, I have a table in my database named HR_Employee_Data, which has everything about particular employees like his/her first...

Federal Holiday Function - Thought this might be helpful. I've written a T-SQL function that returns a federal holiday name based on an input...

SSIS Warning - Global Shared Memory - Hi I'm busy rewriting DTS packages as SSIS packages. As and when I finish a package I run it in debug...

SQL Server 2008 : T-SQL (SS2K8)

Preserving the total field lenght - Hello comunity I have a field Char(10) named bank, and another one Char(15) named namebank. I need to create a TSQL query,...

SQL Server 2008 : SQL Server 2008 Performance Tuning

Query taking more time - Dear All, I have a table and it just have 34K rows in it. I have a non clustered index on...

Data Warehousing : Integration Services

The column "Column 2" cannot be processed because more than one code page (65001 and 1252) are specified for it. - I get this error if i try to import a tab delimited flat file to a table in sql server. The...

Data Warehousing : Data Transformation Services (DTS)

Cannot Open Database "xxx" requested by login. Login failed - I created a DTS package using remote desktop to the server. I'm logged in as me and I'm an administrator. ...

SQL Server 2005 : T-SQL (SS2K5)

Duplicate key error when inserting into a table that has no records!!! Please help! - All, I'm having trouble with an insert statement that is throwing a duplicate error (shown below) on a table with zero...

Career : Events

The SQL Saturday Thread - As popular as SQL Saturday is, I'm surprised that nobody created a thread dedicated to SQL Saturday, so I created...

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.