to search by track, speaker, or session category.
Sessions Found: 66
A dive into Dimensional Modeling
A dive into the basics and some advanced dimensional modeling concepts and design patterns. Topics...
A Perfect Ten: The Data Model
Do you know what makes a great data model? What does it mean to be Third Normal Form or a Star...
Assessing and Planning SQL Database Migrations to Azure
Today's enterprise is evolving at a rapid pace by taking advantage of what cloud services can...
Automate tests in your database with tSQLt
tSQLt is an easy-to-use database unit testing framework for Microsoft SQL Server. It is ideal for...
Azure Data Lakes and Data Warehouses:
This session will break down the options you have in Azure to build a data analytics ecosystem, and...
Azure SQL Database Edge - Tiny but mighty
Have you ever thought what would it be like to run SQL Server engine in a small footprint? Well,...
Basic Windowing Functions
Windowing functions are when you add a "window" to which rows a function will look at using the...
Beginning Admin: The Care and Feeding of SQL Server
Design and development may be exciting, but database administration is absolutely critical (and,...
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming...
Big Data, Big Dupe: A little session about a big bunch of nonsense.
If data is the new oil, then Big Data is the new snake oil. For over a decade, Big Data has...
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...
Columnstore Indexes for Everyone
Columnstore indexes are available to all SQL Server editions, Express to Enterprise, starting with...
Confidence – The Best Super-Power
Have you thought about wanting to do something and thought you may not be successful at it, so it...
CosmosDB - Understanding the main factors for successfull deployment
Let's face it: Microsoft Data Platform is not just SQL Server anymore. Azure has added a dozen of...
CozyRoc: Dynamic Data Flows in SSIS Without Programming
This session is an introduction to the unique functionality offered by COZYROC to create...
Data Modeling Trends for 2019 And Beyond1
It is so difficult to model data today. The number of products the average company uses to store...
Dive into the Query Optimizer - Undocumented Insight
This 500 level session will focus on using undocumented statements and trace flags to get insight...
Easily Interact with Data
Sometimes you need a temporary, quick, and easy way for you or others to add simple data to a...
ETL, Introduction to SSIS, and third-party tools like MelissaData and CozyRoc
We will discuss ETL software, have an intro to SSIS basics, create a basic package, and implement...
From the Trenches - Case Study of a Data Warehouse Migration & Upgrade
There's an old adage about rebuilding the airplane while you're flying it. That sounds a bit like...
Getting started with Azure Database for PostgreSQL
Azure Database for PostgreSQL is a relational database service based on the open-source Postgres...
Getting Started with Azure Databricks Delta
Databricks Delta is a single data management tool that combines the scale of a data lake, the...
How to Be an MVP (in Life and a Microsoft MVP)
Many times we look at the success of others and think it is beyond us. In this session, 12 time...
How to build a T-SQL Framework
What is a T-SQL framework and how will it help you as a developer. In this session we will create...
How to Get SQL Server to Run Better on Crappy Hardware.
Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance...
I'm It - Survival Techniques for the Lone DBA
Are you the only database person at your company? Are you both the DBA and the developer? Being the...
Introduction to Linux for SQL Server Professionals
SQL Server is now available on Linux but you only know Windows, now what? During this session we'll...
Know What Your Code is Doing to SQL Server!
ORMs - oh how I LOVE them! As a consultant, when I see them in play at a client I go...
Launch into Development with CosmosDB
Azure Cosmos DB is Microsoft's globally distributed, multi-model database service. With a click of...
Sessions Found: 66
Back to Top