Tag Archives: problem resolution
-
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 -
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 -
I’ve gotten a transaction log full error but when I look it’s not full??
2April 16, 2018 by Kenneth Fisher
Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
Continue reading -
Deleting a lot of data
5April 12, 2018 by Kenneth Fisher
I recently had the task of deleting a bit over a billion rows from a table. Now I could have …
Continue reading -
Simply Debugging
3March 7, 2018 by Kenneth Fisher
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it …
Continue reading -
A day in the life of a Sr DBA/Dev
Leave a commentFebruary 28, 2018 by Kenneth Fisher
If you are a Sr DBA or developer you have probably had some variation of this conversation at multiple points …
Continue reading -
Help it takes forever to open the SQL Server Log!
Leave a commentJanuary 24, 2018 by Kenneth Fisher
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
Continue reading -
How to read a technical blog
4January 17, 2018 by Kenneth Fisher
There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If …
Continue reading -
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
Leave a commentJanuary 9, 2018 by Kenneth Fisher
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject …
Continue reading -
Compressed backup errors and TF 3042
6March 16, 2017 by Kenneth Fisher
Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time …
Continue reading
