SQL Server SME Interview Experience

SQL Server SME Interview Experience

SQL Server SME Interview Experience

This post “SQL Server SME Interview Experience” can help you in understanding and answering the most common question for a SQL Server DBA or Developer. A few days back I got an email from one of the follower; she has given an interview for one of the top product based company for the position SQL Server SME and product owner role in Toronto and shared the conversation which was happened with the interviewer. I just wanted to make it as a post which might help few people around.

She is 10+ years of experience in delivering enterprise database solutions using Microsoft SQL Server and applied for SQL Server SME with one of the world’s top product company. Initially she had two telephonic interviews and got invited for face to face. Below is the conversation with the interviewer:

SQL Server SME interview experience shared by a follower

Interviewer: Hi Good Morning

Me: Very Good morning, how are you today?

Interviewer: I am doing great, any questions?

Me: (Surprised) Hmm I have gone through the job role description but would like to know more about the responsibilities.

Interviewer: Well to simply describe the job role, SME will be taking care of the entire XXXXX product suite database systems. He or She should be the point of contact for all database development and administration activities. Also the role would be responsible for all product related technical escalations.

Me: Got it, but how a SQL Server SME can be a product owner? Apart from the technical point what other skill set you are looking for?

Interviewer: Well the SME will not responsible from the business or domain prospect. But the person should be able to handle all product related escalations, if any website is not working or the end customers facing a technical issue they would come to you and you need to take the ownership and should handle the problem with the help of concern technical team.

Me: I understand, in fact I am also working for a product development company. Other than the database activities I need to participate in product enhancements related technical discussions and brainstorming sessions.

Interviewer: Yes I knew that. In our environment you many need to attend the performance issues on frequent basis. Can we talk something about performance?

Continue reading

Posted in Interview Q&A, SQL Development, SQL Server DBA | Tagged , , , , , , , , , | 2 Comments

How to connect SQL Server from Excel

How to connect SQL Server from Excel

How to connect SQL Server from Excel

This post can help you in understanding “How to connect SQL Server from Excel Workbook”. There are situations where we need to export data from SQL Server to Excel file. There are multiple ways to do that using BCP, Import-Export wizard, OPENROWSET, SSIS etc. But connecting SQL Server directly from excel might help in some situations:

  • Capturing a huge rows – Data Processing runs in background in excel
  • Connecting to a RDS / Azure instance
  • We can directly create a Pivot Table / Chart
  • No SQL Knowledge required

 

Steps: How to connect SQL Server from Excel Workbook

How to connect SQL Server from Excel

Continue reading

Posted in SQL Development | Tagged , , , , , , | 2 Comments

How to Script Login and User Permissions in SQL Server

How to Script Login and User Permissions in SQL Server

How to Script Login and User Permissions in SQL Server

Migrating login and user permissions to a new instance is one of the most common tasks for a SQL DBA. This post “How to Script Login and User Permissions in SQL Server“ can help you in scripting the login and the user permissions for a given database. Most of us knew that there is a script “sp_help_revlogin” available for migrating SQL Server logins which can also handle the passwords for SQL Server logins. Just to summarize the topic we are also giving the MS suggested script.

Server / Instance Level

  • Script Logins with Passwords
  • Script Login Server Roles
  • Script the Server Level Permissions

Database / Object Level

  • Script User Creation
  • Script User Database Roles
  • Script the Database Level Permissions
  • Script Object Level Permission

 

Here is the script for generating Login creation script for the given SQL Server instance. Here is the reference from the MS site. https://support.microsoft.com/en-us/help/918992/how-to-transfer-logins-and-passwords-between-instances-of-sql-server

There is another beautiful script provided by JP Chen and it also working for login migration.

Server / Instance Level:

 

Database / Object Level:

 

Summary:

The post “How to Script Login and User Permissions in SQL Server” can help you in transferring logins and users between SQL Server instances. Please do comment on the below comment box if you find any issues in code.

Download Scripts:

How to Script Login and User Permissions in SQL Server_Logins

How to Script Login and User Permissions in SQL Server_Users

Posted in SQL Scripts, SQL Server DBA | Tagged , , , , , , , , , , | 6 Comments