SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

What is the best way to on-board (train) a new junior employee?

Today we have a guest editorial as Steve is out of the office.

When a junior employee joins your team, there are a lot of things that need to happen for them to become productive. It is important for them to learn about the details of the business, such as what exactly does the company do? Sometimes there can be industry specific language that needs to be learned. Then there is another side of things for them to learn on the technical end of the spectrum.

This technical knowledge can be more important because it effects their ability to do their job and integrate well with the rest of the team. What source control is used? What style of writing code or scripts is standard? What naming standard is used? What tools, IDE etc. are used? How are things deployed, DevOps, etc.?

Then there is the whole aspect of teaching them skills they don’t know yet or haven’t been exposed to thus far in their career. Perhaps, they are stronger in the administration of SQL server, but haven’t done as much on the database programing side. Maybe they have never used PowerShell before.

Assuming this hypothetical new junior is willing and interested in learning and has enough technical aptitude, there shouldn’t be anything hindering them from becoming a senior someday, right? All it takes is a little investment from the more senior people on the team and perhaps some studying/reading books/online training on junior’s end.

Sadly, in some situations the more senior people don’t want to share, or invest in the people around them. Perhaps they are worried that after putting in the effort and training a junior some of their value as a senior will be diminished. Maybe, they believe once this junior gets enough experience they will just leave for a better job somewhere else.

These can be valid concerns, but I don’t think they should negate our obligation to share and teach others what we know. I would venture a guess that none of us who are seniors made it here without some help from others. So we should also be willing to help train and expand the knowledge of our junior colleagues. This should NOT be done in a condescending prideful way, but recognizing that we were once a junior and in need of someone to show us how to grow in our skills.

So how is this done where you work? Are people assigned to train juniors?  Do new juniors shadow seniors? Share what has worked or not in bringing new people up to speed where you work.

Ben Kubicek from SQLServerCentral.com

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

ADVERTISEMENT
SITC

SQL in the City Summits - New York, London & Chicago

This October, Redgate are inviting those interested in learning how their business can benefit from implementing Compliant Database DevOps to attend one of our SQL in the City Summits. If you manage SQL Server databases, or manage a team of people who do so,  Redgate’s SQL in the City Summit is the conference for you. Find out who’s presenting and register for a Summit near you today.
Register now

RGUni

Redgate University

Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers.
Start Learning

Featured Contents

 

Creating Subtotals and Totals in Aggregated Queries

Adam Aspin from SQLServerCentral.com

Grouping Sets are an effective way to add subtotals to aggregated queries. T His article explains how. More »


 

Free eBook: SQL Server Execution Plans, Second Edition

Press Release from Redgate

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? More »


 

8 practices for business data security

Is your data vulnerable to security breaches? Sophie Ross at Security Gladiators provides 8 rules you should be adhering to to ensure the safety of your data. More »


 

Introduction to Testing Your PowerShell Code with Pester

Additional Articles from SimpleTalk

Everyone knows how important code testing is, and to be thorough, you must automate testing. This includes scripts such as those written in PowerShell as well. In this article, Robert Cain introduces Pester, a tool for testing PowerShell code. More »


 

From the SQLServerCentral Blogs - Format Query as JSON

Eduardo Pivaral from SQLServerCentral Blogs

JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it... More »


 

From the SQLServerCentral Blogs - #SQLCareer 3/4 August 6th 2018

Kenneth Fisher from SQLServerCentral Blogs

Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database... More »

Question of the Day

Today's Question (by Evgeny Garaev):

I want to create an index on a computed column so I will be able to query the orders using a predicate how many days ago they were placed. The OrderDate is the datetime type column. Can I create a following index in order to improve my query performance?

 ALTER TABLE dbo.Orders ADD DaysFromOrder AS datediff(dd, OrderDate, getdate()) PERSISTED; GO CREATE INDEX OrdersIX_DaysFromOrder ON dbo.Orders (DaysFromOrder); 

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: T-SQL.

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

Exam Ref 70-774 Perform Cloud Data Science with Azure Machine Learning

Prepare for Microsoft Exam 70-774 and help demonstrate your real-world mastery of performing key data science activities with Azure Machine Learning services. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.  Get your copy today from Amazon.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have this code that creates a list in the Python REPL:

 >>> Teams = ["Broncos", "Chiefs", "Raiders", "Chargers"] 

What is the result from this code?

 >>> Teams[0:2] 

Answer: ['Broncos', 'Chiefs']

Explanation:

The code returns the values in the list between the 0 and the element with an index of 2, but does not include the element with the index of 2.

Ref: Lists in Python - 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 - Administration

SQL Migration - I have a SQL Cluster with Multiple databases.  some small and large spanning multiple NDF Files. My question is this.  I...

In-place upgrade to SQL server 2017 - I am trying to do a in-place upgrade of our test SQL server from 2014 to 2017. After in-place upgrade, there are...


SQL Server 2017 : SQL Server 2017 - Development

SSIS Package run from Visual Studio but fails from SQL Server Agent with the Error: Exception has been thrown by the target of an Invocation. - HI, I have an SSIS Package which goes to a website using http connection and gets a zip file and loads...

Can't Get BULK INSERT TO ERROR!!! - Hello guy, I was testing my script for bulk insert. But i can't get the rows to error out and...


SQL Server 2016 : SQL Server 2016 - Administration

Managing a large SQL estate ? - Hi, not 2016 specific but cant see where else to ask it and we have a lot of 2016, and...


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

DATALENGTH and LEN difference between NUMERIC(16,6) and NUMERIC(18,2) - Due to one of our customers request in the past, we used to keep financial information across our product in...

Index statistic is empty - how is this possible? - I have a simple index on a table - just one column in the index plus one included column. There is...

How to get a multiple select to populate into a temp table? - I've exhausted everything I have.. I've been trying things for an entire week maybe a week and a half.... I...

Absolutely New to this. Need to query a website to get information. - Any help would be much appreciated.  I need to query a website for a number (Sales Figure) and insert it...

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

When is too many columns too many columns? - I know you can have some insane number of columns in SQL server... but just because you could, doesn't mean...


SQL Server 2012 : SQL 2012 - General

Dynamically pivot a table - Hello, Seeking help to dynamically pivot a table using a date field in a table.  Current structure acctid_prodId    dates 123asd    1/1/2018 123asd    2/1/2018 123asd    3/1/2018 123asd    4/1/2018 123asd    5/1/2018 123asd&nbsp

Cannot fetch a row from OLE DB provider OraOLEDB.Oracle for linked server - Receiving below mentioned error: The OLE DB provider "OraOLEDB.Oracle" for linked server "MAJESCO_OLTP" reported an error.  The provider did not give...

Separating SSIS Datetime - Hi Experts, I have a text file to load to a database.The file has a column Datetime 2013-07-16 15:05:43 and in...


SQL Server 2012 : SQL Server 2012 - T-SQL

Store result in Variable - Hi, I would like to store the first "select" result into a variable to be able to declare it within the...


SQL Server 2008 : T-SQL (SS2K8)

Formatting date of birth using South African ID number - Hi All I need help creating date of birth using ID number the ouput that im looking is a follows e.g. RSA...


SQL Server 2008 : SQL Server Newbies

Balancing Writes - Good Morning Experts, Here is the requirement from client: They have a server A and they want exact replica of server...


Cloud Computing : SQL Azure - Development

Bandwidth to support 30 users 65gb data - Hi All A very broad question I know ..... But what sort of internet connection bandwidth would one need to support a local...


SQL Server 2005 : Development

Date formatting in a text string. - Hi All, I am not sure if I have put this in the correct section as am new to the...

Generate a unique number for a record - Hi, I'm trying to generate a unique id for every record ni a table. The tricky part is, each number is...

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