Dear SQL DBA: Tech Interviews in 2023 With Jeremiah Peschka
Category:
career
Tech interviews are weird and wacky. How did they get this way, and how SHOULD they be? Jeremiah Peschka joins us to discuss.
Tag: dear-sql-dba
Dear SQL DBA - Data Roles: DBA, DBRE, and Data Engineer
Category:
database-administration
, career
There are lots of jobs for data folks. In this episode, I discuss three hot job titles: Database Administrator (DBA), Database Reliability Engineer (DBRE), and Data Engineer (DE).
When NOT to Choose SQL Server to Store Your Data
Category:
database-architecture
, sql-server
I recently posted on LinkedIn that I was interviewing for a SQL Server database administrator role for the first time in a long time. I invited folks: “Ask me your favorite interview question!”
Stephen Vakil had a great one: “when should you use SQL Server to store your data?”
For situations where SQL Server is already in use and there’s a relatively low barrier to entry, I think it’s simpler to turn this question around and ask, “When is SQL Server not a good choice for storing your data?”
This post is also available as a podcast episode, and on YouTube.
Down Tools Week 2020 (10 minute video/podcast episode)
Category:
career
It’s Down Tools Week at Redgate.
About This Episode
In this episode, I share what “Down Tools Week” is, what I’m working on this week, and why I think it’s a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization.
Common Antipatterns in Database Development (28 minute video/podcast episode)
Category:
devops-automation
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I share three things that should NOT be normal for database development– but which are incredibly common.
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)
Category:
tsql-programming
, sql-server
I’m not an expert on collation in SQL Server, but there are a few important facts which I’ve had to learn the hard way. In this episode I share the basics, along with helpful resources to learn more.
The Manager Guide to Git Training for DBAs - Video and Podcast
Category:
devops-automation
Learning Git can be daunting for DBAs. In this 20 minute episode, I discuss why learning a VCS is necessary for DBAs, then give three tips on scoping your project, choosing the right tools, and making sure the project is successful.