Monthly Archives: January 2020
-
Changing the owner of a schema removes all direct permissions of objects owned by the schema.
Leave a commentJanuary 22, 2020 by Kenneth Fisher
This is one of those things that probably doesn’t happen all that often, but bit me in the … elbow …
Continue reading -
Common commands and tasks to make dealing with Windows Core easier.
1January 20, 2020 by Kenneth Fisher
I don’t know how many of you are working with Windows Core these days but personally I think it’s a …
Continue reading -
Permissions required for row counts to show up on Object Explorer Details
Leave a commentJanuary 16, 2020 by Kenneth Fisher
I ran into a rather obscure permissions problem the other day. Since I wasn’t able to figure it out on …
Continue reading -
My experiences with Imposter Syndrome: T-SQL Tuesday #122
3January 14, 2020 by Kenneth Fisher
Jon Shaulis (blog|twitter) is hosting T-SQL Tuesday this month. Thanks Jon! And the subject is obvious if you read the …
Continue reading -
Help! My restore has finished but the database still has a status of recovering.
Leave a commentJanuary 8, 2020 by Kenneth Fisher
I’ve been thinking about writing this for a bit and then a co-worker actually had this problem recently, so, well, …
Continue reading -
What is the program_name in sys.dm_exec_sessions?
Leave a commentJanuary 6, 2020 by Kenneth Fisher
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 -
SQL Homework – January 2020 – Document, document, document
3January 1, 2020 by Kenneth Fisher
Happy New Year! It being New Year’s, at least by the Gregorian calendar, I thought we could make this month’s …
Continue reading
