This mainly demo-based session will cover the following:
After the session, attendees will have an insight into partitioning and have a platform on which to be able to investigate further into implementing a partitioning solution in their own environment.
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stumbled into my career in performance tuning. In this session, you will learn some T-SQL performance tuning tips that can be used in the office immediately. You will learn how to identify top offender queries, be able to benchmark queries. Finally, we will cover some coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.
One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems.
In this session we will look into different methods focusing on effective use of T-SQL and explore how these methods can mixed and matched in your ETL workflows:
There seems to be a common misconception that once you move from on premises SQL Server to Azure PaaS offerings a DBA is no longer required. This perception is wrong and in the session I’ll show you why. As a business intelligence consultant I develop data platform solutions in Azure that once productionised need administration. As the title suggests, be my Azure DBA. Maybe not DB for database. Maybe in Azure I need a DSA, a Data Services Administrator. Specifically we’ll cover a real business intelligence solution in Azure that uses Data Factory, Data Lake, Batch Service, Blob Storage and Azure AD. Help me administer this next generation data solution.