Search Results for “SQL Interview Question”

Home
Search Results

SQL Interview Question: “How do you respond?”

June 13, 2016

Brent’s in class this week! So you get me instead. You can just pretend I’m Brent, or that you’re Brent, or that we’re both Brent, or even that we’re all just infinite recursive Brents within Brents. I don’t care. Here’s the setup A new developer has been troubleshooting a sometimes-slow stored procedure, and wants you…

SQL Interview Question: “Tell me what you see in this screenshot.”

May 23, 2016

Brent Ozar

Interviewing, SQL Server

You’re a data professional working with (or at least applying to work with) a company using the StackOverflow database (I’m using the March 2016 version today). Your users are complaining that this stored procedure is slow: usp_GetPostsByOwnerUserId They didn’t give you parameter 26837 – I’m just giving you that so you can see an execution plan.…

SQL Interview Question: “Talk me through this screenshot.”

May 16, 2016

Brent Ozar

Interviewing, SQL Server

After writing about “For Technical Interviews, Don’t Ask Questions, Show Screenshots”, lots of folks asked what kinds of screenshots I’d show. Here’s this week’s example. I show each screenshot on a projector (or shared desktop) to the candidate and say: What’s this screen from? What does the screen mean? If it was a server you inherited from…

SQL Interview Question: “Talk me through this query.”

May 2, 2016

Brent Ozar

Interviewing, SQL Server

Last month’s post “For Technical Interviews, Don’t Ask Questions, Show Screenshots” was a surprise hit, and lots of folks asked for more details about the types of screenshots I’d show. Over the next few weeks, I’ll share a few more. Normally I’d show this query as a screenshot, but for easier copy/pasting into comments, I’m…

SQL Interview Questions

April 19, 2009

Brent Ozar

SQL Interview Questions Practice interviewing with my video interviews Interviewing and hiring database administrators is tough for managers. It’s hard to understand what a DBA does, let alone whether or not the DBA is good at it. This is especially difficult in shops with just one DBA, and that DBA is now gone – or…

What’s Your Favorite SQL Server Interview Question? Here’s Mine.

April 20, 2020

Brent Ozar

Interviewing

“Out of the stuff on your resume, what are you the proudest of, the most excited about? When I’m interviewing a candidate for one of my clients, I’ll usually start with this question to help understand the resume. See, recruiters seem to actively encourage folks to keyword stuff their resume: to dump in everything and…

Five Interview Questions to Ask SQL Server Developers

March 17, 2015

Doug Lane

Interviewing

“If you were a tree, what kind of tree would you be?”“A tree with a job.” When it comes to hiring a SQL Server developer, we can pepper candidates with HR-type questions (“Tell me about a time when you had a conflict with a co-worker and how you resolved it.”) but that doesn’t give us…

SQL Server Interview Questions and Answers – Book Review

January 17, 2012

Brent Ozar

Book Reviews, Professional Development

I read a lot of technical books – stuff on SQL Server, VMware, storage – and they all start to blend together. Within the first few pages of reading SQL Server Interview Questions and Answers by Pinal Dave and Vinod Kumar, though, it jumped out and grabbed me because it’s really different. This is gonna…

Test-Driven Database Development with tSQLt

July 15, 2018

Brent Ozar

DevOps is becoming ubiquitous. However, the gap between those realising the benefits and those playing catch-up is getting bigger – and the difference between the leaders and the laggards is high quality testing. Automated deployment is great – but without automated testing you are just deploying bad code more quickly than before. You are responsible…

SQL Server Internals 201

March 24, 2018

Brent Ozar

You’re a developer or database administrator, and you’re curious. You love learning about the internals of the tools you use. You’re comfortable writing queries and creating tables, but you don’t always understand why a particular index gets used, and another one does not. You’re not sure when SQL Server chooses to reuse an existing query…

SQL ConstantCare®

October 10, 2017

Brent Ozar

SQL ConstantCare® allows you to be a SQL Server database expert, fast. We eliminate the confusion and ambiguity of advice: it’s about your server. You get daily email advice: you send in your SQL Server’s metrics daily with our lightweight app. Our systems analyze the data and tell you specifically what actions to take to…

7. Questions For YOU to Ask

February 13, 2017

Brent Ozar Unlimited Team

This one isn’t a video because I want you to be able to print this out (or write them down or put them on your phone or whatever) and take the questions along with you to the interview. When the candidate asks questions, it shows that they have valuable experience and can recognize signs of a…

To access this incredible, amazing content, you gotta get DBA Interview Question and Answer Kit or Recorded Class Season Pass, or log in if you already shelled out the cash.

Screenshot Interview Question: “What would you do if you saw this?”

July 4, 2016

Brent Ozar

Interviewing

In this week’s episode of our screenshot interview series, you’re applying for a database professional position who will be on call. You’re not necessarily the DBA, but you’re a member of the team on rotation. While you’re on call, you get an email from the help desk asking if there’s a problem on the production data…

Interview Question Follow-up: How do you respond?

June 27, 2016

Erik Darling

SQL Server

Normally I’d update the original post But I wanted to add a bit more than was appropriate. For my interview question, I asked how you’d respond to a developer showing you progress they’d made on tuning a sometimes slow stored procedure. While a lot of you gave technically correct answers about the recompile hint, and…

Interviewing: How to Test TSQL Writing Skills

November 4, 2015

Kendra Little

SQL Server

“Sure, I write great queries!” We sometimes help clients interview DBAs and Developers for their team. Requirements vary depending by position, but sometimes it’s important to test a candidate’s TSQL skills. While I can test candidates thoroughly on strategies for TSQL (when they’d use certain constructs, the pros and cons of various approaches), if what…

SQL Server Triage Specialist Team (Remote Position)

September 5, 2015

Kendra Little

SQL Server Triage Specialist (Remote Position) What Does a SQL Server Triage Specialist Do? As a Triage Specialist, you’ll guide clients through our SQL Critical Care®. You’ll become the primary point of contact with each client and make sure all their questions get answered by members of our team (whether it’s you or someone else).…

The Third Concern for SQL Server Virtualization: Capacity Planning

October 2, 2014

Brent Ozar

Virtualization

No Comments

Our first two concerns in this series were virtualization licensing and recoverability. It’s not enough to have answers for these questions today, though – we have to think about how long the server will be in place. The server’s expiration date isn’t dictated by IT. If it was up to us, we’d never run an old,…

DBCC CheckDB FAQ: Check for Corruption in SQL Server

May 27, 2014

Kendra Little

Backup and Recovery, CHECKDB and Corruption

DBCC CheckDB: Frequently Asked Questions It’s eating our logo. Will it stop at nothing??? Q: Do I really need to run DBCC CheckDB? Yes. If you’re even partially in charge of a SQL Server and you’d like to keep your job, you should make sure CheckDB is being run regularly. (Seriously!) Q: But WHY do…

Search Results for “SQL Interview Question”

SQL Interview Question: “How do you respond?”

SQL Interview Question: “Tell me what you see in this screenshot.”

SQL Interview Question: “Talk me through this screenshot.”

SQL Interview Question: “Talk me through this query.”

SQL Interview Questions

What’s Your Favorite SQL Server Interview Question? Here’s Mine.

Five Interview Questions to Ask SQL Server Developers

SQL Server Interview Questions and Answers – Book Review

Top 10 Developer Interview Questions About SQL Server

Top 10 SQL Server DBA Interview Questions

Test-Driven Database Development with tSQLt

SQL Server Internals 201

SQL ConstantCare®

7. Questions For YOU to Ask

Screenshot Interview Question: “What would you do if you saw this?”

Interview Question Follow-up: How do you respond?

Interviewing: How to Test TSQL Writing Skills

SQL Server Triage Specialist Team (Remote Position)

The Third Concern for SQL Server Virtualization: Capacity Planning

DBCC CheckDB FAQ: Check for Corruption in SQL Server

Hi! I’m Brent Ozar.