Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 29
Are you just starting out in the database world? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to either of those questions, then this is the session for you! John will be talking about things from both an administrative and developmental aspect that every DBA should know and understand. We'll look at things like Auto Shrink, SELECT *, Index Basics and 7 others!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: August 15

Time: 3:45 PM - 5:00 PM

Room: 121

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:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Developer

Level: Beginner

Session Code:

Date: August 15

Time: 8:30 AM - 9:45 AM

Room: 122

In the world of Data Platform a variety of solutions are available going from on premises, hybrid to cloud solutions. Database Administrators play a crucial role in application design and architecture, providing mission critical and highly available solutions. In this session you will learn everything a DBA needs to know about Azure. You’ll learn about SQL Server running in Windows Azure virtual machines, Azure Storage and network configurations, SQL Database and how to manage and support workloads running in a traditional, hybrid and cloud based environment. 
Become the DBA of the future!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud & Big Data

Level: Intermedia

Session Code:

Date: August 15

Time: 8:30 AM - 9:45 AM

Room: 120

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Soft Skills

Level: Intermedia

Session Code:

Date: August 15

Time: 10:00 AM - 11:15 AM

Room: 120

Most DBA's rarely establish Service Level Agreements (SLA) with the Management and if they do they sometimes just come up with some random numbers for availability. Then when at some point something goes really wrong everybody wonders why it takes so long to bring everything back online.
 
This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Soft Skills

Level: Intermedia

Session Code:

Date: August 15

Time: 12:45 PM - 2:00 PM

Room: 118

Follow along as we adventure through the vastness that is Availability Groups in SQL Server.  In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Developer

Level: Beginner

Session Code:

Date: August 15

Time: 3:45 PM - 5:00 PM

Room: 120

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.   This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data & BI

Level: Beginner

Session Code:

Date: August 15

Time: 2:15 PM - 3:30 PM

Room: 118

Despite the wealth of analytical technologies available today, 65% of fraud at public companies is detected through tips, management review, or simple accidents.  Forensic Analytics combine human intuition and leading-edge technologies, and can provide superior detection methods to significantly improve the detection and investigation of illegal or unethical activities.
In this session, we explore Forensic Analytics: a set of techniques we can use to uncover irregularities in financial data. We also gain an understanding of goals of Forensic Analytics: to enable us to find out how — and why — these irregularities exist, and to find out their source(s) — especially when fraudulent activity is suspected.  We discuss guiding principles that are key to isolating data anomalies, and outline a standard, repeatable process to Forensic Analytics. Throughout the session, we view examples of how we can employ PowerPivot for Excel to drive Forensic Analytics via various tests and reviews.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Security

Level: Beginner

Session Code:

Date: August 15

Time: 12:45 PM - 2:00 PM

Room: 117

Get to know more about the Microsoft Analytical Platform System and how a MPP system is different than a SMP system.

Learn about how the MPP architecture can benefit hundreds of business use-cases and scenarios while providing phenomenal performance gains over a traditional SMP architecture.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
Cloud & Big Data

Level: Intermedia

Session Code:

Date: August 15

Time: 10:00 AM - 11:15 AM

Room: 117

AlwaysOn is SQL Server 2012/2014’s High Availability solution. It provides a new standard for mission critical databases and end-to-end business intelligence at a lower total cost of ownership. It provides the required 9S of availability without the total cost and complexity. In this session, we’ll specifically explore high availability databases – Availability Groups. AG is a new feature that enhances and combines database mirroring and log shipping. We’ll demonstrate the setup and failover of multiple databases simultaneously. 
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: August 15

Time: 12:45 PM - 2:00 PM

Room: 119

Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate.  This presentation will spend a little bit of time on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Cloud & Big Data

Level: Beginner

Session Code:

Date: August 15

Time: 2:15 PM - 3:30 PM

Room: 117

Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We'll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs. 
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud & Big Data

Level: Beginner

Session Code:

Date: August 15

Time: 10:00 AM - 11:15 AM

Room: 118

How often do you review your SQL Servers for basic security, maintenance, and performance issues?  If you say never, I'm not surprised - many of the servers I "inherit" as a managed services provider have many gaping holes.  It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!)

Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing.  If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: August 15

Time: 10:00 AM - 11:15 AM

Room: 122

Come see Dandy do real-time analytics on #SQLSatOmaha tweets and see how Power BI pulls all of the data together in a way that tells a story for any audience!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data & BI

Level: Beginner

Session Code:

Date: August 15

Time: 12:45 PM - 2:00 PM

Room: 120

We’ve all seen the recent news stories about companies whose data has been stolen by hackers.  What was once a rare event has become all too common, and companies large and small are at risk.  While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data.  In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption.  We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Security

Level: Intermedia

Session Code:

Date: August 15

Time: 3:45 PM - 5:00 PM

Room: 119

So you've setup your new SQL Server instance and it’s time to start adding databases to it.  You followed security best practices at the instance level, but what about security within each database?  Is that something you can control?  Well, if like me, you work in a shop that mostly purchases software, then having users with database owner permissions is a reality, and likely not one you can change.  But members of the db_owner role can only make changes that would adversely impact their own databases, right?  Think again. During this session we’ll review some common database level settings and actions which can have a negative impact across the entire instance.  We’ll discuss ways to mitigate these risks and monitor for their occurrence.  Come learn how to not let poor choices made by a database owner impact your entire instance.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Security

Level: Beginner

Session Code:

Date: August 15

Time: 12:45 PM - 2:00 PM

Room: 121

How many times have you received data from a 3rd party or from within your own databases that has anomalies in it?  What are the typical steps to clean up the data before it goes into the data warehouse or other systems?  This session will demonstrate Data Quality Services, using both the client interface to define domains and rules, as well as the control included with Integration Services, allowing cleansing to occur within the data flow task.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Data & BI

Level: Intermedia

Session Code:

Date: August 15

Time: 10:00 AM - 11:15 AM

Room: 121

Have you considered expanding your current skill set and seeking a long-term career in Big Data but don't know what to learn or where to start? Do I have to learn Java, Scala, Python?  Do I have to become a Unix guru or get a Ph.D in mathematics?  This session will show you the different routes to a new Big Data career and provide you the resources and toolsets you'll need to know to get yourself started.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Cloud & Big Data

Level: Intermedia

Session Code:

Date: August 15

Time: 3:45 PM - 5:00 PM

Room: 122

Social Networking and Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter? Can you believe Susie moved to that company? Do any of those sound familiar? No?  Never heard of Twitter or LinkedIn? Have no fear, this is the session for you!  Social networking can be a very confusing and intimidating place. What makes it even worse, is when you have no clue even where to start.  In this session, we will go over different facets of Social Networking and Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. For example, did you know you can get help from some of  the top minds in the SQL Server profession by using the #SQLHELP hash tag for free? We will show you how! We'll be covering that and more using Facebook, LinkedIn and Twitter.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Soft Skills

Level: Beginner

Session Code:

Date: August 15

Time: 10:00 AM - 11:15 AM

Room: 119

Come join Phil Brammer as he talks through the new features in SQL Server 2016.  This session will touch on AlwaysOn, In-Memory, Query Store, and more!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: August 15

Time: 2:15 PM - 3:30 PM

Room: 119

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