Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type


Sessions Found: 38
Indexes can be a boon or decrement for query performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE).  This session will concentrate with a deep dive into clustered indexes and nonclustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases.  Covering nonclustered indexes will also be examined in detail and the scenarios they should be applied.  There will be many query demos illustrating index utilization using statistics and query plans.  Attendee should have some TSQL and Management Studio experience.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 17

Time: 9:45 AM - 10:45 AM

Room: 1.113

Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you'll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately.  Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 17

Time: 11:00 AM - 12:00 PM

Room: 1.148

Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in Power BI? Do you you have a need for analysis  services but don't want to have to deal with the hassle of buying and installing a server?  Is your organization using Office 365?  If you answered yes to any of these questions, you might need Azure Analysis Services.  The wait is almost over! Azure Analysis services is the platform as a service version of the wildly popular Analysis Services Tabular product. Join Phillip as he builds and deploys an Azure Analysis services solution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 17

Time: 8:30 AM - 9:30 AM

Room: 1.148

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, DMVs to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are fruit of Microsoft CSS support cases, and customer field engagements. This session includes several demos.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 17

Time: 9:45 AM - 10:45 AM

Room: 1.142

Join me and get some new perspective on what your DBA is doing, and why!

Targeted at the non-DBA such as BI/DW folks, Application Developers, Managers, and System Admins, this session will go over the reasons we back up our databases, our systems, etc.  Considerations such as Single points of failure, High Availability/Disaster recovery, Business Continuity and others will be discussed in this interactive conversation.   It will be conversation heavy, with supporting slides to download, and one Database backup demo at the end if time permits.

Everyone involved in a technical role needs to at least know that the things they have created will be recoverable in the event of a disaster, or even just an "oops" moment.   The CIO/CTO should know how long critical systems will be down when bad things happen.  Backups are everyone's responsibility...whether asking the right questions or implementing the process.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Beginner

Session Code:

Date: June 17

Time: 11:00 AM - 12:00 PM

Room: 1.142

If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming language. During this session, we’ll design and create our own table to demonstrate key concepts, query syntax, and more. If you’ve been meaning to learn T-SQL, here’s your chance!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 17

Time: 1:30 PM - 2:30 PM

Room: 1.117

CRUX:   The focus of this talk is Data (Big Data, Small Data, Tiny Data, Micro Data)  –and–  The Hybrid Cloud (Microsoft & non-Microsoft) Offerings available as of this point-in-time (Jun-2017).       Pre-requisites required:  none, other than just your interest.

AUDIENCE:  This talk is for anyone, irrespective of whether you are — just entering the industry, updating/expanding your skills, or just seeking answers to questions like:
1.  Big Data?  Small Data?  Tiny Data?
2.  Cloud? Hybrid Cloud? Global Hybrid Cloud? 
3.  Why should I care?   What’s in it for me?  Where do I go from here?

NOTE:  The presenters, Tex (20+ year technologist) & Sons (Valentino & Zane, budding technologists), are with Hybrid Decisions® Corp and are presenting on behalf of  www.HCCUG.org  (Houston Cloud Computing User Group)
«±»
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 17

Time: 4:00 PM - 5:00 PM

Room: 1.147

Ever wonder what’s going on with Microsoft Business Intelligence features? Is everything going to the Cloud, or can I still rely on my own servers to design systems? Well, this session is for you. 

We are going to spend hours on looking at the new features of SQL Server 2016 that will help you create on premise solutions for you company or clients that complement the solutions you have already built. SQL Server 2016 not only gives you new tools like R integration and Mobile Reporting, but enhances Analysis Services and Reporting Services you have been using for years.

You will leave with a comforting feeling that Microsoft is not leaving you behind if you do not or cannot go to the Cloud. Perhaps we shall see the thunder of BI love to what we know best and to succeed in the future.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 17

Time: 8:30 AM - 9:30 AM

Room: 1.115

R is the most popular statistics language used today. It is one of the most useful tools in the data scientist's tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.  
  
Come to this session to get an introduction to the R language including: 

  - installing and Configuring R and RStudio 
  - RStudio Overview and Debugging
  - how to Access and Manipulate Data 
  - install and Manage Packages 
  - create and Use Variables 
  - control Flows 
  - functions 
  - basic Graphing and Statistical Analysis. 

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.  
  
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 17

Time: 4:00 PM - 5:00 PM

Room: 1.115

When all you have is a hammer, everything looks like a nail. But what if you had two hammers? Or three? Let John add just a couple of native tools to your belt in this session, and you should have a better starting ability to distinguish a criminally crappy query from an innocent one, a perpetrator from a victim. We'll delve into some older technology like SQL tracing, its much newer, hotter sibling Extended Events, and even leverage some native DMVs in a hunt to pin down a few T-SQL malefactors.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: June 17

Time: 2:45 PM - 3:45 PM

Room: 1.115

In this session, we will cover the basics of building a data warehouse. We will look at the Kimball and Inman methodologies and see what will fit the situations in building a data warehouse most effectively. We will also cover doing a slowly changing dimension that will load in seconds instead of hours.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 17

Time: 1:30 PM - 2:30 PM

Room: 1.148

The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 17

Time: 4:00 PM - 5:00 PM

Room: 1.148

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:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 17

Time: 1:30 PM - 2:30 PM

Room: 1.113

In an automated world, it’s easy to feel like we are losing the tight control we used to have on some of our daily processes. Other processes have remained manual out of fear of losing that same control. What if there was a way to keep the control and automate the process at the same time? In this session, I go over my experiences with different ways of managing schema changes over the life of a project and explore a controlled and automated approach.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Gold Vendor Lunch Session (45 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 17

Time: 12:30 PM - 1:15 PM

Room: 1.117

Most of us can talk - we've been doing it since we were young.  Unfortunately there can be a huge gap between talking and effective communication.  While not all of us will be chosen for TED talks, there are methods we can use to keep our audience engaged and help our message to be understood whether you're asking your boss for a raise or presenting a session at the PASS Summit. Understand the barriers to effective communication and learn to use words, tone, expression and behavior to enhance your communicate skills.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Professional Development

Level: Beginner

Session Code:

Date: June 17

Time: 2:45 PM - 3:45 PM

Room: 1.117

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed.  Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL.  From parameter based searches to building dynamic SELECT statements at run time.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: June 17

Time: 1:30 PM - 2:30 PM

Room: 1.115

For years, SQL Server Reporting Services chugged along with very few updates. Although it remained a reliable and popular reporting tool, the feature set largely remained unchanged for a decade. With the release of SQL Server 2016, everything changed. Microsoft delivered a brand new SSRS. This session will review and demonstrate the new features of SQL Server Reporting Services 2016. You'll walk through the essential changes in SSRS, from the new report manager to the new visualizations. You'll also discuss the SSRS ecosystem and how it fits together with Datazen, PowerBI, and other Microsoft reporting/analytics platforms.

You will learn:

The scope of changes to the new SSRS in 2016
See these new features in action with several realistic demos.
How the all-new SSRS fits in with Datazen, PowerBI, and other Microsoft reporting
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 17

Time: 9:45 AM - 10:45 AM

Room: 1.117

In this session, we will walk you step by step showing how we determine root cause analysis of an unexplained failure in an Availability Group.  Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover.   We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: June 17

Time: 9:45 AM - 10:45 AM

Room: 1.115

You inherited a SQL Server and a bunch of databases from The Last Guy, and you're pretty sure he was drinking on the job. You need to find out just how big of a mess he left you, and what you need to focus on fixing first. You don't want a generic health check - you only wanna fix things that users are going to notice.

In this all-demo no-slides session, you'll learn how to use the open source First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex, sp_BlitzFirst, sp_BlitzWho, and more. Brent Ozar, one of the script authors, will show you what each script does and how to read the results. It's all completely free, maintained by community volunteers, no strings attached. Come see what the community has been working on lately!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Gold Vendor Lunch Session (45 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: June 17

Time: 12:30 PM - 1:15 PM

Room: 1.115

In this talk, we will explore two powerful technologies from the Microsoft Azure Stack: DocumentDB and Azure Search. DocumentDB is Microsoft's NoSQL service for building globally scalable schema-free applications. Azure Search allows you to integrate the power of Microsoft's search and natural language processing abilities to explore your complex data stores. During this talk we will cover the benefits of implementing a schema-free database, we will learn how to replicate your data at a global scale with the ease of a simple configuration and we will cover various techniques of querying that data using SQL and the DocumentDB API. Once we have a large datastore in place (we will use 200k+ Jeopardy questions), we will apply the powerful natural language querying capabilities and faceted search features of Azure Search to quickly create an searchable data repository. All of this will be built and exposed using a cross-platform application built in Angular on the Electron framework.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 17

Time: 11:00 AM - 12:00 PM

Room: 1.115

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