Welcome to SQLSaturday
SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleagues know about the event.
SQLSaturday Precons - 08 September 2017
Azure Infrastructure with Denny Cherry
In this daylong session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier.
Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.
With the introduction of multiple Azure data centers now available in India many companies will be begin moving services from data centers into the Azure and a solid foundation is key to successful migrations.
•Understanding design decisions and impacts
•Designing for performance
•When can slow be well performing
•Moving deployments from Classic to Research Manager
•Understanding Azure Security
Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny's areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2014 including the Microsoft Certified Master as well as being a Microsoft MVP for several years. Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.
Understanding Execution Plans with Hugo Kornelis
For troubleshooting long-running queries, looking at the execution plan is often a good starting point. Once you know how the query is executed, you know why it's slow and what you can do to speed it up.
But what if the execution plan is just beyond your understanding? What if it uses operators you have seen before, but do not really understand? What if you look at the execution plan, but just don't see the problem?
In this full-day workshop, you will learn everything you need to be able to read and understand any execution plan. We'll start with an overview of execution plans as a whole, and then dive in and look at all the components, and how they fit together. This will increase your understanding on why the optimizer picks a plan, and what you can do to make it pick a better plan.
Whether you have read your share of execution plans or whether you wouldn't know where to find them, this workshop will teach you everything you need to know about execution plans.
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He is a SQL Server MVP since 2006.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has almost 20 years of SQL Server experience in various roles. He has a strong database design background but also loves to write and tune complex queries.
SQL Server for T-SQL and .Net Developers with Mladen Prajdic
Aimed at T-SQL and .Net developers, and DBA's that want to see what developers have to deal with, in this pre-conference session we'll go over what every developer dealing with SQL Server and .Net has to know to be as effective and productive as possible. This day-long session is the result of years working with .Net and SQL Server and hopefully it will give you more than a few ideas on how to apply them.
The modules we'll cover are:
1) Normal forms, data structures and data types to make you understand why the database is designed the way it is and how to make it better and faster from the start.
2) Isolation levels and locking provide us with knowledge about concurrency and blocking issues and how to maintain good data integrity.
3) T-SQL tips and tricks will teach you to write better, faster and more optimized queries
4) Diving into the .Net SqlClient to show some interesting database access features to make your programming easier.
5) Saving the best for last, we'll look at a few attack vectors that can be used against your company, with not only focusing on technical, but on social engineering aspects as well, and what you as a developer can and should do to protect against them.
Mladen Prajdic is a SQL Server MVP from Slovenia and has been a C# and SQL Server developer for over 15 years. He blogs at http://weblogs.sqlteam.com/mladenp and develops a popular add-in for SSMS called SSMS Tools Pack (http://www.ssmstoolspack.com).