As DBAs we quite often run into others who aren’t as smart as us. The dev is an idiot. The .net guy is an idiot. The users are idiots. The manager is an idiot. The VP, well don’t even get me [...]
Ok, so you’re in an interview and their questions are finished and it’s time for them to answer yours. So you start asking them different Qs about their shop. You ask about servers, versions, support, team layout, upcoming projects, etc. You [...]
I’ve blogged about this before, but some things are worth repeating from time to time.
Losing your job really sucks. And it doesn’t matter if you find out about it ahead of time by 2mos, 2wks, or not until they walk [...]
Ok, I just got out of another interview earlier today and there are a couple good ones in here. It’s not anywhere near as good as the last one, but you’ve gotta admit that’s a tough act to follow. So this [...]
Wow, I didn’t realize I left this question out.
So here’s the question:
Q: What’s the difference between char() and varchar()?
A: With char() you can store the standard set of characters. And with varchar() you can store the extended set… [...]
Sorry guys, but I keep remembering things.
When I announced to him that the tech screening was over, he sighed and I could see 10yrs leave his face. Come to think of it, that’s why I decided not to call him [...]
Since everyone is so interested, I thought I’d give some further observations about our favorite candidate.
1. He was visibly shaking throughout the entire interview.
2. He claimed that had he known there would be so many sql questions he would [...]
This is one of the most incredible interviews I’ve had to date. It has plenty of very unique answers and lots of good old-fashioned awkward pause. I’m torn about how much to write down because it really gets kinda long after [...]
Well, since I hear everyone is enjoying these today, I just finished my last phone screening and here are the nuggets I’ve discovered this time. Man you just learn so much interviewing. If any of you really cared for me though [...]
I just had another phone screening and apparently a page fault is the area of memory where SQL keeps things it can’t hold in the buffer cache. And page faults\sec is the counter that shows you how many items were put [...]
The best database career advice you’ve never heard!
Become a DBA. Become a BETTER DBA. Use the Roadmap.
The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!
Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)
Visit www.DBARoadmap.com for info, forums, and more!
Tags
Architecture blunders Camtasia Career Coding Standards CPU data generator DBA Development disaster firewall Idiots Inside SQL Server Interview ITBookworm Jobs Kalen Delaney Katmai Ken Henderson LiteSpeed MidnightDBA PASS Summit 2011 Pinnacle politics Powershell Powershell Hero Query techniques Red-Gate reporting restore SQL Express 1433 SCM SQL Server SQLServerDVD.com SSIS SSRS Training troubleshooting TSQL Tuesday tuning Tutorials Video post videos YukonInterview: Kalen Delaney!
Archives
ITBookworm.com!- Reading: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan
- Repost: “Problems with my new book” by Grant Fritchey
- Announcing SQL Server 2012 Query Performance Tuning by Grant Fritchey
- Quick Review: Logitech Trackball
- Book Review: Microsoft SQL Server 2008 Internals, by Kalen DeLaney et al





