Tag Archives: microsoft sql server
-
Impersonation can give you the wrong answer
1February 8, 2016 by Kenneth Fisher
I use impersonation all the time to let me see additional permissions information I can only get that way and, …
Continue reading -
Blogger questions: What if someone else wrote about the same subject?
8February 3, 2016 by Kenneth Fisher
I have a moderately popular blog. In part because I syndicate but largely (in my opinion) because I write a …
Continue reading -
Running code on the startup of SQL Server
1February 1, 2016 by Kenneth Fisher
Every now and again you need to run code when your instance starts up. For example you might want to …
Continue reading -
Reusing schedules in SQL Agent
1January 25, 2016 by Kenneth Fisher
I’m a big fan of automation. You get it written, tested, and scheduled, then you just sit back and monitor …
Continue reading -
Start SQL Server without tempdb
3January 20, 2016 by Kenneth Fisher
tl;dr; Re-start the instance in safe mode (-f startup parameter) and move tempdb. Then re-start without the parameter. While at …
Continue reading -
To the page and back again
1January 18, 2016 by Kenneth Fisher
To the page It’s not one of those things you have to do frequently but every now and again you …
Continue reading -
What is RESULT SETS?
12January 14, 2016 by Kenneth Fisher
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before …
Continue reading -
Do you check for TRUSTWORTHY databases as part of your security audits?
7December 30, 2015 by Kenneth Fisher
I ran a twitter poll the other day Do you check for databases with trustworthy turned on when you do …
Continue reading
SQL Studies 