SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Building Better Training Opportunities

Recently I wrote a piece about some advice on quitting over training budgets, or the lack thereof. It had some interesting comments, but one stood out to me because it's something I've heard and seen before. One of the readers noted that their company had bought a subscription for employees to learn new skills, but few of them had taken advantage of the courses.

I'm not surprised. Many people are tired at the end of the day. Many people are fairly satisfied with their jobs. They're not great, but not horrible, and we enjoy solving problems most days. Most of us would like to continue working where we are, in a stable situation. Not all of us, but many of us want to go to work and get paid for doing so, without a lot of motivation to do more.

That's fine, and I understand the pressures and stresses from the rest of life that weigh you down. I do understand that there are times that most of us would like to get away from work when we can and enjoy time with family, hobbies, faith, and more. My advice is that those things are important, but so is your career. Make some time to improve and grow your career and skills, even if you plan to stick with your current job. You never know when things will change.

With that in mind, I think buying a subscription to Pluralsight or some other training option without providing any motivation or incentive is a poor plan. There needs to be some goals or expectations, and hopefully some sharing of the learning experience.

If you need motivation, or you want to motivate co-workers, what about a competition? Challenge each other to complete a module of a course and write some code. Whether that's to script installs with Chef, create a CI pipeline, count words with Python, or write faster T-SQL, if you have a goal, you'll do better. I've had companies where we scheduled group watching of training, and with a small competition at the end, we found more people to be engaged and active in their learning.

You could even make this a part of the review process, though please don't just make this a checkbox. Ensure that if you want employees to learn something, you ask that they complete a class and contribute something back. Teach others, build something useful, or benefit the organization in some way. 

When there is a little more motivation, there's a little more effort, and that can go a long way towards improving the skills of your workforce.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 3.5MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

ADVERTISEMENT
SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

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

Featured Contents

 

Converting Binary Numbers To Hex

Steve Jones from SQLServerCentral.com

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL. More »


 

Redgate acknowledged as a representative vendor in Gartner’s 2018 Market Guide for Data Masking

Press Release from Redgate

Data masking really has come of age. Gartner’s 2018 Market Guide for Data Masking has just been published and predicts that the global enterprise use of data masking (DM) or similar de-identification techniques will rise to 40%, an increase from 15% in 2017. And Redgate is acknowledged in the Guide as a representative vendor for Data Masking. More »


 

SQL Server Auditing for HIPAA and SOX – Part 4

Additional Articles from SimpleTalk

Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities. More »


 

From the SQLServerCentral Blogs - Power BI Visual Usability Checklist

meaganl from SQLServerCentral Blogs

At PASS Summit, I presented a session called “Do Your Data Visualizations Need a Makeover?”. In my session I explained... More »


 

From the SQLServerCentral Blogs - Part 2: Predictive Modeling using R and SQL Server Machine Learning Services

Arjun Sivadasan from SQLServerCentral Blogs

Recap! Part 1 of Predictive Modeling using R and SQL Server Machine Learning Services covered an overview of Predictive Modeling and the... More »

Question of the Day

Today's Question (by Steve Jones):

I have to store a series of negative numbers, all of which are between 0 and -100. What data type should I use in my table?

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: Data Types.

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

If I run this query:

 SELECT * FROM dbo.OrderHeader AS oh WHERE oh.Status = -100 

I get no rows returned. What's confusing to me is I have this code in a stored procedure.

 DECLARE @status INT; SELECT * FROM dbo.OrderHeader AS oh WHERE (status = @status OR @Status = -100) AND oh.OrderTotal > 0; 

If I pass in status 1, I get the correct rows for status 1. If I pass in -100, what do I get?

Answer: I get all rows for all statuses

Explanation:

Here the WHERE clause is evaluated as a boolean for each row. When I pass in -100, I get a 1 because this always evaluates to a true value, so I get all rows for all statuses.


» 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

High memory utilization on SQL Server - Hello Gurus, I had emailed earlier  but didn't get any response and googled but didn't get enough info: We have a prod...

Maintenance plan failing - Hi, I have 2 drives where db full backups( D:) and log backups(E:) are created for weekly once Maintenance plan.  The problem...


SQL Server 2017 : SQL Server 2017 - Development

Inserting a new row into a table using a cursor - Hi all, I need help.  I hope someone can provide some info. I have provided the SQL code below. Please note on...

Exif data into a database. - Hello All, With the ExifTool by Phil Harvey I make a number of .CSV files from different media (harddisk, USB-stick, CD-rom's...

Incremental Table Copy - Hi, I have 3 huge table in excess of 100 GB each which need two be copied between two SQL 2017...

EBCDIC file is getting loaded with all special characters in my table - Hi, I have an EBCDIC file and I am trying to load it using SSIS. I created a flat file connection manager,...


SQL Server 2016 : SQL Server 2016 - Administration

order of columns - Good morning Experts, Does the order of columns in a table matter? Also, does the order of columns in an index...

sql server 2016 express installation headache - I installed sql server express 2016 on a windows 2016 server.  Using the same extracted software, I installed SSMS using...

Restarted - Hi,  Happy Friday! ..I see the sql server was restarted in "dashboard". However how to confirm why and by whom it...


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

Inner joins - Hi all. Our current version is 2008 and we are going to migrate it to 2016 or 2017. In many stored procedures,...


SQL Server 2014 : Administration - SQL Server 2014

Deleting older data from Large table - I was deleting the data from a table older than 2 yrs and run the process for1 hr and later...

TempDB - Hi, Please i need your advise,to reduce TempDB allocation contention i must add more mdf files.I have a drive allocated for...

Unregistered Component Error in SSIS - I can't create any Data Flow Task. Once I create (tested and working) Connection (it doesn't matter if it is...


SQL Server 2014 : Development - SQL Server 2014

poor performing report query against table without a PK - The table is practically a heap because its' clustered index is on a column that allows NULLs, and there are...


SQL Server 2012 : SQL 2012 - General

Tempdb and prop fill - Hi We have a SQL 2012 server with Tempdb that has 4 data files. The Tempdb disk is 200 GB. We have traceflag...

DB Corruption - Hello, One of the teams at my place of work came to me with a problem with one of their SharePoint...


SQL Server 2008 : SQL Server 2008 - General

Reindexing and Log files - Hi all, Recently, we've had an issue with disk space on the server that houses our .mdf and .ldf files. As...


SQL Server 2008 : SQL Server Newbies

sys.dm_exec_query_stats - Is there a way to know which query plan added last 5 minutes into sys.dm_exec_query_stats by date . Thank you in...


Programming : Powershell

parse string and check for valid date - I have a flat file with a bar(|) delimiter. It has no headers, but I want to check columns(11,12,13) for...


Data Warehousing : Integration Services

SSIS VS 2015: What SSIS task should i use to check whether there is any Excel file in a directory? - I need in my package to make sure that the destination folder contains no .xlsx files, and then depending on...

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