Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 55
Understanding Index internal operation is very important.
It is a fundamental knowledge of performance tuning and troubleshooting.
However, Index internal seems very hard to understand because many materials explain it a very complicated way.

This presentation covers from basic concept of index to all of internal index structure.
I will explain the index structure very simple concept.
Therefore, all developer who attends this session could understand how index work with a Clustered index and a Non-clustered index together.
Furthermore, this presentation will share very important tip how to troubleshooting index issue.
This presentation would very help not only who does not know index but also, who know very well index internal.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: April 14

Time: 2:45 PM - 3:45 PM

Room: Health Science 118

I would like to share the 3 lessons I learned that helped me become a much better consultant. These lessons were crucial in helping me make that "mind shift" from thinking like a regular "9 to 5 DBA" to thinking like a consultant. The goal of this session is to help those who are interested in becoming a consultant. Hopefully these 3 lessons will help make that transition successful as it did for me.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Humanities 208

In this session, we'll share tips for report creation, including tips about gathering requirements, creating dashboards, understanding business drivers, implementing machine learning quickly and easily, judiciously using coloring, delivering reports strategically, and learn when it's time to retire a report.  Each tip is about sixty seconds and most have demos.  All code will be available for download.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics, Visualization & Presentation

Level: Intermedia

Session Code:

Date: April 14

Time: 1:30 PM - 2:30 PM

Room: Health Science 120

Ever feel like you are just doing busy work while creating new SSIS packages?  Feel like you are doing the same thing over and over while changing the names to protect the innocent?  Ever wonder if there is a better way?  Well wonder no more.  Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors.  Come with intrigue and leave with a fundamental understanding of BIML!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 14

Time: 11:00 AM - 12:00 PM

Room: Humanities 208

You want to migrate your on premise SQL Database to cloud, and soon recognize that SQL Agent is not available.  You heard the promise of spinning up databases on demand and turn off/dial down when not in use. Do you want to do this manually each time?  Azure Automation comes to rescue.  It is a service for simplifying cloud management. Using Azure Automation long-running, manual, error-prone, and frequently repeated tasks can be automated to increase reliability, efficiency, and time to value for your organization.
In this demo intensive session I will show you how to setup Azure Automation, walk you through a runbook example (a compilation of routine procedures and operations), execute runbook on demand and also show how to schedule the same.  At the end of this session you will have solid understanding about how to automate Azure services including replacing SQL Agent functionality using Azure automation, and conveniently encapsulate within the common Azure portal experience.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud

Level: Intermedia

Session Code:

Date: April 14

Time: 1:30 PM - 2:30 PM

Room: Humanities 305

It's not a question on whether or not the landscape for the common DBA is changing. Without a doubt, it is.  Azure offers up a new world of possibilities for DBA's and we should all strive to learn it.  In this session we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this.  This new found knowledge will help propel your career into the new landscape.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud

Level: Beginner

Session Code:

Date: April 14

Time: 9:45 AM - 10:45 AM

Room: Humanities 305

Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT community.  This is an unfortunate state since ADC is an incredibly useful tool that is easy to implement and use. Companies that are able to leverage their data have seen the greatest gains in growth and market capitalization.  The reason for this is simple: We live in the information age.  Being able to leverage the data you gather is the invitation you need just to compete in information age.
ADC is an indispensable tool that helps companies organize and make sense of the mountains of data they collect every day.  By walking participants through an implementation of ADC, I will introduce them to the product, and show how easy it is to use.  By presenting concrete examples of how ADC is used, I will demonstrate its importance. Participants should leave this session determined to introduce ADC to their team and resolute in their intention to implement it within their company.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud

Level: Beginner

Session Code:

Date: April 14

Time: 4:00 PM - 5:00 PM

Room: Humanities 305

In this session, we’ll review all the various infrastructure components that make up the Microsoft Azure platform. When it comes to moving SQL Server systems into the Azure platform having a solid understanding of the Azure infrastructure will make migrations successful and making support solutions much easier.
 
Designing your Azure infrastructure properly from the beginning is extremely important. An improperly designed and configured infrastructure will provide performance problems, manageability problems, and can be difficult to resolve without downtime.
 
As Azure scales around the world many more companies, no matter where they are located, will be begin moving services from on-premises data centers into the Azure Cloud, and a solid foundation is key to successful migrations.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud

Level: Beginner

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Health Science 117

Demonstrate the steps to import raw data from text file and Excel file into Excel 2016, and then build a dashboard using PowerPivot and Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics, Visualization & Presentation

Level: Beginner

Session Code:

Date: April 14

Time: 4:00 PM - 5:00 PM

Room: Health Science 120

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, execution plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Health Science 131

Have you ever worked on a database used by more than one person?  ;-)  If so, then this session is for you!  In this session we'll talk about what happens when multiple processes compete for the same resources  (aka "Concurrency").  We'll break down SQL Server's isolation levels, and the trade-offs between concurrency and such scary-sounding things as "dirty", & "phantom" reads. There will be practical demo's and some real-life examples "from the trenches".   There are a lot of misconceptions out there about this topic, you may be surprised!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 14

Time: 2:45 PM - 3:45 PM

Room: Humanities 206

Confidence is the fuel for action.  How often have you thought about wanting to do something and thought you may not be successful at it, so it then became too much work to try?  The American Pastor Robert Shuler famously asked a very powerful question: “What would you do if you knew you could not fail?”  Come explore this exciting topic with me, and we will see what we can accomplish together!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 14

Time: 9:45 AM - 10:45 AM

Room: Health Science 131

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 Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 14

Time: 12:30 PM - 1:30 PM

Room: Humanities 208

Learning the internals of a data file can seem like a daunting task... So lets make it fun and practical. In this session we will look at some common best practices and see what is actually going on under hood. I'll even share a few stories of the crazy things I've seen and dealt with in my career.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: April 14

Time: 1:30 PM - 2:30 PM

Room: Humanities 206

Ensuring the ongoing protection of personally identifiable information is mandatory in today's business, helping you to guard against data breaches, and comply with the GDPR. In a climate where cyber attacks are all too frequent, and data is spread across a growing number of different environments, the challenge of protecting your data can seem daunting.  This session will address the implications of the GDPR on database management, and demonstrate a privacy-first approach to controlling and protecting data as it changes and moves through your SQL Server estate. As well as offering guidance for assessing your data estate for GDPR readiness, this session will include some great tools and tips for building data protection and privacy into your development processes, and dispel the myth that database DevOps and compliance can't go hand in hand. With the right preparation, you can build compliance into your processes, keep sensitive data safe, and deliver value quickly to your end users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 14

Time: 4:00 PM - 5:00 PM

Room: Health Science 131

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse. 
Mashups using data from partners, commercial and public sources are fast becoming the new normal.
Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening?
Need to determine the quality of a file downloaded from the internet or supplied by another party?
In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Administration

Level: Beginner

Session Code:

Date: April 14

Time: 2:45 PM - 3:45 PM

Room: Humanities 307

Database security is a hot topic, especially with all the recent breaches of major public companies. We know that behind every application or website somewhere lies a database with sensitive information. We also know that companies are pushing data access to an ever growing number of devices, including tablets, cell phones and smart watches. The Internet of Things (IoT) only heightens security concerns. So how do you protect your databases? What are your options, and what ramifications exist with each option? This presentation will provide a high level summary of prevailing database security options along with their pros and cons. Furthermore, an ideal two factor authentication solution is presented for education and consideration.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: April 14

Time: 4:00 PM - 5:00 PM

Room: Humanities 307

Azure Data Factory V2 represents a major new release to the Microsoft's cloud data integration tool, and a complete paradigm shift from V1. We'll discuss which changes are the most significant and which features have stayed the same.  Then, we'll dive into the inner workings of Data Factory V2 so we can discuss common usage patterns, such as loading data from multiple tables with a single pipeline, incrementally pulling data from source systems, and other data warehouse loading techniques.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud

Level: Intermedia

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Humanities 305

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged…  we have you covered.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 14

Time: 12:30 PM - 1:30 PM

Room: Humanities 206

Come learn what DesignMind can do for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics, Visualization & Presentation

Level: Beginner

Session Code:

Date: April 14

Time: 12:30 PM - 1:30 PM

Room: Health Science 120

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