Event Location:
USF Muma College of Business
12212 USF Maple Drive
Tampa, Florida
Abstract:
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. Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters. Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts
Speaker(s): Mohammad Darab,
Abstract:
Would you like to create Pivot Tables in SQL with ease? Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator. Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible
Speaker(s): Peter Doyle,
Abstract:
Whether you're a developer or a DBA, you likely use SSMS (SQL Server Management Studio) a lot. However, are you using all the features and extensions available to maximize your efficiency? This talk will show some of the most useful, yet overlooked, features of SSMS and some of the best (and free) extensions to make life easier for you and your teams. I'll also include some of my most useful code snippets that I've found or written over the years and a quick look at the new Azure Data Studio (previously SQL Operations Studio). Save yourself some time and headaches and optimize the way develop or administer your SQL!
Speaker(s): Nem Schlecht,
Abstract:
Because SQL Server is designed to efficiently operate with set-based queries it does not perform as well with loops and cursors. However there are situations where you really need some type of a loop. Tally tables give you the best of both worlds by allowing you to effectively "loop" through records in a set-based manner. We'll explore what tally tables are, how they work, and more importantly review some of the many ways you can use them to turn your loops and cursors into efficient set-based operations.
Speaker(s): Aaron Cutshall,
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO? Hint: You attend Revenge: The SQL! This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge! Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Speaker(s): Rob Volk,
Abstract:
Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team? SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you: - Document your database schema objects such as procedures, functions, tables, columns and indexes - Investigate performance and look for bottlenecks and tuning opportunities - Discover metadata to administer your databases backups, index maintenance, and security - Apply your own metadata using extended properties We will also cover the official Microsoft documentation on these features and other resources on how to use them.
Speaker(s): Rob Volk,
Abstract:
One of the benefits of the cloud is the ability to be able to create resources quickly and on-demand as you need them. However, without proper control and monitoring, this can quickly generate some not-so-pleasant surprises when your bill arrives. In this session, I want to show you how you can create governance around your Azure environment to avoid these surprises and start getting the most from your spend while still being able to maintain the flexibility that makes the cloud so valuable. We will discuss how you can allocate costs to specific areas and create more accountability in your organization using things such as tagging. We will also dive heavily into the Azure Cost Management + Billing portion of the portal and talk about analyzing spends and how you can create more visibility to your organization. We will also look at creating and using budgets, alerting around billing\spends, and how to review and interpret the cost saving recommendations that Azure provides.
Speaker(s): Dustin Dorsey,
Abstract:
PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.
Speaker(s): Kevin Feasel,
Abstract:
First impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is have a bad first impression. In this session, you will learn the difference between Azure SQL Database, Elastic Pools, Managed Instances, and Hyperscale. You will learn how to test migrations for compatibility issues before you start your migration process. You will learn how to secure your data and also make your data highly available. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload(s) and how to monitor your workload over time to make sure your users have a great experience while you save as much money as possible.
Speaker(s): John Sterrett,
Abstract:
One Data Model fit all cases is not possible- When the only tool you have is a hammer all the problems look like a nail. From Flat File to Big Data different models have been used each with their own advantage and limitations. Depending on the purpose our models change and change the skills and tools we use. From manual processing to the digital collection, storage, manipulation, and analysis of data our models have been changed and enriched in order to make sense of the information inside the data, convert it to knowledge and finally gain wisdom in our decisions. The presentation is an overview of the way we work today with data and how the new perspectives on Data are changing the data profession. In addition to the traditional and new models to work with data, the author introduces two models of his own to explain the “Digital Transformation Hierarchy” and “The Intelligence Life Cycle”.
Speaker(s): Frank Quintana,
Abstract:
Power BI uses themes to customize the look of Power BI reports. I hope most of you already know how to change colors and fonts in your BI reports. But if you are doing that for every data visualization on every page/tab, you are: 1) wasting a lot of time configuring these same properties multiple times, and 2) risking inconsistent styles (colors and fonts) because it is so easy to miss one or more of the format settings as you go from one data visualization on one page to another. But what if you could define your format settings one time and use them across all your pages, even in multiple BI files created by yourself and others in your organization creating a consistency or branding that would be difficult to achieve manually. This session explores how you can build and use themes to accomplish such a task. It consists mostly of demonstrations with an introduction into basic JSON which sounds scarily like coding but don't worry, I'll guide you through the rough waters.
Speaker(s): Michael Antonovich,
Abstract:
Has your organization accumulated a ton of reports that are crucial, yet fragmented and difficult to maintain? This session deals with the challenge of documenting those disconnected reports and replacing them with integrated dashboards. We will also discuss the trade offs of different data integration architecture options such as data lakes, dimensional models, real time solutions like data virtualization, and cloud based solutions. In this session, we will explore: - Different industry solutions to document your existing SSRS reports and SSAS cubes to identify all the columns used in source tables/objects. - Interrogating the database objects (views, stored procedures, etc.) to decipher the ETL mappings and transformations and present this in a human readable format of data lineage with business rules applied to the source system. - Grouping these reports into sets to be consolidated in a few dashboard - Different solutions to accommodate the desired data integration architecture
Speaker(s): Chad Buher,
Abstract:
Over a decade ago Microsoft added the capability to store and work with geometry and geography data types. (Wait...what's this you say?!?) Well, yes...it's been there for quite some time now. You can actually store spatial data in SQL tables (in the form of points, lines and polygons). There are also many powerful, built-in functions that allow the manipulation and calculation of results around this data. This is a powerful, but sadly underused feature of the product given that IoT tends to be so focused around the location of things. Come to this session to learn about: ● The two elusive data types (geography and geometry) ● T-SQL Spatial routines and functions ● How to load spatial data ● Where you can get lots and lots of free spatial data to supplement your existing systems ● See an example of real-world Spatial data in use (aggregating truck positions for tax calcs) ● Write a SQL query from a bitmap picture (pure amusement)
Speaker(s): Mindy Curnutt,
Abstract:
In this session, we will discuss various components available in SSIS to help load a data warehouse, including the data load of dimension and fact tables. We will discuss what to watch for when using the Slowly Changing Dimension (SCD) component, and how you may load into fact tables incrementally on large-scale implementations. As we progress, we will demonstrate some best practices that can be used to achieve the desired performance with great flexibility when loading a data warehouse.
Speaker(s): Daniel Cai,
Abstract:
Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i
Speaker(s): Deji Akomolafe,
Abstract:
Many people want to be a manager; however, most folks believe that their company will guide them or provide the opportunity for that next big step. That is not the case! You have to take your career into your own hands, take additional responsibilities, be more vocal, add more skills, and discuss your career desires with your supervisor and HR. You got the manager role, now what? The transition from a team member to a manager can be a rough road. Just because you’re the manager now, doesn’t mean people will listen to you. Understanding what it takes to become a Leader, not a manager, will be the difference between success and failure! This presentation will share some successful practices on how to successfully transition from Technician to a Leader.
Speaker(s): TBTLA Tampa Bay Technology Leadership Association,
Abstract:
Microsoft released SQL Server 2019 in November. The latest version contains several improvements and new features that improve reliability and performance. First, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process. This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced. ADR also prevents the transaction log from growing during a long-running transaction. Second, metadata for temporary tables can be stored in in-memory tables. For tempdb-heavy workloads, this removes a bottleneck and provides an improvement to performance. Finally, SQL Server 2019 supports the use of persistent-memory (PMEM) devices. PMEM can be used to persist the transaction log buffer, effectively removing LOGWRITE waits. Join me for this session to learn about these new features in SQL Server 2019 and how they can make your workload run faster.
Speaker(s): Frank Gill,
Abstract:
Are you looking for faster performance on your existing hardware? Do you have queries that run slowly and don’t seem to scale as the data set grows? Are you running SQL Server in the cloud where you don’t have control over the configuration of the environment? This session will show you how to find the low hanging fruit in your environment, explain why the problem exists, and step through how you can make the necessary changes to boost your SQL Server’s performance with a minimal amount of effort. This session focuses on schema and code design problems, to help you get the most bang for your buck when performance tuning SQL Server. By focusing on real-world examples with reproducible workloads, you will easily be able to see the impact of common mistakes and learn how to fix them quickly for improved performance. This session is the third session in the SQL Performance for Developers Learning Pathway. For more information please visit our Learning Pathways page.
Speaker(s): Jonathan Kehayias,
Abstract:
Most people don't like to speak in public and technical folks are certainly no exception. Yet, you've got some ideas for a great presentation but just don't know how to go about putting it all together. On top of that, how do you go about giving the presentation itself? This session will cover how to pull your material together in an organized fashion and present it such that your audience can follow along and get the message you want to relay. We'll also discuss how to deal with issues that cause presenters stress to help you to make the process enjoyable and rewarding for all.
Speaker(s): Aaron Cutshall,
Abstract:
In this session, I will be talking about performance turning, index design, statistics, query optimizer, parameter sniffing, data types, analyzing and understanding execution plans, wait stats, activity monitor, DMV(s). After this session you should be able to quickly identify the top performance issues of your databases.
Speaker(s): Jean Joseph,
Abstract:
Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more
Speaker(s): George Walkey,
Abstract:
Did you ever get woken up at night from a call from a user screaming about poor query performance, but didn’t really know how to begin attack the problem? In this session, we will explore the basics of execution plan analysis and how to single out issues that pertain to base table operations. In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
Speaker(s): Konstantin Melamud,
Abstract:
For most DBA's and most companies changes to the database are done during either a maintenance window that allows some downtime or during a full planned outage. Doing it that way makes a lot of sense, you don't have to work about blocking or deadlocks or the code being out of sync with the database. But what if your business needs to move faster, say deploying changes every week? It's possible, with some caveats and a small risk or two! This presentation will start an overview of "blue/green" deployments and why "database first" is a good plan. From there we'll look at how to deploy various types of changes and how to assess and mitigate the risk of each. It is possible, and the upside if that you'll work fewer nights and weekends making changes!
Speaker(s): Andy Warren,
Abstract:
How cool would it be, if it is possible to run a Machine Learning model in AzureML to classify or predict your business requirement and give access of it to your employees to run it every time using their most favorite tool... yes Microsoft Excel Also, would it excite you, if you were told, the entire time to build and deploy this ML App with AzureML and Microsoft Excel is a matter of hours, with no mobile app, no website, no servers... just set, ready to go. Join me in this exploratory session on building and deploying Machine Learning model for your business with AzureML with Microsoft Excel API.
Speaker(s): Srikrishna Krishnarao Srinivasan,
Abstract:
This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.
Speaker(s): Jeff Taylor,
Abstract:
PowerBI is Microsoft's self service reporting tool that give businesses a robust visualization of their data. As Microsoft's Power Platform has evolved, PowerApps is taking a similar approach by providing businesses with a self service application tier. In this session we will see the power of bringing the two together. Let's explore how the visualization tier of PowerBI can enhance the development and capabilities of PowerApps. We will go from a blank canvas app and import visualizations while pointing out some of the pros and cons of marrying the two together. We will use the capabilities of PowerApps to write and update our SQL Server tables. Bringing the two together can provide businesses with a robust solution under one umbrella. Join me in learning how these two services came together and said "I DO".
Speaker(s): Dan King,
Abstract:
Want to get more out of your SSIS development efforts? The SSIS Productivity Pack is a collection of premium SSIS components which enable an improved SSIS ETL development experience with greater potentials. These SSIS components for connectivity and productivity offer more features and bring new enhancements to SSIS to enable integration scenarios not once possible without custom scripting. In this session, we will introduce you to our collection of 150 advanced SSIS components. We will demonstrate some of our most popular offerings including our JSON XML components for integrating with REST APIs, Premium Derived Column with over 225 functions, and unique components such as Duplicate Detector and Diff Detector. In additional to performing advanced transformations you will also find codeless and feature-rich solutions for integrating with virtually any application or database system including leading enterprise applications such as Microsoft SharePoint, Dynamics 365 and more.
Speaker(s): Daniel Cai,
Abstract:
Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.
Speaker(s): Jose Chinchilla,
Abstract:
JSON support was one of the most requested features on the Microsoft Connect site. I will walk through a brief history of JSON in SQL Server with comparisons to XML, then break out some T-SQL demos. The demos will illustrate the fundamentals of working with JSON and some "gotchyas." The demos will also become more complex as the session progresses and attempt to illustrate realistic scenarios and creative uses for working with JSON.
Speaker(s): Alexander Fleming,
Abstract:
This session covers the top 10 things DBA's should know and configure for their database servers infrastructure.
Speaker(s): Jeff Taylor,
Abstract:
The Microsoft Power Platform has become an innovative bridge between data interaction, visualization, and analytics. The possibilities have become almost endless for businesses to engage with their data in amazing ways. In this session, we will dissect an application using Power Apps and location services to track latitude and longitude coordinates on Bing maps. Attendees will learn how to configure and demonstrate it on a mobile device. I will also show two approaches using AI within the application by using Azure SQL Database, Cognitive Services and Power Automate. An end-user will be able to leverage Bing Search for location-aware web searches, while an administrator will be able to leverage the Azure SQL Database and Power Automate to send alerts based on predefined metrics.
Speaker(s): Jeremy Frye,
Abstract:
AlwaysOn Availability Groups have become the most common High Availability technology used with SQL Server. It provides protection at the database group level, and it stores a separate copy of each database on each node, eliminating storage from being a single point of failure. While Availability Groups help to achieve required High Availability, they may also introduce issues in the system. In this session, Dmitri will discuss several less-known problems associated with them. You will learn how Availability Groups may impact transaction log truncation and contribute to the blocking in the system, how readable secondaries may increase CPU and I/O load on primaries among a few other things. Dmitri will also discuss how to properly setup monitoring for Availability Group infrastructure in your environment.
Speaker(s): Dmitri Korotkevitch,
Abstract:
This moderated session features a panel of IT professionals with a wide range of experience ready to answer your questions about transitioning into and progressing in IT. Have a question about what you can do to take the step from your current position into IT to get ready? What do employers look for from those changing career paths? How to show your present skills in a manner that will help you move into an IT opportunity? Bring your questions and we'll answer as many as time permits. This session is focused on professionals that have recently changed into an IT career, or are hoping to do so soon, but is open to all.
Speaker(s): Dale Sullenberger,
Abstract:
This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker(s): Diane Schuster,
Abstract:
In this demo driven session you will learn how to: prepare your computer for installation of the dbatools module, install dbatools and pre-requisites, use dbatools commands to automate routine tasks such as migrating logins and jobs, setup log shipping, and add databases to availability groups. At the end of the session, you will be able to return to your office with dbatools as a new tool in your toolkit to help you manage your SQL Server estate in a more efficient manner.
Speaker(s): Jack Corbett,
Abstract:
Data Warehousing has been traditionally deployed via on-prem MPP solutions, and due to cloud modernization, and datacenter reduction footprint initiatives, organizations are looking out to establish a relationship with a cloud solution that can help them get off the traditional storage and compute licensing scheme, to easily scale their workloads without spending millions in newly acquired hardware, and to reduce their database administration operational tasks. Azure Synapse Analytics, Google BigQuery and Snowflake Provide a path to migrate workloads into the cloud and allows an efficient resource utilization for both compute and storage. That is at least, what the marketing says as it has a tacit disclaimer around it. Azure Synapse Analytics offers scalability, pay-as-you-go compute solutions, with data contained within the database boundaries. The presentation shows a side by side comparison, with pros and cons of each platform and debunks some of the myths that have surfaced.
Speaker(s): Oscar Zamora,
Abstract:
On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks.
Speaker(s): Matt Gordon,
Abstract:
This moderated session features a panel of IT professionals with a wide range of experience ready to answer your questions about getting started and progressing in IT. Have a question about what you can do as a student to get ready? What employers look for from those brand new to the profession? How to grow your skills and know when to look for the next opportunity? Bring your questions and we'll answer as many as time permits. This session is focused on college students, but is open to all.
Speaker(s): Dale Sullenberger,
Abstract:
Data is everywhere and Data Science is a very popular topic among data analysts and BI professionals. In this session, I will cover the basic data science principles and methodologies using the Python programming language. I will also present some real-world data analysis case studies using the Python libraries, such as NumPy, pandas, Matplotlib, and SciPy. This session will benefit to anyone who is looking to get started in the data science/ Data Analytics field.
Speaker(s): Ganesh Lohani,
Abstract:
This presentation provides beginners with an applied way to learn DAX and apply this knowledge in reports right away by optimizing and/or enhancing them. DAX stands for Data Analysis Expressions and it is used in Analysis Services, Excel (Power Pivot) and Power BI Desktop to create powerful calculations and queries. This presentation is a quick DAX 360 by covering not only syntax, formulas and expressions, but it showing how to use tools, best practices, troubleshooting and query optimization techniques. > Topics Covered: * DAX Syntax * DAX Functions * Making reports Dynamics with DAX * Basic Troubleshooting Techniques * DAX Tools The information in this presentation provides attendees with a fresh look at the language and an opportunity to learn some valuable techniques.
Speaker(s): Adriano da Silva,
Abstract:
Have you experienced performance problems caused by contention in TempDB? Have you ever wondered why your TempDB is suddenly 3 TB? In this session, you will learn about all the various components of SQL Server that use TempDB. Whether it be AlwaysOn Availability Groups, Read Committed Snapshot version stores, spills, or simply temporary tables, learn about how to identify what SQL Server or your applications are doing in TempDB. Once you understand all the ways SQL Server uses this critical resource, and how to proper configure it, you'll be better prepared for your workloads whether it be an Azure VM, a physical server, or a container.
Speaker(s): Monica Rathbun,
Abstract:
In this session we will use azure cloud platform to develop and design an end to end data analysis and machine learning platform for an enterprise graded solution. An advanced data analysis and ML platform consists of data storage, training pipeline, training code base, inferencing pipeline, inferencing code base and API designing. We will show all the steps to design an enterprise graded scalable AI solution using Azure platform.
Speaker(s): Rahat Yasir,
Abstract:
As the SharePoint Intern for Smithsonian Institution’s Office of the Chief Information Officer, I created an interactive organization chart in SharePoint so users can find information on all the Smithsonian units in one place. I will go in depth on how I used SharePoint web parts, HTML/CSS, and JavaScript to create an image map with modals to display each unit’s information and the obstacles I faced with the customizations.
Speaker(s): Sarah Patrick,
Abstract:
While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server 2005 and 2008, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server 2005 and 2008; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Speaker(s): Jonathan Kehayias,
Abstract:
You simply can't access large volumes of data without correct indexes. This session teaches indexing from the optimizer's perspective, including what the indexes can and can't do, and how the optimizer can and can't use them.
Speaker(s): Jeffrey Garbus,
Abstract:
Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own? We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.
Speaker(s): John Wang,
Abstract:
Clustered Column Store Indexes are a great tool when used correctly. This session will explain on how to plan, configure, and operate Clustered Columstore indexes to handle trillions of rows. This is done with a real world example that is in production. Avoiding mistakes in the beginning will save you lots of data wrangling over time. Come and learn how to partition, select the right datatypes, and insert the data into a Clustered Column Store Index to achieve optimal performance results.
Speaker(s): Thomas Grohser,
Abstract:
Certifications can set you apart from other candidates. They can also force you to learn new technologies and approaches to business problems. In this session, we will cover Microsoft Certification options centered around data and Azure and which one may be right for you. We will also offer a couple of quick tips on test taking plus how certifications have changed. We will also touch on AWS and GCP certifications.
Speaker(s): Rick Heiges,
Abstract:
Learn how easy to write powershell As being DBA Use powershell for reporting and check database status Run one powershell script for all instance and many more
Speaker(s): Jignesh Patel,
Abstract:
You are awesome! You know that you are a great fit for that role and would be a great hire. But, how do you stand out from the crowd and Get Noticed? This session will go over some tactics on how to get noticed on LinkedIn and also show some examples of how your resume can get you to that next step. Audience participation is encouraged in this lightning talk to get ideas flowing.
Speaker(s): Rick Heiges,
Abstract:
This moderated session features a panel of IT leaders from Tampa Bay area companies. Have a question about what they see as the direction of data and the data profession(s) in the coming years? Want to know what the current trends are across various companies? Want to generate thought about how you can best position yourself for near future in the ever changing landscape? Bring your questions and we will answer as time permits. This session is open to all.
Speaker(s): Dale Sullenberger,
Abstract:
Today's hiring environment is very different from even 1 year ago. If you have applied online to jobs and have not had success this interactive session is for you. Come learn how to craft a resume to start getting results with online submissions. MOre interviews = more offers. Let's learn how to beat the applicant tracking systems.
Speaker(s): Suzanne Ricci,
Abstract:
Excessive authorizations violate the principal of least privilege and put you and your organization at risk. In this session, we'll review how to identify the server and database principals that pose the greatest threats to the security, availability, and recoverability of SQL Server. Then we'll look at a real world example and show how to "downsize" permissions to a more appropriate level that both administrators and users can live with.
Speaker(s): Dave Mason,
Abstract:
SQL Server running on Linux was unthinkable ten years ago. Now it is not only possible to run SQL Server on Linux, but also Windows 10 as the sandbox and development machines that can host SQL Server on Linux. It is possible because of a Container technology. Using Azure Data Studio's notebook as the runbook, we will show step by step to deploy SQL Server on Docker in Windows 10 desktop . The demo will also show the experimental feature of LCOW (Linux Container on Windows).
Speaker(s): Eddy Djaja,
Abstract:
Spark is a very popular and effective framework to deal with batch, streaming data processing, and machine learning challenges nowadays. So far, there have been several APIs to work with Spark like Scala, Java, Python, and R but not .NET. In this session, I’m going to introduce you current challenges in data processing world, what is Spark and how it could be used to solve them and how we can use a brand new Spark .NET API to develop data processing jobs in Spark.
Speaker(s): Sergiy Lunyakin,
Abstract:
Microsoft's powerful new service, Azure Synapse, brings together the worlds of data warehousing and big data analytics by providing a unified experience for ingesting, cleansing, modeling, and sharing data. In this session, we'll discuss the basics of Azure Synapse, ideal uses cases for Azure Synapse, and demonstrate how attendees can use Azure Synapse. By the conclusion of this session, attendees will have a deeper understanding of Azure Synapse and how to begin using Azure Synapse.
Speaker(s): Dustin Ryan,
Abstract:
Turbo charge your career, your projects, and your team by changing the way you approach failure, learning, practice, and praise. This session will cover research in cognitive psychology and neuroscience in an actionable path forward to eliminate perfectionism and other career-stifling behaviors and thoughts, which those of us in the tech industry are particularly susceptible to.
Speaker(s): Donna Ellis Wilson,
Abstract:
2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. At this meetup, Paul LaGrone will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.
Speaker(s): Paul LaGrone,
Abstract:
Demonstrate how to use docker swarm to quickly spin up many containers and persist the same data set to all of the containers. This is what every developer wants. Should your container be on premise or the cloud? Does it matter? Demonstrate how to move a container between on premise and the cloud with data.
Speaker(s): Marsha Pierce,
Abstract:
Learn about data modeling and reporting from a real solution in production and with new features in progress. The District Dashboard is a Business Intelligence solution created for Forsyth County Schools to track and analyze K-12 student performance, college and career readiness. Built on Power BI, Azure Analysis Services, Azure Data Factory and Azure SQL. Working with Microsoft Education Services, this reference solution is built on extensive Azure services as a foundation for education systems.
Speaker(s): Paul Turley,
Abstract:
What is the difference between Artificial Intelligence, Machine Learning and Deep Learning? And how can each be used? Join Buck Woody, a Data Scientist from the Azure Data team at Microsoft, as he covers simple, clear explanations for these technologies, how they can be applied, and how you can get started learning them yourself. You'll get valuable (free) resources for creating Artificial Intelligence programs, and you'll see examples of code for each area.
Speaker(s): Buck Woody,
Abstract:
The focus of this session is to demystify the normal forms and the normalization process. This presentation will provide the audience with simple explantions for each normal form with easy to understand examples starting with 1NF all the way to 6NF.
Speaker(s): Harvey Hyman,
Abstract:
This session is for people who are brand new to SQL Server or are looking for a review of the fundamentals of SSMS. We will review features presented in version 17.9, specifically creating tables and views; choosing data types; creating indexes, constraints, rules and triggers; creating basic queries using select, from, where, order by; simple joins; more complex queries and operators; primary key, foreign key, composite key; generating a system data diagram.
Speaker(s): Harvey Hyman,
Abstract:
Interested in using the Cloud for SQL Server? Wondering what is the cloud? Come find out what Cloud Computing is all about and why you might want to use it. We’ll introduce Microsoft’s Cloud, Azure, and talk about how it can be used for *FREE*! We’ll demonstrate creating Virtual Machines in the cloud that can run SQL Server (just like on premises) and we’ll also demonstrate creating SQL Servers in the Cloud using SQL Azure (no virtual machines required).
Speaker(s): David Patrick,
Abstract:
Every day we are expected to do more and more work with less resources. The future shows this trend will continue. Writing scripts to do automation will only get us so far. Gartner Group has created a new category called Intelligent Infrastructure in 2017 and many infrastructure vendors and software companies are doing more and more in this space. This session will explain what Intelligent Infrastructure is, what AIOps is, what is available now and what is coming and how the DBA can utilize these new tools to improve their daily workflow. Free up your time to focus on bigger strategic problems for your organization.
Speaker(s): Shawn Meyers,
Abstract:
A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.
Speaker(s): Marsha Pierce,
Abstract:
A beginner session to relieve the frustration of using simple aggregation functions in SQL statements. The session will cover simple equations such as adding, counting, MIN and MAX functionality. The syntax for filtering on an aggregated value will also be covered.
Speaker(s): Carolyn Risk,
Abstract:
In this talk we will discover the secrets to create an impact on a presentation using the resources provided by analytics and storytelling. Additionally, we will see the most common mistakes made when presenting data and how to solve them using the best analytical and storytelling practices.
Speaker(s): ALAN FERRANDIZ LANGLEY,
Abstract:
SQL Server 2016 introduced built-in JSON support, with new features that allow you do things like store JSON text in database tables, read and modify JSON, format the results of regular SQL queries into JSON, and transform JSON objects into table format. In this demo heavy session we’ll explore the new JSON functions and T-SQL enhancements that are now available, and find out just what SQL Server can (and can’t) do with JSON.
Speaker(s): Eric Cobb,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://www.rdx.com/Blog/dba_tips/2014/04/the-merge-join-transformation-and-an-ssis-sorting-tip/
My name is Dan King. Believe it or not I am a huge computer geek. I have worked in the System Admin role and for the past 9 years I have worked with RDX holding many positions. My current role is Sr. Manager of Data Analytics. I am a father of one. I love sports and I am a huge outdoors man. I have a few blogs published by my company that can be found on there website.
LinkedIn: https://www.linkedin.com/in/srikrishna-krishnaraosrinivasan-a882b930/
My name is Srikrishna. I am a Technical architect, Python, R, JavaScript developer, Data Analytics Engineer, Machine Learning, AI and Digital Transformation enthusiast, from Tampa, Florida. I started iSrikrishna.com to give back to community by sharing experiences. My entire career so far has been on Digital Transformation. Currently I'm exploring Machine Learning and the fullstack solutions based entirely on JavaScript (read NodeJS). I have a passion for creating value from Data Analytics, use technology to create a great experience for users and an enjoyable experience in their job. I have used AzureML for close to 100 experiments on Logistic regression, Neural Network, K-Means Clustering, NLP, Boosted Decision Tree and few more.
LinkedIn: https://www.linkedin.com/in/harvey-hyman-phd-681a2561
Harvey Hyman is an instructor specializing in MS SQL Server at University of South Florida's MUMA College of Business. His current research areas include software delivery, cloud architecture, IT infrastructure and data analytics/visualization. He has 25+ years of experience in the fields of law, technology, and military service. His most recent professional positions include The Library of Congress, H. Lee Moffitt Cancer Center, and Queens CUNY College. He has previously taught at St. Leo University, New College of Florida, Georgia Southern University and Florida Polytechnic University.
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
LinkedIn: https://www.linkedin.com/in/katja-mosher-70a73643/
Experienced Operations Project Manager with a demonstrated history of working in the information technology and services industry. Skilled in Business Process, Customer Relationship Management (CRM), Databases, SAP SRM, and Training Delivery. Strong operations professional graduated from American Institute of Professional Bookkeepers (AIPB).
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
LinkedIn: http://www.linkedin.com/pub/rick-heiges/1/b93/777/
Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx
Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.
LinkedIn: https://www.linkedin.com/in/harvey-hyman-phd-681a2561
Harvey Hyman is an instructor specializing in MS SQL Server at University of South Florida's MUMA College of Business. His current research areas include software delivery, cloud architecture, IT infrastructure and data analytics/visualization. He has 25+ years of experience in the fields of law, technology, and military service. His most recent professional positions include The Library of Congress, H. Lee Moffitt Cancer Center, and Queens CUNY College. He has previously taught at St. Leo University, New College of Florida, Georgia Southern University and Florida Polytechnic University.
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
LinkedIn: https://www.linkedin.com/in/adasilvatek/
Adriano da Silva is a Lead Power BI Trainer at Intellinsight LLC and a Principal Consultant at Bright International Corporation a consulting company focused in addressing complex business problems with innovative, effective and robust Solutions in the BI, AI, Big Data, Machine Learning Power BI. He is has years of experience in partnering with businesses leaders to advise and implement technical and process oriented solutions. He is engaged in knowledge sharing initiatives by presenting on conferences, user groups and authoring articles. He is also a lead organizer at the South Florida Power BI (SFPBI) and the Microsoft Data and AI South Florida user groups..
LinkedIn: http://www.linkedin.com/in/jackcorbett
Contact: http://www.wisemanorwiseguy.com
JJack Corbett began working with SQL Server, Access, and VB in 1999, when he served an apprenticeship with a good friend who was the software development manager at the local paper mill. He found his niche and has concentrated on SQL Server development and administration since late 2000. He has worked with SQL Server through version 2017 and was a Microsoft Data Plaform MVP from October 2011 to October 2016. Jack is passionate about helping companies architect, design, and develop high performance applications based on the Microsoft Data Platform. He also has a passion for seeing database developers get the core application code (the database) protected under source control. Jack has presented at many user groups and SQLSaturday even
LinkedIn: https://www.linkedin.com/in/danielcai/
Daniel Cai is a software developer specialized in SQL Server-based ETL integration development with various APIs and methodologies such as Microsoft Dynamics 365, data warehouse, etc. Daniel was a Dynamics 365 MVP for consecutive 8 years.
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
I think T-SQL is the best thing since sliced bread and I thoroughly enjoy reading and writing T-SQL whenever I can. I’m also doing increasingly advanced PowerShell scripting and ETL development with SSIS, PowerShell, and TSQL.
LinkedIn: https://www.linkedin.com/in/aspnerd
Contact: https://blog.reviewmydb.com
Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.
LinkedIn: https://www.linkedin.com/in/sarahepatrick/
Sarah has presented at several TechGirlz workshops for the Boys and Girls Club of Harford County, as an advocate for women in STEM. Sarah graduated from the Science and Mathematics Academy in Aberdeen, MD in May 2018, where she presented her senior capstone project "Engineering peer credibility via mastery of roles," where she designed roles for an ad hoc team. She worked with an army professional from CERDEC. She is currently attending the University of Maryland - College Park to major in Information Science. Sarah completed an internship with the Project Management Institute, helping them with their Professional Development Event, and worked as at the SharePoint Intern at Smithsonian Institution’s Office of the Chief Information Officer.
LinkedIn: https://www.linkedin.com/in/jeremyilfrye
Contact: https://jeremyfrye.net
Jeremy Frye is the manager of the Business Intelligence and data warehousing team at RDX. He is a Business Intelligence architect and developer with a background in database administration as well. Jeremy has over 9 years of experience in SQL Server. He has spoken on BI topics at many SQLSaturday's throughout the country, webinars, and local and remote SQL user groups. In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.
LinkedIn: https://www.linkedin.com/in/ozamora
Contact: https://ozamora.com
For the past 20 years, I have led and executed complex data and analytics migrations into cloud and on-premises deployments. I help enterprises discover opportunities by enabling cloud services that improves their efficiency, reduce operational tasks, increase quality and help making strategic decisions that impact their bottom line. I work directly with Senior Management to establish and execute roadmaps and strategies, and mentor engineers with best practices for data processing and development.
LinkedIn: https://www.linkedin.com/in/chadbuher/
Chad Buher is the lead Business Intelligence Architect for 1-Answer Corp, a consulting organization that provides BI guidance, support and a suite of software tools that reduces BI development time by 75%. In roles such as Data Architect Consultant for Pragmatic Works, BI Developer for Dignity Health, Sr. Information Architect for Adventist Health System, and other BI roles over the last 18 years, Chad has seen a wide range of solutions and always seeks to listen and learn from everyone around him. Chad lives with his wife just outside of Orlando, FL where his once neat and quiet home has turned into an exhilarating daily adventure parenting three amazing kids adopted from foster care.
LinkedIn: https://www.linkedin.com/in/sqlrv
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQL Saturday sessions across the country.
LinkedIn: https://www.linkedin.com/in/jeandjoseph/
Contact: http://tsqlhelp.wordpress.com/
Highly experienced in Big Data and traditional data technologies with a history of successes in designing, implementing complex technical projects for diverse businesses in various stages of their development. Acknowledged as a leader capable of mentoring teams of different backgrounds and talents and inspiring individual efforts to deliver. Organized and detail-oriented, with a positive pro-active and hardworking attitude. Performance history reflects a highly analytical strategic thinker with strengths in defining solutions and executing programs that have been invaluable to an all-encompassing range of projects and positions.
LinkedIn: https://www.linkedin.com/in/suzannericci/
With a passion for technology and education, Suzanne established LaSalle Computer to fill a market need for an adult learning center with a focus on high-quality, hands-on training and high-level customer service. By age 27, she had purchased and sold, for a profit, a second school while still growing and leading LaSalle. A life-long student with a deep dedication to education and continuous improvement, Suzanne was able to lead and grow LaSalle to become a successful acquisition by the second largest private equity firm specializing in the knowledge sector. With a love of helping others she established Computer Coach to continue to help IT and business professionals find career success through strategic career plans.
LinkedIn: https://www.linkedin.com/in/aspnerd
Contact: https://blog.reviewmydb.com
Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.
LinkedIn: https://www.linkedin.com/in/sqldusty/
Contact: https://sqldusty.com
Dustin Ryan is a Data Platform Solution Architect at Microsoft. Dustin has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as SQL Saturday, SQL Rally, and PASS Summit, and has a wide range of experience using the Microsoft business intelligence stack of products across multiple industries. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant for a Microsoft partner. Dustin resides outside Jacksonville, Florida with his wife, three children, two cats, two dogs and enjoys spending time with his family and serving at his local church. You can learn more about him at http://SQLDusty.com.
LinkedIn: http://www.linkedin.com/in/aferrandiz
Contact: http://www.ferrandiz.pe
Ingeniero Empresarial, especialista en analítica, estrategia digital e innovación. Posee las certificaciones de Microsoft Certified Trainer (MCT) y Microsoft Certified Solutions Expert (MCSE): Data Management y Analitics.
LinkedIn: http://www.linkedin.com/in/FrankQuintanaDataArchitect
Contact: http://www.businessintelligencematters.us
Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the "Health and Benefits System for the of the Veteran Affairs of Canada" He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQL Saturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQL Saturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: https://www.linkedin.com/in/sqlrv
Contact: http://sqlrv.com
Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQL Saturday sessions across the country.
LinkedIn: http://www.linkedin.com/in/johnsterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQL Saturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John's community activities can be found at https://johnsterrett.com/community/
LinkedIn: https://www.linkedin.com/in/dustindorsey
Contact: https://dustindorsey.com/
Dustin Dorsey has been architecting and managing SQL Server solutions for companies for well over a decade. While Dustin is skilled in many areas, he has a unique specialization in cost management and architecture around the data platform both on-premise and in the cloud that he has used to provide significant savings for multiple organizations and loves sharing information about this. Dustin is an avid speaker and can be seen writing articles on popular SQL websites, as well as, on his own blog at DustinDorsey.com. He is also active in the Nashville community as a local user group leader and co-organizer of his local SQLSaturday. Dustin currently serves as Director of Data Management at Lifepoint Health.
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: http://www.linkedin.com/in/buckwoody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
LinkedIn: https://www.linkedin.com/in/sqlatspeed
Contact: http://www.sqlatspeed.com
Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
LinkedIn: https://www.linkedin.com/in/slunyakin
Contact: https://slunyakin.wordpress.com
Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.
LinkedIn: https://www.linkedin.com/in/dmasondba/
Contact: https://itsalljustelectrons.blogspot.com/
Dave Mason is a data professional who started working with SQL Server and Oracle in 2000. It didn't take him long to realize his brain was wired for set theory and three-valued predicate logic. His Oracle dreams fizzled out, but he continued working with SQL Server as an application developer. As his career progressed, he took on as many DBA tasks as he could, eventually making the transition to full time SQL Server DBA. More recently, Dave has earned the MCSE: Data Management and Analytics certification (2016, 2018).
LinkedIn: https://www.linkedin.com/in/sqlespresso
Contact: http://www.sqlespresso.com
Monica Rathbun lives in Virginia, is a Microsoft MVP for Data Platform and Microsoft Certified Solutions Expert. She has nearly two decades of experience working with a wide variety of database platforms with a focus on SQL Server and the Microsoft Data Platform. She is a frequent speaker at IT industry conferences on topics including performance tuning and configuration management. She is the Leader of the Hampton Roads SQL Server User Group and a Mid‐Atlantic PASS Regional Mentor. She is passionate about SQL Server and the SQL Server community, doing anything she can to give back. Monica can always be found on Twitter (@sqlespresso) handing out helpful tips. You can find Monica blogging at sqlespresso.com
Currently working for a non profit in the insurance industry that facilitates arbitration between member companies as a BI Tester. Have over 20 years experience as a developer across several industries, manufacturing, education, medical, insurance, and non profit for companies such as Rolls-Royce Aerospace, Ameritech, and IUPUI. I consider myself a full cycle developer for both front and backend by doing the requirements gathering, the designing, the programming and the security and maintenance of the applications. I also analysis data and processes and create reports, dashboards and visuals where needed. My experience crosses several languages and platforms, including SQL, VB, HTML, SQL Server, Oracle, ASP.Net, VB.Net, and reporting.
LinkedIn: https://www.linkedin.com/in/marsha-pierce-1a020a2
Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.
John Wang is a Back-end .NET Developer. Currently, his interests are IoT, big compute, services, cloud computing, Powershell and SQL topics. He is an frequent speaker at the various Code Camp, Meetup, IT Pro Camp and SQL Saturday.
LinkedIn: http://www.linkedin.com/in/shawnmeyers42
Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQL Saturday events. Current focus is on improving DBAs lives with better infrastructure.
LinkedIn: https://linkedin.com/in/dale-sullenberger-73295413
Dale lives in Valrico, FL with his wife Connie and son Nathan, three dogs and two cats. While there is some prior user level database experience, Dale has been working with SQL Server in some manner since 1997, and has been in a DBA role for 13 years.
LinkedIn: http://www.linkedin.com/in/dianeschuster
Diane has worked with COZYROC since 2012. She has attended numerous SQL Saturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it! In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.
LinkedIn: http://www.linkedin.com/in/josechinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
LinkedIn: https://www.linkedin.com/in/donna-wilson-26212a37
Contact: https://sqlgrrl.net
Data professional with 25 years in the industry, nearly 10 of which at Microsoft in Product Support. Areas of focus includes: SQL Server administration, general troubleshooting, HADR, replication, log shipping, connectivity, security, and performance tuning. Passionate about women and diversity in tech, brain hacking, behavioral change, and psychology.
LinkedIn: https://www.linkedin.com/in/jignesh-patel-7296817
Learning about SQL Server database administration last 7 years
LinkedIn: https://www.linkedin.com/in/danielcai/
Daniel Cai is a software developer specialized in SQL Server-based ETL integration development with various APIs and methodologies such as Microsoft Dynamics 365, data warehouse, etc. Daniel was a Dynamics 365 MVP for consecutive 8 years.
Contact: http://blogs.vmware.com/apps
Deji Akomolafe (a member of the Office of the CTO Ambassador Program and Staff Solutions Architect within VMware#39;s Global Field and Partners Readiness Group) specializes in the virtualization of Microsoft Business Critical Applications on VMware#39;s vSphere platform. Deji is a regular speaker at VMworld, Partners Exchange Conference, VMUG, SQL Saturday and EMCWorld, presenting technical subject matters related to Microsoft Applications virtualization and providing technical guidance to help clients enhance their expertise and ability to optimally virtualize and operate their critical applications.
LinkedIn: https://www.linkedin.com/in/mdarab/
Contact: https://mohammaddarab.com
Mohammad Darab is a Microsoft Data Professional, speaker and blogger with over 19 years of IT professional experience, 10+ years of that working with SQL Server. Some areas of his focus are the database engine, HA/DR, and security. He is currently an MCITP, MCP, as well as an IDERA ACE Class of 2019.
LinkedIn: https://www.linkedin.com/in/thepeterdoyle/
On Jan 12, 2019, Peter attended his first SQL Saturday and experienced an engaging and uplifting community that encouraged everyone regularly to give back. That experience resulted in teaching eleven sessions and delivering a SQL Fundamentals pre-conference the last six months of the year. He is passionate about sharing knowledge on building a solid T-SQL foundation without wasting time. Peter's journey from minimal Excel knowledge to writing Dynamic SQL all started from watching Youtube videos for three hours every morning before work. Managers took notice of the results and transferred him to the reporting department. A few months later, a co-worker suggested he should learn SQL Server and his world of data has never been the same.
LinkedIn: https://www.linkedin.com/in/rahat-yasir/
Contact: https://learnwithbddevs.wordpress.com/
Rahat Yasir is selected as Canada's top 30 software developer under 30 in 2018. He is five times Microsoft Most Valuable Professional Award holder in Artificial Intelligence category. He is the author of the first eBook on Windows Phone 8.1 app development "Windows Phone 8.1 Complete Solution" and "Universal Windows Platform - Complete Solution". He was the lead AI developer at Immersive Design Studios and developed world's first AI video upscalling tool. He worked as AI Engineer at Intact Financial Corp and designed production graded AI applications that are serving millions of requests everyday. He is currently working as the Lead AI Developer at OSEDEA and designing the next generation AI solutions for manufacturing industry.
LinkedIn: http://http://www.linkedin.com/profile/view?id=22766305amp;trk=tab_pro
Contact: http://skreebydba.com/
Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.
LinkedIn: https://www.linkedin.com/in/pturley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
LinkedIn: https://linkedin.com/in/dale-sullenberger-73295413
Dale lives in Valrico, FL with his wife Connie and son Nathan, three dogs and two cats. While there is some prior user level database experience, Dale has been working with SQL Server in some manner since 1997, and has been in a DBA role for 13 years.
LinkedIn: https://www.linkedin.com/in/thomasgrohser/
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
LinkedIn: http://www.linkedin.com/pub/rick-heiges/1/b93/777/
Contact: http://sqlblog.com/blogs/rick_heiges/default.aspx
Rick is a Former Data Platfrom MVP and Sr. Consultant for Microsoft where he focuses on working with customers on their data estate. His career includes work as a DBA, University full-time faculty member, Systems Analyst, Project Leader, and Developer. He has found his passion in working with data and the community. Rick served nine years on the PASS Board of Directors and spearheaded the popular 24 Hours of PASS event. He also started his local User Group in 2002. Today, he spends much of his time with his head in the clouds.
LinkedIn: https://www.linkedin.com/in/travispage/
Most recently a Senior Database Administrator with Jackson Hewitt, Travis is on the leadership team of the Pinellas SQL User group and an active member of PASS. Passionate about all things related to technology, he maintains a CISSP certification.
LinkedIn: https://www.linkedin.com/in/mindycurnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQL Saturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
LinkedIn: https://www.linkedin.com/in/marsha-pierce-1a020a2
Marsha Pierce lives in Nashville, TN. She studied Computer Science, Mathematics, and French at Belmont University. She has 23 years of experience as a DBA, which means she has broken and fixed a lot of stuff. Before joining Pure Storage, she was an architect at HCA and Asurion. She is passionate about DevOps, Storage, Performance Tuning, and Standardization.
LinkedIn: https://www.linkedin.com/in/michaelpantonovich?
Contact: http://sharepointmike.wordpress.com
Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User's Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.
I've been a Server Administrator and DBA for 20+ years and have worked with multiple operating systems (UNIX variants, Mac OS X and Windows) and database engines (MySQL/MariaDB, Oracle, PostgreSQL, SQLite, and MSSQL). I currently work a lot with PowerShell and automation as well as supervising a group of awesome systems administrators. I've worked for a large state university system, a start-up company, and everything in-between (including my own consulting company). I currently work for Border States Electric as an I.T. Supervisor.
Paul is currently in his fourth year as the ETL Manager for a local CRM software firm. Paul's database work dates back to early database platforms like Dbase III and has worked with every version of SQL Server since SQL 7.0 was introduced. His certifications include MCSE, MCDBA, and MCT. Along with holding a DBA job for the City of Fort Worth, Texas, he also taught T-SQL Intro and Advanced classes to several departments and the North Texas GIS community. In 2006, he founded and ran the Greater Fort Worth SQL Server group for three years, which still continues today. While moving data and other SSIS tasks are Paul's responsibility now, he has also been a Production DBA, worked heavily in the GIS database community, and has dabbled with AWS
LinkedIn: https://linkedin.com/in/dale-sullenberger-73295413
Dale lives in Valrico, FL with his wife Connie and son Nathan, three dogs and two cats. While there is some prior user level database experience, Dale has been working with SQL Server in some manner since 1997, and has been in a DBA role for 13 years.
LinkedIn: https://www.linkedin.com/in/ganesh-lohani-6275a716
Ganesh Lohani has 10 years of experience working with Business Intelligence platform and Data Analytics, with over 8 years of experience with MS BI tools and Business Intelligence processes. He is currently working for Stericycle as a senior Business Intelligence Developer. He also enjoy his evening and weekend time in providing online training, coaching and mentoring individuals who want to learn MSBI (T – SQL, SSIS, SSRS, SSAS, and Power BI ) products. He holds MSIS degree from University of Texas at Arlington.
LinkedIn: https://www.linkedin.com/in/ericcobb
Contact: http://www.sqlnuggets.com
After a 14-year programming career as a web and software developer, Eric decided to move full time into the world of databases and became a SQL Server Database Administrator, earning 2 SQL Server MCSE certifications along the way, and now manages a team of SQL Server professionals. Eric regularly presents and blogs about SQL Sever, with a focus on teaching database administration and design concepts to the developer community, and frequently speaks at Developer and Database conferences throughout the country. In 2019 Eric was selected to be a 2020 IDERA ACE, for showing a passion in helping the developer community and sharing his knowledge.
Contact: http://dbaworld.blogspot.com/
I have worked as a SQL DBA since 1997. I have managed SQL Server starting from version 6.5 to the latest version. Throughout my career I also worked as Oracle DBA, database architect, lead DBA and managing DBA team.
LinkedIn: http://www.linkedin.com/in/davidepatrick
Contact: http://www.madsharepoint.com
Dave has been developing database applications for over 25 years. An MCT since 2001, he has taught many classes from Intro to Visual Interdev to Advanced SharePoint Development. Dave runs two user groups, the Maryland and Pennsylvania Microsoft Developers User Group, www.mapamdug.com, and MAD SharePoint, www.madsharepoint.com. Dave does SharePoint training and development for DSA, Inc., a DoD contractor that does great work for the Army over at Aberdeen Proving Ground. Dave is also an MVP.
The following is a list of sponsors that helped fund the event.