Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 31
Have you heard about SSAS Tabular, maybe even know a couple things about it, but haven't had a chance to dive in and figure out how to develop one yourself? Now is the time!
SSAS Tabular is a new form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, before exploring the development process of creating a tabular model ready for ad-hoc querying.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: June 27

Time: 10:45 AM - 11:45 AM

Room: RM 218

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.
Speaker:

Session Type:
Regular Session

Track:
Management/Personal

Level: Beginner

Session Code:

Date: June 27

Time: 10:45 AM - 11:45 AM

Room: RM 219

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 demo where we’ll cover some pre and post checklist items to help you understand the requirements for a successful implementation.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA/Administration

Level: Beginner

Session Code:

Date: June 27

Time: 3:00 PM - 4:00 PM

Room: RM 302

Every company has a backup strategy. That backup strategy is worthless and will cause your business to fail miserably while losing valuable customer data and more importantly you will lose my order of chicken wings! In this session you will learn why backup strategies are for losers, what can I do to keep from being a loser, and how can I build a winning strategy! 
Speaker:

Session Type:
Regular Session

Track:
DBA/Administration

Level: Beginner

Session Code:

Date: June 27

Time: 4:15 PM - 5:15 PM

Room: RM 302

Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.  
Speaker:

Session Type:
Regular Session

Track:
DBA/Administration

Level: Beginner

Session Code:

Date: June 27

Time: 3:00 PM - 4:00 PM

Room: RM 301

Crash course on becoming better SQL developer by focusing on common mistakes and how to overcome it. What does one need to know to become better SQL Developer? What tools can make your job easier and how to use them? How can I modular code to make it reusable? These and many other questions will be answered by reviewing mistakes, showcasing free tools and going over bad code.
Speaker:

Session Type:
Regular Session

Track:
DBA/Developer

Level: Intermedia

Session Code:

Date: June 27

Time: 9:00 AM - 10:00 AM

Room: RM 301

Geared towards folks who are  starting to dip  their toes into data mining and analytics, but don't know where to start - this session will go over the data mining tools baked into the Sql Server/Analysis Services tool suite.  During the session we will review the basic algorithms available out of the box, demo how to set them up and interpret their results. 
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: June 27

Time: 9:00 AM - 10:00 AM

Room: RM 218

This is a beginner session that will look at the graphical execution plan, and the important operators, properties and what to look for in an execution plan. It will discuss the ways to determine a poor cardinality estimate, parameter sniffing and spill to tempdb.

Speaker:

Session Type:
Regular Session

Track:
DBA/Administration

Level: Beginner

Session Code:

Date: June 27

Time: 4:15 PM - 5:15 PM

Room: RM 218

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:
Management/Personal

Level: Beginner

Session Code:

Date: June 27

Time: 9:00 AM - 10:00 AM

Room: RM 302

In this session we will examine how SQL Server replication works.  A technology that has been around, this tool is not going anywhere anytime soon.  It's an excellent way to keep a subset of data synched with another database without having to synch the entire thing (although you could if you wanted to!).  We will examine terms, internals, and walk through the setup of transactional and snapshot replication pieces so you can implement this technology in your environment and use it as a valuable tool in your personal knowledge book.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA/Administration

Level: Intermedia

Session Code:

Date: June 27

Time: 1:15 PM - 2:15 PM

Room: RM 301

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA/Developer

Level: Intermedia

Session Code:

Date: June 27

Time: 3:00 PM - 4:00 PM

Room: RM 230

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it.  This session includes demonstration and use case scenarios.  The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.
Speaker:

Session Type:
Regular Session

Track:
BigData

Level: Beginner

Session Code:

Date: June 27

Time: 10:45 AM - 11:45 AM

Room: RM 301

What is master data management and why should I care about it?
What does the master data services components of SQL Server do for me?
Overview of all features of MDS
How to build out an MDM subject area
How to use MDS for reference data management
How to use MDS for data quality
How to use MDS with a data warehouse to improve data quality
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
BigData

Level: Beginner

Session Code:

Date: June 27

Time: 9:00 AM - 10:00 AM

Room: RM 202

Developers and DBAs naturally conflict with each other over permissions since developers want to be able to fix their code and research issues, but DBAs are the gatekeepers.  In this session we will discuss Microsoft recommended best practices for setting up users and service account permissions.  We will go over common server and database roles and what they actually allow, including roles that should be avoided as potential security loopholes.  He will also look into alternatives for elevated database roles, and easier ways of setting up users across an enterprise environment, all as part of how to consolidate your development servers into fewer instances.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: June 27

Time: 9:00 AM - 10:00 AM

Room: RM 230

When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments?

If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, we will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: June 27

Time: 1:15 PM - 2:15 PM

Room: RM 218

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

Track:
BigData

Level: Beginner

Session Code:

Date: June 27

Time: 4:15 PM - 5:15 PM

Room: RM 230

In this first part of a two part series, we look at performance tuning from the very beginning.  You're a new DBA, you want to be a DBA, or you've been declared an "Accidental DBA" and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now?  The application is running slowly. Can you help them? Do you even know where to begin to help them?  In this session we'll cover how to handle performance tuning from the very beginning, when the user says "The database is slow."
Speaker:

Session Type:
Regular Session

Track:
DBA/Administration

Level: Beginner

Session Code:

Date: June 27

Time: 10:45 AM - 11:45 AM

Room: RM 201

This is part two of a two part series, looking at performance tuning (i.e. performance troubleshooting) from the beginning. Part II is about the next steps after taking a look at some of the free performance analysis tools. This session will go into more detail about how to capture the current transactions with tools like sp_WhoIsActive stored procedure, Wait Stats, performance counters and Extended Events. 

This is a very demo intensive session some basic issues and performance analysis that will be used as a starting point for performance tuning. 

There will be homework!
Speaker:

Session Type:
Regular Session

Track:
DBA/Administration

Level: Intermedia

Session Code:

Date: June 27

Time: 1:15 PM - 2:15 PM

Room: RM 201

You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: June 27

Time: 1:15 PM - 2:15 PM

Room: RM 302

Power BI (Business Intelligence) is a new and emerging self-service business intelligence and business analytics framework that brings together and enhances a few key Microsoft technologies.  We will answer the following questions:

?What makes Power BI different from the Microsoft Office I have known for years?

?What are the major Power BI features in Excel 2013 and 2010?

?What are the major features for Power BI for Office 365?

?How can our team license Power BI?
Speaker:

Session Type:
Regular Session

Track:
BigData

Level: Beginner

Session Code:

Date: June 27

Time: 9:00 AM - 10:00 AM

Room: RM 219

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