Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type

Sessions Found: 36
Are you a DBA who knows nothing or very little about .NET? It's a more common than you might think, but most DBA's cringe at the thought of seeing C# code. Still, there are a lot of gems in this tried and tested toolbox. In this session, we'll cover the portions of .NET that are useful for any data professional. If you're into database development, administration, or ETL - .NET has some useful implementations that you can leverage easily.

No .NET experience is needed for this session. Basic understanding of programming concepts such as if/then logic and loops is suggested.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
.NET

Level: Beginner

Session Code:

Date: July 25

Time: 10:00 AM - 11:15 AM

Room: LC1

There are some things that you just wish your colleagues had known before they set up and installed SQL Server.  A successful installation of SQL Server requires more than someone accepting all the default options or clicking Next a bunch of times; proper choices need to be made.  In this session you'll learn from the mistakes of others as well as best-practice configurations across the entire infrastructure stack (Physical server, storage, virtualization, OS, and SQL Server layers) in order to ensure stable performance.  This session is for the accidental DBA or anyone who needs to install SQL Server occasionally (or for their colleagues who need to mop up afterwards).
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 25

Time: 8:30 AM - 9:45 AM

Room: LC2

Think CouchDB is for DBA's who work from home? Or never heard about the wonderful job MongoDB does at deleting data?! Well now is your chance to get your feet wet and dive into MEAN development. In this presentation you'll get a tour of the MEAN Stack, a  crash course in some of the NoSQL flavors- CouchDB, MongoDB, Cassandra, and Redis... and also see what Microsoft is doing with this new trend. Then we'll wrap up with a demonstration of working with Hadoop on Amazon's Web Services Cloud.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
DBA - Database Development

Level: Beginner

Session Code:

Date: July 25

Time: 3:30 PM - 4:45 PM

Room: LC1

Many database developers sooner or later need to consume from or feed data to an accounting application such as the 
General Ledger.  Not being trained as bookkeepers, we may find bookkeeping conventions confusing at best and mystical at 
worst.  When is a credit negative, and a debit positive ?  The subject also has a reputation for being dull.  

But not really understanding the concepts and semantics seriously impedes unit testing, effective communication with the business, and  excessive dependence on business analysts as intermediaries.  We can do better !  This session will focus on demystifying the concepts and terms of basic accounting, facilitating further study if you are so inclined and enabling you to understand the requirements and be proactive in testing.  

The session will conclude with a brief demo showing how SQL Server's Analysis Services directly supports some bookkeeping concepts.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Beginner

Session Code:

Date: July 25

Time: 2:00 PM - 3:15 PM

Room: LC25

PowerShell is the hottest new Microsoft technology and you need to know it.  Assuming a basic knowledge of PowerShell, this session will focus on advanced topics like creating modules, advanced functions, creating custom PowerShell objects, creating a GUI for your scripts, application automation and  much more.  Many code examples will be examined to show you how to apply the concepts. This is the presentation to attend to step up your game.  
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Database Development

Level: Advanced

Session Code:

Date: July 25

Time: 12:30 PM - 1:45 PM

Room: LC22

We will cover several advanced topics in Transactional Replication including how to make a ddl change to one table in the publication without reinitializing the publication; how to make a ddl change to a table without having to snapshot; creating replicated tables on file systems other than Primary – including partitioned file systems; and bidirectional replication.  And hint – we will be leaving the wizard in Redmond!!  Bring a copy of SQL 2014 Developers Edition with AdventureWorks2014 if you want to play along
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 25

Time: 12:30 PM - 1:45 PM

Room: LC23

Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect.  It becomes more challenging when we find nothing is wrong with the way SQL Server is running.  In this session we review common mistakes to the configuration of network settings.  We’ll also show how to troubleshoot the SQL Server Browser.  We’ll cover how to test for firewall issues.  Finally we’ll discuss why SQL Server is blamed for dropping its connections.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 25

Time: 3:30 PM - 4:45 PM

Room: LC20

This session will address all things non technical.
Job Market
How to look for a new job while employed
What are employers looking for
Do I stay or do I go
Networking
Social Media pros and cons
Keeping up
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Professional/Personal Development

Level: Intermedia

Session Code:

Date: July 25

Time: 8:30 AM - 9:45 AM

Room: LC25

This presentation provides a high level overview of basic Big Data and Hadoop fundamentals and concepts. It is an ideal opportunity for those considering or learning Hadoop to see Big Data in Action with examples using Microsoft Azure HDInsight, which is a 100% Apache Hadoop-based service in the cloud provided by Microsoft. We will also cover Big Data exploration and data visualization demonstrations using Microsoft products; such as PowerQuery for Excel.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Big Data

Level: Beginner

Session Code:

Date: July 25

Time: 8:30 AM - 9:45 AM

Room: LC1

You are a DBA familiar with some basic Windows clustering and database mirroring concepts. You are considering Always-On Availability Groups and realize that the simplistic setup wizard is a bit, “too easy.” This session will cover the pros and cons of four typical configurations of Always-On Availability Groups including their marketable features such as read-only routing and backup off-loading. I will demonstrate how to use the Availability Group Listener correctly and why you should be using Windows Server 2012 or above, along with some of my own personal lessons learned.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 25

Time: 10:00 AM - 11:15 AM

Room: LC20

Tired of watching progress bars and waiting for servers to reboot while you follow run books on how to install SQL Server. This session teaches you how to automate the whole process of installing a Windows Server (Core Installation), Install SQL Server, setup Clustering and configure an AlwaysOn availability groups.

The whole process is presented as a life demo
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 25

Time: 12:30 PM - 1:45 PM

Room: LC20

This presentation provides a high level overview of Big Data analysis using Microsoft Data Mining Tools and fundamental statistical methods. It is an ideal opportunity for those considering using Big Data to identify patterns and gain insight from their data. We will demonstrate data mining models such as Decision Tree, Clustering, Logistic Regression, Time Series, or Neural Network.  We will visualize the results using the Data Mining plugin for Excel 2013.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Big Data

Level: Intermedia

Session Code:

Date: July 25

Time: 2:00 PM - 3:15 PM

Room: LC21

Have you ever had a package fail and wish it would recover automatically?  Have you ever encountered a source or network issue and loaded bad or incomplete data into production?  Do you have jobs that fail or load bad data because an upstream dependency ran long?  Do you need faster loads to stay within your load window?

Some of the common challenges facing SSIS developers and DBAs are scaling up and/or out to increase throughput, load balancing, recoverability and restartability, basic process auditing, and multiple job dependency checking.  This presentation reviews all of the elements to building a process control framework using the work pile design pattern that can help resolve many of these issues.  Finally we will conclude with a demonstration of a basic process control framework outlining table design, control packages, load packages, dependency checks, audit controls, and very basic load balancing.  Downloads include: slide deck, table scripts, SSIS packages.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise BI

Level: Advanced

Session Code:

Date: July 25

Time: 12:30 PM - 1:45 PM

Room: LC19

With the advent of the tabular model in SQL Server 2012, another analytical option has opened to the BI Specialist. We shall be looking at what critical factors should be analyzed prior to opting for the model and that done,  how to extract data from a tabular model using Data Analysis Expressions (DAX).
We shall discuss many of the often used functions, discuss their 'overloads' (utilizing several practical examples) and see how to turn the extracted data into valuable information that may be used by decision makers to help the enterprise achieve its corporate goals.
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
Enterprise BI

Level: Intermedia

Session Code:

Date: July 25

Time: 10:00 AM - 11:15 AM

Room: LC19

Bugs. Ugh. Who likes 'em? NOBODY. 
But they are a fact of life. Everyone makes mistakes. Tracking them down is part of our lives as developers. This session will fill your tool kit with methods, ideas and techniques for finding and crushing bugs. 

This presentation is (mostly) not .Net and Visual Studio specific and would be a great fit for developers who work in any language.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
.NET

Level: Beginner

Session Code:

Date: July 25

Time: 2:00 PM - 3:15 PM

Room: LC1

Dynamic SQL can be a powerful tool that allows you to write fast & efficient queries when the specifics may not be known until run-time.  It can also be complex, difficult to read and debug, and the source of some of the most confusing TSQL you'll ever see.

Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it, with the bonus of helping to improve the sanity of your coworkers (and your own) in the process!
Speaker:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Database Development

Level: Beginner

Session Code:

Date: July 25

Time: 2:00 PM - 3:15 PM

Room: LC22

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:
Enterprise BI

Level: Beginner

Session Code:

Date: July 25

Time: 8:30 AM - 9:45 AM

Room: LC23

You know all the ways to protect your database when it is at rest, but what about when someone connects and starts running some queries? What if they connect and don't do anything? Just how exposed is that data? 
We will assume the role of a hacker and, by using a simple technique, we will sniff packets on a network to reveal what data is being sent. You may be shocked! 
We will then secure our database connections with a simple self-signed SSL certificate. 
Once secured, we will resume the role of the hacker and look inside the packets to see what has changed. 
*Warning - Do not try these demos at work without proper permissions as actual hacking techniques are used. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (75 minutes)

Track:
DBA - Administration

Level: Intermedia

Session Code:

Date: July 25

Time: 3:30 PM - 4:45 PM

Room: LC23

Come learn how to use Excel tables,  pivot tables, pivot charts, and slicers to build interactive screens to visually explore your data.  During this presentation, Joe will demo several of the explore screens used in the Autotask Performance Dashboards.  He will then step through the process of creating one from scratch - outlining the process step by step.  Whether you are a business owner interested in using dashboards to gather insights from data or on the technical side looking for more information on how to build them – there is something here for you. 
 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (75 minutes)

Track:
Self-Service BI

Level: Beginner

Session Code:

Date: July 25

Time: 3:30 PM - 4:45 PM

Room: LC21

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:
Self-Service BI

Level: Beginner

Session Code:

Date: July 25

Time: 10:00 AM - 11:15 AM

Room: LC23

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