Tsql-Programming

Category: tsql-programming

AVG() in TSQL: Watch Your Data Types

AVG() in TSQL: Watch Your Data Types

This week’s Quizletterย featured a quiz on using the AVG() function in SQL Server.

I was inspired to write this quiz because I’ve been teaching “TSQL School” each week. When we covered aggregate functions, I remembered how tricksy AVG() can be.

Continue reading

What is Deferred Name Resolution, and How Can It Go Wrong?

What is Deferred Name Resolution, and How Can It Go Wrong?

I got a question recently about why a particular bit of code was failing when running.

My first thought: oh, that’s probably related to… whatsitcalled.

Continue reading

SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)

SQL Server 2026: BAGI Edition (#TSQL2SDAY 100!)

By Kendra Little on March 13, 2018

It’s T-SQL Tuesday’s 8 year birthday (or close enough), and Adam Machanic has challenged us with the question: what will the world be like when T-SQLTuesday turns 16?

Continue reading

How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)

How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)

on February 13, 2018

For TSQL Tuesday #99, @AaronBertrand gave us an invitation to write about something weโ€™re passionate about outside of SQL Server.

Continue reading

Kalen Delaney and Inspiration for Adventure

Kalen Delaney and Inspiration for Adventure

on November 14, 2017

This post is part of TSQL Tuesday, a monthly blog party. You’re welcome to join in this party: if you’d like email notifications of future topics, here’s how to set them up.

This month’s topic is “Folks Who Have Made a Difference”, by Ewald Cress.

Continue reading

How to Get Email Notifications for TSQLTuesday

How to Get Email Notifications for TSQLTuesday

on August 21, 2017

Lots of us want to write for TSQL Tuesday, but aren’t always on Twitter at the right time each month to see when the announcement comes out using the #tsql2sday hash tag. And maybe we have an RSS feed set up, but we often get behind on a big pile of posts to read. (Guilty!)

Continue reading

The Story of an Interview Flop

The Story of an Interview Flop

on August 8, 2017

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.

Continue reading