Diagnostics – LincolnBlog.net

About TempDB and the Version Store

Posted on 07/16/201910/09/2019 by Lincoln Bovee'

We will take notes here regarding tempDB, the Verison Store and how tempDB is used. Some of the content here is derived from…

PostgreSQL vs. SQL Server Notes

Posted on 02/13/201903/30/2020 by Lincoln Bovee'

This blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…

Using the KILL command

Posted on 11/22/2016 by Lincoln Bovee'

You can view the status of a KILL command used to stop an open transaction by typing the following:

KILL [SPID] WITH STATUSONLY

1	KILL [SPID] WITH STATUSONLY

Views – 1816

Resolving the “Backup detected log corruption in database”

Posted on 04/14/201612/01/2017 by Lincoln Bovee'

I saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…

MSDB is in “Recovery Pending” state

Posted on 04/14/2016 by Lincoln Bovee'

I had a SQL Server at work today where I found the msdb database in “Recovery Pending” state. After reading a number of…

“Why can’t I truncate my log file?!?”

Posted on 03/07/201603/08/2016 by Lincoln Bovee'

I found a VERY useful query from Brent Ozar’s daily emails that go out on how you can check for the reason SQL…

Error 4064 Return When User Connects via SSMS

Posted on 11/19/2015 by Lincoln Bovee'

USE master;
GO

SELECT	name, dbname
	FROM syslogins
	WHERE dbname = 'MyDatabase'
	ORDER BY dbname

SELECT	name AS LoginName, default_database_name
	FROM sys.server_principals
	WHERE default_database_name IS NOT NULL
	ORDER BY default_database_name

USE master;

SELECT name, dbname

FROM syslogins

WHERE dbname = 'MyDatabase'

ORDER BY dbname

SELECT name AS LoginName, default_database_name

FROM sys.server_principals

WHERE default_database_name IS NOT NULL

ORDER BY default_database_name

Views – 1822

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

Category: Diagnostics