Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 41
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:

Session Type:
Regular Session

Track:
Misc

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

The arrival of the Big Data movement (Hadoop and NoSQL) is changing the Enterprise Data Architecture. This presentation is a continuation of my previous presentation "An Introduction of Business Intelligence and Big Data"
In this presentation, I will describe advantages and disadvantages of OLTP, OLAP and Big Data, and the rise of BDMS (BIG DATA MANAGEMENT SYSTEMS).  I will show how the Modern Database Architecture landscape is changing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

What is "Windows Azure SQL Database" all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to "The Cloud" ? How do I possibly leverage this new technology in my production environment ? 
If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about "The Cloud". Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure. 
Speaker:

Session Type:
Regular Session

Track:
Azure / Prof Dev

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft Access makes an unparalleled front-end for any version of SQL-Server. This session will explain the how and why.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Misc

Level: Intermedia

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

On this session we are going to deal with real work situations such as the loading and transformation of fixed width files in EBCDIC. Conversion of comp-2 and comp-3 fields using custom ssis components and the creation of metadata to dynamic generate ssis at run time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
SSIS

Level: Advanced

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Misc

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

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

Track:
DBA 1

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will show you how to use business rules and workflow to facilitate data governance and business processes around master data management using the built in MDS tools and Maestro.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Are your instances secure? Or do you worry that you've missed something, or made a mistake without realizing it? From install and configuration to day to day operations there are plenty of opportunities for mistakes to happen that can give an attacker a opening they can exploit. This presentation will discuss common security mistakes and how to fix them in areas including installation, patching, performance tuning, and more. We'll also look at mistakes that are made by your users and what you can do to mitigate those. Intended for beginner to intermediate users, even experienced DBA's will find this presentation a useful refresher.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 2

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

DevOps is a term that has come to mean many things to many people. At its core, this important concept represents a way to remove old barriers between the infrastructure, application, and development tiers within an IT organization. An understanding of scripting and automation platforms is becoming a critical skill for SQL Server Database Administrators. Additionally, as hardware is increasingly virtualized, new opportunities for scripted deployment and configuration are available. This session will utilize demos to illustrate the many ways SQL Database Administrators can automate routine tasks from deployment through configuration.
Speaker:

Session Type:
Regular Session

Track:
Misc

Level: Intermedia

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Cloud is full of buzz nowadays, even for data storage.  But is it right for you?  When might you might want to use Azure for your data storage?  During this session we'll explore the various Azure data storage options include SQL via IaaS, SQL DB, Azure Storage, DocumentDB, and using third party solutions like Mongo and MySQL in Microsoft Azure.  You'll leave having a good idea of what each Azure storage option is good for, along with some of the tips and tricks of working with each.  We'll also explore how to provision up storage instances and use them in your applications.
Speaker:

Session Type:
Regular Session

Track:
Azure / Prof Dev

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will show you how to extend the reach of Power BI using easy to use tools from the Dell Information Management Group to connect to Relational, NoSQL and Cloud Sources.  Using standard Ansi SQL means that you can talk across all of these platforms with one language and one tool to enable data to be provisioned in a secure collaboration environment for your end users.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

The SSIS Data Profiler Task contains great functionality, but is not very flexible nor dynamically configurable. Worse, it outputs to xml files only. In this session I will demonstrate an SSIS solution which uses dynamic expressions to flexibly configure what is profiled. The solution also writes to a custom database instead of xml, enabling trending, auditing and reporting. The solution will be made available to attendees. 
Speaker:

Session Type:
Regular Session

Track:
SSIS

Level: Intermedia

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 2

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Misc

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA 1

Level: Intermedia

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques.
Speaker:

Session Type:
Regular Session

Track:
BI 2

Level: Intermedia

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

You have seen glimpses of the new Power BI offering at WPC and PASS in 2014.  Microsoft has totally reimagined the Power BI platform, user experience, added developer APIs, custom apps, hybrid direct connectivity to on-premise data sources without data copying and other top secret enhancements that we can dive into by the time of this session.  Join me to explore all these great changes for both BI professionals and Power BI users. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Intermedia

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

With a renewed emphasis on data mining and machine learning, the Azure Machine Learning service offers customers a solid and approachable platform for developing intelligent, analytical systems. In this session, we will explore how the Azure Machine Learning service can be leveraged in the context of a typical data mining project methodology. From experiment design and model development to integration of the experiment into a line of business application, we will walk through a full lifecycle demonstration while exploring the most common and useful features.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BI 1

Level: Beginner

Session Code:

Date: February 28

Time: 12:00 AM - 1:00 AM

Room: TBD

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