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
A-Z of BI with Glenn Morris
This SQLSaturday Pre-Conference Day will discuss, demo and build out a number of scenarios that deal with data harvesting, data wrangling, data visualization and databases. Primarily through the lenses of the Microsoft Data Platform we will discuss SQL Server 2016/SQL Server 2017, The Azure Data Tools, Big Data, Azure Functions, Artificial Intelligence and Power BI with a view to how it applies to business and how you can get your business using some of the amazing capabilities that are available to assist you in making sense of and being proactive with data. Underpinned by the fact that, ultimately, most businesses want good, accurate reporting and insights we will approach this need from a number of angles using the different technologies available to us.
The world is changing at a pace never seen before and while we all want “Business Intelligence” our goal should be the “Intelligent Business” that uses the capabilities and tools available to us to make better use of our data and the data available to us through other channels.
With over 18 years of experience in the IT Industry, Glenn Morris is truly one of the most respected MVP's, Microsoft Certified Trainers and Consultants in Australia.
A Mathematics graduate turned IT Wrangler, Glenn quickly immersed himself in the world of code while also looking 'beyond the code' at an area that he then termed "Intelligent Business". Combining the code with the business processes he took a role Lecturing at the London School of Accounting and Management where he taught Programming, Performance Analytics and Business Intelligence. He subsequently moved into the Data Science which he saw as his 'sweet spot' and this has been what has underpinned his IT life since.
Glenn lives on the beautiful Gold Coast of Australia.
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).
Hot ideas and plain cold facts on making Integration Services work for YOU! with Steve Simon
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!
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