-
Parameterized dynamic SQL is parameterized.
3November 15, 2018 by Kenneth Fisher
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic …
Continue reading -
T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108
4November 13, 2018 by Kenneth Fisher
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a …
Continue reading -
Missing those we’ve lost
3November 7, 2018 by Kenneth Fisher
It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to …
Continue reading -
SQL Homework – November 2018 – Constraints
2November 5, 2018 by Kenneth Fisher
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed …
Continue reading -
Zombie SQL
2October 31, 2018 by Kenneth Fisher
It Halloween so time for a scary SQL story. Ok, maybe not that scary. Ok, not scary at all, but …
Continue reading -
Blogger Questions: What if I get a mean/rude comment?
12October 29, 2018 by Kenneth Fisher
There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time …
Continue reading -
I’m in a book! Data Professionals at Work
2October 24, 2018 by Kenneth Fisher
A while back a friend of mine, Malathi Mahadevan (b/t), asked me if I’d like to do an interview for …
Continue reading -
How do I look at my error log if SQL won’t open?
1October 22, 2018 by Kenneth Fisher
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you …
Continue reading -
What is the Object Explorer Details tab good for?
Leave a commentOctober 17, 2018 by Kenneth Fisher
For a long time there I would see the Object Explorer Details tab show up when I opened SSMS (SQL …
Continue reading -
Highlighting sp_spaceused
Leave a commentOctober 15, 2018 by Kenneth Fisher
I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick …
Continue reading
SQL Studies
Live, Learn, Share
