Blogs

Watch My Keynote: Adapt and Thrive (25 minutes)

Do you know where your career is going? Do you know what skills you need to be successful in the current climate?

In this 25 minute keynote, I discuss the challenges and opportunities facing you as a data professional in this ever-changing landscape. You’ll also hear recommendations about which skills are needed to help you succeed in your role and how you can in turn support your IT team and business’ needs.

Continue reading

Calendar Reminders for SQL in the City Streamed Free Training Sessions

SQL in the City Streamed is coming up this week! This is an awesome FREE online event, and it’s all about learning new things and getting inspired.

Continue reading

Employee Agreements & Contracts: Best Practices (23 minute video)

So you’ve got an employee agreement in front of you: now what? In this episode, I talk about practical steps you should take to make sure that you understand the terms of your contract, and how to potentially negotiate the terms. Listen on the go Subscribe on iTunes, listen on Google Play, or plug this URL into your favorite podcasting app: http://dearsqldba.libsyn.com/rss# Video

Continue reading

How to cause a simple spill to tempdb

Sometimes it’s useful to know how to cause a problem.

Maybe you’ve never encountered the problem, and want to get hands-on experience. Maybe you’re testing a monitoring tool, and want to see if a condition flags an alert. Maybe you’re testing out a new client tool, and want to see how it displays it.

Continue reading

SQL in the City, Fall 2018 - Join Us!

Online (free!) SQL in the City Streamed – Sept 5, 7AM-12:40PM ET – free – Register In Person SQL in the City – New York – Oct 12 – contact your Redgate rep – Register SQL in the City – London – Oct 18 – GBP £150 until Aug 31, then £200 – Register SQL in the City – Chicago – Oct 26 – contact your Redgate rep – Register What will you learn?

Continue reading

Take the SQLChallenge: Tuning a Stored Procedure

I’ve just published a new SQLChallenge course for subscribers, and I think it’s one of the best ones yet.

Update: this course is now totally free. :smile:

Continue reading

Joining Redgate Software

I’m excited to announce that I’m joining the evangelist team at Redgate. Starting next Monday, I’ll be working with Steve Jones, Grant Fritchey, and Kathi Kellenberger – plus the whole Redgate team. Why take on a “real job”? The last time I had a manager and a normal paycheck was back in the spring of 2011. Since then, I’ve had company co-founders, or I’ve been doing my own thing, solo.

Continue reading

Employee Agreements & Contracts: Anti-Patterns (31 minute video)

When you take a new job in software engineering or in IT, within the paperwork there often lurks an employee agreement: a contract between you and your employer. In this half-hour live episode, I talk about why these contracts exist, and multiple anti-patterns you should avoid.

Continue reading

Table Value Constructors in TSQL

Last week’s quiz was on Table Value Constructors in TSQL.

Table value constructors let you create a dataset on the fly. These can occasionally be useful in writing queries, but I think playing with them has another benefit: they provide a simple, lightweight framework to let you develop your ability to think in sets.

Continue reading

Upcoming Live Podcast Recording Sessions: Employee Agreements and Contracts for DBAs and Devs

I’ve just scheduled two new podcast recording sessions! These are live, half hour sessions - you can join in listen, or share comments. Here’s what we’ll be talking about….

Continue reading