Monthly Archives: May 2014
-
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 -
Microsoft’s free virtual labs
1May 26, 2014 by Kenneth Fisher
If you have spent any time looking around my site, you will notice that I love study materials and in …
Continue reading -
DBA Myths: A table with a primary key is not a heap
5May 21, 2014 by Kenneth Fisher
Typically when you see a heading like this you know the answer is “No” or “False” but in this case …
Continue reading -
Escaping from a runaway Logon trigger
11May 19, 2014 by Kenneth Fisher
Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
Continue reading -
T-SQL Tuesday #54: Interviews!
1May 13, 2014 by Kenneth Fisher
It’s T-SQL Tuesday again and this month our host is Boris Hristov (b/t). He has asked us to discuss Interviewing. …
Continue reading -
Does SQL Server do a CHECKDB during an instance restart?
11May 7, 2014 by Kenneth Fisher
When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
Continue reading -
Why is there a sysobjects when we already have sys.objects?
2May 5, 2014 by Kenneth Fisher
Once upon a time in a version of SQL far far away we had system tables that were easy to …
Continue reading