The Lair of Leaky Abstractions

Lessons on the care and feeding of software developers by Robert N. Harris

Skip to content
  • Home
  • Blog
  • About
  • Contact
  • The Rules
  • Recommended Reading
Search

SQL Server

Everything I whish every developer knew about SQL Server queries

July 28, 2022 / Robert Harris / Leave a comment

…summed up masterfully by Brent Ozar in just 45 minutes. All the ways you’re doing error handling wrong and don’t even know it, why that table valued function is going to bring the pain, and so much more. This should be required viewing for anybody who writes T-SQL.

Fundamentals of Stored Procedures at SQLBitsv_2Z7m0&t=63s

UI Fails #6 – SSMS Database Diagrams Edition

November 18, 2021 / Robert Harris / Leave a comment

Good morning to everyone except the developer who thought these two options should go right next to each other.

DBAs hate this trick!

October 29, 2021October 29, 2021 / Robert Harris / Leave a comment

You have 934 total plans in your cache, with 100.00% plans created in the past 24 hours, 100.00% created in the past 4 hours, and 100.00% created in the past 1 hour.

Shout out to Brent Ozar for his outstanding First Responder Kit.

T-SQL Cheat Sheet

October 15, 2021 / Robert Harris / Leave a comment

Need to right justify output, safely divide by zero (indoors, even!), or generate random numbers within a specified range? Check out Chad Baldwin’s excellent T-SQL Tuesday #143 – Short code examples.

Robert, are you just holding on to SQLCMD mode?

January 15, 2021March 28, 2021 / Robert Harris / Leave a comment
Your point being?
Your point being?

I’ve been struggling with SSMS losing intellisense, seemingly randomly, for months now. Blowing away the local settings cache and reinstalling would help for a bit, but it kept coming back, er, going away. I was losing my serenity. Special thanks to my friend Capt’ Quacks for figuring out that intellisense and SQLCMD mode don’t play well together.

Blog at WordPress.com.
  • Follow Following
    • The Lair of Leaky Abstractions
    • Already have a WordPress.com account? Log in now.
    • The Lair of Leaky Abstractions
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

You must be logged in to post a comment.