Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type

Sessions Found: 40
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:
Track 8

Level: Beginner

Session Code:

Date: March 21

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:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

How do you know if Availability Groups are the correct high availability solution for your business application?  We’ll cover some common business problems that Availability Groups can solve and go through a quick install where we’ll cover some pre and post checklist items to help you understand the requirements for a successful implementation.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

In this demo-heavy session we will take a look at the SQL Server auditing capabilities of Azure-based resources and on-premises resources.  We will discuss and demonstrate the basics of SQL Azure Database Audit,  how configure it, and how to review and analyze the audit findings generated from SQL Azure Database Audit.  We will also discuss and demonstrate  the basics of using the SQL Server 2014 Audit feature on-premises and for  SQL Server IaaS resources in Azure.   We will also discuss best-practices and real-world considerations for both the SQL Azure Database Audit and the SQL Server Audit Feature.  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
Speaker:

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Perfmon is a standard windows monitoring tool available on every windows deployment. It can provide a wealth of information about the activities within your system. We will cover the basics in this session which include how to setup/schedule perfmon to capture data as well as some basics around initial analysis. This session will have a strong component of demos.
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

If you've ever found yourself stating the above, this session is for you.  For many developers, writing T-SQL that works is not the challenge.  But too  often, functional T-SQL is not the same as good T-SQL.  In this session, we  will examine why "SQL that works" is not good enough.  Understanding  indexes, exectuion plans, sargability, and more are all critical to writing  good T-SQL.  We will also examine several real-world examples of T-SQL that  "worked great in dev" but caused major issues when it hit production. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Will show you the chocolate of Fill Factor and how to win the Golden Ticket by easy Re-FillFactoring
  
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

This was the top scoring professional development session from the PASS Summit 2013. 

Ever wanted to convince the boss try something new, but didn't know where to start?  Ever tried to lead your peers only to fail to achieve your goals?  This session teaches you the eight techniques of influencing IT professionals, so that you can innovate and achieve change in your organization.

1.	Learn about the fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority.
2.	Learn the eight techniques of influencing IT professionals, when to apply them, and how to best use them.
3.	Discover the communication and procedural techniques that ensure your ideas get a hearing by bosses and peers, and how to best win support for them.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

John knows everything and goes out of his way to correct you at every turn.  Mary is agreeable to a fault and just placates everyone.  Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Dirty data is everywhere, and it's headed for a database near you. Extraction, transformation, and loading (ETL) can be difficult, but often the most challenging component of that process is the validation and clean up of data. Information must be cleansed in such a way that it retains its original message and business value, while conforming to the expectations of the destination system(s).

In this session, we'll discuss some design patterns for addressing different types of dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native Integration Services components, T-SQL, and SSIS scripting. In addition, we'll briefly review the new SQL Server Data Quality Services and its integration with SSIS. We'll cap off the discussion with demonstrations of several methods for data cleansing.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

In order to build optimal query plans the SQL Server optimizer relies on statistics to estimate the size of the query workload, which determines the resources that get allocated to the query.

This session will demonstrate how to determine if your statistics are current, how to make them current, and how bad things can happen when they are not current.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 8

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Policy-Based Management, introduced in SQL Server 2008 gives DBAs an easily accessible tool for ensuring consistent SQL Server configurations across their environment. This presentation will offer a core set of essential policies and options for implementing and maintaining them.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

The staging area of the data warehouse is an often under-utilized tool in the ETL developers tool belt.  It can be used to optimize ETL performance while limiting impact on source systems.  It can be used to identify data quality concerns before they hit the target load process.  It can be used as a supplemental repository for unintegrated data.  This discussion will cover several common and some not-so-common patterns in the design and use of stage tables within the ETL process and the audience will come away with new ideas and core concepts to put to immediate use.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 5

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services Tabular mode.  If you know Excel, you already know the basics of DAX (without even knowing it).  If you have been meaning to use Analysis Services, but MDX has been getting in the way, now is the perfect time!  Come check out DAX and see how it can help you.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

You're tasked to create the ETL process for a brand-new data warehouse. Where do you start? Data warehouse ETL boils down to three specific problems: Staging, Dimensions, and Facts. This session will show you solutions to these three problems. You'll first learn the fundamentals of a data warehouse before diving into creating packages and leveraging common patterns. You'll see both simple and advanced scenarios such as incrementally loading staging tables, processing type1 and type2 slowly changing dimensions, early arriving facts, snapshot fact tables, and bridge tables. If you want to create scalable and efficient SSIS packages to load a data warehouse, this session is for you.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?
You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries?
Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server,  and see the actual changes in the packet as hackers would.
*Warning - do not try some of these demos at work without proper permissions as hacking techniques are used. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 7

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this new feature is completely new. While the internals of this feature may be foreign to you, accessing the data that uses the structures very much resembles T-SQL as you already know it. As such, the first important question for the average developer will be how to adapt an existing application to make use of the technology to achieve enhanced performance. In this session, I will start with a normalized database, and adapt the logical and physical database model/implementation in several manners, performance testing the tables and code changes along the way.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA!  Feeling overwhelmed, not sure where to begin.  I know I have data and maybe lots of it.  I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends.   For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends.  Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Beginner

Session Code:

Date: March 21

Time: 12:00 AM - 1:00 AM

Room: TBD

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