Build Schedule

Advanced Filters:
  • Track

    clear all








  • Speaker


  • Level


  • Session Type

Sessions Found: 40
An introduction to BI architecture with the focus on the Microsoft BI stack as well as an introduction to Hadoop and its impact on BI and analytics.
Anybody interested in BI and Big Data. Some knowledge of database and/or exposure to BI tools would be beneficial for better appreciation between the significance of BI and Big Data
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

We will define Big Data first. Then, we will talk about Microsoft's two offerings:  HdInsight and Parallel Data Warehousing (PDW).  HDInsight is Microsoft’s new Hadoop-based platform. It combines the simplicity of Windows with the power and reliability of Hortonworks Data Platform (HDP) to deliver big data insights from Apache Hadoop. PDW is a shared nothing massive parallel processing (MPP) relational DB based on SQL Server. This Session will explore how to load data to the Azure blob store, creating an HDInsight Service cluster, adding additional storage locations, and adding structure with Hive objects.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

 BIML--Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We'll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We'll move through basic syntax of plain BIML, and progress to BIMLScript, using LINQ, and Lambda expressions to access enterprise metadata, speeding SSIS development exponentially.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

There comes a point in every career that you will need to talk to people that you do not agree with.  It is important to advancement (and well-being) that you are able to make concise points that will draw interest from other teams, as opposed to alienating them.  
How do you speak to your leadership team?  Your peers?  People who depend on you?  People on whom you depend?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Together we'll explore SQL Server "check engine lights", those little indications that SQL Server needs your attention.  Ignore these and you could be stuck alongside the road with a broken engine.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

The demo intensive session covers how to combine SQL Server, SSRS and SSAS with Tableau visual analytics and the Microsoft BI platform. Topics include:

 - Visual Analytics in Enterprise BI 
 - Solution Architecture 
 - SQL Server, SSRS and SSAS and other Microsoft BI data source connectivity 
 - Mobile BI 
 - Integration 
 - Predictive Visual Analytics 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

PowerPivot is a powerful new tool able to slice and dice data in memory very fast. But how do you acheive complex situations like, parent child hierarchies, Many to Many, and using inactive Relationships. Come see these complex DAX functions and leave with some great DAX knowledge.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Database development has traditionally been done using SQL Server Management Studio query window as the primary tool, when far more powerful tools are available in your toolset. This is the equivalent of writing a document using Notepad, when MS Word is available on your desktop. This session will take you through some of the basics of using SSDT, show you how to use VS2012 database projects effectively, how to utilize TFS build, test and deploy your code. I've had my share of bumps on the road to deploying these toolsets. At the end of this session you will have a good introduction into how to use the tools and how to avoid some common issues with legacy code you are already have in your environments.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session Jose will do an overview of the different types of hierarchies and how to design user hierarchies in SSAS by defining attribute relationships and key columns the right way. Attendees will learn how to implement natural & unnatural hierarchies, balanced and ragged hierarchies, and Parent-Child hierarchies. A brief introduction will be made navigate hierarchies using MDX functions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?

You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.


Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Every organization has to deal with the constant loading of text,csv,excel,pipe, fixed width, and ragged right files in this session we are going to build metadata driving ETL framework that will dynamically create an standard SSIS template that will encompass the file format, enforce standards, and keep track of data lineage across an organization. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Advanced

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Every database professional knows about temporary objects. They can help to solve complex problems and improve application performance when used wisely. However, they can introduce very serious issues when used incorrectly. 

This session focuses on the temporary objects available in SQL Server. It talks about temporary tables, table variables, table-valued parameters and discusses their internal implementation and best use-cases for them. The session also covers some aspects of tempdb usage and monitoring and shows how to reduce tempdb load and improve its throughput.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

No budget?  That's OK!  Need Tools?  We've get them!  Don't know where to go?  We'll show you!  The SQL Server community is one of the best around and has put out loads of free tools, videos, blogs, and other great ideas and information to help you out.  In this session we will show you several great tools, scripts, blogs and other resources to help you out.  Best of all, it's all free!  But wait, there's more.  Order now and we'll include an extra two tips at no additional cost!  
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.
Speaker:

Session Type:
Regular Session

Track:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability.  PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out.  The rewards of the SQL Community are endless.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session we will cover the basics of using Data Explorer (Now called Power Query) + other tools to explore XML data from the SQL Saturday website.  We will look at lesser-known features like XML feeds, harvesting data from other websites, and social media sources using open source tools like Curl (a command line tool for transferring data with URL syntax).  We will use Business Intelligence tools such as the new Data Explorer and SQL Server to download and analyze the XML.
Speaker:

Session Type:
Regular Session

Track:

Level: Beginner

Session Code:

Date: February 22

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:

Level: Beginner

Session Code:

Date: February 22

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:

Level: Intermedia

Session Code:

Date: February 22

Time: 12:00 AM - 1:00 AM

Room: TBD

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