to search by track, speaker, or session category.
Sessions Found: 57
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 Rocket Scientist Perspective on Indexes
Indexes can be a boon or detriment for database performance. This presentation will present what...
Analyzing I/O Subsystem Performance
SQL Server is often I/O bound - but why? Do you feel lost when talking to your storage...
Azure Data Services in 60 minutes
Are you confused about all the ways Azure can help you leverage data in your company? There are...
Azure Transient SQL Warehouse Resource
Cloud Migration Big data to Big Memory Quick review of using a Azure SQL Warehouse to preform a...
But it worked great in Dev! Perfomance for Devs
If you've ever found yourself stating the above, this session is for you. For many developers,...
Challenges and Opportunities in Creating Accessible Power BI Reports
Accessibility is catering for your whole audience, including those with disabilities. According to...
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,...
Consumption Based Architecture and MSBI
As the tools available for BI and data warehousing continue to improve, it should change the way we...
Data Driven Digital Transformation
Go beyond the buzzwords and let’s get real about how you can transform your company as a data...
Data Modeling for the Modern Data Warehouse
A theoretical discussion on two methods that professional data modelers use to model data (ERD and...
Data Security in Power BI
As more enterprises adopt Power BI into their BI environment, questions still remain about data...
Data Wrangling for Reporting & Analytics using Power BI
In today’s world reporting and analytics are no longer focused exclusively on internal data from...
DBA Impacting Trends
There may be resume generating events on the horizon. Find out what trends are happening in our...
Deep Learning Demystified
Deep learning is a key enabler of AI powered technologies being developed across the globe. This...
Designing a Data Warehouse on HDInsight, Relational DBs Need Not Apply
We all have built data warehouses using tried and true patterns from Inmon to Kimball. These...
Dr. DMV's Troubleshooting Toolkit
Dynamic Management Views and functions allow you to easily see exactly what is happening inside...
Dynamic SQL: Tables, Pivots, Parameters & More
Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you...
ETL Best Practices and Techniques
ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or...
Extending SQL Server Using R
Steve Williams from International Cruise and Excursions will demo using R with SQL Server using R. ...
HA in an about an Hour
This session will cover the basics for SQL server native tools to provide high availability to your...
High Availability/Disaster Recovery 101
How do you design a SQL Server 2017 infrastructure in order to meet specific Recovery Time...
How well do you REALLY know your SQL Server
Are you new to Database Administration? Did you find a SQL Server hiding on your network that no...
Implementing a Cloud Analytics Solution
The Azure cloud has matured to the point where a complete Business Intelligence solution can be...
Intro to tSQLt: Unit Testing for Databases
How do I test my Microsoft SQL database logic? How do I integrate it with my build? What's the...
Introduction to Azure SQL Database
What is this “Azure SQL Database” that I keep hearing about? In this session we will start from the...
Is it really HA when you upgrade from 2016 to 2017? I say yes.
Tasked with upgrading 4 TB worth of data to a new HA cluster, I wanted a faster way to do this. Yes...
JSON and the Astronauts
In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch...
Lockless in Seattle: Using In-Memory OLTP Transaction Processing
Locks and latches have long been the mechanism used to implement SQL Server concurrency control,...
Locks, Blocks, and Deadlocks, Oh My!
"I've got a locking problem", "I need to get rid of blocking," and "deadlocks are normal behavior"...
Sessions Found: 57
Back to Top