to search by track, speaker, or session category.
Sessions Found: 108
"Real World" Examples on How to Load Data Warehouse Structures using SSIS
"Real World" Examples on How to Load Data Warehouse Structures using SSIS In this session we will...
#GetModern SQL Server infrastructure with Dell EMC
Get extreme performance and flexibility with modern day infrastructure from Dell EMC. This...
45 min to build your first SSRS report
Does this sound like you? You've been BI curious and now you've been given access to SSRS and you...
45 Minutes to Your First SSAS Tabular Model
Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or...
A DBA's guide to full stack performance troubleshooting
Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a...
A Rocket Scientist Perspective on Indexes
Performance! Performance! Performance! That’s what the rocket scientist and SQL Developer are...
A Window into Your Data: Using SQL Window Functions
Window functions and the OVER() clause are an underused feature in T-SQL. These functions can help...
Agile Data Warehouse and ETL Design with Biml
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse...
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator...
Automate the Pain Away with Query Store and Automatic Tuning
Join John Sterrett, Principal Consultant at Procure SQL LLC to learn how execution plans get...
Azure Data Factory V2 and SSIS Automation With Biml
SSIS was originally designed to work in a world where all data was structured and on premise. As...
Azure SQL Managed Instance the New Hotness
You can't wait to move your databases to an Azure PaaS offering so you don't have to patch and...
Become the Most Valuable Player: Soft Skills for the Hard Market
Whether you are just starting a career, advancing into senior leadership, or trying to woo a...
Beginning Admin: The Care and Feeding of SQL Server
Design and development may be exciting, but database administration is absolutely critical (and,...
Beginning Automation with Powershell
This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA...
Beginning Powershell for DBAs 1.0
The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an...
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming...
Change Detection in SQL Server
Change detection is a critical component of any system that moves data from one structure to...
Climbing the SQL Server Index B-Tree (from a user perspective)
SQL Server® has many performance WOMs (Word of Mouth), especially concerning indexes to...
Cloudy DBA, Amazon (AWS) and SQL Server
Cloud (AWS, Azure, Google or whatever else out there) is a reality now and for most of the...
Code Like a Pirate ... Intro to R and Data Science Tools in MS
R is the most popular statistics language used today. It is one of the most useful tools in the...
Code Like a Snake Charmer - Intro to Python!
Python is the one of the most popular programming languages used today and one of the most useful...
Collecting Performance Metrics
Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or...
Consistent Deployments / Team Development
Unless you are developing code by yourself, you face challenges of working with several team...
Consumption Based Architecture and MSBI
As the tools available for BI and data warehousing continue to improve, it should change the way we...
Cosmos DB for the Data Professional
So, you have heard the buzz and your development team wants to use Cosmos DB. But what does that...
CozyRoc: Dynamic Data Flows in SSIS Without Programming
This session is an introduction to the unique functionality offered by COZYROC to create...
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 the topic of graphical data modeling using enterprise modeling...
Data Security in Power BI
As more enterprises adopt Power BI into their BI environment, questions still remain about data...
Sessions Found: 108
Back to Top