Blogs

Why I Love DML Triggers in SQL Server

It’s TSQL Tuesday! If you’re not familiar, TSQL Tuesday is a monthly blogging event where a Microsoft Data Platform community member chooses a writing prompt. This is a great thing if you’re interested in starting a technical blog and wonder, “What would I write about?” It’s also great if, like me, you occasionally want a little outside inspiration to shake things up.

This month’s topic is from Steve Jones: we’re invited to write about an experience that we’ve had with triggers.

Continue reading

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?

About This Keynote

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.

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?

There’s a pretty sweet schedule for each event, featuring folks like Grant Fritchey, Steve Jones, Kathi Kellenberger, and Bob Ward. 

Continue reading

Take the SQLChallenge: Tuning a Stored Procedure

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

Your mission is to:

1. Identify which statement is slowing down our stored procedure the most
2. Tune the code to speed it up. You can change the query that is slow as well as anything else in the procedure that will help you make that statement faster.

In the solution videos, I’ll step through multiple strategies to figure out which statement in the procedure is slowing it down the most – because in real life, you need to have a whole bag of tricks in different situations. 

Continue reading