Robert, are you just holding on to SQLCMD mode?
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 … Continue reading Robert, are you just holding on to SQLCMD mode?
Cleverness is the Mother of Regret
Scott Locklin on the wisdom of rules 6 and 17 One of the valuable things about popular but boring languages is that the code has been traversed many times, and routine stuff you’re likely to use in production is probably well debugged… The other benefit to boring languages is people concentrate on the problem, rather … Continue reading Cleverness is the Mother of Regret
Time Dilation
When a developer says next week, they mean Friday. When Sales hears next week, they think Monday. Plan accordingly.
Radioactive Web Debugging
With apologies to Imagine Dragons (and everyone, really). I’m waking up to cache and JS I tail my log and I trace my REST I’m breathing in the CSS (unnecessarily long and deep breath)
Quality matters from the start
“When people didn’t think about quality until they were 6 weeks in, they didn’t know how to do it anymore…you get too far in and you never recover.” Nick Van Weerdenburg explains why quality matters on day 0 of your development project.
Everything I don’t like about unit testing
…brilliantly summed up by Alexey Golub in “Unit Testing is Overrated”. My main complaint is that they greatly expand the complexity of the code with interfaces and abstractions that only exist for the sake of the unit tests, without actually testing the application the way it will be used. Users don’t care how high your code … Continue reading Everything I don’t like about unit testing
SQL is not a modular language
When will I ever learn? INSERT EXEC statement cannot be nested Until it is, here is a great overview on How to Share Data between Stored Procedures by Erland Sommarskog.
Rule 14 in the wild
“What if we just used NVARCHAR(4000) as the default datatype parameter for any query, regardless of what datatype the table has in it – like numbers or dates?” Brent Ozar with an interesting example on why (almost) everything could be nvarchar.
Never rewrite, always fix
There is, however, a clear line of heredity and succession which connects my 1986 computer to my bought-in-2018 one, the same way there’s a line of heredity and succession between the first Benz and the latest one…the so-called “x86 architecture” Here’s an entertaining essay on the dangers of a clean sheet re-write, aka Rule 20.
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
