Think twice before using table variables

T-SQL Tuesday

For T-SQL Tuesday this month Raul Gonzalez has asked us all to blog about lessons learnt the hard way:
http://www.sqldoubleg.com/2017/07/03/tsql2sday-92-lessons-learned-the-hard-way/
My...

T-SQL Tuesday #92 - Trust But Verify

It's T-SQL Tuesday time again, and this month the host is Raul Gonzalez (blog/@SQLDoubleG).  His chosen topic is Lessons Learned...

T-SQL Tuesday #92–Hard Lessons

A quick post, written last week as I’m relaxing in the mountains.
This month the topic is lessons learned the hard...

Save and save often

It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...

SQL Server Rookie Mistakes

A quick elementary post which is my entry to this months’ T-SQL Tuesday entry hosted by a good friend SQLDoubleG...

Power BI Custom Visuals Class (Module 59 – Drilldown Cartogram)

In this module you will learn how to use the Drilldown Cartogram Custom Visual.  The Drilldown Cartogram is a map...

T-SQL Tuesday #92: Lessons Learned the Hard Way

This month’s T-SQL Tuesday is hosted by Raul Gonzalez and he’s asked everyone to share things we might be a bit embarrassed about:
For this month, I want you...

SQL Server On Containers

On July 12th 6.30 PM PST, I will be presenting “SQL Implementations On Containers” @ at San Francisco data platform user...

Impact on Indexes When Mixing VARCHAR and NVARCHAR Types

You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...

Spider-Man Homecoming Twitter Sentiment

Hello Dear Reader!  This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast.  Both of us are...