Author Archives: Kenneth Fisher
-
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
Leave a commentNovember 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 -
Which is faster? IN (list) or IN (SELECT FROM Temp)
8October 11, 2018 by Kenneth Fisher
If you’ve done much with IN (list) then you’ve realized that it basically translates out to You’ve probably also realized …
Continue reading -
Letting the business bully you: T-SQL Tuesday #107
1October 9, 2018 by Kenneth Fisher
Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in …
Continue reading
