Author Archives: Kenneth Fisher
-
UDL files and connection strings
Leave a commentDecember 5, 2018 by Kenneth Fisher
A co-worker showed me a really neat trick the other day. We deal with a lot of connection problems and …
Continue reading -
SQL Homework – December 2018 – Configure SSMS
Leave a commentDecember 3, 2018 by Kenneth Fisher
I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of …
Continue reading -
Oh Query, Query, Query
Leave a commentNovember 28, 2018 by Kenneth Fisher
I thought I would post this a bit early so everyone can memorize the words before Hanukka starts next week. …
Continue reading -
My backup script (where, how, how big, etc.)
4November 26, 2018 by Kenneth Fisher
A while back I wrote about how to find where your backups are. And I’ve also written about I use …
Continue reading -
The Cloud and Shadow IT.
2November 21, 2018 by Kenneth Fisher
Shadow IT has been, well, maybe not the bane of the IT department, but certainly a pain in the neck. …
Continue reading -
Dealing with multiple AD accounts
7November 19, 2018 by Kenneth Fisher
To help promote the seperation of duties one of the things my company has done is to divide our permissions …
Continue reading -
Parameterized dynamic SQL is parameterized.
3November 15, 2018 by Kenneth Fisher
Ok, that title sounds silly, but it’s actually a real point. The first parameterized refers to using parameters within dynamic …
Continue reading -
T-shaped knowledge and learning about the cloud: T-SQL Tuesday #108
5November 13, 2018 by Kenneth Fisher
Upper management at my company has started asking for something called T-Shaped knowledge. The idea is that we have a …
Continue reading -
Missing those we’ve lost
3November 7, 2018 by Kenneth Fisher
It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to …
Continue reading -
SQL Homework – November 2018 – Constraints
2November 5, 2018 by Kenneth Fisher
You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed …
Continue reading
