Main Content
Rohan Joackhim's Talks
-
Deep Dive to SQL Server Parallel Query Processing
Rohan Joackhim 1 Recommendation
February 15, 2013 7:00 PMDuring query optimization, SQL Server is looking for queries or index operations that might benefit from parallel execution. This session will start with the basics of parallelism in SQL Server. Then lead you to understand what is under the hood of parallel query execution. How you can avoid…
-
SQL Server Transactional Replication for Dummies
Rohan Joackhim 1 Recommendation
February 15, 2013 7:00 PMSQL Server transactional replication is only part of achieving a highly availability in data replication. If you have implemented it correctly you can achieve a low latency (2-4 seconds) replica of your database. This session will help you to optimize and increase the efficiency of your tran…
-
High Availability in SQL Server
Rohan Joackhim 1 Recommendation
November 28, 2012 1:00 PMThere are numerous high availability options available in SQL Server. Log shipping ,data replication and database mirroring are some of them. During this presentation, I will be scratching the surface of each of these high availability options. End of the presentation, audience will have a b…
-
SQL Server 2008 Policy-Based Management (PBM)
Rohan Joackhim 1 Recommendation
February 25, 2012 3:40 PMThis session will take you from the basics to the intermediate level of policy based management (PBM) in SQL Server 2008.What are Facets, Policies, Categories and Execution Modes? How you can manage over 500 SQL Server instances in a high availability environment using predefined policies? W…
-
ITIL best practices for a SQL Server Administrator
Rohan Joackhim 1 Recommendation
February 24, 2012 10:00 PMThis session will discuss the ITIL best practices for a SQL Server administrator. Some of the questions that will be discussed include: What are the best practices to follow during the code review, release management, and incident detection and recording? What are the Critical Success Factor…
-
Parallel query processing in SQL Server 2008
Rohan Joackhim 1 Recommendation
May 26, 2011 3:00 PMThis presentation was focused on SQL Server 2008 Parallel query prosessing .Some of the areas were covered : Reading the execution plan to discover parallelism,serial plans and parallel execution as multiple serial plans, Schedulers, Workers, and Tasks,Parallel Page Supplier, Distribute Stre…