Category Archives: SQLServerPedia Syndication
-
Permissions script for Azure Synapse
2October 15, 2020 by Kenneth Fisher
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for …
Continue reading -
A table is like a library : T-SQL Tuesday #131
Leave a commentOctober 13, 2020 by Kenneth Fisher
Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like …
Continue reading -
All triggers have to be able to handle multiple row operations.
1September 3, 2020 by Kenneth Fisher
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s …
Continue reading -
SQL Homework – September 2020 – More DML Triggers
Leave a commentSeptember 1, 2020 by Kenneth Fisher
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all …
Continue reading -
As a DBA, am I a gatekeeper?
6August 27, 2020 by Kenneth Fisher
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and …
Continue reading -
SQL Homework – August 2020 – More DML Triggers
Leave a commentAugust 13, 2020 by Kenneth Fisher
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was …
Continue reading -
What goes around comes around : T-SQL Tuesday #129
2August 11, 2020 by Kenneth Fisher
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. …
Continue reading -
HAL0004 – I don’t feel well Dave
Leave a commentJune 29, 2020 by Kenneth Fisher
It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for …
Continue reading -
Azure SQL Database Query Editor
3June 24, 2020 by Kenneth Fisher
I was working on a couple of Azure databases the other day. One was an Azure SQL DB and the …
Continue reading -
Adding people’s names to a blog post can be rather tedious.
Leave a commentJune 18, 2020 by Kenneth Fisher
I blog a fair amount and do you want to know what the most annoying part of the process is? …
Continue reading
