Database Mirror TimeOut

database mirroring timeout message

Here is SQL Server Error Log Message I detected on one of SQL Server 2008R2 “The mirroring connection to “TCP://server_name:5022″ has timed out for database “<dbname> ” after 10 seconds without a response. Check the service and network connections.”      …

Type In-row data is incorrect. Run DBCC UPDATEUSAGE.

sql server 2000

The Issue: Integrity Check (DBCC CHECKDB) produces the error The In-row data USED page count for object “my_table”, index ID 9, partition ID 2609137898356736, alloc unit ID 2609137898356736 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE. CHECKDB found 0 allocation…

Querying Linked Server with OPENQUERY

Linked Server

If you try to invoke a user-defined function (UDF) through a linked server in SQL Server by using a “four-part naming” convention (SQLserver.SQLdatabase.dbo.SQLfunction), you may receive error message.   The reason is User-defined function calls inside a four-part linked server…

SQL Server Reporting Services Data Alerts

actions to create new data alert

SQL Server 2012 introduced data alerts as a way to notify users of changes to report data, enabling them to view reports only when changes in the data may have business implications. By using this data driven alerting solution you…

Microsoft’s SQL Server 2014 new features

SQL Server 2014 Data Platform

HotLap Melbourne was a great opportunity to find out what’s new in the next release of SQL Server, SQL Server 2014. It was nicely presented by Peter Ward from www.wardyit.com. 2 major topics were covered Database Engine Improvements & Power BI.…

SSRS Reports Caching

ssrs cache refresh options

In SSRS there are two options for pre-loading SSRS Reports: caching and snapshots A cached instance of a report is based on the intermediate format of a report. The report server generally caches one instance of a report based on the report…