to search by track, speaker, or session category.
Sessions Found: 27
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator...
Azure Data Factory V2 /SSIS in Azure
Azure Data Factory (ADF) has done some mileage since it's beginning in 2015. It has evolved and is...
Back to the Future with Temporal Tables
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work,...
BI in Excel 2016: The value is in the Refresh
2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and...
Blue Collar SQL Tricks - Make Standard Edition Work for you.
You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just...
Columnstore Index Primer
Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each...
CRUD to Always Encrypted: Exploring the SQL Security Landscape
Enjoy a fun filled adventure through the landscape of data and information security options...
Data Cleansing With SQL And R
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and...
Data Landscape on Azure
There are many Data Platform offerings available on Azure and new ones are introduced regularly and...
DBATools! The reason to finally start learning and using Powershell
Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008. In...
Educating yourself will make a SQL career more fulfilling
Do you want to turn your SQL knowledge into a possible career? This session will show you what...
Introduction to Object-Relational Mapping for DBAs
This talk introduces DBAs to Object-Relational Mapping (ORM) from the point of view of a software...
Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
Like parents having to break up a fight between battling siblings, SQL Server must do the same for...
Modernizing your legacy database integration points
Legacy corporate applications that are built in-house can quite often be tightly coupled together....
Much Ado About Hadoop
If you're interested in Hadoop but don't know where to begin, this session will give you an idea of...
New Era of Data Warehouse Design
Building and maintaining enterprise data warehouse is quite a daunting task; it takes months of...
Performance Tuning Fundamentals for SQL Server
Just a handful of configuration settings in SQL Server can mean the difference between an anguished...
Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got...
Power BI for the Faint of Heart - Understanding On-Prem, Hybrid and Pure Cloud Scenarios
Power BI v1. Started off in Excel. Today Power BI v2 has Excel capabilities, a free desktop app for...
Power BI: Roll up your sleeves, we're getting our hands dirty!
For years, Excel has been the tool of choice for business people around the world. In July 2015,...
R For the SQL Server Developer
R is the premiere language for data analysis. If the world of data science sounds fun and...
Remote Management of SQL Servers with PowerShell
Whether you've tried out PowerShell or not, make no mistake: PowerShell is here to stay. As a SQL...
Six Degrees of Sql Family? - An introduction to Graph Databases in SQL Server and CosmosDB
In this Session we will look at the theory and use of a Graph Database and its implementation in...
If you are involved in data warehouse development using the Microsoft technology stack, then you...
Stop Doing That! Common T-SQL Anti-Patterns
There are several programming design patterns that work great in object oriented code but do not...
Temporal Database Design
In recent years several databases now offer temporal features but did you know you can create a...
Who's on First? SQL Server statistics & Dynamic Power BI Visuals!
What will happen when a Performance Tuner is analyzing statistics and using Power BI reports based...
Sessions Found: 27
Back to Top