to search by track, speaker, or session category.
Sessions Found: 128
"Full Text indexing!" or..."What is that service I never turn on?"
If you've ever wondered what that other service is in your configuration manager then this is the...
"Real World" examples on loading a data warehouse using SSIS
In this demo-heavy session we will discuss the value of a SSIS Framework, explore forward...
#GetModern With Dell EMC
Consistent and predictable performance is critical for any successful deployment of Microsoft SQL...
3 Lessons Learned in Successful Consulting
I would like to share the 3 lessons I learned that helped me become a much better consultant. These...
A Beginner's Guide To Plan Guides
Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and...
A Rocket Scientist Perspective on Indexes
Indexes can be a boon or detriment for database performance. This presentation will present what...
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...
AlwaysOn on 2012/2014/2016/2017 Notes from the field and Best Practice
CIOs and VPs everywhere are asking me, how do we achieve HA with SQL Server? Having architected and...
Are There Time Bombs in your SSIS Packages?
Could your seemingly-normal SSIS package be hiding a disaster, waiting to detonate at the most...
Automating Azure Analysis Services
The elasticity of the cloud lets you provide a better user experience instead of breaking the bank...
AWS Aurora from a SQL Server DBA's perspective
AWS Aurora sounds perfect - a magical in-the-cloud relational database where everything Just Works....
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 and Azure Data Warehouse 101
Need more SQL but you have run out of hardware on premises? How about SQL in the cloud? In this...
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...
Becoming the MVP: 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 Programming with Powershell
Have you ever wanted to learn how to code, but you don’t think you have enough knowledge to jump...
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming...
Being a Woman in the Tech Industry
Mat Velloso posted, “But I do feel someone should write an article about what they have to cope...
Change Detection in SQL Server
Change detection is a critical component of any system that moves data from one structure to...
Choosing the Right Microsoft Data Science Platform
So you've done traditional BI for some time, but now you and your company know it's time to dig...
Climbing the SQL Server Index B-Tree (from a user perspective)
This session dives down and looks at the important items on data pages of clustered, non-clustered,...
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
Have you ever had a manager standing over your shoulder, wanting to know why a server is running...
Consumption Based Architecture and MSBI
As the tools available for BI and data warehousing continue to improve, it should change the way we...
Controlling Competing Workloads with SQL Server Resource Governor
With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor...
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...
Cross Platform Database Monitoring Solutions with Quest
Join Quest for an interactive discussion where we’ll explore the benefits of our cross platform...
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: 128
Back to Top