Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type


Sessions Found: 63
What is SQL Server Docker? How are existing SQL Server environments different from the concept of using SQL Server Docker?

During the given session, I'd like to go over the basic theory of the docker, how to install SQL Server on it, and a few important things to check while operating it.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud Technologies

Level: Beginner

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Health Science 118

Docker and Kubernetes are becomes very hot industry since last couple of years.

SQL Server used to run only on Physical machine.
Now, it's not any more strange or wrong that SQL server run on VM.

This session is designed for understanding about container and how SQL server could run on container.

There are 2 types of applications, Stateless and Stateful.
We will go over the difference between them and will deliver the detail cases how SQL server could adjust in Container environment.

Therefore, developer or DBA could choose better architecture in various conditions.

Within this session will cover what the market demand is and what SQL server can do on the demand.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud Technologies

Level: Beginner

Session Code:

Date: April 13

Time: 9:45 AM - 10:45 AM

Room: Health Science 118

Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 13

Time: 9:45 AM - 10:45 AM

Room: Humanities 307

Amazon Web Services (AWS) offers the ability to run SQL Server both as a managed service part of the Amazon Relational Database Service (Amazon RDS), as well as letting you deploy your own custom solution on Amazon EC2.  Learn how to deploy SQL Server on AWS, and get to know the capabilities Amazon RDS offers to help you operate SQL Server more efficiently at scale.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: April 13

Time: 12:30 PM - 1:30 PM

Room: Health Science 118

It's not a question of 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 Technologies

Level: Beginner

Session Code:

Date: April 13

Time: 1:30 PM - 2:30 PM

Room: Health Science 118

If you are going to do anything with data you are going to need to learn how to query data. And the language to query the majority of those systems is through SQL (Structured Query Language). The pull data from any systems you are going to be relying on the Select statement. The features in the statement may vary slightly from platform to platform, but the core capabilities are the same.

In this session, we will dive deep in to the SELECT statement as the window to getting your data. In this session, we will be using one platform, but the lessons learned here will be applicable to querying any system that supports a SQL language interface. This session will cover things like querying, joins, functions, aggregation, sub queries, and much more. This session will give you the foundation to start analyzing data in any database system.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
T-SQL Introductions

Level: Beginner

Session Code:

Date: April 13

Time: 11:00 AM - 12:00 PM

Room: Health Science 120

When the SQL Server optimizer evaluates a query to determine how best to execute it, the statistics are quite possibly the most important tool at its disposal. But SQL Server statistics objects aren’t perfect because they only contain estimated summary information. In this session, we’ll start with an overview of what the statistics objects are, how the optimizer uses them, and some general guidelines for their maintenance. Then we’ll look at some of the issues, how to find them, and how to solve them, that can arise due to their imperfection: ascending keys (the most prevalent statistics based performance killer?), skewed distribution, or downright bad summary information. There’ll be many examples, and even a stored procedure to help you find ascending keys. By applying the techniques we’ll discuss, you WILL see improved query performance.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 13

Time: 11:00 AM - 12:00 PM

Room: Humanities 208

Demonstrate the steps to use the raw data in a text file to build a dashboard using PowerPivot and Power BI.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Presentation & Visualization

Level: Beginner

Session Code:

Date: April 13

Time: 4:00 PM - 5:00 PM

Room: Health Science 117

Store SSIS on one SQL Server in a centrally managed location. Easily scale resources to handle SSIS execution, keep the ETL workload away from other databases, and standardize multiple SQL instances using the same SSIS package without opening Visual Studio. Review logs in one centralized location. Centralized SSIS is available in version SQL Server 2012 and later.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 13

Time: 9:45 AM - 10:45 AM

Room: Math/Sci 123

Containers have quietly been taking over the world of infrastructure, especially amongst developers and CI/CD practitioners. However, in the database space, container adoption has been lower. SQL Server 2017 introduced the concept of deploying databases into Docker containers. In this session, you will learn the fundamentals of creating containers, learning about Kubernetes for management, and how to further your learning in this new and emerging space.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Beginner

Session Code:

Date: April 13

Time: 1:30 PM - 2:30 PM

Room: Math/Sci 123

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. In contrast, COZYROC's 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 into the SSIS package at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. 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. In t
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 13

Time: 12:30 PM - 1:30 PM

Room: Health Science 131

CCPA and GDPR have left many of us second guessing if our organization is 100% in compliance.  MetaCenter provides a platform to support regulatory compliance requirements while reducing IT costs at 3X the ROI of competing solutions.  Come learn how MetaCenter’s metadata management and data governance capabilities are providing automation to leading Enterprise around the world to document their information assets and automate data lineage analysis.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 13

Time: 12:30 PM - 1:30 PM

Room: Health Science 120

Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.

Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.

In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Intermedia

Session Code:

Date: April 13

Time: 1:30 PM - 2:30 PM

Room: Humanities 307

The pillars will work with any size environment, from the small and agile to the very large and complex SQL database landscape. There IS a valid solution for all environments. All the pillars work in concert to complement each other across all feature sets and integration points.
?	Accelerate – To not only accelerate and Future-Proof the environment but completely modernize your SQL infrastructure. A revamped perspective on storage, leveraging RAM and other memory technologies, to maximum effect.
?	Protect – Protect your database with industry leading backups, replication, resiliency and self-service Deduplicated copies.
?	Reuse – Reuse snapshots. Operational recovery. Dev/Test repurposing. CI/CD pipelines.
Aligning along these pillars will bring efficiency and consistency to a unified approach of data estate management. The combination of a strong, consistent, high-performance architecture supporting the database platform will make your IT team the modernization execution masters.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 13

Time: 12:30 PM - 1:30 PM

Room: Humanities 208

While the Azure platform provides built-in safety mechanisms, these are not always well understood. Further, a good architect will ensure redundancy even within an already protected system. This session will show how the Azure Platform as a Service (PaaS) offerings such as Azure SQL Database, Azure MySQL and Azure Managed Instance, are built and maintained by Microsoft to provide protection for your vital information. We’ll also go over methods you can employ to add additional protection to your systems. Moving to the cloud and taking advantage of all that it offers doesn’t mean your data is automatically, fully protected. The knowledge from this session will help to ensure a higher degree of safety, faster recovery, and more up-time for your databases on the Azure Data Platform.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Azure & Cloud Technologies

Level: Intermedia

Session Code:

Date: April 13

Time: 1:30 PM - 2:30 PM

Room: Health Science 131

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Advanced

Session Code:

Date: April 13

Time: 1:30 PM - 2:30 PM

Room: Humanities 305

If you had an unlimited budget, any problem is easy to fix.  But when users complain and your boss is hovering around your desk, and you don't have Platinum bucks, what can you do to  ensure your SQL Servers are maintained and optimized properly?  In this session, we'll dive through performance monitoring and building baselines using open source scripts that give you super powers to even go back in time and diagnose problems that are no longer available.  

Do you have processes that block or deadlocks queries but are no longer running?  Do you have power users that do some questionable reports or a rogue developer with sysadmin access?  How do you resolve them if they're not using the system when you have eyes on them?

Finally, you will walk away from this session with a plan that can be implemented tomorrow and never be caught off guard again.  You will look like a superhero that can be proud of performance monitoring system that you built yourself.  Come join the fun!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Administration

Level: Intermedia

Session Code:

Date: April 13

Time: 4:00 PM - 5:00 PM

Room: Health Science 120

Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates provide by SSMS for views, stored procedures, functions.
Table-driven applications allow one set of code to handle changing business needs. Metadata-driven code generation takes this a giant step further. If you can describe your code with an algorithm operating against a set of data, you can get a computer to produce the code.
 - Source to Target mapping documents can be used to generate the code to effect the mapping.
 - Service Broker activation stored procedures have a clearly defined structure. They can be mass-produced.
 - Standard CRUD stored procedures can be stamped out cookie-cutter fashion.
 - Business rules can be encoded in data and the code to implement them manufactured.
Generated code has systematic errors. Fix the errors at the generator. All the code now works. If the code is so boring that a computer can produce it, why not spend your talent doing something interesting?
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: April 14

Time: 8:30 AM - 9:30 AM

Room: Humanities 305

Self-promotion is often confused with bragging, but most of the time it is the best tool to advance your career. In this session we talk about how self-promoting is the first step to creating your brand. Many IT Professionals struggle with how to stand out in a room, be noticed in a pile of resumes or maneuver for promotions. By learning to network and communicate effectively, these hurdles are converted into advancement ladders.  Self-Promotion and Networking are skills and therefore can be taught and learned. We will discuss ways to use social media, communities and other avenues to increase your brands visibility online. Equally important is your ability to interact with co-workers, clients and management face to face.  We will discuss ways to meet and network with other individuals and give you the tools to stand out from your peers.  Building and engaging with a large network will increase your worth to both your current and future employer.  Transform into a Networking Master.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: April 13

Time: 11:00 AM - 12:00 PM

Room: Humanities 307

Do you want the highest performing SSD for your storage?
Does your budget limit how much capacity you can buy?
Do you wish you could afford performance and capacity?
 
If you answered “Yes” to these questions then this session is for you.  Automated Real-Time tiering allows you to blend the performance storage of your choice with cost effective storage.  Your queries run fast because Machine Intelligence automatically moves your active data to your performance storage.  
 
Future proof your storage. As needs change or faster storage media becomes available, you can upgrade to newer faster storage without taking your system offline.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: April 13

Time: 12:30 PM - 1:30 PM

Room: Humanities 206

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