Category Archives: SQLServerPedia Syndication
-
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 -
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 -
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 -
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 -
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 -
What happens if I disable the clustered index?
1December 16, 2019 by Kenneth Fisher
You are probably already aware that you can disable an index. This can be handy when you have a large …
Continue reading -
Session Evaluations from “SQL Server Security from the Ground Up”
2December 12, 2019 by Kenneth Fisher
I was recently given the opportunity to speak at Pass Summit. As always (this is the second time) this was …
Continue reading -
A gift. T-SQL Tuesday #121
1December 10, 2019 by Kenneth Fisher
My good friend Malathi Mahadevan (blog|twitter) is hosting T-SQL Tuesday this month and wants us to talk about Gifts received …
Continue reading
