Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 46
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: April 01

Time: 9:45 AM - 10:45 AM

Room: Humanities 208

"Backup and Recovery" is the most basic fundamental responsibility of any DBA, and your mastery (or lack thereof) of this topic can make you a hero or get you fired.  Beginner level folks will benefit from this talk because we'll cover the basics, but I think even more experienced DBA's might learn a few tricks.
Outline:
 * Review the fundamentals (recovery models, backup types, etc) with use cases
 * Give practical examples w/ syntax
 * Do performance tuning on backups
 * Recommend best practices and strategies
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 01

Time: 4:00 PM - 5:00 PM

Room: Health Sci. 117

This session is designed to teach DBAs and developers the best strategy to transfer large data. 

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Architecture, Development & Management

Level: Intermedia

Session Code:

Date: April 01

Time: 9:45 AM - 10:45 AM

Room: Humanities 307

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

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics, Visualization & Presentation

Level: Beginner

Session Code:

Date: April 01

Time: 8:30 AM - 9:30 AM

Room: Health Sci. 117

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo-heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn why top down design is not always the best pattern as well as why implicit conversions can slow down your queries. You’ll learn how to rewrite most cursors as well as finding out how user defined functions affect performance. You’ll learn some simple ways to troubleshoot these types of issues using execution plans and extended events. Finally, we’ll take a look at how standards can help quicken turnaround time when refactoring T-SQL. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: April 01

Time: 2:45 PM - 3:45 PM

Room: Health Sci. 120

Standardizing essential performance health check is the key in responding quickly to production issues and can cut down initial evaluation phase to 1/3rd of the time, whether you have been requested to do health check or you may want to run these due to an alert. These sets of essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to Production issues.

First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 01

Time: 1:30 PM - 2:30 PM

Room: Health Sci. 118

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: April 01

Time: 9:45 AM - 10:45 AM

Room: Health Sci. 118

We have more information available to us today than ever before.  So much so that we run the risk of not being able to tell concise stories.  There's a lot more to creating that story than just getting the correct information.  Come learn not just the do's and don'ts, but the whys…
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics, Visualization & Presentation

Level: Beginner

Session Code:

Date: April 01

Time: 11:00 AM - 12:00 PM

Room: Health Sci. 117

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics, Visualization & Presentation

Level: Beginner

Session Code:

Date: April 01

Time: 1:30 PM - 2:30 PM

Room: Health Sci. 117

Administering SQL Server environments can seem like a daunting task for any DBA.  In this session, we’ll provide some guidelines and tips to help new DBAs get started on the right foot.  Backups/restores, integrity checks, index maintenance, documentation, security and alerting will be some of the topics covered in this session.  We’ll also be covering some of the online resources that are available.  Bring your questions!
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 01

Time: 11:00 AM - 12:00 PM

Room: Humanities 208

The key to becoming a great DBA is time.  The best way to regain some time is by spending less time doing the daily mundane work.  Let this mundane effort work autonomously.  We will introduce the basics in monitoring and maintenance.  The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 01

Time: 4:00 PM - 5:00 PM

Room: Humanities 208

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 01

Time: 4:00 PM - 5:00 PM

Room: Health Sci. 118

Grab your box lunch and come hear all about Dell and EMC's solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 01

Time: 12:30 PM - 1:30 PM

Room: Health Sci. 117

The importance of proper table design cannot be underestimated. Misconceptions could lead into serious problems not only in terms of database performance, but also it can effect disk space management and interactivity of user interface as well. In this session the audience will have a sensible walk-through of database and table design in detail, encompassing a number of key areas of focus ranging from Data Types to FILESTREAM implementation. Discuss most common a table design mistakes. Find out efficiency of one type over another, IDENTITY vs. SEQUENCE vs. GUID to support PK uniqueness, pros and cons of using composite Primary Key and SPARSE column, and more.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: April 01

Time: 8:30 AM - 9:30 AM

Room: Health Sci. 118

Power BI is all the rage right now in visualizing data on the Microsoft BI stack.  We've seen multiple how tos and presentations on the features, but in this hour, we will actually go through the journey of a specific problem, research it, storyboard it, work through how we solve it (before we ever open Power BI) and then build the Power BI visualization.   Make your visualization count.  Come join us on the journey.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Analytics, Visualization & Presentation

Level: Beginner

Session Code:

Date: April 01

Time: 2:45 PM - 3:45 PM

Room: Health Sci. 117

The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Intermedia

Session Code:

Date: April 01

Time: 8:30 AM - 9:30 AM

Room: Humanities 305

This session will cover what is Streaming Analytics and the various use cases.  We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review.  The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud Services

Level: Intermedia

Session Code:

Date: April 01

Time: 8:30 AM - 9:30 AM

Room: Humanities 206

In one small step, SQL Server 2016 has taken a giant leap...to JSON! In this session, we'll launch a probe into a JSON data file containing profiles of NASA astronauts using new JSON T-SQL functions in SQL Server. With each astronaut we meet, we'll learn to validate, read, and manipulate "unstructured" JSON data. We'll get The Right Stuff to start developing, no previous JSON experience required. Let's go where NoSQL has gone before!

Prerequisites:
You should have experience writing queries in T-SQL. No previous knowledge of JSON is needed.

Goals:
Learn about JSON, and its basic data types
Discover how SQL Server 2016 can handle JSON data
Be amazed at the cool people NASA sends into space!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: April 01

Time: 8:30 AM - 9:30 AM

Room: Humanities 307

Apache Kafka is a distributed publish-subscribe messaging system which can scale out to handle millions of messages per second.  In this talk, we will cover the basics of this powerful system, including general architectural and design principles.  We will also build a .NET project which uses Kafka to produce and consume messages quickly and efficiently.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Development

Level: Beginner

Session Code:

Date: April 01

Time: 8:30 AM - 9:30 AM

Room: Humanities 208

You need to nail the interview to get the job but you can't get the interview if you don't nail the resume.  This session starts with key points to get your resume into the "Yes" stack, covers interview tips and concludes with appropriate follow-up actions items.  Bring you own resume for some professional feedback on how it stacks up and get your resume into the "Yes" stack!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 01

Time: 12:30 PM - 1:30 PM

Room: Humanities 208

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