Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type


Sessions Found: 13
There's a lot of general verbiage and API documentation about Service Broker, but how do you fit the queues, services, contracts, and conversations together to actually make something that will work reliably in production?  In this session you'll follow the architecture, design, implementation, and troubleshooting of a simple but production-tested Service Broker messaging framework and get a battlefield-level view of the pitfalls and the payoffs involved in Service Broker development.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI/Other

Level: Intermedia

Session Code:

Date: July 18

Time: 8:30 AM - 9:30 AM

Room: Room 250

Microsoft has been busy working on the next version of SQL Server - SQL Server 2016.  We will go over some of the new features at a high level and dig deeper on Row Level Security and StretchDB.  Row Level Security allows you to add another layer of security to your environment.  StretchDB will allow you to transparently place part or all of a table into a SQL Azure DB freeing up your valuable SAN space for data that is COLD.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
ETL/DB Dev

Level: Beginner

Session Code:

Date: July 18

Time: 10:00 AM - 11:00 AM

Room: Avera Hall

Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect.  It becomes more challenging when we find nothing is wrong with the way SQL Server is running.  In this session we review common mistakes to the configuration of network settings.  We’ll also show how to troubleshoot the SQL Server Browser.  We’ll cover how to test for firewall issues.  Finally we’ll discuss why SQL Server is blamed for dropping its connections.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: July 18

Time: 2:00 PM - 3:00 PM

Room: Room 245

Do you have many SQL instances in your enterprise?  Do you have to maintain multiple dev/test/uat/pre-prod/prod environments?  Need to spin up new instances often?  Do you need a way to ensure these environments are all set up correctly and consistently and be notified of changes to them?  If so, you need an enterprise-wide auditing system!  I will be presenting my free system that does the following: 1) Collects information an all of your SQL instances daily, 2) sends you a report of any changes that have occurred (new/old/changed values), 3) lets you set up rules for all/some of servers and checks these rules on a daily basis (ie - backup compression should be turned on, Max memory should be less than 2TB, etc) and will even send you the SQL to fix any rules that failed.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: July 18

Time: 10:00 AM - 11:00 AM

Room: Room 245

Just because you can do it, does not mean that you should.

There are several programming design patterns that work great in object orientated code that do not 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 (60 minutes)

Track:
BI/Other

Level: Beginner

Session Code:

Date: July 18

Time: 2:00 PM - 3:00 PM

Room: Room 250

Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration has proven to be a valuable technique in improving software quality by finding problems quickly and letting developers know immediately they have introduced a bug.This session demonstrates how you can implement CI for SQL Server databases, execute automated tests against your code and inform developers that they have caused a problem immediately. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
ETL/DB Dev

Level: Intermedia

Session Code:

Date: July 18

Time: 12:30 PM - 1:30 PM

Room: Avera Hall

Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier?  If any of these appeal to you, then you should be familiar with database snapshots within SQL Server.  Available since SQL Server 2005, use of this feature can make your life a lot easier.We'll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot.  Once we've covered the basics, we'll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
ETL/DB Dev

Level: Beginner

Session Code:

Date: July 18

Time: 8:30 AM - 9:30 AM

Room: Avera Hall

Effective reporting is not simply the output of data, but the meaningful presentation of that data in a manner that informs the user. SQL Server Reporting Services provides a myriad of features to create a clear, instructive, and interactive experience. This session will demonstrate techniques to utilize SSRS advanced authoring features to facilitate more informative communication. These features include: nesting data regions, leveraging scope, geographic/geometric reporting, complex charting, rich formatting, incorporating managed code assemblies, intuitive drilldown, data from multiple datasets in a single data region, datasets that update source data, and more.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI/Other

Level: Advanced

Session Code:

Date: July 18

Time: 12:30 PM - 1:30 PM

Room: Room 250

How does The Hortonworks Data Platform (HDP) and Microsoft 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. Discover real-world data tasks/use cases that Hadoop can accomplish. 
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
ETL/DB Dev

Level: Beginner

Session Code:

Date: July 18

Time: 2:00 PM - 3:00 PM

Room: Avera Hall

Your boss comes up to you and asks you why the system is slow, unless you know how your system is supposed to respond you are stuck scrambling to answer those questions.  With a few free quires and some SSIS magic you can capture a Baseline of your systems.  With this you will be able to know exactly where to look and what might be amiss.  Before you can say what is wrong with your system you need to know how it reacts under normal circumstances.  This session will provide the tools you need to start collection of your systems baselines and give you a great deal of information.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Intermedia

Session Code:

Date: July 18

Time: 8:30 AM - 9:30 AM

Room: Room 245

Panel discussion on developing SQL Server skills featuring Steve Jones, Paul Timmerman, Bill Preachuk, Brian Larson, and Alan Faulkner. This panel will discuss how and why they became involved with PASS, some strategies for developing great presentations, and suggestions about how to advance your career. .
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: July 18

Time: 3:30 PM - 4:30 PM

Room: Avera Hall

With the release of SQL Server 2012, we were introduced to two possible options when it came to Analysis Services.  This ultimately presented a question…”Which one do I use SSAS multidimensional or SSAS tabular”?  

Determining whether multidimensional or tabular is the optimum solution for your organization is a key step when working with SQL Server Analysis Services 2012/2014. This session will introduce you to some of the common pitfalls with each solution and how you can avoid them. By the end of this session, you’ll have a clearer understanding of the strengths and weakness of each model and how your organization can optimally leverage the strengths of SSAS 2012/2014.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI/Other

Level: Intermedia

Session Code:

Date: July 18

Time: 10:00 AM - 11:00 AM

Room: Room 250

Presentation from Tegile.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Lunch Sessions (45 minutes)

Track:
DBA

Level: Beginner

Session Code:

Date: July 18

Time: 11:30 AM - 12:15 PM

Room: Avera Hall

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