Yearly Archives: 2014

The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. Here’s an excerpt: The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 73,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 3 days for that many people to see … Continue reading →

The 5th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 5 contains all the hotfixes released since the initial release of SQL Server 2014 RTM. Those who are facing severe issues with their environment, they can plan to test CU5 in test environment … Continue reading →

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of RPC in cluster” ? The Remote Procedure Call (RPC) [http://support.microsoft.com/kb/832017] system service is an interprocess communication (IPC) mechanism that enables data exchange and invocation of functionality … Continue reading →

Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager. Steps I perform to resolve the issue, Seems to be a WMI error :- 1) If using Window Server 2008 & above, Run command from command prompt to verify WMI repository : … Continue reading →

1. Do not change collation of TempDB from the SQL Server instance collation. 2. Do not change the TempDB database owner from sa. 3. Do not drop the TempDB database. 4. Do not drop or revoke the guest user from the database. 5. Do not change the recovery model from SIMPLE. 6. Allow for tempdb … Continue reading →