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

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.

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.

This is the first of a two part series. In the next episode, I’ll discuss best practices for understanding and negotiating the contract.

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

Dear SQL DBA: Remembering Robert Davis, DBA Hero

What makes a person a DBA Hero? In this episode, I talk about how Robert Davis made a huge impact on the SQL Server community, and the traits that Robert displayed that I hope to emulate.

Continue reading