Log in | Register

Satya Shyam K Jayanty, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Satya Shyam K Jayanty, Author at SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SatyaShyamKJayanty

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

About Satya Shyam K Jayanty

This author has not yet filled in any details.
So far Satya Shyam K Jayanty has created 5 entries.

SQL Server: Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook

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 will activate the failover or failback whenever the system is affected with the problem. Similarly, more complex and larger a database application, the more important […]

SQL Server: Master SQL chef series: Designing a best practice approach – Upgrading SQL Server data platform

All 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 keeping up their knowledge up to the level since last few years (at least since 2008 version release). In this regard the Upgrade of […]

By |January 2nd, 2012|Categories: SQL Server||0 Comments

SQL Server 2008 R2: OLE DB provider “SQLNCLI10” for linked server “x” reported a change in schema version between compile time and run time

Recently 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 linked server reported a change in schema version between compile time and execution time.

For a moment the error throws out spanner in works, application […]

SQL Server: performance series – PAGELATCH_ and PAGEIOLATCH_ wait types do not wait until its too late!

Contention 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 attempt to acquire incompatible latches to the same in-memory structure.

Going back to basiscs a latch is an internal mechanism that is used by […]

SQL Server Analysis Services – Multi level hierarchical dimension designs notes from the field

Business 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 data flow.

Just on bascis, on OLAP world the database dimension is treated as colleciton of related objects (referred as attributes) that can provide […]

By |September 9th, 2011|Categories: SQL Server||0 Comments
Newsletter_Footer