Tag Archives: best practices
-
SQL Homework – August 2023 – Have the best practices changed while you weren’t looking?
17August 1, 2023 by Kenneth Fisher
It’s been a bit since I did one of these so let’s go back to the basics. Best practices. We …
Continue reading -
Why is security important in a dev environment?
10August 23, 2022 by Kenneth Fisher
I was asked a rather interesting question during an interview recently. It went something like this: Your resume says you’ve …
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 -
All triggers have to be able to handle multiple row operations.
2September 3, 2020 by Kenneth Fisher
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s …
Continue reading -
Blogging and coding best practices
Leave a commentSeptember 25, 2019 by Kenneth Fisher
I had a discussion a while back, I think it was with Grant Fritchey (b/t) but I just can’t remember. …
Continue reading -
Debugging techniques (focusing on T-SQL)
13September 23, 2019 by Kenneth Fisher
tl;dr; Add PRINT and/or SELECT statements. Comment/uncomment out pieces of code to isolate problems. Change INSERT/UPDATE/DELETE statements to SELECTs. Disclaimer: …
Continue reading -
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
What’s the difference between Files and Filegroups?
2March 28, 2018 by Kenneth Fisher
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
Continue reading -
GDPR – After the restore
1March 19, 2018 by Kenneth Fisher
I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR …
Continue reading -
Simply Debugging
3March 7, 2018 by Kenneth Fisher
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
Continue reading
SQL Studies 