to search by track, speaker, or session category.
Sessions Found: 85
#GetModern With Dell EMC
Consistent and predictable performance is critical for any successful deployment of Microsoft SQL...
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...
Alexa – Skills Development, Data, and Continuous Improvement
"Alexa, make Song Quiz smarter and more fun." That command may not work (yet), but this session can...
Alexa, Talk to Me
Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa. In this...
An (Advanced) Introduction to Dax
Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be...
Analysis Services for the Absolute Beginner
Publications across the globe have called “data the new oil.” However, the value of oil is what...
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator...
Back(up) to Basics
Most DBAs know how to use Management Studio to backup and restore a database. That may work some of...
Beginning Automation with Powershell
This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA...
Build Your Extract Packages Automatically!
Automating extract packages is trivial., you simply use INFORMATION_SCHEMA. The problem is not all...
Cloudy with a Chance of Data
This course is intended as an Introductory look at the Cloud and Azure Data Services. We begin our...
Crash Course on Better SQL Development
SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel...
Crash Course on Indexes for SQL Developer
For SQL Developers performance is necessary, but without correct use of indexes queries just unable...
Data Cleansing With SQL And R
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and...
Data Modeling for the Modern Data Warehouse
A theoretical discussion on two methods that professional data modelers use to model data (ERD and...
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...
Deep Dive into Clustered -vs- Non Clustered Indexes: Which One To Choose?
Enjoy the interactive nature of this session by starting out with an intermediate level Quiz to...
Developing ASP.NET Core 2.0 Web APIs for your Web and Mobile Apps
ASP.NET Core 2.0 is a cross-platform web framework that can be deployed to Windows, macOS, Linux or...
DevOps DBA: Using PowerShell SMO Objects
What are SMO Objects?? Why do I need to know PowerShell? I can create automation with SQL, TSQL,...
DevOps for the DBA
DevOps came out of the Agile movement and the idea that operations needed to be part of the...
Disaster recovery is everyone's job!
Targeted at the non-DBA such as BI/DW folks, Application Developers, Managers, and System Admins,...
Drinking From the Firehose: a Guide to Keeping Up with Technology
Keeping up with technology can feel like a treadmill; you keep running but never get anywhere....
Emergency! Are You Ready for Disaster to Strike?
Most of the time pilots are learning to fly, they're actually learning how to recover from...
Enabling Familiar, Powerful Business Intelligence
This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use,...
Essential Linux for the SQL Server DBA
Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for...
Execution Plans 101
Do you have a query that you want to tune, but don't know where to start? Execution plans can be a...
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...
How to get Microsoft Certified
Microsoft has recently streamlined the certification process and this session focuses on what you...
How to Keep Your Database Servers Out of the News
Every few months the headlines are filled with news of yet another system outage inconveniencing...
Sessions Found: 85
Back to Top