to search by track, speaker, or session category.
Sessions Found: 65
A Look Inside SQL Server Distribution Statistics
Where do the estimated rowcount values come from? Look inside SQL Server’s distribution statistics...
Accelerating Development and Testing Using Data Virtualization
Constraining everything in development and testing is database size. Storage is a bottleneck, and...
Advanced SQL Server troubleshooting with SQLCallStackResolver
Troubleshooting spinlock contention, strange wait types, AVs and asserts is no longer a black box....
An Introduction to Azure SQL Database for DBA's
Are you interested in learning about Azure SQL Databases but are not sure where you should start...
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator...
Back to the Roots: Indexes why, where, when, how?
Indexes are a key point to performance for any database, relational or not. SQL Server and Azure...
Back to the Roots: When indexes are not enough
If you want optimum performance in SQL Server, you have to use indexes. But what if you already...
Becoming a Master by Giving it All Away
It has been said that novices absorb knowledge like a sponge, intermediates hoard it for...
Blurring your Data with Dynamic Data Masking
In this talk Greg will explore the new Data Masking feature, that came out with SQL Server 2016. ...
Build ETL efficiently (10x) with Minimal Logging
This session is designed to teach DBAs and developers the best strategy to transfer large data....
DevOps for the DBA
DevOps came out of the Agile movement and the idea that operations needed to be part of the...
Empowering the Business Analyst & Product Manager
How did PowerBI change the requirements management process? How can it help the Business Analyst or...
Enjoy Your Power Responsibly; Governance for PowerBI & O365
PowerBI is used in many organizations, but how to govern it? this question is still a work in...
Entity Framework Core
With the availability of .NET Core, Entity Framework (also from Microsoft), has been updated with...
Extend Time Slot
Extended time slot for Spotlight Sessions listed above
Four Lighting sessions (click here to see them)
1. Temp Tables & Table Variables by Vern Rabe. You may have heard that temp tables are better...
Gathering Trending Data with PowerShell
Join me in the quest to become a PowerShell DBA! Learn how to improve your career by quickly...
Get the Most Visual Power
Which visuals from the custom visuals free gallery can be the most useful and the prettiest to look...
Getting graphy with CosmosDB Graph API with Gremlin
CosmosDB was announced at Build 2017 as an extension to Microsoft's DocumentDB offering and is...
HiHo! HiHo! SQL Server on Linux, We Go!
SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in...
I like big data for $400 - Exploring quiz show questions using Angular, CosmosDB and Azure Search
In this talk, we will explore two powerful technologies from the Microsoft Azure Stack: CosmosDB...
Internet Of Things: Smart Mirror
A look at the intersection of hardware, software, and internet. See what it takes to bring your...
Introduction to Log Parser: Log What?
Log Parser is one of Microsoft’s best and most under recognized tools. Originally designed to read...
It's Time for a Change: Temporal Table Support in SQL Server 2016
Without temporal tables (AKA history tables), we can only see the current version of data. We can’t...
Managing ETL Change using BIMLScript
You develop an SSIS package to load a flat file. You meticulously identify each of the columns and...
Managing SSRS Reports using PowerShell and SSRS Web Services (60 minutes)
When you have to do something more than once, you should script it! That’s true for SQL Server...
MDX 101 - Query SSAS cube like a Jedi
Multidimensional Expressions (MDX) language is used to query SQL Server Analysis Services Cubes. ...
Modeling and Analytics Features Coming in Azure Analysis Services
Microsoft Azure Analysis Services & SQL Server Analysis Services help you build comprehensive,...
Need For Speed? Top Five SQL Server Query Tuning Tips
Query tuning is key to peak performance in SQL Server databases. However, lots of developers and...
Oracle vs. SQL Server- The War of the Indices
This session is for the love of technology and learning. Its based off research performed on...
Sessions Found: 65
Back to Top