Category Archives: SQLServerPedia Syndication
-
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
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 -
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 -
SQL Homework – December 2019 – The default trace and the system health session.
Leave a commentDecember 2, 2019 by Kenneth Fisher
I know this is the holiday season for many of us (which ones depend on your religion and nationality of …
Continue reading -
Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;
Leave a commentNovember 27, 2019 by Kenneth Fisher
One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of …
Continue reading -
#PowershellBasics: Working with arrays
2November 25, 2019 by Kenneth Fisher
I mentioned arrays in a previous post so I figured I should talk about what they are and how to …
Continue reading
SQL Studies 