SQLSaturday #770 - Pittsburgh 2018 > Sessions

Advanced Analysis Techniques

Analytics and Visualization

Application & Database Development

BI Information Delivery

BI Platform Architecture, Development & Administration

Cloud Application Development & Deployment

Enterprise Database Administration & Deployment

Professional Development

Strategy and Architecture

Other

Schedule is subject to change.

Saturday, Sep 29, 2018 Conference Schedule

Room	Gallery	602	603	605	604C	612	613	501 (Wanna Be A DBA?)
08:15 AM - 08:45 AM	Registration
08:40 AM - 09:00 AM	Opening Remarks in Gallery
09:00 AM - 10:00 AM	Introduction to Azure Machine learning Ravi Kumar Level: Beginner	Cloudy with a Chance of Data Rick Heiges Level: Beginner CloudyChanceDataSQLSatPIT.pdf	SQL Server Databaseology: A Deep Dive Into Database Internals John Morehouse Level: Intermediate SQL_Server_Databaseology.zip	Power BI Internals: a Deep Dive Eugene Meidinger Level: Intermediate		SQL Server with Docker Containers Marsha Pierce Level: Beginner	Take the changes under control Alex Grinberg Level: Intermediate Samples.zip	Branding Yourself for a Dream Job Steve Jones Level: Beginner BrandingDreamJob.ppt
10:00 AM - 10:15 AM	Break
10:15 AM - 11:15 AM	Intro to Query Store Tracy Boggiano Level: Beginner Presentation.txt	Azure IoT, Windows 10 Core & Raspberry PI (DIY) Jens Vestergaard Level: Beginner Azure_IoT_-_RPI_-_Windows_Core_10_-_Pittsburgh.pdf	Power BI with Maps: Choose Your Destination Rayis Imayev Level: Beginner Power_BI_with_Maps_Pittsburgh.pbix	Deep Dive: RedGate's SQL Change Automation tool for database delivery Steve Grier Level: Intermediate SQL_Change_Automation.zip		“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance Jeff Moden Level: Advanced Black_Arts_Index_Maintenance_#1_and_#2.zip	Automate the Pain Away with Adaptive Query Processing and Automatic Tuning John Sterrett Level: Intermediate Automate_The_Pain_Away_-_SQLSatPittsburgh_-_Sept_2018.pdf SQLSatPgh2018.zip	I'm It - Survival Techniques for the Lone DBA Monica Rathbun Level: Beginner I'm_It_-_Survival_Techniques_for_the_Lone.pdf
11:15 AM - 11:30 AM	Break
11:30 AM - 12:30 PM		Build a White/Blacklist Bouncer. Who Gets into Your SQL Club? Chris Bell Level: Intermediate	Temporal Tables – The New Hotness in Data Auditing John Morehouse Level: Beginner Temporal_Tables.zip	Cleaning Is Half The Battle: Launching A Data Science Project Kevin Feasel Level: Beginner CleaningHalfTheBattle.txt		“Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks. Jeff Moden Level: Advanced Black_Arts_Index_Maintenance_#1_and_#2.zip	T-SQL Tips & Tricks to Make Your Life Easier! Andy Yun Level: Beginner	I Want To Go Faster! A Beginner's Guide To Indexing Bert Wagner Level: Beginner Indexing_For_Beginners.pdf
12:30 PM - 01:30 PM	Lunch Break
01:30 PM - 02:30 PM	HiHo! HiHo! SQL Server on Linux, We Go! Janis Griffin Level: Beginner SS_HiHo_HiHo_SQL_Server_on_Linux_We_Go.pptx	Always Encrypted for Beginners Monica Rathbun Level: Beginner Always_Encrypted_Demo.ssmssln Always_Encrypted.pdf	Relationship Goals: The SQL Server Graph Database Jonathan Stewart Level: Beginner	Adopting A DevOps Process for Your Database Steve Jones Level: Beginner Bringing_DevOps_to_the_Database.pptx	SQL Server Transactional Replication: A Deeper Dive Drew Furgiuele Level: Beginner SQL_Server_Replication_-_A_Deeper_Dive_Revised.pptx	XML and JSON, does the DBA need it? Alex Grinberg Level: Intermediate XML_JSON_SampleCode.zip	Mom Rules for Managing Enterprise Database Environments Marsha Pierce Level: Intermediate	DBA - What's Most Important Ed Wagner Level: Beginner Whats_Important_Ed_Wagner.zip
02:30 PM - 02:40 PM	Break
02:40 PM - 03:40 PM	Much Ado About Hadoop Kevin Feasel Level: Beginner Hadoop.txt	Introduction to Spatial Data with the help of SQL Server 2016/17 Hasan Savran Level: Beginner SqlSatPittsburgh.zip	Power BI Basics - On Coke Jens Vestergaard Level: Beginner Power_BI_-_Basics.pdf	Data Profiling or Statistics 201 Slava Murygin Level: Intermediate Data_Profiling_Statistics_201.zip	I have to support what!? SQL, Oracle, and Mongo - A side by side “how to” Kimberly StJacques, Michael Grayson Level: Beginner I_have_to_Support_What.pptx	Emergency! Are You Ready for Disaster to Strike? Allen White Level: Intermediate Emergency_-_Are_You_Ready_for_Disaster_to_Strike.zip	High Performance SSRS: Techniques for Faster Reporting Bert Wagner Level: Beginner High_Performance_SSRS.pdf SQL_and_SSRS_Demos.zip	The Vocabulary of Performance Tuning John Deardurff Level: Beginner JD_Vocab_PerfTune2018.pptx
03:40 PM - 03:50 PM	Break
03:50 PM - 04:50 PM		Successfully Running SQL Server in AWS Brian Carrig Level: Beginner	"Schadenfreude" - Let's enjoy the mistakes other people made... Thomas Grohser Level: Beginner	14 T-SQL Functions You May Not Know Sam Nasr Level: Intermediate 14TSQLFunctions.ppsx 14TSQLFunctionsDemo.sql		Troubleshooting and Tuning Query Performance Allen White Level: Beginner Troubleshooting_and_Tuning_Query_Performance.zip	5 Minute No Sweat SQL Security Audits Chris Bell Level: Beginner	Tips on Managing Lots of SQL Servers Tracy Boggiano Level: Beginner Presentation.txt
04:50 PM - 05:00 PM	Raffle Prize Drawings in Gallery (must be present to win)

Export To PDF