Start Time (24h) | Speaker | Track | Title |
---|---|---|---|
08:30:00 | Drew Furgiuele | Enterprise Database Administration Deployment | SQL Server Transactional Replication: A Deep Dive |
08:30:00 | Paco Gonzalez | Advanced Analysis Techniques | Enterprise Machine Learning with R and SQL Server |
08:30:00 | Doug McClurg | BI Platform Architecture, Development Administration | Tracking Change is the Backbone of Your Data Platform |
08:30:00 | Jana Sattainathan | Application Database Development | Practical PowerShell for the SQL Developers and DBA's - 0 to 60 in 60 mins |
08:30:00 | Pritesh Ostwal | Analytics and Visualization | Embedding Power BI In Your Web Application |
09:45:00 | Jamie Wick | Enterprise Database Administration Deployment | SQL Backups: Choosing the right solution for your environment |
09:45:00 | Slava Murygin | Enterprise Database Administration Deployment | SQL Server on Linux for SQL DBA. |
09:45:00 | Michael Wharton | Enterprise Database Administration Deployment | Best practices for managing SharePoint SQL Server Databases |
09:45:00 | John Martin | Application Database Development | Making Row Level Security and Dynamic Data Masking work for you! |
09:45:00 | Jamie Dixon | Advanced Analysis Techniques | A Gentle Introduction To Machine Learning |
11:00:00 | Jonathan Stewart | Analytics and Visualization | Data Visualization: How to truly tell a great story! |
11:00:00 | Todd Chittenden | BI Platform Architecture, Development Administration | Row Level Security in Power BI |
11:00:00 | Derik Hammer | Enterprise Database Administration Deployment | Architecting Availability Groups |
11:00:00 | George Walkey | Enterprise Database Administration Deployment | Using Powershell to Document SQL Server |
11:00:00 | Thomas Norman | Application Database Development | Database Project Makes Deployment Consistent |
11:00:00 | Chris Voss | Professional Development | From Analyst BI Day to Developer BI Night |
13:15:00 | Azhagappan Arunachalam | Cloud Application Development Deployment | Understanding U-SQL |
13:15:00 | Andrew Kelly | Enterprise Database Administration Deployment | Query Store – What is it all about? |
13:15:00 | Melissa Coates | BI Platform Architecture, Development Administration | Designing a Modern DW + Data Lake |
13:15:00 | Brian Carrig | Enterprise Database Administration Deployment | Running SQL Server in AWS |
13:15:00 | Dan Zaratsian | Analytics and Visualization | SQL on Hadoop, using Hive Spark, to analyze sports data |
13:15:00 | Jared Poché | Enterprise Database Administration Deployment | Using DMVs for Performance Root Cause |
14:30:00 | Solomon Rutzky | Application Database Development | Module Signing or: How I Learned to Stop Using EXECUTE AS and Love Certificates |
14:30:00 | Shannon Lowder | BI Platform Architecture, Development Administration | Interrogating your data sources with Biml |
14:30:00 | Mark Hudson | Advanced Analysis Techniques | Deeper Into Azure Machine Learning |
14:30:00 | Tracy Boggiano | Enterprise Database Administration Deployment | Monitoring Availability Groups |
14:30:00 | Patrick Keisler | Enterprise Database Administration Deployment | SQL Audit - Evidence Never Lies |
15:45:00 | Doug Purnell | Enterprise Database Administration Deployment | Moving from Change Tracking/Change Data Capture to Temporal Tables |
15:45:00 | Maxwell Myrick | Strategy and Architecture | The Art and Science of Designing a Mission Critical SQL Server |
15:45:00 | Thomas Chan | Enterprise Database Administration Deployment | Finding more space for your tight environment. |
15:45:00 | Carlos L Chacon | Enterprise Database Administration Deployment | The ABC's of Database Baselines |
15:45:00 | Mark Gordon | Enterprise Database Administration Deployment | SQL Server Basic Backups For Beginners |
Event Date: 11-03-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 08:30:00 - Track: Advanced Analysis Techniques
Event Date: 11-03-2017 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 11-03-2017 - Session time: 08:30:00 - Track: Application Database Development
Event Date: 11-03-2017 - Session time: 08:30:00 - Track: Analytics and Visualization
Event Date: 11-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.
Event Date: 11-03-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 09:45:00 - Track: Application Database Development
These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.
In this session we will look at how you can get the most out of these features and retain the performance of your system.
Event Date: 11-03-2017 - Session time: 09:45:00 - Track: Advanced Analysis Techniques
Some familiarity of computing programming, statistics, and manipulating tabular data will help you get the most out of this session.
Event Date: 11-03-2017 - Session time: 11:00:00 - Track: Analytics and Visualization
Event Date: 11-03-2017 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 11-03-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 11-03-2017 - Session time: 11:00:00 - Track: Professional Development
This session will provide you with some high-level essential resources, from additional T-SQL query operators to SQL Server Data Tools and data modeling knowledge to warehousing basics, to help you navigate this uncharted territory...coming from a speaker who has been in the same position. You will come out of the session eager to use these resources to moonlight as or transition to a developer in the SQL Server space, ideally blending this developing skill set with your analyst skill set to create a well-rounded data professional!
Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Cloud Application Development Deployment
Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Analytics and Visualization
Event Date: 11-03-2017 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Application Database Development
Module Signing is more flexible and more secure, but requires a Certificate or Asymmetric Key. Those can be confusing to work with, and the security mechanism isn't intuitive.
Come learn how to have more secure, granular control over permissions that covers cross-DB tasks and Dynamic SQL. See what signing can do, understand how certificates work, and rejoice.
Event Date: 11-03-2017 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration
Now, you're looking at data sources other than SQL Server. How do you automate package development for these flat files, Excel Files, and other databases? In this session, I'll share some of the techniques I've used to deal with these second-class sources. I'll be walking you through C# code. Don't worry, I'm not a real programmer, so the code isn't the most complex, but it does solve the need.
Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Strategy and Architecture
This session will show you the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement each design. Along the way, you’ll hear some best practices, tips, and real world advice for choosing between features like Availability Groups and clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. You will also get a glimpse of how some of the largest mission critical systems running on the Microsoft platform are created using a distributed model where redundancy replaces failover. While you may not be able to revisit your current designs right away, what you learn will improve how you approach designing systems.
Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
I am going use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles. And in the final I will defragment the indexes and update the statistics, since shrink datafile is not fragmentation aware task.
Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 11-03-2017 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment