Current database vs database locks

• by Kenneth Fisher

• SQLStudies

I have a lot of co-workers who use sp_who and sp_who2 to see who’s in a given database. This is ... Continue reading

2019-07-22

263 reads

Introducing sp_AzSQLDBPermissions (Beta)

• by Kenneth Fisher

• SQLStudies

I’ve written a version of my permissions scripts for Azure SQL Database. It’s still in Beta but I’m confident enough ... Continue reading

2019-07-11 (first published: 2019-06-27)

346 reads

SQL Homework – July 2019 – Table Size

• by Kenneth Fisher

• SQLStudies

In general this homework series is meant to give you ideas of things to play with that most if not ... Continue reading

2019-07-01

124 reads

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-27 (first published: 2019-06-17)

817 reads

What does the User Mapping tab of Login Properties really tell us.

• by Kenneth Fisher

• SQLStudies

In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS). Now, ... Continue reading

2019-06-24

16 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-19 (first published: 2019-06-05)

459 reads

What permissions do temp stored procedures use?

• by Kenneth Fisher

• SQLStudies

In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned temporary stored procedures and an interesting ... Continue reading

2019-06-19

83 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

451 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)

745 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

7 reads