SQL Server Education (by the geeks, for the geeks)
When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that …
SQL Server: Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook Read MoreAll this month let us cook some best practices within SQL Server to become a master SQL chef in your data platform. There is no doubt that SQL Server users have been …
SQL Server: Master SQL chef series: Designing a best practice approach – Upgrading SQL Server data platform Read MoreRecently I had an intersting issue at one of the client’s place that pertains to Linked Server issue on a SQL Server 2008 R2 X64 environment. The OLEDB provider for the …
SQL Server 2008 R2: OLE DB provider “SQLNCLI10” for linked server “x” reported a change in schema version between compile time and run time Read MoreContention is the word that you need to concentrate in resolving the performance issue, page latches contention is common in multi-CPU systems due to the nature of when multiple threads concurrently …
SQL Server: performance series – PAGELATCH_ and PAGEIOLATCH_ wait types do not wait until its too late! Read MoreBusiness Intelliigence is the integral part of your data platform, by keeping up the design and development practices you can reduce the excess baggage that can reduce the performance of your …
SQL Server Analysis Services – Multi level hierarchical dimension designs notes from the field Read More