Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

Daily Coping Tip

Actively listen to what people say, without judging them

I also have a thread at SQLServerCentral dealing with coping mechanisms and resources. Feel free to participate.

For many of you out there working in a new way, I'm including a thought of the day on how to cope in this challenging time from The Action for Happiness Coping Calendar. My items will be on my blog, feel free to share yours.

An Amazing Interview

We have guest editorial today as Steve is on holiday.

Last year, I had the pleasure of interviewing a number of candidates for the post of a SQL Developer.  I had prepared some questions for the interview: some based on technical skills that we were looking for and some from the candidates' CVs.

We had finalized three candidates with very similar skills and level of experience. But one of them left an impression that I thought to share. It was an online interview and as always, it started with formal introductions followed by questions from the Interview Panel. During the interview, we were not only amazed with how well she was prepared, but also with her enthusiasm of working in IT. She genuinely seemed someone who enjoys learning new things that the technology has to offer. Her answers mostly ended with examples showing how she managed to save the day or help the clients in a way better than they had expected.

We were supposed to send HR our feedback by the following day. But before that, we received her feedback from HR, summarizing on how much she enjoyed the interview process, where she struggled to answer, what she felt about our team and the areas where she can learn as well as contribute. For most of us, this was the first time where we had received a feedback from an interviewee. This not only showed her proactive and out of the box approach, but also her great communication skills and her keenness on working with us.

Needless to say, we offered her the role, which she gladly accepted. She is still working with us as a valued member of our team. One thing she regularly quotes is:  "If you are not doing what you love, you are wasting your time. And if you are doing what you love, remember to be grateful and excited."

I thought to title this article as 'An amazing candidate'. However, I know for sure that there are many individuals, just like her, who love what they do in IT and are really good people to work with. But how many can actually showcase this in a tiny window of an interview. I feel I can't, can you?

nitinbhojwani

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

 
  Featured Contents

Using ADF to Upload Disparate CSV Files into Azure MySQL

Randheer from SQLServerCentral

In this article our objective is to showcase how to leverage Azure Data Factory (ADF) and a custom script to upload data in Azure MySQL database when we have CSV files with different schemas. As there is no straightforward way to upload data directly using ADF for this given scenario, it will actually help to […]

SQL Server 101 Tutorial

Additional Articles from MSSQLTips.com

Since its initial release in 1989, SQL Server has come a long way from its base functionality as an enterprise level database platform. While the core of SQL Server is still it's database engine, it is now so much more than just a relational database plat

From the SQL Server Central Blogs - How to: exec sp_help on temp tables?

Will Assaf from SQL Tact

Say you have a temp table and you want to see the columns names.
For example, I was trying to convert a query from using a #temp table to a...

From the SQL Server Central Blogs - ADF: Querying JSON documents

Ed Elliott from Ed Elliott's Sql Developer Blog

In my previous blog post I talked about how to read from an XML Webervice and use xpath to query the XML on the expressions side of things. You...

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

The Managed Instance Audit Targets

I have a Azure SQL Managed Instance on which I want to create a SQL Server Server Audit. However, I want the audit data to go to an Event Hub in Azure. What is the target I specify in the CREATE SERVER AUDIT syntax?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Using mode() in R

What does the function, mode(), do in R? As in:

> i [1] 26 > mode(i)

Answer: This gives the storage mode, or type, of the parameter

Explanation: This gives the storage mode of the parameter, which is the type of the variable being used. Ref: Mode in R - https://stat.ethz.ch/R-manual/R-patched/library/base/html/mode.html

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 - Development
Concatenate columns with spl characters - Hi, In order to avoid redundant rows, I have to make the following changes to my SQL code :   For the same Quarters,Function, Product and Manager combination we want to update the [GM Scope] and [BL Scope] column as follows : 1) If Quarters,Function, Product and Manager are identical, then GM Scope should show […]
SQL Server 2016 - Administration
Distributed AG DB movement - I have a DAG between On prem and Azure. We have a maintenance window coming up next week where networking team will be replacing some switches. It will cause internet outage for 4 hours. It will disrupt data movement between 2 servers. I have a plan where I pause DB movement in Azure before they […]
object_name (st.objectid) returns NULL. How can I overcome/fix this? - How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in the below query, as well as any other similar queries..). White paper says   "A user can only view the metadata of securables that the user owns or on which the user has been granted permission. This means that metadata-emitting, built-in functions […]
How can I prepare SQL server 2016 certification? - How can I prepare SQL server 2016 certification? Answer Follow · 12 Request plzz guide me.
Development - SQL Server 2014
trigger email alerts in case file is delivered or failed for the job - Hi all, I have two SQL jobs. These jobs execute SSIS packages and then send files to e-mail. I need to create one more SQL Job that would be send an alter to email about file delivering (file was success delivered or not). Could you help me? Thanks
SQL 2012 - General
List all stored procedures which return datasets - Is there any way to do that? I need to list that kind of procedures in a list on a application form. There is more than 1500 procedures in the DB, most of which are returning result but not dataset. Is it at all possible? Thank you
SQL Server 2019 - Administration
Creating an Extended Event in a SQL Managed Instance - Recently moved our environment to SQL 2019 Managed Instance from SQL 2017 environment.  Trying to re-setup the Extended Event we had running to capture Deadlocks but having issues using an Azure Data Blob for storing the Extended Event file. The initial creation finally worked but when trying to start it get the following error: "The […]
Developer vs Enterprise - Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server (2019 ,2017 & 2014) both in features & performance wise?   TIA
SQL Server 2019 - Development
Newb - SQL Server IIF() Function - I am using the following function: IIf([var1Title] != '', [var1Title] + ' - ' + [var1Topic] + ' - ' + [var1Name], '') AS Item1 In some cases, the value of var1Name is NULL. Oddly, when var1Name is NULL, the value retuned for the entire line is NULL. I am hoping the value returned would […]
Looking for US state geospatial shape data - We have a request to calculate distances across states for a given line between 2 points. Example a line from Minneapolis to Los Angeles, I need to know the total length and what percentage of that length is within each state it crosses. I know how to do it but I need the state outlines. […]
SQL Server 2008 - General
SQL Server maximum Server Memory - I am using SQL Server 2008 R2  Express  edition. I have already set Maximum Server memory to 2Gb. Is there any benefit if I Change it from 2Gb to 3Gb?
Reporting Services
SSRS Export to separate pdfs - Hi everyone, can anyone tell me the process of how to create multiple pdf's from an SSRS report ? Each pdf should refer to one student . Thank you.   I tried doing data driven expressions , but got stuck with the "File name, Path, Render Format, Write mode, File Extension, User name, Password, Use […]
Reporting Services 2008/R2 Administration
how to configure Database Mirroring in SQL Server 2008 - sorry to bother all! could you please tell me the following concerns about database mirroring in SQL server 2008 ? thanks! how to configure the database mirroring for SQL Server 2008 without witness server under not windows domain environment? how to configure the database mirroring for SQL Server 2008 without witness server under windows domain […]
Integration Services
Missing connections not causing a job failure - Hello I have a package that logs using Configure SSIS Logs: Logging It logs to a database (log) I've set up a new connection to the DB and called this log I've created a config file and added log to this: log So, if I create a job that runs […]
SQLServerCentral.com Website Issues
how do you change your display name? - When I edit my profile the display name field is a dropdown. How can I change my display name to something not in the list?
 

 

RSS FeedTwitter

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.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -