Monthly Archives: May 2018
-
Updated query to view data in the error log
5May 31, 2018 by Kenneth Fisher
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it …
Continue reading -
An interview with Brent Ozar
5May 30, 2018 by Kenneth Fisher
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time …
Continue reading -
Interview questions: What’s the first thing you would do if a user reports slowness.
8May 28, 2018 by Kenneth Fisher
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do …
Continue reading -
What are the system databases?
5May 21, 2018 by Kenneth Fisher
I get to help with technical interviews every now and again, and one of the questions we always ask is …
Continue reading -
The trials and tribulations of REVERTing from impersonation
1May 16, 2018 by Kenneth Fisher
Impersonation is a highly useful tool in your toolbox. With the EXECUTE AS clause you can allow your stored procedure …
Continue reading -
Blogging and when to keep your big mouth shut
2May 14, 2018 by Kenneth Fisher
I’ve been blogging for a while now. I’ve thought about blogging quite a bit. I’ve even done quite a few …
Continue reading -
Each session should be able to have its own temp table, but there can be problems.
1May 10, 2018 by Kenneth Fisher
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things …
Continue reading -
Why I blog: TSQL Tuesday #102
2May 8, 2018 by Kenneth Fisher
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given …
Continue reading -
SQL Homework – May 2018 – Create a database
4May 2, 2018 by Kenneth Fisher
I’ve really got to make a plan here at some point. So far I’ve been just putting down things as …
Continue reading
SQL Studies 