to search by track, speaker, or session category.
Sessions Found: 107
Accelerating Development and Testing Using Data Virtualization
Constraining everything in development and testing is database size. Storage is a bottleneck, and...
Administering and Deploying Power BI Solutions
To create a successful data culture Business needs the freedom to explore and analyze data. At the...
Administering your Azure SQL Database
Administration tasks for a PaaS service like Azure SQL Database are different than for a regular...
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...
Azure Analysis Services: Purpose, Migration, Benefits, and Tools
This presentation will briefly go over the history of OLAP and Microsoft's contribution to the...
Azure Data Factory V2: The cloud SSIS we have been waiting for?
Azure Data Factory V2 is currently in preview and has a lot of great new SSIS-like features but is...
Azure SQL Database Performance Tuning
When using Azure SQL Database, you're paying for performance. In this session, you'll learn what...
Back(up) to Basics
Most DBAs know how to use Management Studio to backup and restore a database. That may work some of...
Building a Microsoft Business intelligence Solution step-by-step
Overview of the Microsoft BI Technologies BI Solution Topology BI solution requirements Data...
Building the HASSP: Putting SQL Server In Space
In today's world, technology is a pervasive part of our lives. We have "smart" appliances...
Busy is a Four-Letter Word
If I ask you, "How are you?", is your default answer, "I'm so busy!"? Why do we measure our worth...
Cloudy with a Chance of Data
This course is intended as an Introductory look at the Cloud and Azure Data Services. We begin our...
Columnstore 101: The Five Ws of Columnstore Indexes
While Columnstore Indexes were introduced with SQL Server 2012, their popularity and general use...
COZYROC: Dynamic Data Flows in SSIS without Programming
This session is an introduction to the unique functionality offered by COZYROC to create...
Custom Activities in Azure Data Factory
There are a lot of impressive out of the box capabilities with Azure Data Factory. Also, just like...
Data Cleansing With SQL And R
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and...
Data Security for the Cloud
Have you moved your application to the cloud? Are you thinking about it? Great! Now… how are you...
Data Testing & Integrity – BI Edition
Unit Testing and Test-Driven Development are common practices in application development. In SQL...
Data Vault 2.0 An Introduction To A Better Data Warehouse Database Designing Method
As Dan Linstedt, the creator of Data Vault 2.0, describes it as follows: The Data Vault Model is a...
DEA (not what you think) Will Be Your New Best Friend!
Database Experimentation Assistant (DEA) is Microsoft's new tool to help you collect, replay, and...
Decoding the Cardinality Estimator to Speed Up Queries
The cardinality estimator in SQL Server is a massively complex piece of software that is...
Demystifying Data Compression
SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce...
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...
Take your T-SQL skills to the next level. Regardless of your current level there will be something...
Disaster Recovery Planning for Your Career and Your Life
As DBAs, disaster recovery planning is one of the first things we learn. We plan it, practice it...
Dynamic SQL: Tables, Pivots, Parameters & More
Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you...
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...
Enter the Tidyverse: R for the Data Professional
In this day-long training, you will learn about R, the premiere language for data analysis. We...
Ethics, Morals, and Laws for the DBA 101
Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern...
Sessions Found: 107
Back to Top