-
Adding a user to an Azure SQL DB
1November 5, 2020 by Kenneth Fisher
Creating a user is simple right? Yes and no. First of all, at least in SSMS it appears you don’t …
Continue reading -
SQL Homework – November 2020 – Help!
Leave a commentNovember 3, 2020 by Kenneth Fisher
If you ask any senior IT person What is the most important tool you have? there is a decent chance that …
Continue reading -
What do they want to hear?
3October 29, 2020 by Kenneth Fisher
I was helping my 16yo write his first college essay the other day. He’s always struggled a bit with writing …
Continue reading -
How do I test if a linked server works using T-SQL?
4October 27, 2020 by Kenneth Fisher
I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
Continue reading -
SQL Virtual Machines
Leave a commentOctober 22, 2020 by Kenneth Fisher
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) …
Continue reading -
My 800th post!
Leave a commentOctober 20, 2020 by Kenneth Fisher
It took me a little bit longer to get here than I expected but I finally made it. 800 posts. …
Continue reading -
Permissions script for Azure Synapse
3October 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
SQL Studies
Live, Learn, Share
