to search by track, speaker, or session category.
Sessions Found: 69
"Schadenfreude" - Let's enjoy the mistakes other people made...
This session will show a lot of things in the world of data that went very, very wrong... And yes...
“Go Faster!” And Other Things Yelled at the Backup Jobs
This session is an introduction to tuning backups. Learn how to take those backup jobs to disk and...
A 50,000 Foot Overview of Azure Data Services
Azure has so many services that its mind boggling. This presentation will give you a high level...
Adding 6 Billion Rows to a Columnstore Daily - What Can Go Wrong
There are many wrong ways how to add many rows of data to a column store, this session will help...
An Introduction to Azure/Jupyter Notebooks
A hot new data science technology is on the scene called Jupyter notebooks. This powerful, web...
An introduction to Data Mining with SQL Server 2016
With the vast amount of changes that occur in our daily business environments, it becomes more and...
An Introduction to Predictive Modeling with R
In this presentation we'll learn the basics of constructing a predictive model in the R programming...
Ask the Experts Panel
This is an open session where you may show up any time and ask any technical or professional...
Azure Data Factory V2 /ETL in the clouds
Azure Data Factory (ADF) has done some mileage since it's beginning in 2015. It has evolved and is...
Basic Database Programming
Abstract: You just found out that a client needs a SQL database to be designed from scratch. ...
BI Infrastructure in Azure: Points to Consider
Success of a good BI infrastructure is measured by two most important factors: a) Better access to...
Big data architectures and the data lake
With so many new technologies it can get confusing on the best approach to building a big data...
Choosing technologies for a big data solution in the cloud
Has your company been building data warehouses for years using SQL Server? And are you now tasked...
Common TSQL Mistakes
We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some...
Compare the Query Store to other T-SQL tuning methods
In this session I will compare the new SQL 2016 and Azure Query Store to the other methods for...
DAX and the tabular model
With the advent of the tabular model in SQL Server 2012, another analytical option has opened to...
Development & Test Data Management: Achieving breakthrough saving
An estimated 2,000 new applications are released daily yet, the demand for new applications is...
DevOps Database administration.
How outsource administrative tasks to your end user groups in a safe, secure, and repeatable...
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. ...
Documenting your SQL Server environment with PowerShell
Do you know what your SQL Server environment looks like? Using PowerShell along with dbatools and...
Effective Data Warehouse Storage Patterns
Abstract: Many companies start off with a simple data mart for reporting. As the company grows,...
Efficient and Effective coding of Stored Procedures
Data does not become information until decision makers are able to view it and make those decisions...
From (User) Story to Tables: Read Between the Lines to Find Your Data
If you work in an agile environment, design requirements often come to us as stories with the...
Full Text Indexing Basics
Abstract: Today’s large data fields (LDF) are full of unstructured information stored in varchar,...
How to build your career
In three years I went from a complete unknown to a popular blogger, speaker at PASS Summit, a SQL...
How to Get and Nail Your Job Interviews
Are you stuck in your existing job for years? Do you feel you need to get out, try either a new...
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...
Implementing Security Standard Regulations in SQL Server & Azure
PCI-DSS, SOX, ISO, GDPR... What are the Cyber Standard regulation and how do we implement them in...
Insight into the SQL Server Buffer Cache
When we talk about memory usage in SQL Server, we are often referring to the buffer cache. This is...
Installing and Getting Started with Python for Data Analysis and Machine Learning
You've heard about Python but don't know where to start. This session will show you how to install...
Sessions Found: 69
Back to Top