Dear SQL/Data Geek
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