SQLStudies

It’s interesting how an OR short circuits.

• by Kenneth Fisher

• SQLStudies

I recently did a post on the case expression short circuting and received a very very interesting comment from Chad ... Continue reading

2019-06-17

4 reads

Does the case statement short circuit?

• by Kenneth Fisher

• SQLStudies

Let’s start with definitions: CASE Statement: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc ... Continue reading

2019-06-13

320 reads

The butterfly effect. T-SQL Tuesday #115

• by Kenneth Fisher

• SQLStudies

This month, our host Mohammad Darab (b/t) has given us an interesting subject. Dear 20 year old self. Where we ... Continue reading

2019-06-11

4 reads

How do I force a SQL Login to change it’s password on next login

• by Kenneth Fisher

• SQLStudies

Forcing someone to change their password on a periodic basis is a pretty common thing, and any time I’ve gotten ... Continue reading

2019-06-05

140 reads

SQL Homework – June 2019 – Property functions

• by Kenneth Fisher

• SQLStudies

Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This ... Continue reading

2019-06-03

14 reads

I’m moving my permissions scripts to GitHub

• by Kenneth Fisher

• SQLStudies

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

2019-05-30

31 reads

What is a distributed transaction?

• by Kenneth Fisher

• SQLStudies

A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example ... Continue reading

2019-06-13 (first published: 2019-05-28)

579 reads

Using VALUES to construct an in-line table.

• by Kenneth Fisher

• SQLStudies

This has come up a few times recently, I find it rather fascinating and I can never seem to remember ... Continue reading

2019-06-07 (first published: 2019-05-22)

945 reads

Bad Idea Cowboy Hat: Using a foreign key to prevent updates

• by Kenneth Fisher

• SQLStudies

When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading

2019-06-06 (first published: 2019-05-20)

874 reads

Security Learning Pathway at PASS Summit.

• by Kenneth Fisher

• SQLStudies

This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway ... Continue reading

2019-05-17

3 reads