Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email helpdesk@pass.org. Thank you for your patience.

Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 20
In this session I’ll share some of the lessons I've learned the hard way about loading data.  I’ll show you some ways SQL Server Integration Services can make your life easier (or harder!) and ways you can move data without ever leaving SQL Server management studio.   Want to move data like a boss Monday morning?  This session will show you how!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Developer Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Despite some overlapping concepts, the worlds of the Relational engine and Analysis Services really are quite different. With more and more organizations realizing the power of Analytics, there is a good chance a BI initiative will come your way at some point. 

This session is intended for the DBA that wants/needs to learn more about SQL Server Analysis Services. The goal is to provide a meaningful base of knowledge that will allow you to effectively participate in discussions of Analysis Services in your organization.

Through both slides and demos, you will learn:
-- The differences between SSAS Multidimensional and SSAS Tabular
-- Key terms like Measures, Dimensions, Hierarchies
-- Storage options such as MOLAP, HOLAP, ROLAP, and Direct Query
-- Monitoring with Extended Events
-- Overviews of MDX, DAX, and XMLA
-- and more

Come take a few steps into the exciting world of Business Intelligence with SQL Server Analysis Services.
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will present how you can load and stress test your SQL Server database using SQL Profiler and OStress. This session will review how to performance test Extract, Transform, and Load SSIS processes, application SQL code, Reports, and free-roaming SQL. We will share SQL Profiler templates that help to trap the poorly performing SQL statements that can then be using to stress test your database until it breaks. In addition, we will show how SQL Profiler can be used to extract the SQL submitted by SSIS and Object-Relational Modeling tools like Hibernate and then use that SQL to take stress testing to the next level.

The first third of the presentation will be presentation style and the following two thirds will be demonstrations where we try and break the database with our stress testing. All this with a Breaking Bad theme!
Speaker:

Session Type:
Regular Session

Track:
DBA Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Hive is the gateway for SQL Server professionals to enter the world of Hadoop.  In this session you will learn why & how you should augment your relational systems with HDP/HDinsight and Hive. We will discuss the differences between SQL Server and Hadoop/Hive at the Hardware, Software, and Query levels. We’ll go into the syntax differences between T-SQL and HiveQL (surprise, there aren’t that many). Finally we will discuss common Use Cases where Hive shines. Expect plenty of useful tips and side-by-side comparisons.   
Speaker:

Session Type:
Regular Session

Track:
New Technology Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Frequently I encounter SQL servers and databases in enterprises with huge interdependency issues, such as linked servers, cross-database views and stored procedures, and complicated ETL packages. In this session I will show the most grievous bad practices, what sorts of problems and constrictions they cause, and how they can be re-written to achieve much looser coupling across all data in an enterprise. Any DBA or developer that uses more than two part table or view names in their queries or stored procedures should attend!
Speaker:

Session Type:
Regular Session

Track:
Developer Track

Level: Intermedia

Session Code:

Date: November 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:
DBA Track

Level: Intermedia

Session Code:

Date: November 22

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 Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Graph databases are used to represent graph structures with nodes, edges and properties. Neo4j, an open-source graph database is reliable and fast for managing and querying highly connected data. Will explore how to install and configure, create nodes and relationships, query with the Cypher Query Language, importing data and using Neo4j in concert with SQL Server... Providing answers and insight with visual diagrams about connected data that you have in your SQL Server Databases!
Speaker:

Session Type:
Regular Session

Track:
New Technology Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

How does The Hortonworks Data Platform (HDP and HDInsight) fit into our neat & tidy database world? In this beginner-friendly technical session you'll learn about  Big Data from the ground up with a focus on what SQL Server professionals need to know.  Find out technical details about what HDFS, MapReduce and YARN actually are & how they work. Discover the Hadoop ecosystem and the projects within. Learn how Hadoop complements the traditional relational database world. See demos of real-world data tasks/use cases that Hadoop can accomplish. 
Speaker:

Session Type:
Regular Session

Track:
New Technology Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Have a large or potentially large database that you would like to partition?  Manually implementing partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables.  In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column.  We set it up to keep a FIXED number of file groups.  The partition maintenance will recycle the file groups over time as partitions are dropped and created.  We do as much as possible through dynamic scripting.  This solution can easily be used for archiving but in this example we are simply keeping the most current 6 months of data and dropping the rest.  Assumes you have a basic understanding of SQL Server table partitioning.
Speaker:

Session Type:
Regular Session

Track:
DBA Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker:

Session Type:
Regular Session

Track:
Developer Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment. 
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

What is the architecture of a data warehouse in 2014? How can we integrate new trends and technologies? This session talks on how a data warehouse can benefit of newest SQL Server 2014 features and Azure HDInsight Big Data technologies.
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Are you bored on spending your days creating reports for the business users? Do you dream on the day the user will simple use a search box and ask what they want and the magic will happen and the report will show up on their screen? Wait no more, this day is today! 
Let's see on this session how to use this powerful new tool to transform our BI solution in a true self-service BI
Speaker:

Session Type:
Regular Session

Track:
BI Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

We DBAs are a busy lot. As time passes, it seems like we're being asked to configure and manage more and more servers and databases without an increase in headcount. What can we do to keep up? In this session, you'll learn about Powershell and how you can use it to automate your routine (and not-so-routine) tasks. After covering the basics, we'll get into some practical scenarios and compare the Powershell approach with the alternatives.
Speaker:

Session Type:
Regular Session

Track:
DBA Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

This session provides a comparison of SQL High Availability & Disaster Recovery options, presented by a practitioner who has implemented and managed all the SQL High Availability and Disaster Recovery approaches (and various combinations thereof). We will provide an overview of all the various HA & DR options, then compare trade-offs for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.
Speaker:

Session Type:
Regular Session

Track:
DBA Track

Level: Intermedia

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL injections are a technique where malicious users can inject SQL commands into a SQL statement, through web page input. If left unprotected, SQL injections can cause havoc with web applications by compromising security, manipulating data, hoarding system resources, retrieving sensitive data, removing databases and database objects, or taking databases offline! This session will show how SQL injections work, identify if you are being attacked, and cover various prevention techniques and their effectiveness.
Speaker:

Session Type:
Regular Session

Track:
New Technology Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
Speaker:

Session Type:
Regular Session

Track:
Developer Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Whether it's because you inherited the code from the "last guy," or your stored procedures haven't been looked at since the database was created in 2001, there will come a time when you need to rewrite old code. When you start this project you may ask yourself, how did I get here? And you may ask yourself, how do I work this? This is not my beautiful database. This is not my beautiful T-SQL. Letting the data go by, information flowing to the end users is the goal. Refactoring old code can be tedious, but necessary. Sometimes it isn't just about identifying the worst queries in your application, but figuring out how to rewrite everything to introduce the best practices that the last guy didn't know about five years ago. 

This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can't be used in modern versions of SQL Server. Don't leave your old T-SQL the same as it ever was.
Speaker:

Session Type:
Regular Session

Track:
Developer Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

Window functions are one of the coolest new things in SQL Server 2012, but they can be tricky to figure out. In this session we'll talk about how windows functions work and why you should start using them. This is going to be a demo heavy session with code samples you can take back to work and start using Monday morning!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
New Technology Track

Level: Beginner

Session Code:

Date: November 22

Time: 12:00 AM - 1:00 AM

Room: TBD

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