Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type

Sessions Found: 56
Does your data sit around mocking your best attempts to support good data practices?  Databases are also bound by the GIGO rule: Garbage In is Garbage Out.  In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions-- using real-life evidence of her own data in your systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 11

Time: 2:45 PM - 3:45 PM

Room: Math Science 118

SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure?  You can actually do this, by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.

In this session you will:

* Understand how rolling upgrades are better than in place upgrades
* Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades
* Explore how you might use Log Shipping to perform a simpler type of rolling upgrade

This is a demo-intensive session, so you can see rolling upgrades live and up close. If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 11

Time: 4:00 PM - 5:00 PM

Room: Math Science 118

Head starting to explode from all the technical information you’re absorbing?  Come spend a session with us while we play games with Reporting Services…literally!  Come watch as Stacia Misner and a special guest introduce you to some  word play, all wrapped up in SQL Server Reporting Services.  She'll push the limits with what can be built in SSRS and show you how to have fun while doing it.  Board games and SQL…who could ask for more?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: April 11

Time: 2:45 PM - 3:45 PM

Room: Math Science 109

Learn about the easiest way to monitor your SQL Server and Windows environment including data collection, historical and real time diagnostics, alarming, notifications, reporting and more.

Speaker: David Swanson

David Swanson is a graduate of the University of Arizona. He has worked in the software industry for 15 years. He has been a developer, a DBA, worked in support, product management and is currently a Database Systems Consult for Dell Software. He assists in product proof of concepts and production implementations with organizations ranging in size from very small to some of the biggest companies in the United States. He lives in the greater Boston area.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: April 11

Time: 12:30 PM - 1:30 PM

Room: Math Science 123

Overview of Pyramid Analytics and Demonstration on our BI Office
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: April 11

Time: 12:30 PM - 1:30 PM

Room: Health Science 117

We all want a strong and steady engineering process for our database development that allows us to deploy our code in a consistent and safe manner. Come see an overview of how a complex database lifecycle process can work to ensure changes made in development environments are always tested and reviewed, before being deployed in an automated fashion. Learn to Ship Safe, and Ship Often.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: April 11

Time: 12:30 PM - 1:30 PM

Room: Math Science 118

Are you working with an application supporting different time zones and international date formats? How does your choice of storing date / time values differ if you are using Windows Azure SQL Database instead of on-prem SQL Server database? Did you know that SQL Server Database Engine, Integration Services (SSIS) and Analysis Services (SSAS) all have slightly different date / time data types? How can you bullet proof your system for the ever growing data in your organization with much more date and time data to come?  
 
With time being the one thing that constantly changes, date and time calculations are widely used and essential to all business transactions. Yet, most systems only use one or two date data types; Is this a wise decision? Quite often data retrieval relating to a period of time does performs poorly, or worst of all, is not accurate. These 10 tips will help you bridge the gap, and provide the techniques to build bulletproof systems the users demand and DESERVE! 
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 11

Time: 11:00 AM - 12:00 PM

Room: Health Science 117

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:
Track 5

Level: Beginner

Session Code:

Date: April 11

Time: 9:45 AM - 10:45 AM

Room: Math Science 109

Have you wanted to get started with Azure but don't know where to start?  Aside from the reasons why to learn Azure, what resources can you use to quickly ramp up your skills for little costs?  In this session, you will learn the way to fast track your Azure knowledge.  Learn how to either use it as an idea lab to test new features of SQL and other technologies.
Speaker:

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: April 11

Time: 4:00 PM - 5:00 PM

Room: Humanities 206

For years, data warehouses have required a significant investment in hardware and software. We frequently planned for the three year lifecycle. As virtual machines started to handle the load, we gained additional flexibility. In this session, we will look at the various services in Azure and how they can be leveraged to handle various workloads and capabilities. By blending IaaS, PaaS, and even SaaS in the Microsoft Cloud, we can build highly flexible and scalable solutions to meet our needs large and small. We will look at some designs and their strengths and weaknesses including cost, maintenance, scalability, and elasticity. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 11

Time: 9:45 AM - 10:45 AM

Room: Health Science 120

One of the biggest challenges in any large SQL environment is maintaining consistent configurations and meeting the pressures from the business for rapid server deployments. Additionally by default, SQL Server does not install with the best practices for every environment. You will learn best practices for system settings, file system layout and scheduling maintenance tasks. You will learn about what the best practices are for most SQL Server configurations, and how to automate your SQL Server builds in both a physical and virtual world. You will learn about the tradeoffs and benefits to completely automating the build process. You were hear about lessons learned building a private cloud at a Fortune 100 telecommunications company. You will also learn how use these same methods to ensure consistency with your servers whether they are in the cloud, or on-premises.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: April 11

Time: 4:00 PM - 5:00 PM

Room: Math Science 123

Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 6

Level: Beginner

Session Code:

Date: April 11

Time: 11:00 AM - 12:00 PM

Room: Humanities 206

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance.  I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker:

Session Type:
Regular Session

Track:
Track 4

Level: Intermedia

Session Code:

Date: April 11

Time: 1:30 PM - 2:30 PM

Room: Health Science 120

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:

Session Type:
Regular Session

Track:
Track 2

Level: Intermedia

Session Code:

Date: April 11

Time: 1:30 PM - 2:30 PM

Room: Math Science 118

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 1

Level: Beginner

Session Code:

Date: April 11

Time: 1:30 PM - 2:30 PM

Room: Math Science 123

So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it.  I've got some of the answers here in this session for you.  During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: April 11

Time: 2:45 PM - 3:45 PM

Room: Math Science 123

All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or create it in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!
Speaker:

Session Type:
Regular Session

Track:
Track 3

Level: Beginner

Session Code:

Date: April 11

Time: 1:30 PM - 2:30 PM

Room: Health Science 117

tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, where it can be used in an automated deployment pipeline, and introduce you to the tSQLt framework. We’ll show you how to design and write tests to enforce standards, check calculations and other DML operations as well as check exception handling. You will see how a real world refactoring task can be tested in a repeatable manner. Learn how you can incrementally write tests that help you build higher quality code and minimize the introduction of errors against your existing objects.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 2

Level: Beginner

Session Code:

Date: April 11

Time: 8:30 AM - 9:30 AM

Room: Math Science 118

Do you wish you could quickly and easily get some or your data into the hands of your end users? Well… SQL Server Reporting Services (SSRS) is part of SQL:  You’ve already paid for it, so put it to use!  In this introductory level session designed for users with no exposure to SSRS we will cover the basics of developing, publishing and using SQL Server Reporting Services.  From building a dataset through automating report delivery you will learn how you can return to the office and present meaningful data to your end users with minimal time and effort.  Come learn how this very powerful and easy to use tool can relieve you from data delivery tasks and thrill your end users all at the same time.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 7

Level: Beginner

Session Code:

Date: April 11

Time: 9:45 AM - 10:45 AM

Room: Humanities 208

Are you trying to implement Continuous Integration for your DB?
This session will equip you with the basics and tools needed to approach automating SSIS and SQL Agent Job deployments.

There are many blog postings and articles about this but it is not easy to find good working examples of this automation. In this session, I will go over the basics of this automation and discuss the necessary components and possible options that you can use, including a working example of SSIS and SQL Agent Job deployment.
Speaker:

Session Type:
Regular Session

Track:
Track 8

Level: Intermedia

Session Code:

Date: April 11

Time: 8:30 AM - 9:30 AM

Room: Health Science 118

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