Tag Archives: problem resolution
-
Who has the DAC open?
2May 28, 2014 by Kenneth Fisher
The other day I started seeing the following error in my SQL log. Error: 17810, Severity: 20, State: 2. Could …
Continue reading -
Start with stupid
2March 17, 2014 by Kenneth Fisher
True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked …
Continue reading -
Check your SQL Agent history settings before it’s too late!
9February 10, 2014 by Kenneth Fisher
A little while back I was doing some research into a failed job and ran into a slight problem. The …
Continue reading -
Negative session_ids
3January 27, 2014 by Kenneth Fisher
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
Continue reading -
Why you should know how to script as well as use the GUI
Leave a commentOctober 14, 2013 by Kenneth Fisher
Personally I’ve always enjoyed learning the T-SQL for any given task. The GUI is usually pretty easy to figure out …
Continue reading -
I’ve refreshed a test database from prod but now the users can’t access it.
4October 9, 2013 by Kenneth Fisher
This happens to me all the time. I get a request from a developer to overwrite the test copy of …
Continue reading -
Brad Shultz’s blog on reviewing your database
1September 17, 2013 by Kenneth Fisher
This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
Continue reading -
A T-SQL query to get current job activity
30September 5, 2013 by Kenneth Fisher
I recently had the task of collecting job activity for the purposes of turning it into a report for some …
Continue reading -
The most important skill to practice when preparing for any certification exam!
4August 28, 2013 by Kenneth Fisher
I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an …
Continue reading -
Notes on debugging Database Mail problems
10July 29, 2013 by Kenneth Fisher
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
Continue reading
SQL Studies 