to search by track, speaker, or session category.
Sessions Found: 15
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator...
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...
Data Cleansing With SQL And R
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, 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...
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...
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...
Performance Tuning Fundamentals for SQL Server
Just a handful of configuration settings in SQL Server can mean the difference between an anguished...
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...
Stop Doing That! Common T-SQL Anti-Patterns
There are several programming design patterns that work great in object oriented code but do not...
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: 15
Back to Top