The Story of an Interview Flop
Category:
tsql-programming
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.
Running SQL Server in a Docker Container on a Mac
Category:
database-administration
, sql-server
A user recently asked me what a good use case might be to run SQL Server on Linux in a Docker container.
TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns
Category:
tsql-programming
Welcome to T-SQL Tuesday for August 2017!
T-SQL Tuesday is a chance for you to join in the SQL Server community and write a blog post on a suggested topic. You can use this as a way to start a new blog, dust off a blog you haven’t used in a while, or make it part of regular blogging: your choice!
I would love for you to participate. The whole SQL Server community would. Please, join us!
The COMPRESS() TSQL Function in SQL Server 2016+
Category:
sql-server
One cool little feature in SQL Server 2016 is COMPRESS(). It’s a TSQL function available in all editions that shrinks down data using the GZIP algorithm (documentation).
Desktop Wallpapers and Webcasts on Isolation Levels and Memory
Category:
database-administration
I’ve been having lots of fun drawing and doing webcasts this summer. I’ve got four SQL Server themed desktop wallpapers to share, and I’ve got lots more coming– along with a new chunk of free webcasts.
Downloadable SQL Server Desktop Wallpapers
Category:
database-administration
Get ’em here
Grab wallpapers at https://github.com/LitKnd/littlekendracomments/tree/main/SQLWorkbooks-Wallpaper-and-Posters.
Did that Query Eliminate Partitions? (videos)
Category:
query-performance
Table partitioning makes execution plans a bit more confusing.
Free Course
I have a free online course which walks you through decoding execution plans, including whether or not partition elimination occurred.