| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | Derik Hammer | Enterprise BI | Introduction to Azure SQL Data Warehouse |
| 08:30:00 | John Miner | Database Administration | Effective Data Warehouse Storage Patterns |
| 08:30:00 | Steve Simon | Self-Service BI | DAX and the tabular model |
| 08:30:00 | Greg Moore | Database Administration | Whoa! Backup, what happened? The Basics of Backups |
| 08:30:00 | Ray Kim | Professional/Personal Development | Networking: it isn't just for breakfast anymore |
| 08:30:00 | Stephen Mokszycki | QA/Automation | DevOps Database administration. |
| 10:00:00 | James Serra | Professional/Personal Development | Learning to present and becoming good at it |
| 10:00:00 | Derik Hammer | Cloud Application Development Deployment | Launching your database into Azure |
| 10:00:00 | Steve Simon | Enterprise BI | An introduction to Data Mining with SQL Server 2016 |
| 10:00:00 | Kevin Boles | Application Development | Common TSQL Mistakes |
| 10:00:00 | Taiob Ali | Database Administration | Performance Troubleshooting made easier - new features in Management Studio ! |
| 10:00:00 | Paresh Motiwala | Enterprise BI | BI Infrastructure in Azure: Points to Consider |
| 11:30:00 | Vijaya Kokkili | Professional/Personal Development | WIT Luncheon: Women Participation at Conferences/Workshops/Technical Market |
| 11:30:00 | Andrew Cary | Application Development | Development Test Data Management: Achieving breakthrough saving |
| 12:30:00 | James Serra | Big Data | Big data architectures and the data lake |
| 12:30:00 | Thomas Grohser | Optimization/Tuning | Shaving of Microseconds |
| 12:30:00 | Matthew Anderson | Database Administration | Documenting your SQL Server environment with PowerShell |
| 12:30:00 | Christian Cote | Big Data | Azure Data Factory V2 /ETL in the clouds |
| 12:30:00 | Kevin Boles | Lightning Talks | Lightning Talks |
| 14:00:00 | Bryan Cafferky | Machine Learning and AI | An Introduction to Predictive Modeling with R |
| 14:00:00 | Kevin Boles | Optimization/Tuning | SQL Server 2016 (SP1) 2017 ROCKS!! |
| 14:00:00 | Michelle Gutzait | Database Administration | Implementing Security Standard Regulations in SQL Server Azure |
| 14:00:00 | Deborah Melkin | Database Development | From (User) Story to Tables: Read Between the Lines to Find Your Data |
| 14:00:00 | Alex Grinberg | Database Administration | Take the changes under control |
| 14:00:00 | Edward Pollack | Database Development | Query Optimization Techniques |
| 15:30:00 | John Miner | Database Development | Full Text Indexing Basics |
| 15:30:00 | Greg Moore | Professional/Personal Development | So you want to Present: Tips and Tricks of the trade |
| 15:30:00 | Mike Hays | Database Administration | “Go Faster!” And Other Things Yelled at the Backup Jobs |
| 15:30:00 | Thomas Grohser | Professional/Personal Development | "Schadenfreude" - Let's enjoy the mistakes other people made... |
| 15:30:00 | Sunil Kadimdiwan | Enterprise BI | Power up SSRS 2017 with Power BI and other new enhancements |
| 15:30:00 | Bryan Cafferky | Panel | Ask the Experts Panel |
Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Enterprise BI
Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Database Administration
Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).
Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.
How do you reduce the size of your data mart and speed up data retrieval?
This presentation will review the following techniques to fix your woes.
Coverage:
1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?
Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Self-Service BI
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Database Administration
Many DBAs still setup their backups via a GUI and “fire and forget” and don’t think about backups and restores until too late. This session will show you while that works in many cases, for larger or more complex databases, or databases with specialized HA requirements, the out of the box solution may be far from optimal.
Event Date: 28-07-2018 - Session time: 08:30:00 - Track: Professional/Personal Development
In this interactive session, we will discuss networking -- what it is, why it's important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn't previously have!
Event Date: 28-07-2018 - Session time: 08:30:00 - Track: QA/Automation
There will be a demo!
Event Date: 28-07-2018 - Session time: 10:00:00 - Track: Professional/Personal Development
Event Date: 28-07-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment
Event Date: 28-07-2018 - Session time: 10:00:00 - Track: Enterprise BI
In this hands on BEGINNERS presentation we shall be looking at Microsoft SQL Server’s Data Mining capabilities and we shall be discussing:
Defining what questions we want answered and how to go about this in an effective and efficient manner.
Creating the data model.
How to gather the necessary data, discussing the training and testing aspect.
Processing the model.
Extracting information from our finished model, discussing the implications of this information.
Event Date: 28-07-2018 - Session time: 10:00:00 - Track: Application Development
Event Date: 28-07-2018 - Session time: 10:00:00 - Track: Database Administration
Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?
In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.
Event Date: 28-07-2018 - Session time: 10:00:00 - Track: Enterprise BI
a) Better access to data and b) Increased operational efficiency How can you set up your own BI infrastructure in the cloud to address these? What components do we consider? We can do that by proper selection of technology and vendors from Azure Market Place. How do we keep an eye on possible use of Big Data for your BI. We will also look at the best practices for doing so. We will take a fleeting look at some of the storage options for us in Azure and some Big Data concepts as well. We will learn about Copy Data Virtualization in Azure Market Place that can help you provision terabytes worth of information in matter of minutes. We will also learn about setting up teams and ways to train them(and yourself) in this fast evolving world of Azure.
Event Date: 28-07-2018 - Session time: 11:30:00 - Track: Professional/Personal Development
We’ve assembled a panel of presenters and women in tech to delve into the causes, solutions and provide tips for women or diversity of speakers at technical conferences.
This session will be presented by Capital Region Women in Technology: https://www.meetup.com/CD-WiT/
Event Date: 28-07-2018 - Session time: 11:30:00 - Track: Application Development
data automation to reduce application development cycle time, reduce costs and eliminate production impact.
Event Date: 28-07-2018 - Session time: 12:30:00 - Track: Big Data
Event Date: 28-07-2018 - Session time: 12:30:00 - Track: Optimization/Tuning
Event Date: 28-07-2018 - Session time: 12:30:00 - Track: Database Administration
Finding a free and simple method to gather information about my SQL Server environment was difficult. Using a combination of PowerShell, the dbatools module, and a PowerBI report I finally found something that works for me. I hope it can be helpful for you as well.
Event Date: 28-07-2018 - Session time: 12:30:00 - Track: Big Data
This session will also introduce concepts like the modern data warehouse and what are the new challenges that comes with data integration both on-premise and cloud based.
Event Date: 28-07-2018 - Session time: 12:30:00 - Track: Lightning Talks
Bryan Cafferky: Cool PowerShell Tricks and Tips Paresh Motiwala: LinkedIn for Professional Success! Kevin Boles: Trouble With Triggers Alex Grinberg: SQL Server: XML and JSON technologies Michelle Gutzait: Performance Tuning
Event Date: 28-07-2018 - Session time: 14:00:00 - Track: Machine Learning and AI
Event Date: 28-07-2018 - Session time: 14:00:00 - Track: Optimization/Tuning
Event Date: 28-07-2018 - Session time: 14:00:00 - Track: Database Administration
The focus will be on the new GDPR standard.
Event Date: 28-07-2018 - Session time: 14:00:00 - Track: Database Development
For example: As a DBA, I want to be able to break down user stories to understand how they translate into our current database design and usage and have an understanding as to how it will affect future needs.
That user story is also the goal for the session. This will present one approach to how we can think about these user stories to find the data that we need to design our databases for. We'll even work through an example together.
This is for DBAs who are involved in any part of designing databases, who want to practice how to come up with database designs, or who just another way to think about how they approach their database development in general.
Event Date: 28-07-2018 - Session time: 14:00:00 - Track: Database Administration
Event Date: 28-07-2018 - Session time: 14:00:00 - Track: Database Development
The problem won't always be a bad query, but when it is, knowing how to dive in, diagnose its performance, and resolve the situation efficiently will turn a potentially frustrating situation into a fun one! Using that knowledge in development to prevent future performance issues will improve script quality and application design, while making your future self less burdened by performance emergencies.
This is an opportunity to identify common query mistakes and learn a variety of ways in which we can solve them. This discussion will include query rewrites, indexing, statistics, database design, monitoring, execution plans, and more!
Demos of poor-performing queries will be provided to illustrate key optimization techniques, design considerations, and the tools you need to fix them. Fast.
Event Date: 28-07-2018 - Session time: 15:30:00 - Track: Database Development
Today’s large data fields (LDF) are full of unstructured information stored in varchar, text, varbinary or xml data types. How do you write an application to search the column for patterns? Traditional SQL techniques using a column INDEX and LIKE operator result in a query plan that contains a full table scan.
I will be introducing the brother’s grimm database that has the full text of each fairy tale. I will create a full text catalog / index, select a change tracking strategy, define optional stop list / thesaurus file, and then populate the index. I will use CONTAINS and FREETEXT operators in SELECT queries to leverage the FTI. This resulting query plan performs index seek.
Coverage:
1 – Creating a database from scratch. 2 – Creating a table with LOB field. 3 – Loading files via BULK INSERT. 4 – Performance via traditional techniques. 5 – Creating a full text index. 6 – Performance with the full text index. 7 - Using FTI in a Azure SQL database.
Event Date: 28-07-2018 - Session time: 15:30:00 - Track: Professional/Personal Development
This talk will guide you through the process of selecting a topic, preparing for it and actually giving it.
We'll talk about what can go wrong and how to handle that. We'll also talk about what can be done to prevent something from going wrong in the first place.
What are some good guidelines to follow and when can, or even should, you break them.
This will be partly interactive so come with questions and be prepared to be asked some.
Event Date: 28-07-2018 - Session time: 15:30:00 - Track: Database Administration
Event Date: 28-07-2018 - Session time: 15:30:00 - Track: Professional/Personal Development
And yes you are welcome to have a laugh at the misfortune of other people (or as the german speaking population would call it: Let's have some "Schadenfreude"! After a log day, come in and have some fun before the evening event starts
Event Date: 28-07-2018 - Session time: 15:30:00 - Track: Enterprise BI
In this session I will demonstrate how to develop and publish Power BI reports (.PBIX) in Power BI Report Server, including custom visuals.
Then show you how to work with Mobile Reports, KPIs and Paginated reports. The new Mobile Report publisher produces stunning dashboards that can be viewed on any device (iOS, Android and Windows). Other enhancements include, show/hide download menu, report comments, custom placement of parameters, custom branding your SSRS portal's with your choice of colors and logo.
Event Date: 28-07-2018 - Session time: 15:30:00 - Track: Panel
Ask the Experts is an opportunity to find answers and resources to address ongoing challenges, learn more about our speakers, and maybe stump them : )