Build Schedule

Advanced Filters:
  • Track

    clear all






  • Speaker


  • Level


  • Session Type

Sessions Found: 21
In this talk Aaron will introduce users to some techniques and tools for developing and maintaining SQL code inside an Agile SDLC.  Aaron will use test driven development techniques and commit his code changes to Team Foundation Services and schedule a build.  He'll also demonstrate some custom solutions and go over all of the different databases that a DBA might support in an on-premise TFS install.
Speaker:

Session Type:
Regular Session

Track:
App Dev

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

We hear these names bandied about, but what exactly are they?  How do they benefit the end user?  How do they differ?  What problems do they solve?  How does a DBA implement them?
We will address these technologies showing what they do.  We'll describe the typical situations where they are used.  We'll list the major costs associated with each.  We'll give bullet points that can help management decide whether to implement a given option.
Speaker:

Session Type:
Regular Session

Track:
DBA II

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.
Speaker:

Session Type:
Regular Session

Track:
Data Platform

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

For too long have database developers had to suffer with inferior tools and processes! Database development is just as important as application development and it deserves equivalent tooling. In this session, we'll demonstrate how SQL Server Data Tools allow you to utilize source code control, generate deployment and rollback scripts, refactor databases, and much more.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
App Dev

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Performance matters.  A well-designed application will reduce hardware and licensing
costs while providing an enjoyable end-user experience with maximum scalability.  This
session covers the key considerations of database application design from a 
holistic performance perspective.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Cube functions have existed since Excel 2007, but they’re not as well known nor as well publicized as other methods to obtain data from Analysis Services/PowerPivot sources. Business Analysts may feel confined to tabular (symmetrical) reports with pivot tables. BI Developers may avoid Excel because they want the ability to write calculations in MDX and the extensive formatting capabilities of Reporting Services. And Power View limits you to the sets, calculations, and captions available in the data source and doesn’t provide drillthrough detail. We’ll start with the basics of how to write and use cube functions, then employ them to build a nicely formatted, asymmetrical, parameter-driven report that overcomes the previously noted limitations. In addition to facilitating new methods for data retrieval and report design, learning cube functions can help business analysts understand the MDX language and BI developers appreciate the power of Excel’s formulas and formatting options.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Beginner

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server 2012 introduced a new set of high availability features collectively called AlwaysOn. Availability Groups are an AlwaysOn alternative to database mirroring. In this session we will discuss the advantages of Availability Groups and walkthrough a basic implementation.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA II

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Trace flags alter the way SQL Server behaves.  Learn the how & why to use them.  Understand the difference between documented and undocumented trace flags.  Review a couple trace flags that your SQL Server might benefit from.
Speaker:

Session Type:
Regular Session

Track:
DBA I

Level: Beginner

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Just about anyone can click through a SQL Server installation and get it working. But, it is not running close to efficient, and as the workloads grow, it will only get worse. This session by David Klee (@kleegeek) provides valuable details on how to tweak and tune your SQL Server installations to ensure maximum performance, as well as tips on capacity management so you know when you need to add more hardware to take your server to the next level.
Speaker:

Session Type:
Regular Session

Track:
Data Platform

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

As SQL Server Professionals we spend countless hours inside a single tool - Microsoft SQL Server Management Studio - yet odds are you don't know of some of the enhancements that exist inside Management Studio that provide you with the ability to re-use code, parameterize frequently-run scripts, and store all these scripts right at your fingertips.  In this session Tim will dive into some of the less familiar areas of SSMS and give you ideas on how you can work less... and get more accomplished.  We will also touch upon some additional functionality that Red Gate's SQLPrompt offers for taking this one step further. 
Speaker:

Session Type:
Regular Session

Track:
Data Platform

Level: Beginner

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Windows Azure provides several different ways of storing and managing data. Windows Azure SQL Database and SQL Server in Windows Azure Virtual Machines are solutions in Windows Azure for working with relational data. If you are familiar with SQL Server, Windows Azure SQL Database will be a natural extension of your knowledge and skills. 
In this session, you will learn: 
1)	Windows Azure SQL Database - Learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to Windows Azure SQL Database. We will then walk through how to manage and administer your Windows Azure SQL servers and databases. 
2)	 Provision the SQL Server VM on Windows Azure - We will learn provisioning the Virtual Machine through the Windows Azure Management Portal. Once created, we will open the VM through the Remote Desktop . Finally, we will connect to SQL server  using SSMS.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
App Dev

Level: Beginner

Session Code:

Date: August 03

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 I

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Do you develop SSIS packages, SSRS reports or SSAS cubes (multidimensional or tabular)? Then this class is for you! We'll cover the capabilities this free tool empowers you to perform as well as address some of the grating little quirks of BIDS/SSDT. 
Analysis Services Multidimensional: Roles Report, Printer Friendly Dimension Usage

Tabular: Tabular Actions Editor, Tabular Display Folders, Tabular HideMemberIf

SSRS: Delete Dataset Cache Files

SSIS: Deploy packages from BIDS/SSDT, Identify items with configuration/expressions, Create packages based on templates, Find differences between packages

Learn about this perfect combination from Meagan Longoria and Bill Fellows and you'll never want to have your BIDS without the helper.
Speaker:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

More and more companies are virtualizing with VMware, and databases are the next logical step. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMware environment.
Speaker:

Session Type:
Regular Session

Track:
DBA II

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Although many have still not heard much about Microsoft's Parallel Data Warehouse Appliance the 2012 release of the product is our 7th version to market.  I will cover the basic differences between SMP and MPP data warehouse systems, how the Microsoft PDW works, and what features and sizes are available in PDW 2012.   We'll also talk about how PDW 2012 allows you to integrate your typical relational data with your Big Data in one integrated environment. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
BI

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Many SQL Server DBAs support Reporting Services administratively, but may not know how a report is actually developed. This session will outline some fundamentals of SQL Server Reporting Services, as well as walk through the development of a parameterized report from end to end.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
DBA I

Level: Beginner

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Learn how the new analytic functions introduced with SQL Server 2012 can take your T-SQL skills to the next level! Solve complicated requirements with better performing and easier to write queries.
Speaker:

Session Type:
Regular Session

Track:
App Dev

Level: Advanced

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

With the number of deployments of SharePoint exponentially growing every day, as a DBA, it is very likely you are going to have SharePoint databases on SQL Servers you support. This session reviews SharePoint strictly from the SQL Server perspective. You will learn how SharePoint is optimized for SQL, how to properly manage and maintain the SharePoint databases, how to optimize the SQL configuration for SharePoint,  what settings in SharePoint need to be changed or not changed to maintain SQL Server performance, supported methods for providing high availability and disaster recovery, and the part SharePoint and SQL each play in the Microsoft Business Intelligence story.
Speaker:

Session Type:
Regular Session

Track:
Data Platform

Level: Intermedia

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women -- and men -- in tech. Everyone welcome to this very interactive session.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
DBA I

Level: Beginner

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

Referred to as “DBA by Default” or “Reluctant DBA”, many people are faced with the situation of suddenly becoming a SQL Server database administrator.  Once the initial shock passes they realize that they need help. The abundance of SQL Server books and websites that exist, some good and some not so good, might only increase confusion leading to panic and rash decisions. DON’T PANIC! In this session we will cover ways to address basic problems and offer some suggestions for finding good places to find help. 
Speaker:

Session Type:
Regular Session

Track:
DBA II

Level: Beginner

Session Code:

Date: August 03

Time: 12:00 AM - 1:00 AM

Room: TBD

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