Category Archives: SQLServerPedia Syndication
-
WITDC Mental Health and Wellness Day- April 8th
2April 5, 2022 by Kenneth Fisher
This Friday WITDC is having another Mental Health and Wellness Day virtual event and I’m part of a panel! This …
Continue reading -
Talk to the duck.
Leave a commentMarch 31, 2022 by Kenneth Fisher
Over the years, one of the best pieces of problem solving advice I’ve been able to give my kids is …
Continue reading -
Scripting with a temp stored procedure
2March 17, 2022 by Kenneth Fisher
A few years back I learned about temporary stored procedures from a Kendra Little (blog|twitter) blog post. At the time …
Continue reading -
Shift calculations (or same time every day)
2March 15, 2022 by Kenneth Fisher
One of the more interesting jobs I’ve had over the years was for a company that created emergency room software. …
Continue reading -
Database Code Reviews
1March 10, 2022 by Kenneth Fisher
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog …
Continue reading -
An increased opportunity. Remote user groups. : T-SQL Tuesday #148
Leave a commentMarch 8, 2022 by Kenneth Fisher
Rie Merritt (blog|twitter) is our host this month for T-SQL Tuesday! She’d like us to give advice on running a …
Continue reading -
Saving your requests
4March 3, 2022 by Kenneth Fisher
The other day a friend of mine mentioned that they were questioned on one of the scripts they ran recently …
Continue reading -
SQL Homework – March 2022 – Formatting
Leave a commentMarch 1, 2022 by Kenneth Fisher
Please write the following on the chalk board 100 times. Queries should be readable!Queries should be readable!Queries should be readable!Queries …
Continue reading -
Help, not all of my column is displaying in the output of the query!
1February 22, 2022 by Kenneth Fisher
I’ll be honest, I don’t remember if I’ve written about this before but I couldn’t find it, so here we …
Continue reading -
You can’t use GO in dynamic SQL.
2February 10, 2022 by Kenneth Fisher
This is one of those things that when I look back on it seems really obvious. Note: If at the …
Continue reading
SQL Studies 