SQL Server DBA Diaries

SQL DBA Diaries. SQL Server DBA Diaries...

Read Sqldbadiaries.com news digest here: view the latest SQL DBA Diaries articles and content updates right away or get to their most visited pages. Sqldbadiaries.com is not yet rated by Alexa and its traffic estimate is unavailable. It seems that SQL DBA Diaries content is notably popular in USA. We haven’t detected security issues or inappropriate content on Sqldbadiaries.com and thus you can safely use it. Sqldbadiaries.com is hosted with Newfold Digital, Inc. (United States) and its basic language is English.

Content verdict: Safe
Website availability: Live
Language: English
Last check: 1 month ago

N/A
Visitors daily
N/A
Pageviews daily
1
Google PR
N/A
Alexa rank

Best pages on Sqldbadiaries.com

SQL Server DBA Diaries

SQL Server DBA Diaries Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. Af...
I/O is frozen on database, No user action is required | SQL Server DBA Diaries

I recently responded to one of the questions in which the user wanted to know what these messages in the SQL Server Error Log mean. spid92,Unknown,I/O is frozen on database [databasename]. No user …
Property Owner is not available for Database | SQL Server DBA Diaries

Couple of days back, on one of the databases encountered a strange error. When clicked on Properties of the database in SSMS, it threw an error which read **************** Property Owner is not ava…

Sqldbadiaries.com news digest

9 years

No transaction is active message when accessing Linked Server

Last week I had worked on an issue related to Linked Server. The customer had migrated the SQL Server Instances to Virtual Servers. They had quite a few Linked Servers setup. After migration any Distributed Transaction like the one below across the linked...
9 years

Application timing out due to excessive blocking on tempdb PFS

Problem
Applications Connecting to SQL Server timing out
Symptoms
9 years

SQL Server Cluster resource fails with “Data source name not found and no defaul...

Last week I had worked on SQL Server 2008 R2 installation on a Windows Cluster. The installation would go fine until the installer tries to bring the SQL Server resource online. At that time it would fail with the following error message,
The cluster resource 'SQL Server' could not be brought online. Error: The group or resource is not in the correct state to perform the requested operation. (Exception from HRESULT: 0x8007139F)...
9 years

CDC job failing with “Unable to add entries to the Change Data Capture LSN time ...

I got a chance work on CDC job failure issue recently. The customer had configured CDC on the database but it wasn’t working as expected. Hence he had disabled/enabled CDC multiple times on this database.
The “cdc.[DBName]_capture” job was failing with the following error...

Domain history

Web host:	Newfold Digital, Inc.
Registrar:	Tucows Domains Inc.
Registrant:	REDACTED FOR PRIVACY
Updated:	June 23, 2023
Expires:	July 08, 2024
Created:	July 08, 2010

Whois record

Visitor gender

Male

Female

Safety scores

Trustworthiness

Good

Child safety

N/A