Open Abstracts

Abstracts for the next round of voting.

SQL Server Developer Tricks

1 Comment
Target Audience: The session content targets SQL Developers but is equally meaningful for DBAs. Either way, two years of genuine experience is expected to get most out of the demos. Abstract: If you are programming with SQL Server, you ought to know how your query is being treated inside the engine. Join this session to…
Read More

Deploying SQL Server 2019 Big Data Clusters on VMware

2 Comments
Target Audience: SQL Server 2019 introduces Big Data Clusters, an exciting new feature set for managing big data environments. This session is recommended for anyone interested in learning about building and deploying this environment on-prem. Abstract: This session will walk through step-by-step deployment of a SQL Server Big Data Cluster (BDC) on VMware. During this…
Read More

How to Build a Blog Worth Reading

No Comments
Target Audience: Any technical folks who currently have a blog or want to start blogging Abstract: Creating a blog worth reading is no easy task. It’s a fine balance between consistency, topic choice, readability and SEO magic. Join marketing expert Blythe Morrow as we discuss how to build content for technical audiences that generates reads…
Read More

Query Store without SQL 2016 = Open Query Store

No Comments
Target Audience: DBAs and Devs that are stuck on SQL Server versions below SQL 2016 Abstract: When SQL Server 2016 was released, it offered a fantastic new feature with the Query Store. Long term, statistics based, query tuning became a reality. But what about the thousands of servers that aren’t upgrading to SQL 2016 or…
Read More

Working with Very Large Tables Like a Pro in SQL Server 2017

1 Comment
Target Audience: This session is intended for database administrators and database developers, who have a basic understanding of indexes, statistics and partitioning. Abstract: A common use case in many databases is a very large table, which serves as a fact table or an activity log, with an ever-increasing date/time column. This table is usually partitioned,…
Read More

Demystifying Dynamic SQL

Target Audience: This is for people who regularly write SQL code to solve varied problems, and who find themselves writing a lot of repetitive code, or frequently tweaking some code to fit new environments. You don’t need to know what dynamic SQL is to follow this talk. Abstract: Dynamic SQL is the name for SQL…
Read More

The SQL Server Performance Tasting Menu

No Comments
Target Audience: People who want to write smarter queries. Abstract: You’re a DBA or Developer, and you’ve been using SQL Server for a few years. You know there are different ways to make queries faster, but you’re not sure when to use them. I’m Erik Darling, and I’ll be your sommelier for the evening. Over…
Read More

Locks, Blocks, and Snapshots: Maximizing Database Concurrency

1 Comment
Target Audience: DBAs, developers, and anyone else curious about how isolation levels can affect the performance and accuracy of a query. Abstract: The ability for multiple processes to query and update a database concurrently has long-been a hallmark of database technology, but this feature can be implemented in many ways. This session will explore the…
Read More
Mohammad Darab

Big Data Clusters for the Absolute Beginner

2 Comments
Target Audience: Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today’s ever changing tech space and take your career to the next level. Whether you’re a junior or senior data professional, you will benefit from this session. Abstract: Join me, Mohammad…
Read More
Menu