Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type



Sessions Found: 69
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:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Information Delivery

Level: Intermedia

Session Code:

Date: February 29

Time: 10:15 AM - 11:45 AM

Room: 1201

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: February 29

Time: 2:30 PM - 3:30 PM

Room: 111

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 2:30 PM - 3:30 PM

Room: 1301

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:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 29

Time: 9:00 AM - 10:00 AM

Room: 2303

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:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 29

Time: 2:30 PM - 3:30 PM

Room: 118

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: February 29

Time: 9:00 AM - 10:00 AM

Room: 1201

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:

Session Type:
Regular Session (60 minutes)

Track:
Compliance and Security

Level: Intermedia

Session Code:

Date: February 29

Time: 2:30 PM - 3:30 PM

Room: 1102

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:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 10:15 AM - 11:45 AM

Room: 1102

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:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 1:15 PM - 2:15 PM

Room: 118

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 29

Time: 3:45 PM - 4:45 PM

Room: 115

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 29

Time: 3:45 PM - 4:45 PM

Room: 1201

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:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 29

Time: 10:15 AM - 11:15 AM

Room: 112

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:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 29

Time: 1:15 PM - 2:15 PM

Room: 1201

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: February 29

Time: 1:15 PM - 2:15 PM

Room: 111

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:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 29

Time: 2:30 PM - 3:30 PM

Room: 1201

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:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 29

Time: 10:15 AM - 11:15 AM

Room: 2304

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:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: February 29

Time: 1:15 PM - 2:15 PM

Room: 1102

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 29

Time: 3:45 PM - 4:45 PM

Room: 2304

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: February 29

Time: 2:30 PM - 3:30 PM

Room: 112

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 29

Time: 2:30 PM - 3:30 PM

Room: 1201

Sessions Found: 69
Back to Top cage-aids
cage-aids
cage-aids
cage-aids