-
What permissions do temp stored procedures use?
1June 19, 2019 by Kenneth Fisher
In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting …
Continue reading -
It’s interesting how an OR short circuits.
1June 17, 2019 by Kenneth Fisher
I recently did a post on the case expression short circuting and received a very very interesting comment from Chad …
Continue reading -
Does the case expression short circuit?
5June 13, 2019 by Kenneth Fisher
Let’s start with definitions: CASE Expression: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc …
Continue reading -
The butterfly effect. T-SQL Tuesday #115
Leave a commentJune 11, 2019 by Kenneth Fisher
This month, our host Mohammad Darab (b/t) has given us an interesting subject. Dear 20 year old self. Where we …
Continue reading -
How do I force a SQL Login to change it’s password on next login
2June 5, 2019 by Kenneth Fisher
Forcing someone to change their password on a periodic basis is a pretty common thing, and any time I’ve gotten …
Continue reading -
SQL Homework – June 2019 – Property functions
Leave a commentJune 3, 2019 by Kenneth Fisher
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This …
Continue reading -
I’m moving my permissions scripts to GitHub
2May 30, 2019 by Kenneth Fisher
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are …
Continue reading -
What is a distributed transaction?
1May 28, 2019 by Kenneth Fisher
A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example …
Continue reading -
Using VALUES to construct an in-line table.
1May 22, 2019 by Kenneth Fisher
This has come up a few times recently, I find it rather fascinating and I can never seem to remember …
Continue reading -
Bad Idea Cowboy Hat: Using a foreign key to prevent updates
2May 20, 2019 by Kenneth Fisher
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that …
Continue reading
SQL Studies
Live, Learn, Share
