to search by track, speaker, or session category.
Sessions Found: 70
3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
Need to report on some data from SharePoint? We will look at three different techniques to pull...
A DBA's guide to whole stack performance troubleshooting
Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a...
ARMed for Azure
The Azure Resource Model (ARM) enables Azure infrastructure automation for both IaaS and PaaS...
Azure Sql PAAS: Lessons from the Real World
So you're using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how...
Azure SQLDW Fundamentals
On this session we are going to cover general aspects of Azure SQL Data Warehouse, how it works,...
Beginning Automation with Powershell
This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA...
Building a Complete DR Recovery Plan
When disaster strikes, the last question you want to be asking is where is the important...
Calculated Columns, Measures, and KPIs, Oh My!
To do serious work in a Power Pivot table or even a SQL Analytics Cube, you must know the...
Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching
SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for...
Creating Reports and Dashboards with Power BI
This session looks at both Power BI Desktop and Power BI.com to compare the advantages and...
Data Cleansing With SQL And R
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and...
Data Mining in Analysis Services (2005, 2008, 2012, 2014 & 2016)
This demo filled session will step through some predictive modeling functionality built into SQL...
Data Modeling for the Modern Enterprise
Explore data modeling and process modeling. Show Business Benefits and Value of Data Modeling Data...
Data Security with Power BI, SSAS, SQL Server and Active Directory
Today's Business Intelligence Tools allow to secure the data for a variety of business scenarios....
Database Creation Process
How to set up a Requirements Analysis to develop successful databases
DBA Monitoring and Maintenance Fundamentals
The key to becoming a great DBA is time. The best way to regain some time is by spending less time...
Deadlock, Block & Two Smoking Barrels: Breaking Down Blocking and Deadlocks
While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another...
Does This Look Weird? The Importance Of Baselining
How do you know when your server is on fire? Without a set of known-good measurements to compare...
Excel and SSIS: Better Together
If you’ve ever used the standard Excel Source or Destination components in SSIS, you know there are...
Execution Plan Basics - Beginners
This will be a Beginners session highlighting the starting point for using the execution plans from...
Genetics In Action: Evolutionary Algorithms
Evolutionary algorithms help us solve optimization problems where we know what the answer is, but...
Getting graphy with CosmosDB Graph API with Gremlin
CosmosDB was announced at Build 2017 as an extension to Microsoft's DocumentDB offering and is...
Getting Noticed: Strategies for Your Resume and LinkedIn
You know you are well qualified for the jobs that you search for on any major job site. You know...
Hi, my name is Powershell, let's be friends! An Intro to PoSH
Powershell wants to be your friend - your very powerful friend. In this session we will go over...
How to be a GREAT DBA
This presentation describes the tasks a DBA needs to perform to do a great job. Formal training...
How to Build Your Disaster Recovery Plan
So your boss asked for a copy of your DR plan. Once you've wiped that deer-in-the-headlights look...
How To Tune A Multi-Terabyte Database For Optimum Performance.
This session will cover how to tune a multi-terabyte database where all of the data is stored a...
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...
Indexing for performance
Learn all you wanted to know about index design, but were afraid to ask. This session focuses on...
InMemory Improvements on SQL 2016
SQL Server 2016 lifted several limitations from its initial implementation. This session will cover...
Sessions Found: 70
Back to Top