Satya Shyam K Jayanty


Satya Shyam K Jayanty

Principal Solutions Architect, D Bi A Solutions, Europe

Satya is an SQL Server MVP for the last 10 years, subject matter expert with consulting & technical expertise within Data Platform, Business Intelligence, and Architecture solutions with over 24+ years of experience. He is the author of Microsoft SQL Server 2008 R2 Administration Cookbook (released May 2011) and Microsoft SQL Server 2012 cube-security How-to (October 2012) from, co-author of MVP Deep Dives SQL Server Volume II (released October 2011) from Manning Publications.

Satya (@SQLMaster) is a prolific speaker at major technology conferences such as Microsoft Tech-Ed (Europe, India and North America), SQL PASS (Europe and North America), and SQL Bits (UK). Owner of 2 leading SQL Server usergroup in the United Kingdom. Satya was very active (held Moderator positions) in SQL Server related newsgroups and forums such as, SQL Server Central. Microsoft SQL Server tutorials, training & forum. and SQL Server Information at along with Microsoft Technet forums. Whenever time permits, Satya contributes to his own blog site, Data Platform Knowledge Sharing Network | – A Knowledge Sharing Network… and shares knowledge from his Twitter pod ( With his down to earth attitude he believes every day is a new learning in SQL world – happy to learn and proud to share the knowledge.


Session Details

Session Title & Code Abstract Level Track
Let’s Cook ‘Affordable DBA Practices’ Using SQL Server Features – A Prolonged Journey from 2008 to 2016 – (DBA-10I) DBA trade is still in-demand and will remain as long as databases are alive!
If you are an average IT person/Developer/SysAdmin who has been managing development and databases in your organization, now you want to manage SQL Server databases using tricks of DBA trade and you’ve got no idea what to do with it!

In this session we will overview range of topics that every DBA handles, such as: backup/restore strategy, high availability, scalability and performance tuning. We will touch base on how best SQL Server technology will offer home-grown tools to keep your BAU tasks.

Not giving opportunity of riding a super-duper car, but best learning techniques on how to manage your SQL Server database and make it efficient enough to run like a fast car on performance aspects. You will get o know what is needed to get that new features to implement, how best they can fit in.

All the examples and demos in this session are originated from real-world work from my (18 years) Consulting experience.

Intermediate DBA
What do I Need to Know About Data Platform Upgrade Best Practices & Techniques – (DBA-11I) Why Upgrade?
Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe & India), SQLPASS, SQLSaturdays and SQLbits since the year 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server 2000, 2005, 2008 R2 & SQL Server 2012/2014 (with a good overview on 2016 too) by using best practices and available resources.
We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why & how such a solution will work in critical situations.

Intermediate DBA
Power BI – Deployment Best Practices to Deliver Data Analytics to The Business – (BIA-09I) How to deploy Power BI, how to implement configuration parameters and package BI features as a part of Office 365 roll out in your organisation.
Having said that, cloud computing is another aspect of this technology made is possible to get data within few clicks and ticks to the end-user. Let us review how to manage & connect on-premise data to cloud capabilities that can offer full advantage of data catalogue capabilities by keeping data secure as per Information Governance standards. Not just with nuts and bolts, performance is another aspect that every Admin is keeping up, let us look into few settings on how to maximize performance to optimize access to data as required.
Gain understanding and insight into number of tools that are available for your Business Intelligence needs.
There will be a showcase of events to demonstrate where to begin and how to proceed in BI world.
Intermediate BIA


Don’t miss SQLServerGeeks Annual Summit at NIMHANS Convention Centre in Bangalore, August 27 – 29, 2015!

Register Now
Sponsor Now
Exhibit Now
Submit a Session