Search Results for “SQL Interview Question”

Cloud-based database thoughts before #SQLPass

Last Updated February 12, 2017

Next week at the PASS Summit, I’m presenting a session called “Yes, I’m Actually Using The Cloud.” I’ll be talking about what’s out there, why I use it, and why you might want to use it too. Brendan Cournoyer of SearchSQLServer.com interviewed me recently about the topic and asked questions like: For those who are…

SQL Server DBA Interview: Kendal Van Dyke

Last Updated February 12, 2017

Brent Ozar

#SQLPass

Kendal Van Dyke is a Senior SQL Server DBA from Florida, and he’s been blogging since last year. He’s syndicated at SQLServerPedia, and his recent series on RAID performance is a must-read. I’ve talked back and forth with him a lot lately, and I figured I’d try something new: a virtual interview. I emailed Kendal…

Interview Tip: Don’t Stress Out

Last Updated February 12, 2017

Brent Ozar

Professional Development

I was just talking to a fellow blogger who’s going through an interview process, and we touched on something that bears repeating here. Interviewers don’t always expect you to know the answers. Sometimes they ask you a string of ugly, nasty technical questions that you can’t possibly have seen before. They might not be testing…

PASS Interview with Tom Casey, BI Thoughts

Last Updated February 9, 2017

Brent Ozar

#SQLPass

Microsoft’s keynotes and sessions catered to the business intelligence sector of the audience. In Tom Casey’s keynote on Thursday, one slide said: “You are on your way to becoming a BI expert.” I know what you’re thinking, dear reader. If you’re a DBA, whether it’s a production DBA or a development DBA, you’re thinking, “That’s…

PASS Summit 2008 Thursday Recap (#sqlpass)

Last Updated February 12, 2017

Brent Ozar

#SQLPass

PASS Board Election Results Dribbling In Andy Warren is in! He talks about it on his blog, and I got a huge chuckle out of this part: I didn’t have any idea what my chances were, I really didn’t do a lot of campaigning (hard to figure out a way to do it that didn’t…

SQL Server Magazine post about the Quest SQL community

Last Updated March 12, 2008

Brent Ozar

SQL Server Magazine just posted an interview with Billy Bosworth about the Quest Association for SQL Server Experts. One of the quotes that stood out for me was: “We want real people who do real jobs . . . that can interact with us very early in the process of building a product. That helps…

Interviewing DBAs: Check their Business Decisionmaking

Last Updated February 12, 2017

Brent Ozar

Professional Development

When interviewing a database administrator, it’s not enough to check their knowledge of technical skills: we have to check their ability to make sound business decisions. DBAs are in a position to make a lot of architectural decisions with long-term ramifications, and in smaller shops with just one or two DBAs, these decisions won’t come…

When hiring a DBA, test their skills

Last Updated February 12, 2017

Brent Ozar

Professional Development

During my recent job search, I noted a few things about the hiring process for DBA’s, and I figured I’d make a few blog entries out of them. This first one covers technical skill testing – finding out whether a candidate has the experience they claim. DBAs can be tough people to screen because the…

How My Attitude and Branding Changed Over 20 Years

Last Updated March 30, 2021

Brent Ozar

Professional Development

This month, to mark the 20th anniversary of BrentOzar.com, I’m stepping back and looking at the big picture rather than blogging about database problems & solutions like I usually do. It wouldn’t be a good navel-gazing series without a couple thousands words looking inward at myself. When I first got started writing online, I was…

Level 1 Bundle

Last Updated March 19, 2021

Brent Ozar

You’re a database administrator, developer, or sysadmin responsible for the health and performance of your company’s Microsoft SQL Servers. You’ve used our free First Responder Kit, and you want to take things to the next level. This bundle includes my most popular self-paced recorded online training videos, plus tools to help you improve your server’s…

Research Paper Week: Plan Stitch: Harnessing the Best of Many Plans

Last Updated August 11, 2019

Brent Ozar

Execution Plans

Those of you who follow me on Instagram, Twitter, or Facebook know I’m taking most of August off for vacation. Erika and I spent the last couple of weeks in Telluride, had a brief stop in Sacramento for SQL Saturday, and this week we’re touring wineries in Napa and Sonoma. As part of recharging, I…

Why That “DBA” Job Posting Sounds So Terrible

Last Updated June 2, 2019

Brent Ozar

Professional Development

What follows are just some of the highlights from an actual job posting. I’m not including the job description, just the requirements that an applicant has to have in order to even throw their hat in the ring: Requires Bachelor’s degree or equivalent experience. Experience running and maintaining a 24×7 production computing environment Hands-on experience…

Thanks for attending the workshop!

Last Updated November 21, 2019

Brent Ozar

Thanks for attending the workshop! You get your choice of either: Recorded Class Season Pass – dozens of hours of streaming videos about performance tuning, database administration, and even interview Q&A SQL ConstantCare® – send in your SQL Server’s metrics, and my automated systems tell you what to do for better performance and improved reliability.…

Pre-Con: Performance Tuning in 21 Demos

Last Updated March 19, 2021

Brent Ozar

Thanks for joining me at the pre-conference workshop! As part of your registration, you get one year free access to: Performance Tuning in 21 Demos Instant Replay Performance tuning videos: Fundamentals of Index Tuning, Fundamentals of Query Tuning, Fundamentals of Server Tuning with Wait Stats DBA videos: Fundamentals of Database Administration, The Senior DBA Class, and the DBA Job Interview Questions…

Recorded Class Season Pass for Teams

Last Updated March 19, 2021

Brent Ozar

Comprehensive training for database professionals who have to do it all: build SQL Servers, protect them, and make them go faster.

My Videos & Downloads

Last Updated July 12, 2023

Brent Ozar Unlimited Team

Enjoy your training! Already a subscriber? Log in to see the rest of your swag. Foundations We make these videos available for free to everybody because we think everyone should get started here: How to Think Like the SQL Server Engine – Every developer, database administrator, and report writer should start here. Explains how clustered…

Self-Paced Recorded Training Videos

Last Updated August 12, 2019

Brent Ozar

Free Fundamentals Start your SQL Server learning journey here – no registration required. I see these as table stakes for anybody who works with SQL Server – developers, DBAs, data scientists, etc. You’ve never had a formal SQL Server training class, and you want to learn how SQL Server builds your query results using indexes…

[Video] Office Hours 2018/8/8 (With Transcriptions)

Last Updated August 11, 2018

Brent Ozar Unlimited Team

Videos

This week, Brent, Tara, Erik, and Richie discuss troubleshooting port blocking, page life expectancy issues, problems with turning off CPU schedulers, coordinating two jobs across servers, adding additional log files to an almost-full partition, tips for getting a new SQL Server DBA job, using alias names for SQL Servers, database going into suspect mode during…

Search Results for “SQL Interview Question”

Cloud-based database thoughts before #SQLPass

Top 10 Interview Questions for Windows Administrators

SQL Server DBA Interview: Kendal Van Dyke

Top 10 Questions To Ask During an Interview

Interview Tip: Don’t Stress Out

PASS Interview with Tom Casey, BI Thoughts

PASS Summit 2008 Thursday Recap (#sqlpass)

SQL Server Magazine post about the Quest SQL community

Interviewing DBAs: Check their Business Decisionmaking

When hiring a DBA, test their skills

How My Attitude and Branding Changed Over 20 Years

Level 1 Bundle

Research Paper Week: Plan Stitch: Harnessing the Best of Many Plans

Why That “DBA” Job Posting Sounds So Terrible

Thanks for attending the workshop!

Pre-Con: Performance Tuning in 21 Demos

Recorded Class Season Pass for Teams

My Videos & Downloads

Self-Paced Recorded Training Videos

[Video] Office Hours 2018/8/8 (With Transcriptions)

Hi! I’m Brent Ozar.