Category Archives: Microsoft SQL Server
-
Configure your tools : T-SQL Tuesday #123
5February 11, 2020 by Kenneth Fisher
Happy T-SQL Tuesday! Thanks for hosting this month Jess Pomfret (blog|twitter) and great topic. Life Hacks. There is one thing …
Continue reading -
SQL Homework – February 2020 – Write a blog post.
Leave a commentFebruary 3, 2020 by Kenneth Fisher
Following along with last month’s documentation homework this month I want you to write a blog post. But Ken, what …
Continue reading -
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
Leave a commentJanuary 27, 2020 by Kenneth Fisher
If you read the title to this post and your first thought was That’s not SQL is it? then you …
Continue reading -
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 -
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
4January 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 -
Viewing Azure SQL DB security with sp_AzSQLDBPermissions
2December 18, 2019 by Kenneth Fisher
A few months back I put the Azure SQL DB version of my permissions script into beta. I’m not sure …
Continue reading
