dear-sql-dba

Interview Advice from the SQL Server Community (video or transcript)

In this episode of “Dear SQL DBA”, I talk about three articles written by members of the SQL Server community on interviewing that I can’t stop thinking about: “Playing the Third Party Recruiter Game”, by Adam Machanic – read it here “I Hate Interviews”, by Rob Sewell – read it here “Learning to say ‘No’” by Mark […]

sqlworkbooks-interview-parameter-sniffing

Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Community

I’m glad I picked interviewing as the topic of TSQL Tuesday #93, because people wrote posts chock full of great advice and funny stories. Get ready to learn, be amazed, and laugh out loud as you read these posts, which I’ve indexed by the author’s first name. Don’t blame these authors for the dorky jokes […]

red-panda-interview

The Story of an Interview Flop

Welcome to T-SQL Tuesday #93! Some of the biggest lessons I’ve learned about interviewing come from an interview experience that meant a ton to me — and all my dreams came crashing down. No time to watch? Scroll down, a transcript is below Or listen on the go! This is available in podcast format on iTunes , on […]

tt_300_thumb_710BE775

TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns

Welcome to T-SQL Tuesday for August 2017! T-SQL Tuesday is a chance for you to join in the SQL Server community and write a blog post on a suggested topic. You can use this as a way to start a new blog, dust off a blog you haven’t used in a while, or make it […]

badger-download-me

Desktop Wallpapers and Webcasts on Isolation Levels and Memory

I’ve been having lots of fun drawing and doing webcasts this summer. I’ve got four SQL Server themed desktop wallpapers to share, and I’ve got lots more coming– along with a new chunk of free webcasts SQL Server desktop wallpapers I have four wallpapers available for free: Top Queries in SQL Server SSMS Shortcuts & […]

43 partitions accessed

Did that Query Eliminate Partitions? (videos)

Table partitioning makes execution plans a bit more confusing How much work did that query really have to do? It can be tricky to tell! I have a new online course which walks you through decoding execution plans, including whether or not partition elimination occurred. In this first 10 minute video, I go over concepts for […]