Barney Lawrence has over a decade's experience on the Microsoft data platform having moved from the guy who knows Excel, to Data Analyst, to Accidental BI Developer and finally to Actual BI Developer. He currently works as a Senior BI Developer for Jet2.com
Temporal tables, introduced with SQL Server 2016, have a number of useful applications within the data warehouse. This session provides an introduction to temporal tables and what you need to know about them in order to get started using them in your data warehouse.
Learn how create temporal tables from scratch or convert existing tables, find out what the catches are and when you should (and probably shouldn't) consider using them, how they can simplify the code needed in comparison to other solutions and take a brief look at performance in comparison to their alternatives. Finally, we walk through some real-world use cases.
CROSS and OUTER APPLY are the Swiss Army knives of joins.
This session will show you how to apply these two join types to your code not just for table valued functions but to make your queries faster, shorter, easier to read or simply to help to sweep those data quality gremlins under the carpet and avoid errors.
Examples will be taken from situations the speaker has encountered within Business Intelligence work but will be equally applicable elsewhere.
Moving beyond the basics of DAX can as tough as learning to tap-dance without falling in the sink. Several of the key concepts you need to understand can be hard to grasp before more complex expressions can be confidently written.
This session will help anyone who is either looking to move their formulae up to the next level or looking to support others in doing the same by providing new ways of thinking about some of these concepts.
Together we will explore filter contexts with punchlines, learn how row contexts are like a barn dance, how CALCULATE can work like a distracted boyfriend, and discover what makes a Zebra Fish blush.
This session is aimed at anyone with basic level T-SQL experience or above looking to improve their code; especially when writing long, complex queries.
We will cover topics including getting the most out of Management Studio, Common Table Expressions, the APPLY operator, Window Functions, methods of pivoting and unpivoting data and more.
Through this you will expand your tool-belt of techniques to help you produce T-SQL code that's not just faster to run but also easier to read and faster to write.