to search by track, speaker, or session category.
Sessions Found: 83
“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance
This isn’t your typical presentation on Index Maintenance. In this 1st of two back-to-back...
“Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.
This isn’t your typical presentation on Index Maintenance. In this 2nd of two back-to-back...
“Black Arts” Index Maintenance #3: Defragmented by Default
This is NOT your typical session on indexes. When Microsoft introduced the MAX and XML (LOB)...
14 T-SQL Functions You May Not Know
Newer releases of SQL Server have introduced many new functions developers may not know or use....
20 tips on Remote Presentations
Presenting is hard, but presenting remotely is even harder. Come to this session and learn 20 tips...
An (Advanced) Introduction to DAX
Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be...
An Introduction to Azure Data Studio
This session will provide a high level overview of Azure Data Studio and highlight some of the...
Avoiding angry calls: Power BI model optimization
It's easy to get started with Power BI, but it's also easy to end up with an out-of-control data...
Azure Analysis Service or SSAS Tabular: How they work
When deploying Analysis Services Tabular, where to deploy: Azure Analysis Services or SSAS Tabular...
Azure Data Factory for Beginners
You know there is ETL in Azure called Azure Data Factory (ADF), but you don't know what it does and...
Azure Databricks: A Beginner's Journey
Have you heard about Azure Databricks but are not sure about how to or even if you should...
Azure SQL DB Managed Instance: Today
It has been about a year since Azure SQL DB Managed Instance has been released. What is it? Where...
Basic Windowing Functions
Windowing functions are when you add a "window" to which rows a function will look at using the...
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...
Columnstore Indexes for Everyone
Columnstore indexes are available to all SQL Server editions, Express to Enterprise, starting with...
Connection to SQL Server. Problems. Troubleshooting. Solutions.
It is very frustrating when users complain about inability to connect to SQL Server while SQL...
Continuous integration and delivery (CI/CD) in Azure Data Factory
With Azure Data Factory (ADF) continuous integration, you help your team to collaborate and develop...
CozyRoc: Dynamic Data Flows in SSIS Without Programming
This session is an introduction to the unique functionality offered by COZYROC to create...
Cross Tabs & Pivots - Reporting on Steroids
This session covers and compares the PIVOT operator to an ancient but very high performance...
Data Collection and Usage: Illegal or Unethical?
Data collection and usage is all around us, it is what we do. But is what we do with the data...
Data Time Travel with SQL Server Temporal Tables
Many times developers have to support users by answering the “What happened to the data?” The task...
DBA - What's Most Important
There are so many topics for a DBA to focus on that it can be overwhelming, especially for a new or...
Demystifying Data Compression
SQL Server 2016 SP1 makes data compression available in all editions. Data compression can reduce...
Dimension Management for Power BI
No matter the complexity of your BI application, dimension management can provide your...
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....
Easily Interact with Data
Sometimes you need a temporary, quick, and easy way for you or others to add simple data to a...
Emergency! Are You Ready for Disaster to Strike?
Just like pilots who are prepared for disaster recovery through regular practice, we as database...
Encrypting Data within SQL Server
Data breaches abound! Do you want to keep your company out of the headlines? What are some of the...
Ethics, Morals, and Laws for the DBA 101
Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern...
Everything You Need to Know About Indexes!
The attendee will learn all about the various index structures, how or when to use them and why....
Sessions Found: 83
Back to Top