Meet Our Experts
Thomas LeBlanc
Webinars
SQL Server 2016: New BI Superpower
SQL Server 2016 includes some of the best features from Microsoft ever! Plus, the Standard edition now includes many features previously available only in Enterprise. In this webinar, we’ll review four areas of changes—the database engine...
Make Report Building Easy with Dimensional Modeling!
Why do you need Dimensional Modeling? Analysis Services in combination with good Dimensional Modeling is the ticket for managing constant requests for new or changing reports. In this webinar, we'll start by covering some examples of T-SQL that's gen...
Courses
Exploring SQL Server 2016, Part 5 of 5: Advanced Integration
Take a look at the R language, which has been more deeply integrated into SQL Server 2016 via the SQL Server database engine, and how to run stand-alone R services for development. Examine new client tools to interact with R services and learn how to...
Exploring SQL Server 2016, Part 4 of 5: Business Intelligence
Dive deeper into your SQL Server 2016 exploration, starting with a review of new improvements to integration services including how to use catalogue and project parameters, as well as improvements related to deploying packages. Explore the new data s...
Exploring SQL Server 2016, Part 3 of 5: Security and Availability
Continue your exploration of SQL Server 2016 with a review of row level security, including a look at Always Encrypted and dynamic data masking, high availability, and clusters, and discover a wealth of enhancements in the areas of security and encry...
Exploring SQL Server 2016, Part 2 of 5: Performance Enhancements
Enhancements in performance are an important reason to upgrade to SQL Server 2016. Learn about changes in manageability features and execution, as well as query plans with live query statistics before taking a look at Powershell and integration with...
Exploring SQL Server 2016, Part 1 of 5: First Look
Begin your exploration of SQL Server 2016 with an overview of what’s new and what’s been updated. Following an installation example, discover the changes in R services and configuring tempdb, then take a close-up look at the various ways SQL Server M...
SSAS 2014, Part 10 of 10: Data Mining
Data Mining is an analytical process to explore data looking for patterns. In this course, you will learn how to create a model from a data source and by using data sets and SQL Server Data Tools analyze data. By using business questions like "what c...
SSAS 2014, Part 09 of 10: Cube and Tabular Processing
The Tabular Model can be used to efficiently retrieve data. This course discusses how cube automation and tabular processing can be done on Dimensions and Measure groups. It also covers how storage and retrieval of the tabular model works for both ...
SSAS 2014, Part 08 of 10: DAX
DAX or Data Analysis Expression language allows developers to extract data from dashboards and reports. This course will begin by explaining how DAX relates to the tabular model. It will progress to how row and filter contexts and functions can be...