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

The Voice of the DBA

Top Talent Leaves

This editorial was originally published on Feb 10, 2014. It is being re-published as Steve is out of town.

Derek Jeter will likely play his entire career with the New York Yankees. LeBron James has already left one team, and might leave another soon. Both are Hall of Fame players that have had extreme success in their chosen professions. They are recognized as some of the most talented players in their sports. Why did one stay and one leave? Probably for a variety of reasons, but it seems more and more that organizations are realizing there is some value in the retention of their players and are trying to find ways to improve their success at retention.

In the business world outside of sports, we have much more freedom to change employers whenever we want. Most of us are glad we have that choice. Sometimes we move on when we don't want to, but in the majority of cases I think technology workers leave companies because they aren't happy about something.

There was an article about why the top talent leaves a company and I think it presents a number of issues that many employees experience within their own organizations. People aren't engaged, respected, valued, challenged, and more. In short, they really don't like their jobs. Many of the issues are often easy to fix, but only if you could fix two of the major items mentioned (#7 and #10). Those are leadership issues, often systemic ones that occur when upper management doesn't care about culture or doesn't make an effort to hire and train good managers.

I don't know if I'd prefer to see people in technology working only a few jobs during their careers, spending decades at each, or if we are better workers with the exposure to differing environments and businesses. All I know is that I am glad that I've had the ability to leave bad jobs in the past, usually because of bad managers.

Steve Jones from SQLServerCentral.com

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

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

Write, format, and refactor SQL effortlessly with SQL Prompt

Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial

Featured Contents

SQL Server Performance Benchmarking with Patterns

Paul Brewer from SQLServerCentral.com

A SQL Server, SQL Azure and Hekaton performance bench marking application that uses patterns. More »

Simple SQL: Random Thoughts

Additional Articles from SimpleTalk

How does one get a truly random sample of data of a certain size from a SQL Server database table. Well, there are simple non-portable tricks one can use, such as the NewID() function, but then refining those can be tricky. Take the Rand() function for a start. Can it really provide you with a truly random number? Why doesn't the TABLESAMPLE clause give you a set number of rows? Joe Celko scratches his head a bit, explains some of the issues and invites some suggestions and tricks from readers. More »

Discover database DevOps and more at PASS Summit

PASS Summit lands in Seattle from October 31 to November 3 this year, bringing with it the latest thinking and developments in the SQL Server world. This blog post from Annabel Bradford gives the details of what Redgate willl be presenting on, when this year's Redgate Rocks party will be, and how you can get involved with the team! More »

From the SQLServerCentral Blogs - Avoid “Constants” in T-SQL

matthew.mcgiffen 73574 from SQLServerCentral Blogs

Unlike some other languages, T-SQL doesn’t have the concept of a constant. As good coders, we’ve all at some point tried... More »

From the SQLServerCentral Blogs - SQL Server Temporal Tables

Tim Mitchell from SQLServerCentral Blogs

Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in which relational databases maintain row-level... More »

Question of the Day

Today's Question (by Steve Jones):

What's the limit on text in each row returned by sp_helptext()?

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

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

SQL Server T-SQL Recipes

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):

I have the movies.csv file from the MovieLens project. I want to load this in R Studio for some analysis. What should I do in order to build a variable called "movies" with this data?

Answer: movies <- read.csv("movies.csv")

Explanation:

The read.csv function is used to load a csv formatted file. The file name/path is used as an argument for the function.

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

Column encryption advice - All, If possible I would appreciate your advice on my plan and questions. Situation: I need to encrypt certain columns against the risk...

MS-SQL 2016 Eating Memory - Hi All, I'm a newbie here and in general to MS-SQL but I've been thrown in at the deep end and...

Worse Page Compression after upgrade to SQL 2016 - We have a table with Page compression which is partitioned daily. Before upgrading from SQL 2014 to SQL 2016 each...

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

T-SQL Help on same table join - Hi SQL View SELECT a.Name , Q0.Value, Q.1.Value,Q2.Value FROM A with (nolock) Left Outer join B AS Q0 ON Q0.FK_ID = A.ID AND Q0.Type...

Salesforce data and missing foreign keys - For reporting purposes we have synced our SFDC data onto a SQL server using a third party middleware. Everything looks great,...

SQL Server 2014 : Administration - SQL Server 2014

Database Mirroring Issue - Hello Team, I have a database which was mirroring currectly to DR successfully until the principal database crashed due to fried...

SQL Server 2014 : Development - SQL Server 2014

Extract to CSV File - I have data something like below for one of the column. ADDRESS 2248|("snake") ft NE, FTE 700 When I extract this record to...

Code for 'week to date' DATETIME() mine is displaying previous weeks - (Invoice_Exceptions.DateTime >= DATEADD(dd, DATEDIFF(dd,'17530101', GETDATE()) / 7 * 7 - 7, '17530101')) AND (Invoice_Exceptions.DateTime <= DATEADD(dd, DATEDIFF(dd,'17530101', GETDATE()) / 7 * 7, '17530101')) This code...

Select data based on multiple date criteria - Hi Guys, My company are looking at sending out customer satisfaction surveys to our customers. There are two different date criteria...

How to get columns which has null's - Hi Experts, Need some tsql help. I wanted all the column names from all below 3 tables which has nulls. i.e....

TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO - Hi guys, i wonder why executing a TRUNCATE and INSERT INTO Command is mutch slower than executing these commands separately ? Conditions: recovery...

SQL Server 2012 : SQL Server 2012 - T-SQL

Help in finding events in two-week period - Hello everyone,

OPEN TEXTFILE FROM T-SQL - Hai Friends, I have this TXT FILE And I want to create Stored Procedure to insert to TEMP TABLE With each name of...

SQL Server 2008 : SQL Server 2008 - General

Handling string column with dates - I imported a csv file that has a column with dates. The column is a varchar type and it has...

Stock take FiFo conundrum - Hello, I'd very much appreciate some advice/help with a stock take problem. I've had a look at https://ask.sqlservercentral.com/questions/1961/the-fifo-stock-inventory-sql-problem.html but my scenario differs somewhat....

Reporting Services : Reporting Services 2008 Development

How to create a summary for a dataset - My report consists of a list of patients, location in the hospital, and a column called "TobaccoUseWithin30Days. The values in this...

Data Warehousing : Integration Services

SQL Native client driver 10 vs 11 - Has anyone experienced a difference between SQL driver SQLNCLI11.1 vs 10.1? I inherited a complex SSIS package where I had to...

SQL Server 2005 : Administering

sql backup to avamar - Is anyone using avamar backups to do live backups of sql server? are there any issues, are there problems? AW

SQL Server 2005 : Backups

The database cannot be recovered because the log was not restored. - Hi, my db name is abc.. i hv restored the bckup on tht db.. But in middle i have cancleed the...

SQL Server 7,2000 : In The Enterprise

Project Plan - I'm looking for a decent Project Plan (in any format) for moving from SQL Server 2000 to a SQL Server...

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.