Insperation

• by Kenneth Fisher

• SQLStudies

Inspiration: The process of being mentally stimulated to do or feel something, especially to do something creative. a person or ... Continue reading

2020-01-29

8 reads

Permissions required for row counts to show up on Object Explorer Details

• by Kenneth Fisher

• SQLStudies

I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on ... Continue reading

2020-01-23 (first published: 2020-01-16)

347 reads

My experiences with Imposter Syndrome: T-SQL Tuesday #122

• by Kenneth Fisher

• SQLStudies

Jon Shaulis (blog|twitter) is hosting T-SQL Tuesday this month. Thanks Jon! And the subject is obvious if you read the ... Continue reading

2020-01-21 (first published: 2020-01-14)

539 reads

Help! My restore has finished but the database still has a status of recovering.

• by Kenneth Fisher

• SQLStudies

I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, ... Continue reading

2020-01-17 (first published: 2020-01-08)

653 reads

What is the program_name in sys.dm_exec_sessions?

• by Kenneth Fisher

• SQLStudies

If you’ve ever looked at the output for sys.dm_exec_sessions you may have noticed the column program_name. Frequently you’ll see entries ... Continue reading

2020-01-13 (first published: 2020-01-06)

518 reads

What I’ve learned from Groundhog Day.

• by Kenneth Fisher

• SQLStudies

One of my all time favorite movies is Groundhog Day staring Bill Murray. In case you’ve never watched it (and ... Continue reading

2020-01-10 (first published: 2019-12-30)

396 reads

SQL Homework – January 2020 – Document, document, document

• by Kenneth Fisher

• SQLStudies

Happy New Year! It being New Year’s, at least by the Gregorian calendar, I thought we could make this month’s ... Continue reading

2020-01-01

12 reads

What happens if I disable the clustered index?

• by Kenneth Fisher

• SQLStudies

You are probably already aware that you can disable an index. This can be handy when you have a large ... Continue reading

2019-12-30 (first published: 2019-12-16)

926 reads

A gift. T-SQL Tuesday #121

• by Kenneth Fisher

• SQLStudies

My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants us to talk about Gifts received ... Continue reading

2019-12-23 (first published: 2019-12-10)

267 reads

Viewing Azure SQL DB security with sp_AzSQLDBPermissions

• by Kenneth Fisher

• SQLStudies

A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure ... Continue reading

2019-12-18

40 reads