DataPlatformGeeks Free Saturday Training Events in Mindtree, Chennai (DevOps in Databases/SQL Server Monitoring, April 22) & Microsoft, Bangalore (DevOps/Azure, April 29). Register Now Check-out Pre-Con Session Abstracts Dear Rajesh, SQL Server is a mission critical database platform but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong. In short, analyzing SQL Server like a Pro was & is - a challenging task. Not Anymore. Uwe Ricken from Germany is flying down to Bangalore this August 16 to deliver a full day workshop on Analysis of Your SQL Server Like a PRO as part of Data Platform Summit 2017's Pre-conference seminars. Uwe Ricken, the first MCM + MVP in Germany, has more than 20 years of operational experience as a DBA & a developer of complex database models. He blogs about Microsoft SQL Server to the interested German community since 2010 at http://www.sqlmaster.de (in German). Analysis of Your SQL Server Like a PRO (Pre-con By Uwe Ricken on Aug 16) - In this full training day, Uwe will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers.
- This workshop will provide over 40 scripts which can be used directly in trainee's own machine during the day. Performance problems will be simulated and resolved using a top-down approach.
- The workshop will include the following modules:
- Insides to the workflow of the database engine
- Importance of security settings for the service accounts
- Waits and Queues methodology
- Instance and database level configuration
- Temp DB importance and optimization
- Index Analysis and tuning
Demo's by Uwe Ricken - More than 30 analysis scripts help you to understand the bottlenecks of your Microsoft SQL Server
- Run all scripts on your test- or production environment
- Analyze the results of the scripts
- Fix wrong server settings immediately
- Evaluate bad performing indexes / statistics
- Take a set of default maintenance tasks every Microsoft SQL Server should have implemented
This month, Uwe's Rs 9,200 priced one-day workshop is available to you at Rs 6,000 (exclusive taxes). Like our other pre-cons, Uwe'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 April 2017. (Price increases every month) Registration for Uwe Ricken'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
| | |
No comments:
Post a Comment