One-day Training on Query Optimizer & T-SQL (By Rob Farley)

Check-out Pre-Con Session Abstracts   Dear Rajesh, When you were taught to write T-SQL, you learned how to create queries that are logically correct to produce the results you want. You were probably taught about using indexes, and other techniques for tuning, but what about - Hash Aggregates, Spools, or Parallelism? Rob Farley, MCM, MVP, MCT & author, is coming to Bangalore, all the way from Australia, to teach you how to write queries that produce the plans you want, and identify how particular query plan operators can help or hinder the performance of your queries, to give the kind of performance you should expect. Rob Farley will take a full-day workshop on the topic "Plan-first Querying – Writing Queries to Suit the Optimizer" on Aug 16 (Pre-Conference Seminar) as part of Data Platform Summit 2017. In this workshop, Rob will take a different approach to T-SQL, by teaching you to cater for what the Query Optimizer is doing. Watch Rob Farley talk about his DPS 2017 Pre-Con workshop Plan-first Querying – Writing Queries to Suit the Optimizer (Pre-con By Rob Farley on Aug 16) The workshop will include the following modules: Reading & Evaluating SQL Plans Query rewrites Simplification Base Rows Join & Aggregate Types Seek Order & Sort Order Demo's by Rob Farley Rob says "it is full of it, and nothing else" This month, Rob's Rs 9,200 priced one-day workshop is available to you at Rs 6,500 (exclusive taxes). Like our other pre-cons, Rob's pre-con is already very popular, so if you are interested, register at the earliest to block your seat and enjoy the reduced Pre-con price of May 2017. (Price increases every month). Registration for Rob Farley's Pre-con Offline Registration & Payment: Register here for offline registration and pay using offline methods (Cheque, Demand Draft, Pay Order, etc.) Online Registration & Payment: If you want to register online & pay using Credit Card or Net Banking, Click Here Are you being sponsored by your company? Download the Corporate Registration Kit. Check-out our other Pre-con sessions/speakers of DPS 2017 below the signature.   Best Regards, Data Platform Summit 2017 Team +91 7829999046/47, +91 9503124667   Data Platform Summit 2017   Dates:                   Aug 17-19. Pre-Conference Seminars on Aug 16 Venue:                 NIMHANS Convention Centre, Bangalore. Download Catalogue Download the Corporate Registration Kit   Data Platform Summit 2017 Pre-Conference Seminars (Full Day Training) Speaker Track Title Denny Cherry Cloud Azure Infrastructure   Leila Etaati Data Science /BI/Analytics Advanced Analytics with R, Microsoft SQL Server, Power BI, and Azure Machine Learning Peter Myers Business Intelligence & Analytics Zero to Microsoft Power BI   Rob Farley Database Development / Administration Plan-first Querying – Writing Queries to Suit the Optimizer Steve Jones Database Development Building a Database DevOps Process   Uwe Ricken Database Administration Analysis of Your SQL Server Like a PRO

This email was sent to seekajob@outlook.com why did I get this?    unsubscribe from this list    update subscription preferences eDominer · Koramangala · Bangalore 560034 · India