SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Interviewing Avatars

Imagine that you go to interview a candidate over Skype or even a phone call and the first thing you see or hear is: "Hi, my name is Hank, and I am an avatar. I will answer all your questions about Nick factually and completely, as if you’re talking directly to Nick. Are you still looking to fill this position?"

That's a quote from a blog post about HR and hiring issues. In this post, the author talks about a new system that allows a job seeker to use an avatar as a way to quickly apply for thousands of jobs. While this might be nice for the applicant, would any of you want to interview an avatar? Maybe you would a few times, or maybe you'd even start to like this as a way to get some basic information about a candidate. Of course, if the candidate has loaded up all sorts of technical facts from Inside SQL Server or How Would You Move Mount Fuji, then maybe you're less interested.

One one hand this is scary. On the other it's awesome. I'd love to be able to answer some questions and provide some data about my career and goals and let an avatar go through initial screens. I wouldn't want this to be used anywhere past the initial interview, but certainly it would help me to present a little more of myself in an interactive format. It could be a nice brand, and how fun would it be to interact with Steve's avatar?

In some sense, we might move in this direction. After all, this just levels the playing field between candidates and employers. Plenty of recruiting and HR people use their own software or algorithms to make quick decisions about a large number of applicants. I certainly know that you need to stand out with your brand and ensure your resume and online profile attract attention and this could help with that.

Think about this. Is there a way to better present the data and information about ourselves, using technology to respond and help ensure that the position is a good fit for each of us? Hiring managers might use this, why not us? Actually, they are using Alex and Mya. Would this be a better way for you to control and show off some of your work? Even have the avatar show how you solved problems or responded to different situations? While this seems silly or science fiction, I wouldn't be surprised to see this type of avatar-avatar interaction being used early in the process to decide if both parties should move forward.

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.

SQL Source Control

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


Strange Filtered Index Problem

Mike Good from SQLServerCentral.com

What I thought was a strange filtered index problem but turned out to be a DB settings problem More »


Create Azure VMs with PowerShell Part 1

Additional Articles from SimpleTalk

Azure virtual machines are created for many reasons, even just to have an environment to quickly test something out. In this article, Robert Cain demonstrates the first few steps in automating the process with PowerShell. He shows how to gather information needed and set up a resource group, storage and networking needed for the VM. More »


Automatic Provisioning of Developer Databases with SQL Provision

This article shows a simple proof-of-concept workflow that allows an organization to provision full size databases for developers, using production like data that has been masked automatically as part of the provisioning process. More »


From the SQLServerCentral Blogs - Connect to Power BI Report Server with SSMS

Koen Verbeeck from SQLServerCentral Blogs

Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security... More »


From the SQLServerCentral Blogs - Developer, speaker, blogger – how did all of this happen?

Thomas Hütter from SQLServerCentral Blogs

It’s been exactly two years today, that I stood on an international “stage” as a speaker for the first time,... More »

Question of the Day

Today's Question (by Steve Jones):

I have an Azure SQL Database and want to run Extended Events on this database. My intention is to persist the data in an Event File target. How can I do this?

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: Extended Events (XE).

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


The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced.  Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I don't have time to worry about indexes. I need to create a new database for an application and I have some choices. I want the database engine to run create and drop index statements itself, based on the workload being executed

In which one of these versions of SQL Server should I create my database to allow for automatic indexing? (as of May 2018)

Answer: Azure SQL Database


Automatic Indexing is available in Azure SQL Database, which allows the engine to create and drop indexes as it detects a need based on the workload.

Ref: Automatic tuning in Azure SQL Database - 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

Error in SSIS connecting to MySQL - I have 1.Server_A hosting     MySQL   (5.5.29-0ubuntu0.12.04.2-log) 2.Server_B (windows2012    MySQL   (5.6.38-log)    SQL Server 2012 On my workstation using Visual studio 2015 I created...

SSIS Buffer Error - Hi, I am trying to execute a package and I am getting the following error messages: Error: A buffer failed while allocating...

Removing stored procedures to move to cloud - I got an interesting email today about cutting back on the reliance of the applications on databases and plans to...

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

Updating datetime2 column not working - Hello, Trying to update some datetime2 columns. UPDATE T_MYTABLE SET dateTransferred = '2018-03-26 05.00.00' where id = 1223 Causes an error.  So, I tried casting it. UPDATE...

Strange "The datepart millisecond is not supported by date function dateadd for data type date." error - Hi, I am getting strange error 9810 "The datepart millisecond is not supported by date function dateadd for data type date.",...

SQL Server 2014 : Administration - SQL Server 2014

Point in time recovery with backups from different sources - Users came to me recently with a corrupted database after server crash. They have a full backup from a 3rd...

Setting a column collation to NULL - How can I set a column with a  set collation  back  to null? We currently have a mixture of column...

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

will this SQL trigger recursive - I am new on writing and testing trigger.  I am trying to write a trigger to monitor ta colume wih...

SQL Server 2012 : SQL 2012 - General

RESTORE DATABASE is terminating abnormally. - Hi there, I have a database called - Oneserve_Stage, which for some reason is showing as (Restoring...) next to the database. How...

SQL Server 2012 : SQL Server 2012 - T-SQL

Compare XML column to XML variable (The XML data type cannot be compared or sorted, except when using the IS NULL operator).??????? - Hello, I need to compare an XML column with an XML variable. If the values match, we will not process the...

SQL Server 2008 : SQL Server 2008 - General

Rebuilding Indexes very often is good? - Hi Friends, I was about to work on the production server all day last week. I was doing ETL process. Every...

ldap query with variable - I am querying Active Directory and am able to get results when I hard code the filter requirements. But I'd...

SQL Server 2008 : T-SQL (SS2K8)

TSQL - Return rows based on the value in another row - Hello, I hope someone may be able to help? I have table which holds relationship data where most of the relationships are...

Number of Days between two Day Names - I have a table with a Start Day and a End Day Column ID StartDay EndDay 1 Monday Friday 2 Tuesday Wednesday 3 Friday...

SQL Server 2008 : SQL Server 2008 Administration

SQL Server Backup failed... did NOT record failure in sql server log? - We DO have TraceFlag 3226 enabled.  However, as I understand, it only suppresses successful backup events? We are using Commvault agent...

Programming : Powershell

Could not load file or assembly Microsoft.SqlServer.Smo, Version= - Hi all A lot happened on my machine at work last week - I installed Visual Studio 2015 which somehow messed up...

Data Warehousing : Integration Services

Creating derived columns from column of variable length components - Hi All, I'm hoping to get your guidance on this. I have a column, consisting of variable length sections that needs to be...

SQL Server 2005 : T-SQL (SS2K5)

OPENQUERY UPDATE problem with MySQL as linked server - I need to update a table in a MySQL linked server from SQL2K5. This worked the first time or two...

SQL Server 7,2000 : T-SQL

Prepare a stored procedure work flow diagram - Dear Experts, I would like to prepare a diagram which will explain the work flow of a stored procedure. what is the...

This email has been sent to {user_email}. 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