to search by track, speaker, or session category.
Sessions Found: 70
42 TSQL Functions
SQL Server has many build in T-SQL functions. This session will introduce you to a selection of 42...
A Beginner's Guide to Seven Practices that Kill Performance
Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you...
Advanced Plan Explorer Usage for Tuning Execution Plans
In 2010, SentryOne gave the community a completely free execution plan analysis tool: Plan...
An (Advanced) Introduction to DAX
Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be...
Automated machine learning with Azure AutoML
AutomatedML is the process of automating the time consuming, iterative tasks of machine learning...
Azure SQL Managed Instance - Experiencies from the Field
In this pre-conference you will learn the best practices, tips and tricks on how to successfully...
Jose Manuel Jurado Diaz
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming...
Beyond the Basic SELECT
The SELECT statement is one of the most used tools in our SQL toolbelt. While it’s the basis for...
Business cards: the most important networking tool
Business cards -- those innocuous little items -- may be the single most important networking tool...
Disaster Documents: The role of documentation in disaster recovery
I was an employee of a company that had an office in the World Trade Center on Sept. 11, 2001. ...
Drinking From the Firehose: a Guide to Keeping Up with Technology
Keeping up with technology can feel like a treadmill; you keep running but never get anywhere....
Emergency! Are You Ready for Disaster to Strike?
Just like pilots who are prepared for disaster recovery through regular practice, we as database...
Extended Events - How to collect the first 10 or every 4th event
Extended Events offers a rich filtering mechanism, called predicates. Have you ever thought of...
Fencing Your Azure SQL Database
The cloud is just using someone else's computer. You still need to keep your resources safe, which...
Find (So You can Fix) those Troublesome Queries
Every expert has their own set of tools they use to find and fix the problem areas of queries, but...
How I Cut My Maintenance Window by 80%
As DBAs we oversee the safety and security of our databases. Integrity, Backup and ability to...
How Intelligent Query Processing improves T-SQL performance
Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party...
I lost my job! Now what?!? A survival guide for the unemployed
You've just been told by HR that you are no longer a part of their organization. You've been...
Inside of Indexes
We will go through Clustered and Non Clustered index internals. How Indexes are allocated and how...
Inside the UPDATE
When we think of modifying our data, we tend to think of updating only one table at a time. But the...
Intelligent Query Processing Enhancement in SQL Server 2019
Application developers and DBAs want to gain performance for queries without making application...
Intro to Query Store
In this session, we will look at the new Query Store feature in SQL Server 2016, 2017, and 2019. ...
Introduction to Azure Database for PostgreSQL
Azure Database for PostgreSQL is a relational database service in Azure based on the community...
Introduction to DAX in Power BI
PowerPivotPro's Foundations curriculum is a crash course that has been crafted and refined over 10+...
Introduction to Financial Data Analysis using Azure Machine Learning
Financial sector is highly depending on data analysis, data cleaning and different machine learning...
Introduction to M (a.k.a Power Query)
When it comes to getting your data into Excel or Power BI, M is your best choice. The M Language...
Introduction to Sentiment Analysis with SQL Server
Data > Opinion Sentiment Analysis helps you understand what customers are feeling. Being able to...
Introduction to SQL Server 2019 Enhanced PolyBase
Do you have ETL processes pulling data from multiple data sources into a data warehouse so you can...
Let's Dive Into SQL Server I/O To Improve T-SQL Performance
Do you understand how SQL Server handles I/O? If not, you should. Understanding I/O is more...
Lightning Talks - AM
Three fast-paced 15-minutes-or-less talks, followed by a chance to have some Q&A with our...
Sessions Found: 70
Back to Top