Monthly Archives: August 2021
-
Rule 1: Be kind, be polite.
2August 31, 2021 by Kenneth Fisher
In my house, this is rule one. Sometimes it’s my wife or I reminding our kids, sometimes it’s them reminding …
Continue reading -
The sysname datatype defaults to not NULL.
4August 26, 2021 by Kenneth Fisher
The other day I was creating a table to store some metadata. Since the metadata I was collecting (sys.databases.name for …
Continue reading -
Error: Cannot continue the execution because the session is in the kill state.
Leave a commentAugust 24, 2021 by Kenneth Fisher
This was a rather interesting error. I’d certainly never seen it before, and based on one of the answers to …
Continue reading -
A new presentation on Auditing your databases
Leave a commentAugust 19, 2021 by Kenneth Fisher
I’m giving a presentation at the PASS Data Community Summit 2021 being put on by Redgate! It’s going to be …
Continue reading -
Experiment: Does sp_recompile on a table update associated views.
2August 17, 2021 by Kenneth Fisher
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the …
Continue reading -
Work requests: It’s broke. Fix it.
4August 12, 2021 by Kenneth Fisher
Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you …
Continue reading -
Thoughts on a work/life balance – Spend Wisely : T-SQL Tuesday #141
1August 10, 2021 by Kenneth Fisher
Wow, it’s TSQL Tuesday again! Tjay Belt (blog|twitter) is our host this month and he’d like us to talk about …
Continue reading -
Interview Tip: Know your resume
Leave a commentAugust 5, 2021 by Kenneth Fisher
Seriously. Make a point of reading your resume before submitting it, and again before an interview. I’ve been helping with …
Continue reading -
SQL Homework – August 2021 – Security Standards
1August 3, 2021 by Kenneth Fisher
A few years back (wow time flies) I had you Work with Security. It’s been a while so if you …
Continue reading
SQL Studies 