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.
This year we have 4 exciting precons covering a good variety of topics to ensure that there is something for everyone.
Azure Infrastructure with Denny Cherry
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.
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
Understanding Execution Plans with Hugo Kornelis
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.
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.
SQL Server for T-SQL and .Net Developers with Mladen Prajdic
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).
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.
Hot ideas and plain cold facts on making Integration Services work for YOU! with Steve Simon
Steve Simon is a Data Platform MVP and a senior BI Development Engineer with Carousel Industries. He has been involved with database design and analysis for over 32 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQL Saturday circuit and he is a regular contributor on SQLShack.com
Data availability is only a half the story in being able to provide timely information to the decision maker. Moreover, this information is oft times critical to the corporate mission success.
This “hands on” pre-conference session will be concentrating on how to optimally utilize the features of SQL Server Integration Services to build an Integration Services solution which will process corporate data in a manner in which corporate information may be formulated from our data.
Topics will include
- Package storage: the pros and cons of database storage vs. file system storage.
- Introduction to the package concept. Physically creating packages and a detailed discussion of many of the gotcha’s that you may and will encounter.
- What is a package and why do we use them (20 minutes).
- Why utilize SQL Server Integration Services (20 minutes): An introduction to the product.
- We shall be developing and implementing both.
- Performance testing of packages.
- Creating SQL Serve Agent Jobs, running scheduling these jobs and we shall be discussing in detail many of the gotcha’s including maintaining accurate agent execution plans.
- Integration Services and Master Data Services daily load processing.
- Integration Services and Data Quality Services daily load processing.
- Extracting data from the cloud and loading of data into local warehouses.
- Utilizing Integration Services controls to extract, manipulate and transform, and load our raw data into our databases and warehouses in the most efficient and effective manner.
- The effective utilization of Integration Services “transforms”.
- Control flows and Data Flows. What are they and why do we need them? How do we utilize them?
- All the techniques that we shall be working through have been utilized on two major North American projects. One point though, rest assure that you will leave this session with more questions than answers!