to search by track, speaker, or session category.
Sessions Found: 64
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 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 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...
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...
InMemory Improvements on SQL 2016
SQL Server 2016 lifted several limitations from its initial implementation. This session will cover...
Introduction to Azure Streaming Analytics
This session will cover what is Streaming Analytics and the various use cases. We will demonstrate...
Introduction to BI Architecture
There is a ton of buzz in the market about BI, but do we really know what is BI Architecture? We...
Introduction to unit and integration testing with tSQLt
Testing allows database code to be consistently verified during the development process, but it can...
Let Her Finish: Supporting Women's Voices in Technology
Next time you attend a meeting, watch what happens when women at the table offer ideas. If your...
Sessions Found: 64
Back to Top